326:
327:
328:
329: sysdate,
330: nvl(fnd_global.user_id,-1),
331: sysdate,
332: nvl(fnd_global.user_id,-1),
333: nvl(fnd_global.login_id,-1),
334: sc.salesgroup_id,
328:
329: sysdate,
330: nvl(fnd_global.user_id,-1),
331: sysdate,
332: nvl(fnd_global.user_id,-1),
333: nvl(fnd_global.login_id,-1),
334: sc.salesgroup_id,
335: sg.group_name,
336: nvl(sc.salesforce_id,-1),
329: sysdate,
330: nvl(fnd_global.user_id,-1),
331: sysdate,
332: nvl(fnd_global.user_id,-1),
333: nvl(fnd_global.login_id,-1),
334: sc.salesgroup_id,
335: sg.group_name,
336: nvl(sc.salesforce_id,-1),
337: sc.person_id,
378: decode(jrs.category,'EMPLOYEE',jrs.source_first_name,'PARTY',jrs.source_first_name,Null),
379: lead.org_id,
380: nvl(lead.last_update_date,sysdate),
381: nvl(lead.last_updated_by,-1),
382: FND_GLOBAL.Conc_Request_Id,
383: FND_GLOBAL.Conc_Program_Id,
384: FND_GLOBAL.Prog_Appl_Id,
385: sysdate,
386: pr.conversion_status_flag,
379: lead.org_id,
380: nvl(lead.last_update_date,sysdate),
381: nvl(lead.last_updated_by,-1),
382: FND_GLOBAL.Conc_Request_Id,
383: FND_GLOBAL.Conc_Program_Id,
384: FND_GLOBAL.Prog_Appl_Id,
385: sysdate,
386: pr.conversion_status_flag,
387: sc.credit_type_id,
380: nvl(lead.last_update_date,sysdate),
381: nvl(lead.last_updated_by,-1),
382: FND_GLOBAL.Conc_Request_Id,
383: FND_GLOBAL.Conc_Program_Id,
384: FND_GLOBAL.Prog_Appl_Id,
385: sysdate,
386: pr.conversion_status_flag,
387: sc.credit_type_id,
388: ll.quantity,
502: PARALLEL(JRS0) PARALLEL(JRS1) PARALLEL(JRS2) PARALLEL(ORG) PARALLEL(PD)
503: USE_HASH(LEAD, CUST) */
504: sc.sales_credit_id,
505: sysdate,
506: nvl(fnd_global.user_id,-1),
507: sysdate,
508: nvl(fnd_global.user_id,-1),
509: nvl(fnd_global.login_id,-1),
510: sc.salesgroup_id,
504: sc.sales_credit_id,
505: sysdate,
506: nvl(fnd_global.user_id,-1),
507: sysdate,
508: nvl(fnd_global.user_id,-1),
509: nvl(fnd_global.login_id,-1),
510: sc.salesgroup_id,
511: sg.group_name,
512: nvl(sc.salesforce_id,-1),
505: sysdate,
506: nvl(fnd_global.user_id,-1),
507: sysdate,
508: nvl(fnd_global.user_id,-1),
509: nvl(fnd_global.login_id,-1),
510: sc.salesgroup_id,
511: sg.group_name,
512: nvl(sc.salesforce_id,-1),
513: sc.person_id,
550: decode(jrs.category,'EMPLOYEE',jrs.source_first_name,'PARTY',jrs.source_first_name,Null),
551: lead.org_id,
552: nvl(lead.last_update_date,sysdate),
553: nvl(lead.last_updated_by,-1),
554: FND_GLOBAL.Conc_Request_Id,
555: FND_GLOBAL.Conc_Program_Id,
556: FND_GLOBAL.Prog_Appl_Id,
557: sysdate,
558: NULL, --pr.conversion_status_flag,
551: lead.org_id,
552: nvl(lead.last_update_date,sysdate),
553: nvl(lead.last_updated_by,-1),
554: FND_GLOBAL.Conc_Request_Id,
555: FND_GLOBAL.Conc_Program_Id,
556: FND_GLOBAL.Prog_Appl_Id,
557: sysdate,
558: NULL, --pr.conversion_status_flag,
559: sc.credit_type_id,
552: nvl(lead.last_update_date,sysdate),
553: nvl(lead.last_updated_by,-1),
554: FND_GLOBAL.Conc_Request_Id,
555: FND_GLOBAL.Conc_Program_Id,
556: FND_GLOBAL.Prog_Appl_Id,
557: sysdate,
558: NULL, --pr.conversion_status_flag,
559: sc.credit_type_id,
560: ll.quantity,
679: BEGIN
680: ForALL J in 1 .. p_last
681: UPDATE AS_SALES_CREDITS_DENORM
682: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = SYSDATE,
683: LAST_UPDATED_BY = nvl(FND_GLOBAL.User_Id,-1),
684: LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.Login_id,-1),
685: REQUEST_ID = nvl(FND_GLOBAL.Conc_Request_Id,-1),
686: PROGRAM_ID = nvl(FND_GLOBAL.Conc_Program_Id,-1),
687: PROGRAM_APPLICATION_ID = nvl(FND_GLOBAL.Prog_Appl_Id,-1),
680: ForALL J in 1 .. p_last
681: UPDATE AS_SALES_CREDITS_DENORM
682: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = SYSDATE,
683: LAST_UPDATED_BY = nvl(FND_GLOBAL.User_Id,-1),
684: LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.Login_id,-1),
685: REQUEST_ID = nvl(FND_GLOBAL.Conc_Request_Id,-1),
686: PROGRAM_ID = nvl(FND_GLOBAL.Conc_Program_Id,-1),
687: PROGRAM_APPLICATION_ID = nvl(FND_GLOBAL.Prog_Appl_Id,-1),
688: PROGRAM_UPDATE_DATE = SYSDATE,
681: UPDATE AS_SALES_CREDITS_DENORM
682: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = SYSDATE,
683: LAST_UPDATED_BY = nvl(FND_GLOBAL.User_Id,-1),
684: LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.Login_id,-1),
685: REQUEST_ID = nvl(FND_GLOBAL.Conc_Request_Id,-1),
686: PROGRAM_ID = nvl(FND_GLOBAL.Conc_Program_Id,-1),
687: PROGRAM_APPLICATION_ID = nvl(FND_GLOBAL.Prog_Appl_Id,-1),
688: PROGRAM_UPDATE_DATE = SYSDATE,
689: customer_name = scd_customer_name(J),
682: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = SYSDATE,
683: LAST_UPDATED_BY = nvl(FND_GLOBAL.User_Id,-1),
684: LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.Login_id,-1),
685: REQUEST_ID = nvl(FND_GLOBAL.Conc_Request_Id,-1),
686: PROGRAM_ID = nvl(FND_GLOBAL.Conc_Program_Id,-1),
687: PROGRAM_APPLICATION_ID = nvl(FND_GLOBAL.Prog_Appl_Id,-1),
688: PROGRAM_UPDATE_DATE = SYSDATE,
689: customer_name = scd_customer_name(J),
690: competitor_name = scd_competitor_name(J),
683: LAST_UPDATED_BY = nvl(FND_GLOBAL.User_Id,-1),
684: LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.Login_id,-1),
685: REQUEST_ID = nvl(FND_GLOBAL.Conc_Request_Id,-1),
686: PROGRAM_ID = nvl(FND_GLOBAL.Conc_Program_Id,-1),
687: PROGRAM_APPLICATION_ID = nvl(FND_GLOBAL.Prog_Appl_Id,-1),
688: PROGRAM_UPDATE_DATE = SYSDATE,
689: customer_name = scd_customer_name(J),
690: competitor_name = scd_competitor_name(J),
691: owner_person_name = scd_owner_person_name(J),