196: p_cnt OUT NOCOPY Number) IS
197:
198: l_module CONSTANT VARCHAR2(255) := 'as.plsql.scden.insert_scd';
199: --Code added for performance bug#5802537
200: l_user_id NUMBER:= NVL(fnd_global.user_id,-1);
201: l_login_id NUMBER:= NVL(fnd_global.login_id,-1);
202: l_Conc_Request_Id NUMBER:= FND_GLOBAL.Conc_Request_Id;
203: l_Conc_Program_Id NUMBER:= FND_GLOBAL.Conc_Program_Id;
204: l_Prog_Appl_Id NUMBER:=FND_GLOBAL.Prog_Appl_Id;
197:
198: l_module CONSTANT VARCHAR2(255) := 'as.plsql.scden.insert_scd';
199: --Code added for performance bug#5802537
200: l_user_id NUMBER:= NVL(fnd_global.user_id,-1);
201: l_login_id NUMBER:= NVL(fnd_global.login_id,-1);
202: l_Conc_Request_Id NUMBER:= FND_GLOBAL.Conc_Request_Id;
203: l_Conc_Program_Id NUMBER:= FND_GLOBAL.Conc_Program_Id;
204: l_Prog_Appl_Id NUMBER:=FND_GLOBAL.Prog_Appl_Id;
205:
198: l_module CONSTANT VARCHAR2(255) := 'as.plsql.scden.insert_scd';
199: --Code added for performance bug#5802537
200: l_user_id NUMBER:= NVL(fnd_global.user_id,-1);
201: l_login_id NUMBER:= NVL(fnd_global.login_id,-1);
202: l_Conc_Request_Id NUMBER:= FND_GLOBAL.Conc_Request_Id;
203: l_Conc_Program_Id NUMBER:= FND_GLOBAL.Conc_Program_Id;
204: l_Prog_Appl_Id NUMBER:=FND_GLOBAL.Prog_Appl_Id;
205:
206: BEGIN
199: --Code added for performance bug#5802537
200: l_user_id NUMBER:= NVL(fnd_global.user_id,-1);
201: l_login_id NUMBER:= NVL(fnd_global.login_id,-1);
202: l_Conc_Request_Id NUMBER:= FND_GLOBAL.Conc_Request_Id;
203: l_Conc_Program_Id NUMBER:= FND_GLOBAL.Conc_Program_Id;
204: l_Prog_Appl_Id NUMBER:=FND_GLOBAL.Prog_Appl_Id;
205:
206: BEGIN
207: RETCODE := 0;
200: l_user_id NUMBER:= NVL(fnd_global.user_id,-1);
201: l_login_id NUMBER:= NVL(fnd_global.login_id,-1);
202: l_Conc_Request_Id NUMBER:= FND_GLOBAL.Conc_Request_Id;
203: l_Conc_Program_Id NUMBER:= FND_GLOBAL.Conc_Program_Id;
204: l_Prog_Appl_Id NUMBER:=FND_GLOBAL.Prog_Appl_Id;
205:
206: BEGIN
207: RETCODE := 0;
208: --Hint added for performance bug#5802537
515: BEGIN
516: ForALL J in 1 .. p_last
517: UPDATE AS_SALES_CREDITS_DENORM
518: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = SYSDATE,
519: LAST_UPDATED_BY = nvl(FND_GLOBAL.User_Id,-1),
520: LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.Login_id,-1),
521: REQUEST_ID = nvl(FND_GLOBAL.Conc_Request_Id,-1),
522: PROGRAM_ID = nvl(FND_GLOBAL.Conc_Program_Id,-1),
523: PROGRAM_APPLICATION_ID = nvl(FND_GLOBAL.Prog_Appl_Id,-1),
516: ForALL J in 1 .. p_last
517: UPDATE AS_SALES_CREDITS_DENORM
518: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = SYSDATE,
519: LAST_UPDATED_BY = nvl(FND_GLOBAL.User_Id,-1),
520: LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.Login_id,-1),
521: REQUEST_ID = nvl(FND_GLOBAL.Conc_Request_Id,-1),
522: PROGRAM_ID = nvl(FND_GLOBAL.Conc_Program_Id,-1),
523: PROGRAM_APPLICATION_ID = nvl(FND_GLOBAL.Prog_Appl_Id,-1),
524: PROGRAM_UPDATE_DATE = SYSDATE,
517: UPDATE AS_SALES_CREDITS_DENORM
518: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = SYSDATE,
519: LAST_UPDATED_BY = nvl(FND_GLOBAL.User_Id,-1),
520: LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.Login_id,-1),
521: REQUEST_ID = nvl(FND_GLOBAL.Conc_Request_Id,-1),
522: PROGRAM_ID = nvl(FND_GLOBAL.Conc_Program_Id,-1),
523: PROGRAM_APPLICATION_ID = nvl(FND_GLOBAL.Prog_Appl_Id,-1),
524: PROGRAM_UPDATE_DATE = SYSDATE,
525: customer_name = scd_customer_name(J),
518: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = SYSDATE,
519: LAST_UPDATED_BY = nvl(FND_GLOBAL.User_Id,-1),
520: LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.Login_id,-1),
521: REQUEST_ID = nvl(FND_GLOBAL.Conc_Request_Id,-1),
522: PROGRAM_ID = nvl(FND_GLOBAL.Conc_Program_Id,-1),
523: PROGRAM_APPLICATION_ID = nvl(FND_GLOBAL.Prog_Appl_Id,-1),
524: PROGRAM_UPDATE_DATE = SYSDATE,
525: customer_name = scd_customer_name(J),
526: competitor_name = scd_competitor_name(J),
519: LAST_UPDATED_BY = nvl(FND_GLOBAL.User_Id,-1),
520: LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.Login_id,-1),
521: REQUEST_ID = nvl(FND_GLOBAL.Conc_Request_Id,-1),
522: PROGRAM_ID = nvl(FND_GLOBAL.Conc_Program_Id,-1),
523: PROGRAM_APPLICATION_ID = nvl(FND_GLOBAL.Prog_Appl_Id,-1),
524: PROGRAM_UPDATE_DATE = SYSDATE,
525: customer_name = scd_customer_name(J),
526: competitor_name = scd_competitor_name(J),
527: owner_person_name = scd_owner_person_name(J),