DBA Data[Home] [Help]

APPS.POP_CMERGE_REQ dependencies on HZ_CUSTOMER_MERGE_LOG

Line 208: into the HZ_CUSTOMER_MERGE_LOG table.

204: END LOOP;
205:
206: /*
207: If auditing has been enabled, insert the changed records
208: into the HZ_CUSTOMER_MERGE_LOG table.
209: */
210: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
211: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
212: INSERT INTO HZ_CUSTOMER_MERGE_LOG(

Line 212: INSERT INTO HZ_CUSTOMER_MERGE_LOG(

208: into the HZ_CUSTOMER_MERGE_LOG table.
209: */
210: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
211: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
212: INSERT INTO HZ_CUSTOMER_MERGE_LOG(
213: MERGE_LOG_ID,
214: TABLE_NAME,
215: MERGE_HEADER_ID,
216: PRIMARY_KEY_ID,

Line 227: HZ_CUSTOMER_MERGE_LOG_s.nextval,

223: LAST_UPDATE_LOGIN,
224: LAST_UPDATE_DATE,
225: LAST_UPDATED_BY)
226: VALUES(
227: HZ_CUSTOMER_MERGE_LOG_s.nextval,
228: 'PO_REQUISITION_LINES',
229: MERGE_HEADER_ID_LIST(I),
230: PRIMARY_KEY_ID_LIST(I),
231: NUM_COL1_ORIG_LIST(I),

Line 644: into the HZ_CUSTOMER_MERGE_LOG table.

640: END LOOP;
641:
642: /*
643: If auditing has been enabled, insert the changed records
644: into the HZ_CUSTOMER_MERGE_LOG table.
645: */
646: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
647: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
648: INSERT INTO HZ_CUSTOMER_MERGE_LOG(

Line 648: INSERT INTO HZ_CUSTOMER_MERGE_LOG(

644: into the HZ_CUSTOMER_MERGE_LOG table.
645: */
646: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
647: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
648: INSERT INTO HZ_CUSTOMER_MERGE_LOG(
649: MERGE_LOG_ID,
650: TABLE_NAME,
651: MERGE_HEADER_ID,
652: PRIMARY_KEY_ID,

Line 685: HZ_CUSTOMER_MERGE_LOG_s.nextval,

681: LAST_UPDATE_LOGIN,
682: LAST_UPDATE_DATE,
683: LAST_UPDATED_BY)
684: VALUES(
685: HZ_CUSTOMER_MERGE_LOG_s.nextval,
686: 'PO_LOCATION_ASSOCIATIONS',
687: MERGE_HEADER_ID_LIST(I),
688: PRIMARY_KEY_ID_LIST(I),
689: NUM_COL1_ORIG_LIST(I),

Line 825: into the HZ_CUSTOMER_MERGE_LOG table.

821: END LOOP;
822:
823: /*
824: If auditing has been enabled, insert the changed records
825: into the HZ_CUSTOMER_MERGE_LOG table.
826: */
827: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
828: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
829: INSERT INTO HZ_CUSTOMER_MERGE_LOG(

Line 829: INSERT INTO HZ_CUSTOMER_MERGE_LOG(

825: into the HZ_CUSTOMER_MERGE_LOG table.
826: */
827: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
828: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
829: INSERT INTO HZ_CUSTOMER_MERGE_LOG(
830: MERGE_LOG_ID,
831: TABLE_NAME,
832: MERGE_HEADER_ID,
833: PRIMARY_KEY_ID,

Line 846: HZ_CUSTOMER_MERGE_LOG_s.nextval,

842: LAST_UPDATE_LOGIN,
843: LAST_UPDATE_DATE,
844: LAST_UPDATED_BY)
845: VALUES(
846: HZ_CUSTOMER_MERGE_LOG_s.nextval,
847: 'PO_LOCATION_ASSOCIATIONS',
848: MERGE_HEADER_ID_LIST(I),
849: PRIMARY_KEY_ID_LIST(I),
850: NUM_COL1_ORIG_LIST(I),