13: )
14: AS
15:
16: l_node_label VARCHAR2(200);
17: l_ld_list IEU_PUB.EnumeratorDataRecordList;
18:
19: l_node_counter NUMBER;
20: l_bind_list IEU_PUB.BindVariableRecordList ;
21: l_Access varchar2(10);
16: l_node_label VARCHAR2(200);
17: l_ld_list IEU_PUB.EnumeratorDataRecordList;
18:
19: l_node_counter NUMBER;
20: l_bind_list IEU_PUB.BindVariableRecordList ;
21: l_Access varchar2(10);
22: l_person_id NUMBER;
23: l_Level varchar2(15);
24: l_check NUMBER;
382: l_ld_list(l_node_counter).WHERE_CLAUSE := l_default_where || l_full_brk || l_str_str ;
383: END IF;
384: END IF;
385:
386: l_ld_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
387:
388: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
389: iex_debug_pub.LogMessage('ENUMERATE_STRATEGY_NODES: full Mode: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
390: END IF;
437: ELSE
438: l_ld_list(l_node_counter).WHERE_CLAUSE := l_default_where || l_restrict_assign_resource|| l_work_item_where;
439: END IF;
440:
441: l_ld_list(l_node_counter).BIND_VARS := IEU_PUB.SET_BIND_VAR_DATA(l_bind_list) ;
442:
443: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
444: iex_debug_pub.LogMessage('ENUMERATE_STRATEGY_NODES: restricted Mode: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
445: END IF;
453:
454:
455: l_node_counter := l_node_counter + 1;
456:
457: IEU_PUB.ADD_UWQ_NODE_DATA
458: (P_RESOURCE_ID,
459: P_SEL_ENUM_ID,
460: l_ld_list
461: );