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.AR_CMGT_ACCOUNT_MERGE dependencies on HZ_UTILITY_PUB

Line 111: hz_utility_pub.CREATED_BY,

107: NUM_COL2_ORIG_LIST(I),
108: NUM_COL2_NEW_LIST(I),
109: 'U',
110: req_id,
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY

Line 112: hz_utility_pub.CREATION_DATE,

108: NUM_COL2_NEW_LIST(I),
109: 'U',
110: req_id,
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
116: );

Line 113: hz_utility_pub.LAST_UPDATE_LOGIN,

109: 'U',
110: req_id,
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
116: );
117:

Line 114: hz_utility_pub.LAST_UPDATE_DATE,

110: req_id,
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
116: );
117:
118: END IF;

Line 115: hz_utility_pub.LAST_UPDATED_BY

111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
116: );
117:
118: END IF;
119: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 263: hz_utility_pub.CREATED_BY,

259: NUM_COL2_ORIG_LIST(I),
260: NUM_COL2_NEW_LIST(I),
261: 'U',
262: req_id,
263: hz_utility_pub.CREATED_BY,
264: hz_utility_pub.CREATION_DATE,
265: hz_utility_pub.LAST_UPDATE_LOGIN,
266: hz_utility_pub.LAST_UPDATE_DATE,
267: hz_utility_pub.LAST_UPDATED_BY

Line 264: hz_utility_pub.CREATION_DATE,

260: NUM_COL2_NEW_LIST(I),
261: 'U',
262: req_id,
263: hz_utility_pub.CREATED_BY,
264: hz_utility_pub.CREATION_DATE,
265: hz_utility_pub.LAST_UPDATE_LOGIN,
266: hz_utility_pub.LAST_UPDATE_DATE,
267: hz_utility_pub.LAST_UPDATED_BY
268: );

Line 265: hz_utility_pub.LAST_UPDATE_LOGIN,

261: 'U',
262: req_id,
263: hz_utility_pub.CREATED_BY,
264: hz_utility_pub.CREATION_DATE,
265: hz_utility_pub.LAST_UPDATE_LOGIN,
266: hz_utility_pub.LAST_UPDATE_DATE,
267: hz_utility_pub.LAST_UPDATED_BY
268: );
269:

Line 266: hz_utility_pub.LAST_UPDATE_DATE,

262: req_id,
263: hz_utility_pub.CREATED_BY,
264: hz_utility_pub.CREATION_DATE,
265: hz_utility_pub.LAST_UPDATE_LOGIN,
266: hz_utility_pub.LAST_UPDATE_DATE,
267: hz_utility_pub.LAST_UPDATED_BY
268: );
269:
270: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 267: hz_utility_pub.LAST_UPDATED_BY

263: hz_utility_pub.CREATED_BY,
264: hz_utility_pub.CREATION_DATE,
265: hz_utility_pub.LAST_UPDATE_LOGIN,
266: hz_utility_pub.LAST_UPDATE_DATE,
267: hz_utility_pub.LAST_UPDATED_BY
268: );
269:
270: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
271: UPDATE AR_CMGT_CREDIT_REQUESTS yt SET

Line 618: hz_utility_pub.CREATED_BY,

614: ,DEL_PAST_DUE_INV_INST_COUNT(I)
615: ,DEL_LAST_PAYMENT_AMOUNT(I)
616: ,DEL_LAST_PAYMENT_DATE(I)
617: ,DEL_LAST_PAYMENT_NUMBER(I),
618: hz_utility_pub.CREATED_BY,
619: hz_utility_pub.CREATION_DATE,
620: hz_utility_pub.LAST_UPDATE_LOGIN,
621: hz_utility_pub.LAST_UPDATE_DATE,
622: hz_utility_pub.LAST_UPDATED_BY

Line 619: hz_utility_pub.CREATION_DATE,

615: ,DEL_LAST_PAYMENT_AMOUNT(I)
616: ,DEL_LAST_PAYMENT_DATE(I)
617: ,DEL_LAST_PAYMENT_NUMBER(I),
618: hz_utility_pub.CREATED_BY,
619: hz_utility_pub.CREATION_DATE,
620: hz_utility_pub.LAST_UPDATE_LOGIN,
621: hz_utility_pub.LAST_UPDATE_DATE,
622: hz_utility_pub.LAST_UPDATED_BY
623: );

Line 620: hz_utility_pub.LAST_UPDATE_LOGIN,

