[Home] [Help]
140: END LOOP;
141:
142: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
143: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
144: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
145: MERGE_LOG_ID,
146: TABLE_NAME,
147: MERGE_HEADER_ID,
148: PRIMARY_KEY_ID,
158: CREATION_DATE,
159: LAST_UPDATE_LOGIN,
160: LAST_UPDATE_DATE,
161: LAST_UPDATED_BY
162: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
163: 'ASO_QUOTE_HEADERS',
164: MERGE_HEADER_ID_LIST(I),
165: PRIMARY_KEY_ID_LIST(I),
166: NUM_COL1_ORIG_LIST(I),
335: END LOOP;
336:
337: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
338: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
339: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
340: MERGE_LOG_ID,
341: TABLE_NAME,
342: MERGE_HEADER_ID,
343: PRIMARY_KEY_ID,
351: CREATION_DATE,
352: LAST_UPDATE_LOGIN,
353: LAST_UPDATE_DATE,
354: LAST_UPDATED_BY
355: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
356: 'ASO_QUOTE_LINES',
357: MERGE_HEADER_ID_LIST(I),
358: PRIMARY_KEY_ID_LIST(I),
359: NUM_COL1_ORIG_LIST(I),
500: END LOOP;
501:
502: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
503: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
504: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
505: MERGE_LOG_ID,
506: TABLE_NAME,
507: MERGE_HEADER_ID,
508: PRIMARY_KEY_ID,
514: CREATION_DATE,
515: LAST_UPDATE_LOGIN,
516: LAST_UPDATE_DATE,
517: LAST_UPDATED_BY
518: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
519: 'ASO_SHIPMENTS',
520: MERGE_HEADER_ID_LIST(I),
521: PRIMARY_KEY_ID_LIST(I),
522: NUM_COL1_ORIG_LIST(I),