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.

[Home] [Help]

APPS.IEX_UWQ_DELIN_ENUMS_PVT dependencies on FND_PROFILE

Line 131: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');

127: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';
128: l_node_counter := 0;
129: l_check := 0;
130:
131: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
132: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
133: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
134: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
135: --Bug4221359. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.

Line 132: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

128: l_node_counter := 0;
129: l_check := 0;
130:
131: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
132: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
133: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
134: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
135: --Bug4221359. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.
136: /* l_additional_where :=

Line 133: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

129: l_check := 0;
130:
131: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
132: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
133: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
134: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
135: --Bug4221359. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.
136: /* l_additional_where :=
137: ' UNION ALL SELECT hp.party_id ' ||

Line 134: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');

130:
131: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
132: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
133: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
134: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
135: --Bug4221359. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.
136: /* l_additional_where :=
137: ' UNION ALL SELECT hp.party_id ' ||
138: ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp, ' ||

Line 398: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');

394: IEX_DEBUG_PUB.logMessage('l_ld_list(l_node_counter).WHERE_CLAUSE1: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
395: END IF;
396:
397: -- Begin - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
398: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
399:
400: if (l_EnableNodes <> 'N') then
401: -- End - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
402:

Line 665: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');

661:
662: SET_MO_GLOBAL;
663:
664:
665: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
666: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
667: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
668: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
669:

Line 666: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

662: SET_MO_GLOBAL;
663:
664:
665: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
666: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
667: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
668: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
669:
670: --Bug4221349. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.

Line 667: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

663:
664:
665: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
666: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
667: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
668: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
669:
670: --Bug4221349. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.
671: /* l_additional_where :=

Line 668: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');

664:
665: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
666: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
667: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
668: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
669:
670: --Bug4221349. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.
671: /* l_additional_where :=
672: ' UNION ALL SELECT hp.party_id ' ||

Line 910: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');

906: l_node_counter := l_node_counter + 1;
907: --l_check := 0;
908:
909: -- Begin - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
910: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
911:
912: if (l_EnableNodes <> 'N') then
913: -- End - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
914:

Line 1225: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');

1221: BEGIN
1222:
1223: SET_MO_GLOBAL;
1224:
1225: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1226: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1227: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1228: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1229: l_str_and := ' AND ';

Line 1226: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

1222:
1223: SET_MO_GLOBAL;
1224:
1225: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1226: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1227: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1228: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1229: l_str_and := ' AND ';
1230: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';

Line 1227: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

1223: SET_MO_GLOBAL;
1224:
1225: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1226: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1227: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1228: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1229: l_str_and := ' AND ';
1230: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';
1231: l_node_counter := 0;

Line 1228: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');

1224:
1225: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1226: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1227: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1228: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1229: l_str_and := ' AND ';
1230: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';
1231: l_node_counter := 0;
1232: l_check :=0;

Line 1537: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');

1533: l_node_counter := l_node_counter + 1;
1534: --l_check := 0;
1535:
1536: -- Begin - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
1537: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
1538:
1539: if (l_EnableNodes <> 'N') then
1540: -- End - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
1541:

Line 1905: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');

1901:
1902: SET_MO_GLOBAL;
1903:
1904:
1905: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1906: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1907: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1908: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1909: l_str_and := ' AND ';

Line 1906: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

1902: SET_MO_GLOBAL;
1903:
1904:
1905: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1906: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1907: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1908: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1909: l_str_and := ' AND ';
1910: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';

Line 1907: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

1903:
1904:
1905: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1906: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1907: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1908: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1909: l_str_and := ' AND ';
1910: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';
1911:

Line 1908: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');

1904:
1905: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1906: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1907: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1908: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1909: l_str_and := ' AND ';
1910: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';
1911:
1912: l_node_counter := 0;

Line 2270: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');

2266: l_node_counter := l_node_counter + 1;
2267: --l_check := 0;
2268:
2269: -- Begin - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
2270: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
2271:
2272: if (l_EnableNodes <> 'N') then
2273: -- End - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
2274:

Line 2589: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

2585:
2586:
2587: BEGIN
2588:
2589: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
2590:
2591: END IEX_UWQ_DELIN_ENUMS_PVT;