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_PROM_ENUMS_PVT dependencies on FND_PROFILE

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

104: MO_GLOBAL.INIT('IEX');
105: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
106: -- Moac Changes End. Set the policy context.
107:
108: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
109: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
110: --l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
111: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
112: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

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

105: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
106: -- Moac Changes End. Set the policy context.
107:
108: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
109: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
110: --l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
111: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
112: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
113:

Line 110: --l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK

106: -- Moac Changes End. Set the policy context.
107:
108: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
109: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
110: --l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
111: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
112: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
113:
114: l_node_counter := 0;

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

107:
108: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
109: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
110: --l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
111: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
112: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
113:
114: l_node_counter := 0;
115: If (l_Access = 'T') then

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

108: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
109: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
110: --l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
111: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
112: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
113:
114: l_node_counter := 0;
115: If (l_Access = 'T') then
116: SELECT count(*) into l_check from iex_assignments where

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

288:
289: l_node_counter := l_node_counter + 1;
290:
291: -- Begin -jypark- 05/25/05 - 4608220 - Added profile to show/hide UWQ sub-nodes
292: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
293:
294: if (l_EnableNodes <> 'N') then
295: -- End -jypark- 05/25/05 - 4608220 - Added profile to show/hide UWQ sub-nodes
296:

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

466: BEGIN
467:
468: SET_MO_GLOBAL;
469:
470: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
471: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
472: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
473: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
474: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

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

467:
468: SET_MO_GLOBAL;
469:
470: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
471: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
472: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
473: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
474: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
475:

Line 472: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK

468: SET_MO_GLOBAL;
469:
470: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
471: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
472: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
473: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
474: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
475:
476: /* IF (l_Access = 'T') THEN

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

469:
470: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
471: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
472: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
473: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
474: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
475:
476: /* IF (l_Access = 'T') THEN
477: SELECT count(*) INTO l_check FROM iex_assignments where

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

470: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
471: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
472: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
473: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
474: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
475:
476: /* IF (l_Access = 'T') THEN
477: SELECT count(*) INTO l_check FROM iex_assignments where
478: alt_resource_id = p_RESOURCE_ID

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

645: iex_debug_pub.LogMessage('ENUMERATE_CU_PROM_NODES: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
646: END IF;
647:
648: l_node_counter := l_node_counter + 1;
649: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
650:
651: if (l_EnableNodes <> 'N') then
652: l_view_name := 'IEX_CU_PRO_ALL_UWQ_V';
653: l_refresh_view_name := 'IEX_CU_PRO_ALL_UWQ_V';

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

827: BEGIN
828:
829: SET_MO_GLOBAL;
830:
831: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
832: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
833: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
834:
835: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');

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

828:
829: SET_MO_GLOBAL;
830:
831: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
832: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
833: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
834:
835: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
836: /*

Line 833: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK

829: SET_MO_GLOBAL;
830:
831: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
832: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
833: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
834:
835: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
836: /*
837: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'), 'PARTY');

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

831: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
832: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
833: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
834:
835: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
836: /*
837: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'), 'PARTY');
838:
839: -- !!

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

833: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
834:
835: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
836: /*
837: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'), 'PARTY');
838:
839: -- !!
840: -- !!!!!!!!!! BUILDING MAIN NODE WHERE CLAUSE
841: -- !!

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

1036:
1037: l_node_counter := l_node_counter + 1;
1038:
1039:
1040: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
1041:
1042: if (l_EnableNodes <> 'N') then
1043: l_view_name := 'IEX_CU_PRO_ALL_UWQ_V';
1044: l_refresh_view_name := 'IEX_CU_PRO_ALL_UWQ_V';

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

1222: BEGIN
1223:
1224: SET_MO_GLOBAL;
1225:
1226: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1227: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1228: --l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
1229: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1230: l_node_counter := 0;

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

1223:
1224: SET_MO_GLOBAL;
1225:
1226: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1227: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1228: --l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
1229: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1230: l_node_counter := 0;
1231:

Line 1228: --l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK

1224: SET_MO_GLOBAL;
1225:
1226: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1227: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1228: --l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
1229: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1230: l_node_counter := 0;
1231:
1232: OPEN c_sel_enum(p_sel_enum_id);

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

1225:
1226: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1227: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1228: --l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); -- commented for bug 8826561 PNAVEENK
1229: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1230: l_node_counter := 0;
1231:
1232: OPEN c_sel_enum(p_sel_enum_id);
1233: FETCH c_sel_enum INTO l_sel_enum_rec;

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

1421:
1422: l_node_counter := l_node_counter + 1;
1423:
1424:
1425: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
1426:
1427: if (l_EnableNodes <> 'N') then
1428: l_view_name := 'IEX_CU_PRO_ALL_UWQ_V';
1429: l_refresh_view_name := 'IEX_CU_PRO_ALL_UWQ_V';

Line 1526: l_Access varchar2(1) := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');

1522: l_check number := 0;
1523: l_collector_id number;
1524: l_security_where varchar2(2000);
1525:
1526: l_Access varchar2(1) := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1527: l_bkr_filter varchar2(1) := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1528: l_person_id number;
1529:
1530: l_bind_list IEU_PUB.BindVariableRecordList ;

Line 1527: l_bkr_filter varchar2(1) := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');

1523: l_collector_id number;
1524: l_security_where varchar2(2000);
1525:
1526: l_Access varchar2(1) := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1527: l_bkr_filter varchar2(1) := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1528: l_person_id number;
1529:
1530: l_bind_list IEU_PUB.BindVariableRecordList ;
1531: l_ld_list IEU_PUB.EnumeratorDataRecordList;

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

1609: END ATTACH_WHERE_CLAUSE;
1610:
1611: -- PL/SQL Block
1612: BEGIN
1613: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1614: END IEX_UWQ_PROM_ENUMS_PVT;