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

Line 33: l_run_parallel_query VARCHAR2(5) := NVL(FND_PROFILE.VALUE('PARALLEL_QUERIES_IN_CUST_MERGE'), 'Y');

29:
30: l_dbi_profile varchar2(10);
31:
32: -- Bug 7379750
33: l_run_parallel_query VARCHAR2(5) := NVL(FND_PROFILE.VALUE('PARALLEL_QUERIES_IN_CUST_MERGE'), 'Y');
34:
35: --ER 3095805
36: TYPE t_RelId IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
37: TYPE t_RelFlg IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;

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

328: END LOOP;
329:
330:
331: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
332: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
333:
334: -- GTT insertion , bug 8883694 ,9349882 ,9558975
335: IF l_run_parallel_query = 'N' THEN
336: ----bug 8883694,9349882 Inserting unique duplicate_id into GTT for a request .

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

1715:
1716: ELSE
1717:
1718: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1719: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1720:
1721: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1722: insert into HZ_CUSTOMER_MERGE_LOG (
1723: MERGE_LOG_ID,

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

2561: END LOOP;
2562:
2563:
2564: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2565: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2566:
2567: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines():1' );
2568: -- Bug 7379750
2569: IF l_run_parallel_query = 'Y' THEN

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

3584:
3585: ELSE
3586:
3587: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3588: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3589:
3590: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3591: insert into HZ_CUSTOMER_MERGE_LOG (
3592: MERGE_LOG_ID,

Line 4130: --l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'Y');

4126: arp_message.set_line( 'OE_CUST_MERGE.Merge()+' );
4127: -- sql_stmnt := 'Alter Session set hash_area_size=61440000';
4128: -- EXECUTE IMMEDIATE sql_stmnt;
4129: --Changed for Bug#12313696 start
4130: --l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'Y');
4131: l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N');
4132: --Changed for Bug#12313696 end
4133:
4134: arp_message.set_line(' Dbi Profile='||l_dbi_profile);

Line 4131: l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N');

4127: -- sql_stmnt := 'Alter Session set hash_area_size=61440000';
4128: -- EXECUTE IMMEDIATE sql_stmnt;
4129: --Changed for Bug#12313696 start
4130: --l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'Y');
4131: l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N');
4132: --Changed for Bug#12313696 end
4133:
4134: arp_message.set_line(' Dbi Profile='||l_dbi_profile);
4135: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);

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

4219:
4220: ELSE
4221:
4222: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4223: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4224:
4225: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4226: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4227: MERGE_LOG_ID,

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

4577:
4578: ELSE
4579:
4580: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4581: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4582: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4583: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4584: MERGE_LOG_ID,
4585: TABLE_NAME,

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

5225:
5226: ELSE
5227:
5228: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5229: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5230:
5231: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5232: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
5233: MERGE_LOG_ID,

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

5582:
5583: ELSE
5584:
5585: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5586: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5587:
5588: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5589: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
5590: MERGE_LOG_ID,

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

5838:
5839: ELSE
5840:
5841: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5842: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5843:
5844: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5845: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
5846: MERGE_LOG_ID,

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

5962:
5963: ELSE
5964:
5965: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5966: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5967:
5968: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5969: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
5970: MERGE_LOG_ID,

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

6166:
6167: ELSE
6168:
6169: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6170: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6171: ---bug 13786914
6172: IF l_run_parallel_query = 'Y' THEN
6173: OPEN sets_merge_2;
6174: ELSE

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

6354:
6355: ELSE
6356:
6357: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6358: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6359:
6360: OPEN c1_2;
6361: LOOP
6362: FETCH c1_2

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

6665:
6666: END LOOP;
6667:
6668: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6669: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6670:
6671: -- Bug 7379750
6672: IF l_run_parallel_query = 'Y' THEN
6673: OPEN merge_headers_2;

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

6973:
6974: ELSE
6975:
6976: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6977: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6978:
6979: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
6980: insert into HZ_CUSTOMER_MERGE_LOG (
6981: MERGE_LOG_ID,

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

7562: END LOOP;
7563:
7564:
7565: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
7566: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
7567:
7568: -- Bug 7379750
7569: IF l_run_parallel_query = 'Y' THEN
7570: OPEN merge_lines_2;

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

7990: END LOOP;
7991:
7992:
7993: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
7994: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
7995:
7996: -- Bug 7379750
7997: IF l_run_parallel_query = 'Y' THEN
7998: OPEN merge_lines_history_2;

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

8234:
8235: ELSE
8236:
8237: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
8238: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
8239:
8240:
8241: -- customer level update
8242: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');