APPS.WSH_CUST_MERGE dependencies on HZ_CUSTOMER_MERGE_LOG

Line 124: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

120: --
121:
122: -- Insert into Hz_Log_Table
123: FORALL InsCnt in p_id_tab.FIRST..p_id_tab.LAST
124: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
125: MERGE_LOG_ID,
126: TABLE_NAME,
127: MERGE_HEADER_ID,
128: PRIMARY_KEY_ID,

Line 147: HZ_CUSTOMER_MERGE_LOG_S.NextVal,

143: LAST_UPDATE_LOGIN,
144: LAST_UPDATE_DATE,
145: LAST_UPDATED_BY )
146: VALUES (
147: HZ_CUSTOMER_MERGE_LOG_S.NextVal,
148: p_table_name,
149: G_MERGE_HEADER_ID,
150: p_id_tab(insCnt),
151: G_FROM_CUSTOMER_ID,

Line 170: setARMessageRowCount( 'HZ_CUSTOMER_MERGE_LOG', SQL%ROWCOUNT );

166: HZ_UTILITY_PUB.Last_Update_Date,
167: HZ_UTILITY_PUB.Last_Updated_By );
168:
169: --
170: setARMessageRowCount( 'HZ_CUSTOMER_MERGE_LOG', SQL%ROWCOUNT );
171:
172: --
173: IF l_debug_on THEN
174: arp_message.set_line('WSH_CUST_MERGE.Insert_Log_Table()+' || getTimeStamp );

Line 3381: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

3377: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
3378: END LOOP;
3379: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3380: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3381: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
3382: MERGE_LOG_ID,
3383: TABLE_NAME,
3384: MERGE_HEADER_ID,
3385: PRIMARY_KEY_ID,

Line 3395: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

3391: CREATION_DATE,
3392: LAST_UPDATE_LOGIN,
3393: LAST_UPDATE_DATE,
3394: LAST_UPDATED_BY
3395: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
3396: 'WSH_PICKING_BATCHES',
3397: MERGE_HEADER_ID_LIST(I),
3398: PRIMARY_KEY_ID_LIST(I),
3399: NUM_COL1_ORIG_LIST(I),

Line 3527: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

3523: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
3524: END LOOP;
3525: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3526: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3527: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
3528: MERGE_LOG_ID,
3529: TABLE_NAME,
3530: MERGE_HEADER_ID,
3531: PRIMARY_KEY_ID,

Line 3543: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

3539: CREATION_DATE,
3540: LAST_UPDATE_LOGIN,
3541: LAST_UPDATE_DATE,
3542: LAST_UPDATED_BY
3543: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
3544: 'WSH_CALENDAR_ASSIGNMENTS',
3545: MERGE_HEADER_ID_LIST(I),
3546: PRIMARY_KEY_ID_LIST(I),
3547: NUM_COL1_ORIG_LIST(I),

Line 3674: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

3670: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
3671: END LOOP;
3672: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3673: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3674: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
3675: MERGE_LOG_ID,
3676: TABLE_NAME,
3677: MERGE_HEADER_ID,
3678: PRIMARY_KEY_ID,

Line 3688: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

3684: CREATION_DATE,
3685: LAST_UPDATE_LOGIN,
3686: LAST_UPDATE_DATE,
3687: LAST_UPDATED_BY
3688: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
3689: 'WSH_PICKING_RULES',
3690: MERGE_HEADER_ID_LIST(I),
3691: PRIMARY_KEY_ID_LIST(I),
3692: NUM_COL1_ORIG_LIST(I),