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.JL_CMERGE dependencies on HZ_ACCT_MERGE_UTIL

Line 68: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

64: NULL;
65: ELSE
66: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
67: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_BANK_RETURNS',FALSE);
68: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
69: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
70:
71: open merged_records;
72: LOOP

Line 85: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

81: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
82: exit;
83: END IF;
84: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
85: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
86: END LOOP;
87: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
88: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
89: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 211: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

207: NULL;
208: ELSE
209: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
210: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_OCCURRENCE_DOCS',FALSE);
211: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
212: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
213:
214: open merged_records;
215: LOOP

Line 229: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

225: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
226: exit;
227: END IF;
228: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
229: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
230: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
231: END LOOP;
232: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
233: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 230: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));

226: exit;
227: END IF;
228: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
229: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
230: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
231: END LOOP;
232: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
233: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
234: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 353: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

349: NULL;
350: ELSE
351: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
352: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_PAY_SCHED_AUX',FALSE);
353: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
354: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
355:
356: open merged_records;
357: LOOP

Line 370: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));

366: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
367: exit;
368: END IF;
369: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
370: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
371: END LOOP;
372: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
373: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
374: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 682: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

678: */
679:
680: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
681: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);
682: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
683: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
684:
685: l_count:=0;
686: open merged_records;

Line 715: NUM_COL1_NEW_LIST(I) :=HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

711: END IF;
712:
713: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
714:
715: NUM_COL1_NEW_LIST(I) :=HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
716:
717: -- Is defaulted to N because, the journals need to added to the balance of the customer
718: VCHAR_COL1_NEW_LIST(I) :='N';
719:

Line 1048: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

1044: x_profile_org:=fnd_profile.value ('ORG_ID');
1045:
1046: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1047: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);
1048: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1049:
1050: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1051:
1052: -- For each Brazilian organization, update the balances.

Line 1556: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

1552: -- Replaced with new logic that will generate log file.
1553:
1554: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1555: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);
1556: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1557: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1558:
1559: l_count:=0;
1560:

Line 1588: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

1584: END IF;
1585:
1586: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1587: -- 5 stores the personnel id
1588: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1589:
1590: END LOOP;
1591:
1592: