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

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

113: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';
114: l_node_counter := 0;
115: l_check := 0;
116:
117: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
118: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
119: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
120: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
121: --Bug4221359. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.

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

114: l_node_counter := 0;
115: l_check := 0;
116:
117: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
118: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
119: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
120: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
121: --Bug4221359. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.
122: /* l_additional_where :=

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

115: l_check := 0;
116:
117: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
118: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
119: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
120: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
121: --Bug4221359. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.
122: /* l_additional_where :=
123: ' UNION ALL SELECT hp.party_id ' ||

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

116:
117: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
118: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
119: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
120: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
121: --Bug4221359. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.
122: /* l_additional_where :=
123: ' UNION ALL SELECT hp.party_id ' ||
124: ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp, ' ||

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

308: l_node_counter := l_node_counter + 1;
309:
310:
311: -- Begin - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
312: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
313:
314: if (l_EnableNodes <> 'N') then
315: -- End - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
316:

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

539:
540: SET_MO_GLOBAL;
541:
542:
543: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
544: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
545: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
546: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
547:

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

540: SET_MO_GLOBAL;
541:
542:
543: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
544: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
545: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
546: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
547:
548: --Bug4221349. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.

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

541:
542:
543: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
544: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
545: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
546: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
547:
548: --Bug4221349. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.
549: /* l_additional_where :=

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

542:
543: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
544: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
545: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
546: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
547:
548: --Bug4221349. Implement Group Hierarchy. Fix By LKKUMAR on 22-Mar-2006. Start.
549: /* l_additional_where :=
550: ' UNION ALL SELECT hp.party_id ' ||

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

762: l_node_counter := l_node_counter + 1;
763: --l_check := 0;
764:
765: -- Begin - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
766: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
767:
768: if (l_EnableNodes <> 'N') then
769: -- End - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
770:

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

1065: BEGIN
1066:
1067: SET_MO_GLOBAL;
1068:
1069: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1070: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1071: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1072: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1073: l_str_and := ' AND ';

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

1066:
1067: SET_MO_GLOBAL;
1068:
1069: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1070: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1071: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1072: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1073: l_str_and := ' AND ';
1074: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';

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

1067: SET_MO_GLOBAL;
1068:
1069: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1070: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1071: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1072: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1073: l_str_and := ' AND ';
1074: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';
1075: l_node_counter := 0;

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

1068:
1069: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1070: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1071: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1072: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1073: l_str_and := ' AND ';
1074: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';
1075: l_node_counter := 0;
1076: l_check :=0;

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

1354: l_node_counter := l_node_counter + 1;
1355: --l_check := 0;
1356:
1357: -- Begin - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
1358: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
1359:
1360: if (l_EnableNodes <> 'N') then
1361: -- End - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
1362:

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

1710:
1711: SET_MO_GLOBAL;
1712:
1713:
1714: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1715: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1716: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1717: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1718: l_str_and := ' AND ';

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

1711: SET_MO_GLOBAL;
1712:
1713:
1714: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1715: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1716: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1717: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1718: l_str_and := ' AND ';
1719: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';

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

1712:
1713:
1714: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1715: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1716: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1717: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1718: l_str_and := ' AND ';
1719: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';
1720:

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

1713:
1714: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1715: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
1716: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1717: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1718: l_str_and := ' AND ';
1719: l_str_del := ' AND NUMBER_OF_DELINQUENCIES > 0 ';
1720:
1721: l_node_counter := 0;

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

2053: l_node_counter := l_node_counter + 1;
2054: --l_check := 0;
2055:
2056: -- Begin - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
2057: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
2058:
2059: if (l_EnableNodes <> 'N') then
2060: -- End - jypark - 05/25/05 - 4605402 - Added profile to show/hide UWQ sub-nodes
2061:

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

2372:
2373:
2374: BEGIN
2375:
2376: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
2377:
2378: END IEX_UWQ_DELIN_ENUMS_PVT;