--www.askhareesh.com DECLARE LV_RETURN_STATUS VARCHAR2 (1) := NULL; LV_MSG_COUNT NUMBER := 0; LV_MSG_DATA VARCHAR2 (2000) := NULL; LV_VENDOR_REC AP_VENDOR_PUB_PKG.R_VENDOR_REC_TYPE; BEGIN LV_VENDOR_REC.END_DATE_ACTIVE := SYSDATE; --End Date AP_VENDOR_PUB_PKG.UPDATE_VENDOR ( P_API_VERSION => 1.0, P_INIT_MSG_LIST => FND_API.G_TRUE, P_COMMIT => FND_API.G_FALSE, P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL, X_RETURN_STATUS => LV_RETURN_STATUS, X_MSG_COUNT => LV_MSG_COUNT, X_MSG_DATA => LV_MSG_DATA, P_VENDOR_REC => LV_VENDOR_REC, P_VENDOR_ID => 33164 --Vendor id ); BEGIN IF NVL (LV_RETURN_STATUS, 'XX') = 'S' THEN DBMS_OUTPUT.PUT_LINE ('Vendor deactivated successfully'); ELSE DBMS_OUTPUT.PUT_LINE ( 'Error while deactivating the supplier, Msg Count' || LV_MSG_COUNT || ', Error : ' || LV_MSG_DATA); END IF; END; COMMIT; EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE ( 'Exception while deactivating supplier : ' || SQLERRM); END;
Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com
ReplyDeletenice information
ReplyDeleteCasino - Mapyro
ReplyDeleteThe Casino 속초 출장마사지 at O'Sullivan Lake offers over 1800 성남 출장마사지 slot machines, including over 900 table games including blackjack, roulette, slots, craps, Distance to airport: 화성 출장마사지 5.0 kmLocation rating: 8.3Nearest airport: 동두천 출장마사지 New London England Distance to city centre: 사천 출장샵 5.0 km
25% OFF on Oracle Apps R12 Financials Self Paced Course along with 11 Additional Add On Courses (321 Session Videos of 120 Hours Recordings). Our Top Trending Course with 1700 Enrolled Udemy Students
ReplyDeletePlease Check https://www.oracleappstechnical.com for details