DBA Data[Home] [Help]

APPS.IEX_UWQ_STRAT_ENUMS_PVT dependencies on FND_PROFILE

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

105:
106: -- SAVEPOINT start_str_enumeration;
107:
108: l_node_counter := 0;
109: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
110: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
111:
112: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
113: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');

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

106: -- SAVEPOINT start_str_enumeration;
107:
108: l_node_counter := 0;
109: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
110: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
111:
112: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
113: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
114: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));

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

108: l_node_counter := 0;
109: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
110: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
111:
112: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
113: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
114: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
115:
116: l_str_and := ' AND ';

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

109: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
110: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
111:
112: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
113: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
114: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
115:
116: l_str_and := ' AND ';
117: l_str_or := ' OR ';

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

110: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
111:
112: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
113: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
114: l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID')));
115:
116: l_str_and := ' AND ';
117: l_str_or := ' OR ';
118: l_str_str := ' AND NUMBER_OF_STRATEGIES > 0 ';

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

400:
401: END ENUMERATE_STRAT_NODES;
402:
403: BEGIN
404: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
405: -- PL/SQL Block
406: END IEX_UWQ_STRAT_ENUMS_PVT;