13: l_node_pid NUMBER;
14: l_node_label VARCHAR2(100);
15: l_def_where VARCHAR2(20000);
16:
17: l_wl_list IEU_PUB.EnumeratorDataRecordList;
18: l_bind_list IEU_PUB.BindVariableRecordList;
19: l_ind_own_bind_list IEU_PUB.BindVariableRecordList;
20: l_ind_asg_bind_list IEU_PUB.BindVariableRecordList;
21: l_grp_own_bind_list IEU_PUB.BindVariableRecordList;
14: l_node_label VARCHAR2(100);
15: l_def_where VARCHAR2(20000);
16:
17: l_wl_list IEU_PUB.EnumeratorDataRecordList;
18: l_bind_list IEU_PUB.BindVariableRecordList;
19: l_ind_own_bind_list IEU_PUB.BindVariableRecordList;
20: l_ind_asg_bind_list IEU_PUB.BindVariableRecordList;
21: l_grp_own_bind_list IEU_PUB.BindVariableRecordList;
22: l_grp_asg_bind_list IEU_PUB.BindVariableRecordList;
15: l_def_where VARCHAR2(20000);
16:
17: l_wl_list IEU_PUB.EnumeratorDataRecordList;
18: l_bind_list IEU_PUB.BindVariableRecordList;
19: l_ind_own_bind_list IEU_PUB.BindVariableRecordList;
20: l_ind_asg_bind_list IEU_PUB.BindVariableRecordList;
21: l_grp_own_bind_list IEU_PUB.BindVariableRecordList;
22: l_grp_asg_bind_list IEU_PUB.BindVariableRecordList;
23:
16:
17: l_wl_list IEU_PUB.EnumeratorDataRecordList;
18: l_bind_list IEU_PUB.BindVariableRecordList;
19: l_ind_own_bind_list IEU_PUB.BindVariableRecordList;
20: l_ind_asg_bind_list IEU_PUB.BindVariableRecordList;
21: l_grp_own_bind_list IEU_PUB.BindVariableRecordList;
22: l_grp_asg_bind_list IEU_PUB.BindVariableRecordList;
23:
24: BEGIN
17: l_wl_list IEU_PUB.EnumeratorDataRecordList;
18: l_bind_list IEU_PUB.BindVariableRecordList;
19: l_ind_own_bind_list IEU_PUB.BindVariableRecordList;
20: l_ind_asg_bind_list IEU_PUB.BindVariableRecordList;
21: l_grp_own_bind_list IEU_PUB.BindVariableRecordList;
22: l_grp_asg_bind_list IEU_PUB.BindVariableRecordList;
23:
24: BEGIN
25:
18: l_bind_list IEU_PUB.BindVariableRecordList;
19: l_ind_own_bind_list IEU_PUB.BindVariableRecordList;
20: l_ind_asg_bind_list IEU_PUB.BindVariableRecordList;
21: l_grp_own_bind_list IEU_PUB.BindVariableRecordList;
22: l_grp_asg_bind_list IEU_PUB.BindVariableRecordList;
23:
24: BEGIN
25:
26: IF (FND_PROFILE.VALUE('IEU_QEN_WORKLIST') = 'N' ) THEN
51: l_wl_list(l_node_counter).WHERE_CLAUSE := 'resource_id = :owner_id or resource_id = :assignee_id';
52: l_wl_list(l_node_counter).NODE_TYPE := 1;
53: l_wl_list(l_node_counter).HIDE_IF_EMPTY := '';
54: l_wl_list(l_node_counter).NODE_DEPTH := 1;
55: l_wl_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_bind_list);
56: l_wl_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
57:
58: /*
59:
81: ' and owner_id = :owner_id and (status_id <> 3 or status_id <> 4) ';
82: l_wl_list(l_node_counter).NODE_TYPE := 2;
83: l_wl_list(l_node_counter).HIDE_IF_EMPTY := '';
84: l_wl_list(l_node_counter).NODE_DEPTH := 2;
85: l_wl_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_own_bind_list);
86: l_wl_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
87: l_node_counter := l_node_counter + 1;
88:
89:
107: 'and assignee_id = :assignee_id and (status_id <> 3 or status_id <> 4)';
108: l_wl_list(l_node_counter).NODE_TYPE := 3;
109: l_wl_list(l_node_counter).HIDE_IF_EMPTY := '';
110: l_wl_list(l_node_counter).NODE_DEPTH := 2;
111: l_wl_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_asg_bind_list);
112: l_wl_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
113: l_node_counter := l_node_counter + 1;
114:
115: -- Owned by My Groups
133: ( select group_id from jtf_rs_group_members where resource_id= :owner_id ) and (status_id <> 3 or status_id <> 4) ';
134: l_wl_list(l_node_counter).NODE_TYPE := 4;
135: l_wl_list(l_node_counter).HIDE_IF_EMPTY := '';
136: l_wl_list(l_node_counter).NODE_DEPTH := 2;
137: l_wl_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_own_bind_list);
138: l_wl_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
139: l_node_counter := l_node_counter + 1;
140:
141: -- Assigned To My Groups
158: ( select group_id from jtf_rs_group_members where resource_id= :assignee_id ) and (status_id <> 3 or status_id <> 4) ';
159: l_wl_list(l_node_counter).NODE_TYPE := 5;
160: l_wl_list(l_node_counter).HIDE_IF_EMPTY := '';
161: l_wl_list(l_node_counter).NODE_DEPTH := 2;
162: l_wl_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_asg_bind_list);
163: l_wl_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
164: l_node_counter := l_node_counter + 1;
165:
166: */
164: l_node_counter := l_node_counter + 1;
165:
166: */
167:
168: IEU_PUB.ADD_UWQ_NODE_DATA
169: (P_RESOURCE_ID,
170: P_SEL_ENUM_ID,
171: l_wl_list
172: );