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');
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')));
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 ';
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 ';
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 ';
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;