[Home] [Help]
143:
144: IF g_profile_val IS NOT NULL AND g_profile_val = 'Y' THEN
145:
146: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
147: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
148: MERGE_LOG_ID,
149: TABLE_NAME,
150: MERGE_HEADER_ID,
151: PRIMARY_KEY_ID,
158: LAST_UPDATE_LOGIN,
159: LAST_UPDATE_DATE,
160: LAST_UPDATED_BY
161: ) VALUES (
162: HZ_CUSTOMER_MERGE_LOG_s.nextval,
163: 'JTF_TASKS_B',
164: MERGE_HEADER_ID_LIST(I),
165: PRIMARY_KEY_ID_LIST(I),
166: NUM_COL1_ORIG_LIST(I),
278:
279: IF g_profile_val IS NOT NULL AND g_profile_val = 'Y' THEN
280:
281: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
282: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
283: MERGE_LOG_ID,
284: TABLE_NAME,
285: MERGE_HEADER_ID,
286: PRIMARY_KEY_ID,
295: LAST_UPDATE_LOGIN,
296: LAST_UPDATE_DATE,
297: LAST_UPDATED_BY
298: ) VALUES (
299: HZ_CUSTOMER_MERGE_LOG_s.nextval,
300: 'JTF_TASK_AUDITS_B',
301: MERGE_HEADER_ID_LIST(I),
302: PRIMARY_KEY_ID_LIST(I),
303: NUM_COL1_ORIG_LIST(I),
428:
429: IF g_profile_val IS NOT NULL AND g_profile_val = 'Y' THEN
430: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
431: -- Log account id
432: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
433: MERGE_LOG_ID,
434: TABLE_NAME,
435: MERGE_HEADER_ID,
436: PRIMARY_KEY_ID,
443: LAST_UPDATE_LOGIN,
444: LAST_UPDATE_DATE,
445: LAST_UPDATED_BY
446: ) VALUES (
447: HZ_CUSTOMER_MERGE_LOG_s.nextval,
448: 'JTF_PERZ_QUERY_PARAM',
449: MERGE_HEADER_ID_LIST(I),
450: PRIMARY_KEY_ID1_LIST(I),
451: VCHAR_COL1_ORIG_LIST(I),
460: );
461:
462: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
463: -- Log account number
464: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
465: MERGE_LOG_ID,
466: TABLE_NAME,
467: MERGE_HEADER_ID,
468: PRIMARY_KEY_ID,
475: LAST_UPDATE_LOGIN,
476: LAST_UPDATE_DATE,
477: LAST_UPDATED_BY
478: ) VALUES (
479: HZ_CUSTOMER_MERGE_LOG_s.nextval,
480: 'JTF_PERZ_QUERY_PARAM',
481: MERGE_HEADER_ID_LIST(I),
482: PRIMARY_KEY_ID2_LIST(I),
483: VCHAR_CN_ORIG_LIST(I),