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.OKL_PARTY_MERGE_PUB dependencies on FND_PROFILE

Line 96: SELECT NVL(FND_PROFILE.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') INTO l_prof_value FROM DUAL;

92: p_party_site_rec.application_id := 540;
93:
94: --Obtain the profile value to find out whether site number is to be passed
95: --or not.
96: SELECT NVL(FND_PROFILE.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') INTO l_prof_value FROM DUAL;
97:
98: IF l_prof_value = 'Y'
99: THEN
100: p_party_site_rec.party_site_number := NULL;

Line 672: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

668: NEW_IS_ID_LIST(I) := NULL;
669: END IF;
670: END LOOP;
671:
672: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
673:
674: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y'
675: THEN
676: FORALL I in 1..ASSET_ID_LIST.COUNT

Line 3488: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

3484: ELSE
3485: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3486: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_LEASE_OPPORTUNITIES_B',FALSE);
3487: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3488: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3489:
3490: OPEN merged_records;
3491: LOOP
3492: FETCH merged_records BULK COLLECT INTO

Line 4018: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

4014: ELSE
4015: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
4016: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_LEASE_APPLICATIONS_B',FALSE);
4017: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4018: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4019:
4020: OPEN merged_records;
4021: LOOP
4022: FETCH merged_records BULK COLLECT INTO

Line 4308: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

4304: ELSE
4305: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
4306: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_EXT_SELL_INVS_B',FALSE);
4307: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4308: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4309:
4310: open merged_records;
4311: LOOP
4312: FETCH merged_records BULK COLLECT INTO

Line 4513: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

4509: ELSE
4510: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
4511: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TAX_SOURCES_T',FALSE);
4512: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4513: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4514:
4515: open merged_records;
4516: LOOP
4517: FETCH merged_records BULK COLLECT INTO

Line 4790: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

4786: ELSE
4787: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
4788: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TAX_SOURCES',FALSE);
4789: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4790: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4791:
4792: open merged_records;
4793: LOOP
4794: FETCH merged_records BULK COLLECT INTO

Line 5005: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

5001: ELSE
5002: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5003: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TRX_AR_INVOICES_B',FALSE);
5004: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5005: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5006:
5007: open merged_records;
5008: LOOP
5009: FETCH merged_records BULK COLLECT INTO

Line 5139: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

5135: ELSE
5136: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5137: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TXL_RCPT_APPS_B',FALSE);
5138: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5139: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5140:
5141: open merged_records;
5142: LOOP
5143: FETCH merged_records BULK COLLECT INTO

Line 5274: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

5270: ELSE
5271: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5272: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_CNSLD_AR_HDRS_B',FALSE);
5273: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5274: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5275:
5276: open merged_records;
5277: LOOP
5278: FETCH merged_records BULK COLLECT INTO

Line 5408: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

5404: ELSE
5405: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5406: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_CNTR_LVLNG_GRPS_B',FALSE);
5407: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5408: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5409:
5410: open merged_records;
5411: LOOP
5412: FETCH merged_records BULK COLLECT INTO

Line 5528: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

5524: ELSE
5525: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5526: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_ACCT_SOURCES',FALSE);
5527: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5528: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5529:
5530: open merged_records;
5531: LOOP
5532: FETCH merged_records BULK COLLECT INTO

Line 5651: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

5647: ELSE
5648: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5649: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_SUPP_INVOICE_DTLS',FALSE);
5650: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5651: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5652:
5653: open merged_records;
5654: LOOP
5655: FETCH merged_records BULK COLLECT INTO

Line 5771: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

5767: ELSE
5768: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5769: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_SUPP_INVOICE_DTLS_H',FALSE);
5770: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5771: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5772:
5773: open merged_records;
5774: LOOP
5775: FETCH merged_records BULK COLLECT INTO

Line 6315: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

6311: ELSE
6312: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
6313: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKC_RULES_B',FALSE);
6314: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6315: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6316:
6317: OPEN merged_records;
6318: LOOP
6319: FETCH merged_records BULK COLLECT INTO