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 102: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);

98: MO_GLOBAL.INIT('IEX');
99: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
100: -- Moac Changes End. Set the policy context.
101:
102: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
103: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
104: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
105: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
106: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

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

99: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
100: -- Moac Changes End. Set the policy context.
101:
102: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
103: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
104: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
105: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
106: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
107:

Line 104: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));

100: -- Moac Changes End. Set the policy context.
101:
102: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
103: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
104: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
105: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
106: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
107:
108: l_node_counter := 0;

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

101:
102: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
103: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
104: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
105: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
106: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
107:
108: l_node_counter := 0;
109: If (l_Access = 'T') then

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

102: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
103: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
104: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
105: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
106: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
107:
108: l_node_counter := 0;
109: If (l_Access = 'T') then
110: SELECT count(*) into l_check from iex_assignments where

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

268:
269: l_node_counter := l_node_counter + 1;
270:
271: -- Begin -jypark- 05/25/05 - 4608220 - Added profile to show/hide UWQ sub-nodes
272: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
273:
274: if (l_EnableNodes <> 'N') then
275: -- End -jypark- 05/25/05 - 4608220 - Added profile to show/hide UWQ sub-nodes
276:

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

434: BEGIN
435:
436: SET_MO_GLOBAL;
437:
438: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
439: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
440: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
441: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
442: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

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

435:
436: SET_MO_GLOBAL;
437:
438: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
439: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
440: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
441: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
442: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
443:

Line 440: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));

436: SET_MO_GLOBAL;
437:
438: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
439: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
440: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
441: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
442: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
443:
444: /* IF (l_Access = 'T') THEN

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

437:
438: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
439: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
440: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
441: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
442: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
443:
444: /* IF (l_Access = 'T') THEN
445: SELECT count(*) INTO l_check FROM iex_assignments where

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

438: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
439: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
440: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
441: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
442: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
443:
444: /* IF (l_Access = 'T') THEN
445: SELECT count(*) INTO l_check FROM iex_assignments where
446: alt_resource_id = p_RESOURCE_ID

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

589: iex_debug_pub.LogMessage('ENUMERATE_CU_PROM_NODES: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
590: END IF;
591:
592: l_node_counter := l_node_counter + 1;
593: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
594:
595: if (l_EnableNodes <> 'N') then
596: l_view_name := 'IEX_CU_PRO_ALL_UWQ_V';
597: l_refresh_view_name := 'IEX_CU_PRO_ALL_UWQ_V';

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

750: BEGIN
751:
752: SET_MO_GLOBAL;
753:
754: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
755: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
756: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
757:
758: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');

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

751:
752: SET_MO_GLOBAL;
753:
754: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
755: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
756: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
757:
758: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
759: /*

Line 756: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));

752: SET_MO_GLOBAL;
753:
754: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
755: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
756: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
757:
758: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
759: /*
760: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'), 'PARTY');

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

754: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
755: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
756: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
757:
758: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
759: /*
760: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'), 'PARTY');
761:
762: -- !!

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

756: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
757:
758: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
759: /*
760: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'), 'PARTY');
761:
762: -- !!
763: -- !!!!!!!!!! BUILDING MAIN NODE WHERE CLAUSE
764: -- !!

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

935:
936: l_node_counter := l_node_counter + 1;
937:
938:
939: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
940:
941: if (l_EnableNodes <> 'N') then
942: l_view_name := 'IEX_CU_PRO_ALL_UWQ_V';
943: l_refresh_view_name := 'IEX_CU_PRO_ALL_UWQ_V';

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

1100: BEGIN
1101:
1102: SET_MO_GLOBAL;
1103:
1104: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1105: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1106: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
1107: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1108: l_node_counter := 0;

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

1101:
1102: SET_MO_GLOBAL;
1103:
1104: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1105: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1106: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
1107: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1108: l_node_counter := 0;
1109:

Line 1106: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));

1102: SET_MO_GLOBAL;
1103:
1104: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1105: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1106: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
1107: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1108: l_node_counter := 0;
1109:
1110: OPEN c_sel_enum(p_sel_enum_id);

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

1103:
1104: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
1105: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1106: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
1107: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1108: l_node_counter := 0;
1109:
1110: OPEN c_sel_enum(p_sel_enum_id);
1111: FETCH c_sel_enum INTO l_sel_enum_rec;

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

1274:
1275: l_node_counter := l_node_counter + 1;
1276:
1277:
1278: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');
1279:
1280: if (l_EnableNodes <> 'N') then
1281: l_view_name := 'IEX_CU_PRO_ALL_UWQ_V';
1282: l_refresh_view_name := 'IEX_CU_PRO_ALL_UWQ_V';

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

1365: l_check number := 0;
1366: l_collector_id number;
1367: l_security_where varchar2(2000);
1368:
1369: l_Access varchar2(1) := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1370: l_bkr_filter varchar2(1) := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1371: l_person_id number;
1372:
1373: l_bind_list IEU_PUB.BindVariableRecordList ;

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

1366: l_collector_id number;
1367: l_security_where varchar2(2000);
1368:
1369: l_Access varchar2(1) := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
1370: l_bkr_filter varchar2(1) := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
1371: l_person_id number;
1372:
1373: l_bind_list IEU_PUB.BindVariableRecordList ;
1374: l_ld_list IEU_PUB.EnumeratorDataRecordList;

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

1447: END ATTACH_WHERE_CLAUSE;
1448:
1449: -- PL/SQL Block
1450: BEGIN
1451: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1452: END IEX_UWQ_PROM_ENUMS_PVT;