119:
120: -- SAVEPOINT start_str_enumeration;
121:
122: l_node_counter := 0;
123: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
124: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
125:
126: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
127: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
120: -- SAVEPOINT start_str_enumeration;
121:
122: l_node_counter := 0;
123: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
124: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
125:
126: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
127: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
128: l_work_item_prf_val := nvl(fnd_profile.value('IEX_SHOW_WORK_ITEM_TYPES'),'MANUAL'); --Added for Bug 9769710 07-Dec-2010 barathsr
122: l_node_counter := 0;
123: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
124: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
125:
126: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
127: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
128: l_work_item_prf_val := nvl(fnd_profile.value('IEX_SHOW_WORK_ITEM_TYPES'),'MANUAL'); --Added for Bug 9769710 07-Dec-2010 barathsr
129: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); --commented for bug 8826561 PNAVEENK
130:
123: l_Access := NVL(FND_PROFILE.VALUE('IEX_CUST_ACCESS'), 'F');
124: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
125:
126: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
127: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
128: l_work_item_prf_val := nvl(fnd_profile.value('IEX_SHOW_WORK_ITEM_TYPES'),'MANUAL'); --Added for Bug 9769710 07-Dec-2010 barathsr
129: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); --commented for bug 8826561 PNAVEENK
130:
131: l_str_and := ' AND ';
124: l_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
125:
126: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
127: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
128: l_work_item_prf_val := nvl(fnd_profile.value('IEX_SHOW_WORK_ITEM_TYPES'),'MANUAL'); --Added for Bug 9769710 07-Dec-2010 barathsr
129: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); --commented for bug 8826561 PNAVEENK
130:
131: l_str_and := ' AND ';
132: l_str_or := ' OR ';
125:
126: l_Complete_Days := NVL(FND_PROFILE.VALUE('IEX_UWQ_COMPLETION_DAYS'), 30);
127: l_bkr_filter := NVL(fnd_profile.value('IEX_BANKRUPTCY_FILTER'), 'Y');
128: l_work_item_prf_val := nvl(fnd_profile.value('IEX_SHOW_WORK_ITEM_TYPES'),'MANUAL'); --Added for Bug 9769710 07-Dec-2010 barathsr
129: -- l_org_id := TO_NUMBER(oe_profile.value('OE_ORGANIZATION_ID', fnd_profile.value('ORG_ID'))); --commented for bug 8826561 PNAVEENK
130:
131: l_str_and := ' AND ';
132: l_str_or := ' OR ';
133: l_str_str := ' AND NUMBER_OF_STRATEGIES > 0 ';
472:
473: END ENUMERATE_STRAT_NODES;
474:
475: BEGIN
476: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
477: -- PL/SQL Block
478: END IEX_UWQ_STRAT_ENUMS_PVT;