DBA Data[Home] [Help]

APPS.ASO_MERGE_PVT dependencies on HZ_CUSTOMER_MERGE_LOG

Line 145: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

141: END LOOP;
142:
143: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
144: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
145: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
146: MERGE_LOG_ID,
147: TABLE_NAME,
148: MERGE_HEADER_ID,
149: PRIMARY_KEY_ID,

Line 163: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

159: CREATION_DATE,
160: LAST_UPDATE_LOGIN,
161: LAST_UPDATE_DATE,
162: LAST_UPDATED_BY
163: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
164: 'ASO_QUOTE_HEADERS',
165: MERGE_HEADER_ID_LIST(I),
166: PRIMARY_KEY_ID_LIST(I),
167: NUM_COL1_ORIG_LIST(I),

Line 340: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

336: END LOOP;
337:
338: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
339: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
340: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
341: MERGE_LOG_ID,
342: TABLE_NAME,
343: MERGE_HEADER_ID,
344: PRIMARY_KEY_ID,

Line 356: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

352: CREATION_DATE,
353: LAST_UPDATE_LOGIN,
354: LAST_UPDATE_DATE,
355: LAST_UPDATED_BY
356: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
357: 'ASO_QUOTE_LINES',
358: MERGE_HEADER_ID_LIST(I),
359: PRIMARY_KEY_ID_LIST(I),
360: NUM_COL1_ORIG_LIST(I),

Line 505: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

501: END LOOP;
502:
503: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
504: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
505: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
506: MERGE_LOG_ID,
507: TABLE_NAME,
508: MERGE_HEADER_ID,
509: PRIMARY_KEY_ID,

Line 519: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

515: CREATION_DATE,
516: LAST_UPDATE_LOGIN,
517: LAST_UPDATE_DATE,
518: LAST_UPDATED_BY
519: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
520: 'ASO_SHIPMENTS',
521: MERGE_HEADER_ID_LIST(I),
522: PRIMARY_KEY_ID_LIST(I),
523: NUM_COL1_ORIG_LIST(I),