616: ,DEL_LAST_PAYMENT_DATE(I)
617: ,DEL_LAST_PAYMENT_NUMBER(I),
618: hz_utility_pub.CREATED_BY,
619: hz_utility_pub.CREATION_DATE,
620: hz_utility_pub.LAST_UPDATE_LOGIN,
621: hz_utility_pub.LAST_UPDATE_DATE,
622: hz_utility_pub.LAST_UPDATED_BY
623: );
624:

Line 621: hz_utility_pub.LAST_UPDATE_DATE,

617: ,DEL_LAST_PAYMENT_NUMBER(I),
618: hz_utility_pub.CREATED_BY,
619: hz_utility_pub.CREATION_DATE,
620: hz_utility_pub.LAST_UPDATE_LOGIN,
621: hz_utility_pub.LAST_UPDATE_DATE,
622: hz_utility_pub.LAST_UPDATED_BY
623: );
624:
625: arp_message.set_line( 'after Insert into HZ_CUSTOMER_MERGE_LOG');

Line 622: hz_utility_pub.LAST_UPDATED_BY

618: hz_utility_pub.CREATED_BY,
619: hz_utility_pub.CREATION_DATE,
620: hz_utility_pub.LAST_UPDATE_LOGIN,
621: hz_utility_pub.LAST_UPDATE_DATE,
622: hz_utility_pub.LAST_UPDATED_BY
623: );
624:
625: arp_message.set_line( 'after Insert into HZ_CUSTOMER_MERGE_LOG');
626: END IF;

Line 1191: ,hz_utility_pub.CREATED_BY,

1187: ,DEL_LARGEST_INV_CUST_TRX_ID(I)
1188: ,DEL_DAYS_CREDIT_GRANTED_SUM(I)
1189: ,DEL_NSF_STOP_PAYMENT_COUNT(I)
1190: ,DEL_NSF_STOP_PAYMENT_AMOUNT(I)
1191: ,hz_utility_pub.CREATED_BY,
1192: hz_utility_pub.CREATION_DATE,
1193: hz_utility_pub.LAST_UPDATE_LOGIN,
1194: hz_utility_pub.LAST_UPDATE_DATE,
1195: hz_utility_pub.LAST_UPDATED_BY

Line 1192: hz_utility_pub.CREATION_DATE,

1188: ,DEL_DAYS_CREDIT_GRANTED_SUM(I)
1189: ,DEL_NSF_STOP_PAYMENT_COUNT(I)
1190: ,DEL_NSF_STOP_PAYMENT_AMOUNT(I)
1191: ,hz_utility_pub.CREATED_BY,
1192: hz_utility_pub.CREATION_DATE,
1193: hz_utility_pub.LAST_UPDATE_LOGIN,
1194: hz_utility_pub.LAST_UPDATE_DATE,
1195: hz_utility_pub.LAST_UPDATED_BY
1196: );

Line 1193: hz_utility_pub.LAST_UPDATE_LOGIN,

1189: ,DEL_NSF_STOP_PAYMENT_COUNT(I)
1190: ,DEL_NSF_STOP_PAYMENT_AMOUNT(I)
1191: ,hz_utility_pub.CREATED_BY,
1192: hz_utility_pub.CREATION_DATE,
1193: hz_utility_pub.LAST_UPDATE_LOGIN,
1194: hz_utility_pub.LAST_UPDATE_DATE,
1195: hz_utility_pub.LAST_UPDATED_BY
1196: );
1197: END IF;

Line 1194: hz_utility_pub.LAST_UPDATE_DATE,

1190: ,DEL_NSF_STOP_PAYMENT_AMOUNT(I)
1191: ,hz_utility_pub.CREATED_BY,
1192: hz_utility_pub.CREATION_DATE,
1193: hz_utility_pub.LAST_UPDATE_LOGIN,
1194: hz_utility_pub.LAST_UPDATE_DATE,
1195: hz_utility_pub.LAST_UPDATED_BY
1196: );
1197: END IF;
1198: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1195: hz_utility_pub.LAST_UPDATED_BY

1191: ,hz_utility_pub.CREATED_BY,
1192: hz_utility_pub.CREATION_DATE,
1193: hz_utility_pub.LAST_UPDATE_LOGIN,
1194: hz_utility_pub.LAST_UPDATE_DATE,
1195: hz_utility_pub.LAST_UPDATED_BY
1196: );
1197: END IF;
1198: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1199: UPDATE AR_TRX_SUMMARY yt