DBA Data[Home] [Help]

APPS.IEU_WORKLIST_ENUMS_PVT dependencies on IEU_PUB

Line 17: l_wl_list IEU_PUB.EnumeratorDataRecordList;

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;

Line 18: l_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;

Line 19: l_ind_own_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:

Line 20: l_ind_asg_bind_list IEU_PUB.BindVariableRecordList;

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

Line 21: l_grp_own_bind_list IEU_PUB.BindVariableRecordList;

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:

Line 22: l_grp_asg_bind_list IEU_PUB.BindVariableRecordList;

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

Line 55: l_wl_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_bind_list);

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:

Line 85: l_wl_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_own_bind_list);

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:

Line 111: l_wl_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_ind_asg_bind_list);

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

Line 137: l_wl_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_own_bind_list);

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

Line 162: l_wl_list(l_node_counter).BIND_VARS := ieu_pub.set_bind_var_data(l_grp_asg_bind_list);

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: */

Line 168: IEU_PUB.ADD_UWQ_NODE_DATA

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