[Home] [Help]
364: IF NOT not_found_flag THEN
365: /*Added for Tca audit */
366: IF g_audit_profile='Y' THEN
367:
368: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
369: MERGE_LOG_ID,
370: TABLE_NAME,
371: MERGE_HEADER_ID,
372: PRIMARY_KEY1,
403: DEL_COL23,
404: DEL_COL24 -- FP_M Changes
405: )
406: ( SELECT
407: HZ_CUSTOMER_MERGE_LOG_s.nextval,
408: 'PA_PROJECT_CUSTOMERS',
409: RACM.CUSTOMER_MERGE_HEADER_ID,
410: var_project_id,
411: new_customer_id,
461: --
462: /*Added for Tca audit */
463: IF g_audit_profile='Y' THEN
464:
465: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
466: MERGE_LOG_ID,
467: TABLE_NAME,
468: MERGE_HEADER_ID,
469: PRIMARY_KEY1,
478: LAST_UPDATE_DATE,
479: LAST_UPDATED_BY
480: )
481: ( SELECT
482: HZ_CUSTOMER_MERGE_LOG_s.nextval,
483: 'PA_PROJECT_CUSTOMERS',
484: RACM.CUSTOMER_MERGE_HEADER_ID,
485: PC.project_id,
486: PC.customer_id,
534:
535: /*Added for tca audit*/
536: IF g_audit_profile='Y' THEN
537:
538: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
539: MERGE_LOG_ID,
540: TABLE_NAME,
541: MERGE_HEADER_ID,
542: PRIMARY_KEY1,
550: LAST_UPDATE_LOGIN,
551: LAST_UPDATE_DATE,
552: LAST_UPDATED_BY)
553: ( SELECT
554: HZ_CUSTOMER_MERGE_LOG_s.nextval,
555: 'PA_PROJECT_CUSTOMERS',
556: RACM.CUSTOMER_MERGE_HEADER_ID,
557: PC.project_id,
558: PC.customer_id,
601: -- update pa_project_customers table for customer_id and ship_to_address_id.
602: --
603: IF g_audit_profile='Y' THEN
604:
605: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
606: MERGE_LOG_ID,
607: TABLE_NAME,
608: MERGE_HEADER_ID,
609: PRIMARY_KEY1,
617: LAST_UPDATE_LOGIN,
618: LAST_UPDATE_DATE,
619: LAST_UPDATED_BY)
620: ( SELECT
621: HZ_CUSTOMER_MERGE_LOG_s.nextval,
622: 'PA_PROJECT_CUSTOMERS',
623: RACM.CUSTOMER_MERGE_HEADER_ID,
624: PC.project_id,
625: PC.customer_id,
667: /*For customer account relation enhancement*/
668:
669: IF g_audit_profile='Y' THEN
670:
671: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
672: MERGE_LOG_ID,
673: TABLE_NAME,
674: MERGE_HEADER_ID,
675: PRIMARY_KEY1,
683: LAST_UPDATE_LOGIN,
684: LAST_UPDATE_DATE,
685: LAST_UPDATED_BY)
686: ( SELECT
687: HZ_CUSTOMER_MERGE_LOG_s.nextval,
688: 'PA_PROJECT_CUSTOMERS',
689: RACM.CUSTOMER_MERGE_HEADER_ID,
690: PC.project_id,
691: PC.customer_id,
726: AND PC.CUSTOMER_ID = var_customer_id;
727:
728: IF g_audit_profile='Y' THEN
729:
730: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
731: MERGE_LOG_ID,
732: TABLE_NAME,
733: MERGE_HEADER_ID,
734: PRIMARY_KEY1,
742: LAST_UPDATE_LOGIN,
743: LAST_UPDATE_DATE,
744: LAST_UPDATED_BY)
745: ( SELECT
746: HZ_CUSTOMER_MERGE_LOG_s.nextval,
747: 'PA_PROJECT_CUSTOMERS',
748: RACM.CUSTOMER_MERGE_HEADER_ID,
749: PC.project_id,
750: PC.customer_id,
790: --
791:
792: IF g_audit_profile='Y' THEN
793:
794: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
795: MERGE_LOG_ID,
796: TABLE_NAME,
797: MERGE_HEADER_ID,
798: PRIMARY_KEY1,
805: CREATION_DATE,
806: LAST_UPDATE_LOGIN,
807: LAST_UPDATE_DATE,
808: LAST_UPDATED_BY)
809: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
810: 'PA_PROJECT_CUSTOMERS',
811: RACM.CUSTOMER_MERGE_HEADER_ID,
812: PC.project_id,
813: RACM.CUSTOMER_ID,
870: -- update log file to indicate the table being updated.
871: --
872: IF g_audit_profile='Y' THEN
873:
874: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
875: MERGE_LOG_ID,
876: TABLE_NAME,
877: MERGE_HEADER_ID,
878: PRIMARY_KEY1,
887: LAST_UPDATE_DATE,
888: LAST_UPDATED_BY
889: )
890: (SELECT
891: HZ_CUSTOMER_MERGE_LOG_S.nextval,
892: 'PA_DRAFT_INVOICES_ALL',
893: RACM.CUSTOMER_MERGE_HEADER_ID,
894: PDI.PROJECT_ID,
895: PDI.DRAFT_INVOICE_NUM,
930: AND RACM.SET_NUMBER = set_no );
931:
932: IF g_audit_profile='Y' THEN
933:
934: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
935: MERGE_LOG_ID,
936: TABLE_NAME,
937: MERGE_HEADER_ID,
938: PRIMARY_KEY1,
947: LAST_UPDATE_DATE,
948: LAST_UPDATED_BY
949: )
950: (SELECT
951: HZ_CUSTOMER_MERGE_LOG_S.nextval,
952: 'PA_DRAFT_INVOICES_ALL',
953: RACM.CUSTOMER_MERGE_HEADER_ID,
954: PDI.PROJECT_ID,
955: PDI.DRAFT_INVOICE_NUM,
990: AND RACM.SET_NUMBER = set_no );
991:
992: IF g_audit_profile='Y' THEN
993:
994: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
995: MERGE_LOG_ID,
996: TABLE_NAME,
997: MERGE_HEADER_ID,
998: PRIMARY_KEY1,
1007: LAST_UPDATE_DATE,
1008: LAST_UPDATED_BY
1009: )
1010: (SELECT
1011: HZ_CUSTOMER_MERGE_LOG_S.nextval,
1012: 'PA_DRAFT_INVOICES_ALL',
1013: RACM.CUSTOMER_MERGE_HEADER_ID,
1014: PDI.PROJECT_ID,
1015: PDI.DRAFT_INVOICE_NUM,
1051:
1052:
1053: IF g_audit_profile='Y' THEN
1054:
1055: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1056: MERGE_LOG_ID,
1057: TABLE_NAME,
1058: MERGE_HEADER_ID,
1059: PRIMARY_KEY1,
1068: LAST_UPDATE_DATE,
1069: LAST_UPDATED_BY
1070: )
1071: (SELECT
1072: HZ_CUSTOMER_MERGE_LOG_S.nextval,
1073: 'PA_DRAFT_INVOICES_ALL',
1074: RACM.CUSTOMER_MERGE_HEADER_ID,
1075: PDI.PROJECT_ID,
1076: PDI.DRAFT_INVOICE_NUM,
1112: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' );
1113:
1114: IF g_audit_profile='Y' THEN
1115:
1116: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1117: MERGE_LOG_ID,
1118: TABLE_NAME,
1119: MERGE_HEADER_ID,
1120: PRIMARY_KEY1,
1129: LAST_UPDATE_DATE,
1130: LAST_UPDATED_BY
1131: )
1132: (SELECT
1133: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1134: 'PA_DRAFT_INVOICES_ALL',
1135: RACM.CUSTOMER_MERGE_HEADER_ID,
1136: PDI.PROJECT_ID,
1137: PDI.DRAFT_INVOICE_NUM,
1178: -- update pa_draft_invoice_items for ship_to_address_id only.
1179: --
1180: IF g_audit_profile='Y' THEN
1181:
1182: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1183: MERGE_LOG_ID,
1184: TABLE_NAME,
1185: MERGE_HEADER_ID,
1186: PRIMARY_KEY1,
1194: CREATION_DATE,
1195: LAST_UPDATE_LOGIN,
1196: LAST_UPDATE_DATE,
1197: LAST_UPDATED_BY)
1198: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1199: 'PA_DRAFT_INVOICE_ITEMS',
1200: RACM.CUSTOMER_MERGE_HEADER_ID,
1201: PDII.project_id,
1202: PDII.draft_invoice_num,
1251: -- update pa_tasks for address_id ( ship address id ).
1252: --
1253: IF g_audit_profile='Y' THEN
1254:
1255: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1256: MERGE_LOG_ID,
1257: TABLE_NAME,
1258: MERGE_HEADER_ID,
1259: PRIMARY_KEY_ID,
1267: CREATION_DATE,
1268: LAST_UPDATE_LOGIN,
1269: LAST_UPDATE_DATE,
1270: LAST_UPDATED_BY)
1271: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1272: 'PA_TASKS',
1273: RACM.CUSTOMER_MERGE_HEADER_ID,
1274: PT.TASK_ID,
1275: PT. address_id,
1322: -- update pa_implementations for customer_id (duplicate_id ).
1323: --
1324: IF g_audit_profile='Y' THEN
1325:
1326: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1327: MERGE_LOG_ID,
1328: TABLE_NAME,
1329: MERGE_HEADER_ID,
1330: PRIMARY_KEY_ID,
1336: CREATION_DATE,
1337: LAST_UPDATE_LOGIN,
1338: LAST_UPDATE_DATE,
1339: LAST_UPDATED_BY)
1340: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1341: 'PA_IMPLEMENTATIONS_ALL',
1342: RACM.CUSTOMER_MERGE_HEADER_ID,
1343: PI.ORG_ID,
1344: PI.CUSTOMER_ID,
1393: -- update pa_proj_retn_rules for customer_id (duplicate_id ).
1394:
1395: IF g_audit_profile='Y' THEN
1396:
1397: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1398: MERGE_LOG_ID,
1399: TABLE_NAME,
1400: MERGE_HEADER_ID,
1401: PRIMARY_KEY_ID,
1407: CREATION_DATE,
1408: LAST_UPDATE_LOGIN,
1409: LAST_UPDATE_DATE,
1410: LAST_UPDATED_BY)
1411: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1412: 'PA_PROJ_RETN_RULES',
1413: RACM.CUSTOMER_MERGE_HEADER_ID,
1414: PR.RETENTION_RULE_ID,
1415: PR.CUSTOMER_ID,
1471: -- update pa_proj_retn_bill_rules for customer_id (duplicate_id ).
1472: --
1473: IF g_audit_profile='Y' THEN
1474:
1475: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1476: MERGE_LOG_ID,
1477: TABLE_NAME,
1478: MERGE_HEADER_ID,
1479: PRIMARY_KEY_ID,
1485: CREATION_DATE,
1486: LAST_UPDATE_LOGIN,
1487: LAST_UPDATE_DATE,
1488: LAST_UPDATED_BY)
1489: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1490: 'PA_PROJ_RETN_BILL_RULES',
1491: RACM.CUSTOMER_MERGE_HEADER_ID,
1492: PB. RETN_BILLING_RULE_ID,
1493: PB.CUSTOMER_ID,
1549: -- update pa_summary_project_retn for customer_id (duplicate_id ).
1550: --
1551: IF g_audit_profile='Y' THEN
1552:
1553: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1554: MERGE_LOG_ID,
1555: TABLE_NAME,
1556: MERGE_HEADER_ID,
1557: PRIMARY_KEY1,
1565: CREATION_DATE,
1566: LAST_UPDATE_LOGIN,
1567: LAST_UPDATE_DATE,
1568: LAST_UPDATED_BY)
1569: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1570: 'PA_SUMMARY_PROJECT_RETN',
1571: RACM.CUSTOMER_MERGE_HEADER_ID,
1572: PS.PROJECT_ID,
1573: PS.TASK_ID,