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 3378: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

Line 3392: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

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

Line 3524: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

Line 3540: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

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

Line 3671: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

Line 3685: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

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