eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_MERGE_PVT dependencies on HZ_CUSTOMER_MERGE_LOG

Line 178: insert into HZ_CUSTOMER_MERGE_LOG (MERGE_LOG_ID, TABLE_NAME,

174:
175: --fix 2899235: do not transfer exp chkout setting
176: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
177: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
178: insert into HZ_CUSTOMER_MERGE_LOG (MERGE_LOG_ID, TABLE_NAME,
179: MERGE_HEADER_ID,request_id,PRIMARY_KEY_ID,DEL_COL1,DEL_COL2,DEL_COL3,
180: DEL_COL4,DEL_COL5,DEL_COL6,DEL_COL7,DEL_COL8,DEL_COL9,DEL_COL10,DEL_COL11,DEL_COL12,
181: DEL_COL13,DEL_COL14,DEL_COL15,DEL_COL16,DEL_COL17,DEL_COL18,DEL_COL19,DEL_COL20,DEL_COL21,
182: DEL_COL22,DEL_COL23,DEL_COL24,DEL_COL25,DEL_COL26,DEL_COL27,DEL_COL28,DEL_COL29,DEL_COL30,

Line 184: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ORD_ONECLICK_ALL',MERGE_HEADER_ID_LIST(I)

180: DEL_COL4,DEL_COL5,DEL_COL6,DEL_COL7,DEL_COL8,DEL_COL9,DEL_COL10,DEL_COL11,DEL_COL12,
181: DEL_COL13,DEL_COL14,DEL_COL15,DEL_COL16,DEL_COL17,DEL_COL18,DEL_COL19,DEL_COL20,DEL_COL21,
182: DEL_COL22,DEL_COL23,DEL_COL24,DEL_COL25,DEL_COL26,DEL_COL27,DEL_COL28,DEL_COL29,DEL_COL30,
183: DEL_COL31,DEL_COL32,DEL_COL33,DEL_COL34,DEL_COL35,ACTION_FLAG,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY)
184: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ORD_ONECLICK_ALL',MERGE_HEADER_ID_LIST(I)
185: ,req_id,ORD_ONECLICK_ID,OBJECT_VERSION_NUMBER, CUST_ACCOUNT_ID, PARTY_ID, CREATED_BY, CREATION_DATE,
186: LAST_UPDATED_BY,LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ENABLED_FLAG, FREIGHT_CODE, PAYMENT_ID,
187: BILL_TO_PTY_SITE_ID, SHIP_TO_PTY_SITE_ID,ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
188: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11,

Line 319: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

315: WHERE SHP_LIST_ID=PRIMARY_KEY_ID_LIST(I);
316:
317: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
318: --if logging profile is ON, log data
319: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
320: MERGE_LOG_ID,
321: TABLE_NAME,
322: MERGE_HEADER_ID,
323: PRIMARY_KEY_ID,

Line 335: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

331: CREATION_DATE,
332: LAST_UPDATE_LOGIN,
333: LAST_UPDATE_DATE,
334: LAST_UPDATED_BY
335: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
336: 'IBE_SH_SHP_LISTS_ALL',
337: MERGE_HEADER_ID_LIST(I),
338: PRIMARY_KEY_ID_LIST(I),
339: NUM_COL1_ORIG_LIST(I),

Line 455: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

451: where quote_header_id = l_from_quote_id
452: AND quote_name = 'IBE_PRMT_SC_UNNAMED';
453: --check profile, log when it's ON
454: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
455: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
456: MERGE_LOG_ID,TABLE_NAME,MERGE_HEADER_ID,PRIMARY_KEY_ID,
457: VCHAR_COL1_ORIG,VCHAR_COL1_NEW,ACTION_FLAG,REQUEST_ID,CREATED_BY,
458: CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY
459: ) VALUES (

Line 460: HZ_CUSTOMER_MERGE_LOG_s.nextval,'ASO_QUOTE_HEADERS_ALL',

456: MERGE_LOG_ID,TABLE_NAME,MERGE_HEADER_ID,PRIMARY_KEY_ID,
457: VCHAR_COL1_ORIG,VCHAR_COL1_NEW,ACTION_FLAG,REQUEST_ID,CREATED_BY,
458: CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY
459: ) VALUES (
460: HZ_CUSTOMER_MERGE_LOG_s.nextval,'ASO_QUOTE_HEADERS_ALL',
461: l_customer_merge_id,l_from_quote_id,'IBE_PRMT_SC_UNNAMED','IBE_PRMT_SC_DEFAULTNAMED',
462: 'U',req_id,hz_utility_pub.CREATED_BY,
463: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,
464: hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY

Line 470: insert into HZ_CUSTOMER_MERGE_LOG (MERGE_LOG_ID, TABLE_NAME,

466: end if;
467:
468: --log data when audit profile is On
469: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
470: insert into HZ_CUSTOMER_MERGE_LOG (MERGE_LOG_ID, TABLE_NAME,
471: MERGE_HEADER_ID,request_id,PRIMARY_KEY_ID,DEL_COL1,DEL_COL2,DEL_COL3,
472: DEL_COL4,DEL_COL5,DEL_COL6,DEL_COL7,DEL_COL8,DEL_COL9,DEL_COL10,DEL_COL11,ACTION_FLAG,
473: CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY)
474: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ACTIVE_QUOTES_ALL',l_customer_merge_id

Line 474: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ACTIVE_QUOTES_ALL',l_customer_merge_id

470: insert into HZ_CUSTOMER_MERGE_LOG (MERGE_LOG_ID, TABLE_NAME,
471: MERGE_HEADER_ID,request_id,PRIMARY_KEY_ID,DEL_COL1,DEL_COL2,DEL_COL3,
472: DEL_COL4,DEL_COL5,DEL_COL6,DEL_COL7,DEL_COL8,DEL_COL9,DEL_COL10,DEL_COL11,ACTION_FLAG,
473: CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY)
474: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ACTIVE_QUOTES_ALL',l_customer_merge_id
475: ,req_id,ACTIVE_QUOTE_ID,PARTY_ID,CUST_ACCOUNT_ID,ORG_ID,CREATED_BY,CREATION_DATE
476: ,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_VERSION_NUMBER,LAST_UPDATE_LOGIN
477: ,SECURITY_GROUP_ID,QUOTE_HEADER_ID,'D',hz_utility_pub.CREATED_BY,hz_utility_pub.CREATION_DATE,
478: hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,hz_utility_pub.LAST_UPDATED_BY

Line 632: insert into HZ_CUSTOMER_MERGE_LOG (

628: delete IBE_SH_QUOTE_ACCESS
629: where quote_header_id = l_from_quote_id
630: and cust_account_id = l_from_acct_id;
631: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
632: insert into HZ_CUSTOMER_MERGE_LOG (
633: MERGE_LOG_ID, TABLE_NAME,MERGE_HEADER_ID,PRIMARY_KEY_ID,
634: DEL_COL1,DEL_COL2,DEL_COL3,DEL_COL4,DEL_COL5,DEL_COL6,DEL_COL7,DEL_COL8,
635: DEL_COL9,DEL_COL10,DEL_COL11,DEL_COL12,DEL_COL13,DEL_COL14,DEL_COL15,
636: DEL_COL16,DEL_COL17,DEL_COL18,DEL_COL19,DEL_COL20,ACTION_FLAG,

Line 640: HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,

636: DEL_COL16,DEL_COL17,DEL_COL18,DEL_COL19,DEL_COL20,ACTION_FLAG,
637: REQUEST_ID,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,
638: LAST_UPDATED_BY)
639: values(
640: HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,
641: l_from_quote_sharee_id,l_request_id,l_program_application_id,l_program_id,
642: l_program_update_date,l_object_version_number,l_created_by,l_creation_date,
643: l_last_updated_by,l_last_update_date,l_last_update_login,l_quote_header_id,
644: l_quote_sharee_number,l_update_privilege_type_code,l_security_group_id,l_party_id,

Line 665: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

661: end if;
662: --debug: need TCA profile for test
663: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
664:
665: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
666: MERGE_LOG_ID,TABLE_NAME,MERGE_HEADER_ID,PRIMARY_KEY_ID,NUM_COL1_ORIG,NUM_COL1_NEW,
667: NUM_COL2_ORIG,NUM_COL2_NEW,ACTION_FLAG,REQUEST_ID,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
668: LAST_UPDATE_DATE,LAST_UPDATED_BY
669: ) VALUES (

Line 670: HZ_CUSTOMER_MERGE_LOG_s.nextval,

666: MERGE_LOG_ID,TABLE_NAME,MERGE_HEADER_ID,PRIMARY_KEY_ID,NUM_COL1_ORIG,NUM_COL1_NEW,
667: NUM_COL2_ORIG,NUM_COL2_NEW,ACTION_FLAG,REQUEST_ID,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
668: LAST_UPDATE_DATE,LAST_UPDATED_BY
669: ) VALUES (
670: HZ_CUSTOMER_MERGE_LOG_s.nextval,
671: 'IBE_SH_QUOTE_ACCESS',l_customer_merge_header_id,l_from_quote_sharee_id,l_from_acct_id,
672: l_to_acct_id, l_from_party_id, l_to_party_id,'U',req_id,hz_utility_pub.CREATED_BY,
673: hz_utility_pub.CREATION_DATE,hz_utility_pub.LAST_UPDATE_LOGIN,hz_utility_pub.LAST_UPDATE_DATE,
674: hz_utility_pub.LAST_UPDATED_BY