APPS.AR_CMGT_ACCOUNT_MERGE dependencies on HZ_CUSTOMER_MERGE_LOG

Line 85: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

81: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
82: END LOOP;
83: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
84: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
85: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
86: MERGE_LOG_ID,
87: TABLE_NAME,
88: MERGE_HEADER_ID,
89: PRIMARY_KEY_ID,

Line 101: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

97: CREATION_DATE,
98: LAST_UPDATE_LOGIN,
99: LAST_UPDATE_DATE,
100: LAST_UPDATED_BY
101: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
102: 'AR_CMGT_CASE_FOLDERS',
103: MERGE_HEADER_ID_LIST(I),
104: PRIMARY_KEY_ID_LIST(I),
105: NUM_COL1_ORIG_LIST(I),

Line 237: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

233: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
234: END LOOP;
235: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
236: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
237: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
238: MERGE_LOG_ID,
239: TABLE_NAME,
240: MERGE_HEADER_ID,
241: PRIMARY_KEY_ID,

Line 253: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

249: CREATION_DATE,
250: LAST_UPDATE_LOGIN,
251: LAST_UPDATE_DATE,
252: LAST_UPDATED_BY
253: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
254: 'AR_CMGT_CREDIT_REQUESTS',
255: MERGE_HEADER_ID_LIST(I),
256: PRIMARY_KEY_ID_LIST(I),
257: NUM_COL1_ORIG_LIST(I),

Line 530: arp_message.set_line( 'Inserting into HZ_CUSTOMER_MERGE_LOG');

526: arp_message.set_line( 'NUM_COL1_NEW_LIST(I)='||NUM_COL1_NEW_LIST(I));
527: arp_message.set_line( 'NUM_COL2_NEW_LIST(I)='||NUM_COL2_NEW_LIST(I));
528: END LOOP;
529: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
530: arp_message.set_line( 'Inserting into HZ_CUSTOMER_MERGE_LOG');
531: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
532: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
533: MERGE_LOG_ID,
534: TABLE_NAME,

Line 532: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

528: END LOOP;
529: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
530: arp_message.set_line( 'Inserting into HZ_CUSTOMER_MERGE_LOG');
531: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
532: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
533: MERGE_LOG_ID,
534: TABLE_NAME,
535: MERGE_HEADER_ID,
536: PRIMARY_KEY1,

Line 578: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

574: CREATION_DATE,
575: LAST_UPDATE_LOGIN,
576: LAST_UPDATE_DATE,
577: LAST_UPDATED_BY
578: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
579: 'AR_TRX_BAL_SUMMARY',
580: MERGE_HEADER_ID_LIST(I),
581: PRIMARY_KEY1_LIST(I),
582: PRIMARY_KEY2_LIST(I),

Line 625: arp_message.set_line( 'after Insert into HZ_CUSTOMER_MERGE_LOG');

621: hz_utility_pub.LAST_UPDATE_DATE,
622: hz_utility_pub.LAST_UPDATED_BY
623: );
624:
625: arp_message.set_line( 'after Insert into HZ_CUSTOMER_MERGE_LOG');
626: END IF;
627: arp_message.set_line( 'before UPDATE AR_TRX_BAL_SUMMARY ');
628: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
629: UPDATE AR_TRX_BAL_SUMMARY yt SET

Line 1089: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1085:
1086: END LOOP;
1087: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1088: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1089: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1090: MERGE_LOG_ID,
1091: TABLE_NAME,
1092: MERGE_HEADER_ID,
1093: PRIMARY_KEY1,

Line 1143: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

1139: CREATION_DATE,
1140: LAST_UPDATE_LOGIN,
1141: LAST_UPDATE_DATE,
1142: LAST_UPDATED_BY
1143: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1144: 'AR_TRX_SUMMARY',
1145: MERGE_HEADER_ID_LIST(I),
1146: PRIMARY_KEY1_LIST(I),
1147: PRIMARY_KEY2_LIST(I),