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.FII_AR_ACCOUNT_MERGE_PKG dependencies on HZ_CUSTOMER_MERGE_LOG

Line 91: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

87:
88:
89: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
90: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
91: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
92: MERGE_LOG_ID,
93: TABLE_NAME,
94: MERGE_HEADER_ID,
95: PRIMARY_KEY_ID,

Line 105: ) VALUES (HZ_CUSTOMER_MERGE_LOG_s.nextval,

101: CREATION_DATE,
102: LAST_UPDATE_LOGIN,
103: LAST_UPDATE_DATE,
104: LAST_UPDATED_BY
105: ) VALUES (HZ_CUSTOMER_MERGE_LOG_s.nextval,
106: 'FII_AR_PMT_SCHEDULES_F',
107: MERGE_HEADER_ID_LIST(I),
108: PRIMARY_KEY_ID_LIST(I),
109: NUM_COL1_ORIG_LIST(I), NUM_COL1_NEW_LIST(I),

Line 318: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

314: END IF;
315:
316: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
317: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
318: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
319: MERGE_LOG_ID,
320: TABLE_NAME,
321: MERGE_HEADER_ID,
322: PRIMARY_KEY_ID,

Line 333: ) VALUES (HZ_CUSTOMER_MERGE_LOG_s.nextval,

329: CREATION_DATE,
330: LAST_UPDATE_LOGIN,
331: LAST_UPDATE_DATE,
332: LAST_UPDATED_BY
333: ) VALUES (HZ_CUSTOMER_MERGE_LOG_s.nextval,
334: 'FII_COLLECTORS',
335: MERGE_HEADER_ID_LIST(I),
336: null,
337: PRIMARY_KEY_ID1_LIST(I), PRIMARY_KEY_ID2_LIST(I),

Line 397: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

393: END IF;
394:
395: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
396: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
397: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
398: MERGE_LOG_ID,
399: TABLE_NAME,
400: MERGE_HEADER_ID,
401: PRIMARY_KEY_ID1, PRIMARY_KEY_ID2,

Line 411: ) VALUES (HZ_CUSTOMER_MERGE_LOG_s.nextval,

407: CREATION_DATE,
408: LAST_UPDATE_LOGIN,
409: LAST_UPDATE_DATE,
410: LAST_UPDATED_BY
411: ) VALUES (HZ_CUSTOMER_MERGE_LOG_s.nextval,
412: 'FII_COLLECTORS',
413: MERGE_HEADER_ID_LIST(I),
414: PRIMARY_KEY_ID1_LIST(I), PRIMARY_KEY_ID2_LIST(I),
415: PARTY_ID_LIST(I),

Line 525: INSERT INTO HZ_Customer_Merge_Log(

521: END IF;
522:
523: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
524: FORALL i in 1..Merge_Header_ID_List.Count
525: INSERT INTO HZ_Customer_Merge_Log(
526: MERGE_LOG_ID,
527: TABLE_NAME,
528: MERGE_HEADER_ID,
529: PRIMARY_KEY_ID1,

Line 543: HZ_Customer_Merge_Log_S.nextval,

539: LAST_UPDATE_LOGIN,
540: LAST_UPDATE_DATE,
541: LAST_UPDATED_BY)
542: VALUES (
543: HZ_Customer_Merge_Log_S.nextval,
544: 'FII_CUST_ACCOUNTS',
545: Merge_Header_ID_List(i),
546: Cust_Account_ID_List(i),
547: Account_Owner_Party_ID_List(i),