eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_UWQ_GET_NEXT_WORK_PVT dependencies on IEU_UWQ_GET_NEXT_WORK_PVT

Line 1: PACKAGE BODY IEU_UWQ_GET_NEXT_WORK_PVT AS

1: PACKAGE BODY IEU_UWQ_GET_NEXT_WORK_PVT AS
2: /* $Header: IEUVGNWB.pls 120.3 2006/03/08 22:40:21 msathyan noship $ */
3:
4: -- SORT NOT DONE BY WORKITEM OBJECT CODE SO IT WAS REMOVED FROM THE ORDER BY CLAUSE (DEC-06-2001) - ckurian
5:

Line 28: ( p_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.ieu_uwqm_item_data_rec,

24:
25: END GET_NEXT_WORKITEM;
26:
27: PROCEDURE GET_WORKITEM_ACTION_FUNC_DATA
28: ( p_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.ieu_uwqm_item_data_rec,
29: x_workitem_action_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA )
30: AS
31:
32:

Line 161: IEU_UWQ_GET_NEXT_WORK_PVT.GET_NEXT_WORKITEM

157:
158: IF (p_worklist_cont_mode = 'TRUE')
159: THEN
160:
161: IEU_UWQ_GET_NEXT_WORK_PVT.GET_NEXT_WORKITEM
162: ( p_api_version => p_next_work_api_version,
163: p_resource_id => p_resource_id,
164: p_user_id => p_user_id,
165: x_uwqm_workitem_data => x_uwqm_workitem_data,

Line 179: x_uwqm_workitem_data OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.ieu_uwqm_item_data,

175: ( p_api_version IN NUMBER,
176: p_resource_id IN NUMBER,
177: p_user_id IN NUMBER,
178: p_no_of_recs IN NUMBER,
179: x_uwqm_workitem_data OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.ieu_uwqm_item_data,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: x_return_status OUT NOCOPY VARCHAR2)
183: IS

Line 229: l_next_ind_own_work IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

225: l_open_status_id NUMBER := 0; -- Not In Use
226: l_lock_status_id NUMBER := 1; -- Status 'L' - Locked by UWQ
227:
228: -- cursor to get Owned items
229: l_next_ind_own_work IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
230: l_next_grp_own_work_1 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
231: l_next_grp_own_work_2 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
232:
233: -- cursor to get Assigned items

Line 230: l_next_grp_own_work_1 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

226: l_lock_status_id NUMBER := 1; -- Status 'L' - Locked by UWQ
227:
228: -- cursor to get Owned items
229: l_next_ind_own_work IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
230: l_next_grp_own_work_1 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
231: l_next_grp_own_work_2 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
232:
233: -- cursor to get Assigned items
234: l_next_ind_asg_work IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

Line 231: l_next_grp_own_work_2 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

227:
228: -- cursor to get Owned items
229: l_next_ind_own_work IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
230: l_next_grp_own_work_1 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
231: l_next_grp_own_work_2 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
232:
233: -- cursor to get Assigned items
234: l_next_ind_asg_work IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
235: l_next_grp_asg_work_1 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

Line 234: l_next_ind_asg_work IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

230: l_next_grp_own_work_1 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
231: l_next_grp_own_work_2 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
232:
233: -- cursor to get Assigned items
234: l_next_ind_asg_work IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
235: l_next_grp_asg_work_1 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
236: l_next_grp_asg_work_2 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
237:
238:

Line 235: l_next_grp_asg_work_1 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

231: l_next_grp_own_work_2 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
232:
233: -- cursor to get Assigned items
234: l_next_ind_asg_work IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
235: l_next_grp_asg_work_1 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
236: l_next_grp_asg_work_2 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
237:
238:
239: l_ind_own_no_data_found number := 0;

Line 236: l_next_grp_asg_work_2 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

232:
233: -- cursor to get Assigned items
234: l_next_ind_asg_work IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
235: l_next_grp_asg_work_1 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
236: l_next_grp_asg_work_2 IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
237:
238:
239: l_ind_own_no_data_found number := 0;
240: l_grp1_own_no_data_found number := 0;

Line 250: l_nw_item_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_NEXTWORK_ITEM_LIST;

246:
247: l_ctr PLS_INTEGER := 0;
248: l_loop_ctr PLS_INTEGER := 0;
249:
250: l_nw_item_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_NEXTWORK_ITEM_LIST;
251: l_uwqm_item_data IEU_UWQ_GET_NEXT_WORK_PVT.ieu_uwqm_item_data; -- := null;
252:
253: --- Values assigned for different work items ---
254:

Line 251: l_uwqm_item_data IEU_UWQ_GET_NEXT_WORK_PVT.ieu_uwqm_item_data; -- := null;

247: l_ctr PLS_INTEGER := 0;
248: l_loop_ctr PLS_INTEGER := 0;
249:
250: l_nw_item_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_NEXTWORK_ITEM_LIST;
251: l_uwqm_item_data IEU_UWQ_GET_NEXT_WORK_PVT.ieu_uwqm_item_data; -- := null;
252:
253: --- Values assigned for different work items ---
254:
255: l_owner_type_ind varchar2(25);

Line 850: l_nw_item_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_NEXTWORK_ITEM_LIST;

846: l_owner_type_ind varchar2(25);
847: l_owner_type_grp varchar2(25);
848: l_work_item_id number(15);
849:
850: l_nw_item_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_NEXTWORK_ITEM_LIST;
851:
852: BEGIN
853:
854: l_owner_type_ind := 'RS_INDIVIDUAL';

Line 951: l_next_wr_items IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

947: l_del_status NUMBER := 3;
948: l_dist_status NUMBER := 1;
949: l_open_status_id NUMBER := 0;
950: l_resource_id NUMBER := 100001713;
951: l_next_wr_items IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
952:
953:
954: -- Table of records for all OUT variables
955: l_del_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

Line 955: l_del_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

951: l_next_wr_items IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
952:
953:
954: -- Table of records for all OUT variables
955: l_del_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
956: l_dist_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
957: l_del_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
958: l_dist_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
959: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;

Line 956: l_dist_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

952:
953:
954: -- Table of records for all OUT variables
955: l_del_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
956: l_dist_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
957: l_del_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
958: l_dist_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
959: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
960: l_dist_flag VARCHAR2(10);

Line 957: l_del_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;

953:
954: -- Table of records for all OUT variables
955: l_del_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
956: l_dist_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
957: l_del_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
958: l_dist_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
959: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
960: l_dist_flag VARCHAR2(10);
961: l_del_items_flag VARCHAR2(10);

Line 958: l_dist_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;

954: -- Table of records for all OUT variables
955: l_del_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
956: l_dist_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
957: l_del_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
958: l_dist_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
959: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
960: l_dist_flag VARCHAR2(10);
961: l_del_items_flag VARCHAR2(10);
962: l_dist_items_flag VARCHAR2(10);

Line 959: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;

955: l_del_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
956: l_dist_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
957: l_del_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
958: l_dist_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
959: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
960: l_dist_flag VARCHAR2(10);
961: l_del_items_flag VARCHAR2(10);
962: l_dist_items_flag VARCHAR2(10);
963: l_delivery_only_flag VARCHAR2(10);

Line 1075: -- IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE('DIST_TO',l_where_clause);

1071: end if;
1072:
1073: --- *** Get the Distributed Work Item with sorted by pty and due_date *** ---
1074:
1075: -- IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE('DIST_TO',l_where_clause);
1076:
1077: -- Build the complete select stmt
1078: l_sql_stmt := 'SELECT /*+ first_rows */
1079: WORK_ITEM_ID,

Line 1199: -- IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE('DIST_FROM',l_where_clause);

1195: -- CLOSE l_del_wr_cur;
1196:
1197: --- *** Get the Distributable Work Item with sorted by pty and due_date *** ---
1198:
1199: -- IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE('DIST_FROM',l_where_clause);
1200:
1201: -- Get the Distributed Work Item with sorted by pty and due_date
1202:
1203: -- Build the complete select stmt

Line 1424: IEU_UWQ_GET_NEXT_WORK_PVT.SET_DIST_AND_DEL_ITEM_DATA_REC(p_var_in_type_code => 'REC',

1420: --dbms_output.put_line('Delivery Only');
1421:
1422:
1423:
1424: IEU_UWQ_GET_NEXT_WORK_PVT.SET_DIST_AND_DEL_ITEM_DATA_REC(p_var_in_type_code => 'REC',
1425: p_dist_workitem_data => null,
1426: p_dist_del_workitem_data => l_del_nw_item,
1427: x_ctr => l_ctr,
1428: x_workitem_action_data => x_uwqm_workitem_data);

Line 1649: IEU_UWQ_GET_NEXT_WORK_PVT.SET_DIST_AND_DEL_ITEM_DATA_REC(p_var_in_type_code => 'REC',

1645: --dbms_output.put_line('Delivery Only');
1646:
1647:
1648:
1649: IEU_UWQ_GET_NEXT_WORK_PVT.SET_DIST_AND_DEL_ITEM_DATA_REC(p_var_in_type_code => 'REC',
1650: p_dist_workitem_data => null,
1651: p_dist_del_workitem_data => l_del_nw_item,
1652: x_ctr => l_ctr,
1653: x_workitem_action_data => x_uwqm_workitem_data);

Line 2273: IEU_UWQ_GET_NEXT_WORK_PVT.SET_DIST_AND_DEL_ITEM_DATA_REC(p_var_in_type_code => 'OBJ',

2269:
2270: -- If a work item was distributed, copy the Work Item data from table of obj - l_dist_workitem_data
2271: -- to table of Rec - x_uwqm_workitem_data
2272:
2273: IEU_UWQ_GET_NEXT_WORK_PVT.SET_DIST_AND_DEL_ITEM_DATA_REC(p_var_in_type_code => 'OBJ',
2274: -- p_dist_workitem_data => l_dist_workitem_data,
2275: p_dist_workitem_data => l_dist_items,
2276: p_dist_del_workitem_data => null,
2277: x_ctr => l_ctr,

Line 2380: IEU_UWQ_GET_NEXT_WORK_PVT.SET_DIST_AND_DEL_ITEM_DATA_REC(p_var_in_type_code => 'REC',

2376: l_ieu_comment_code3 := 'DIST_FAILURE_DELIVERY_ONLY';
2377: end if;/* Audit Log Val is detailed */
2378:
2379:
2380: IEU_UWQ_GET_NEXT_WORK_PVT.SET_DIST_AND_DEL_ITEM_DATA_REC(p_var_in_type_code => 'REC',
2381: p_dist_workitem_data => null,
2382: p_dist_del_workitem_data => l_del_nw_item,
2383: x_ctr => l_ctr,
2384: x_workitem_action_data => x_uwqm_workitem_data);

Line 2510: x_uwqm_workitem_data OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST,

2506: p_source_lang IN VARCHAR2,
2507: p_num_of_dist_items IN NUMBER, -- Number of Items Requested to be Distributed
2508: p_extra_where_clause IN VARCHAR2,
2509: p_bindvar_list IN IEU_UWQ_BINDVAR_LIST,
2510: x_uwqm_workitem_data OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST,
2511: x_num_of_items_distributed OUT NOCOPY NUMBER, -- Number of Items finally Distributed
2512: x_msg_count OUT NOCOPY NUMBER,
2513: x_msg_data OUT NOCOPY VARCHAR2,
2514: x_return_status OUT NOCOPY VARCHAR2) IS

Line 2572: IEU_UWQ_GET_NEXT_WORK_PVT.GET_DIST_WR_ITEMS

2568: -- dbms_output.put_line('calling get_next_wr_item..requesting '||l_num_of_dist_items ||' items');
2569:
2570: l_dist_deliver_num_of_attempts := l_dist_items_ctr;
2571:
2572: IEU_UWQ_GET_NEXT_WORK_PVT.GET_DIST_WR_ITEMS
2573: ( p_api_version => p_api_version,
2574: p_resource_id => p_resource_id,
2575: p_language => p_language,
2576: p_source_lang => p_source_lang,

Line 2600: IEU_UWQ_GET_NEXT_WORK_PVT.SET_WR_ITEM_DATA_REC(p_var_in_type_code => 'OBJ',

2596: -- l_num_of_items_distributed - Items distributed this time
2597:
2598: x_num_of_items_distributed := x_num_of_items_distributed + l_num_of_items_distributed;
2599:
2600: IEU_UWQ_GET_NEXT_WORK_PVT.SET_WR_ITEM_DATA_REC(p_var_in_type_code => 'OBJ',
2601: p_dist_workitem_data => l_dist_workitem_data,
2602: p_dist_del_workitem_data => null,
2603: x_ctr => l_ctr,
2604: x_uwqm_workitem_data => x_uwqm_workitem_data);

Line 2688: l_next_wr_items IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

2684: l_sql_stmt VARCHAR2(4000);
2685: l_dist_status NUMBER := 1;
2686: l_open_status_id NUMBER := 0;
2687: l_resource_id NUMBER := 100001713;
2688: l_next_wr_items IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
2689:
2690:
2691: -- Table of records for all OUT variables
2692: l_work_item_num NUMBER;

Line 2694: l_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

2690:
2691: -- Table of records for all OUT variables
2692: l_work_item_num NUMBER;
2693:
2694: l_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
2695: l_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
2696: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2697:
2698: l_nw_items_list2 IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;

Line 2695: l_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;

2691: -- Table of records for all OUT variables
2692: l_work_item_num NUMBER;
2693:
2694: l_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
2695: l_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
2696: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2697:
2698: l_nw_items_list2 IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2699: l_nw_ctr number := 1;

Line 2696: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;

2692: l_work_item_num NUMBER;
2693:
2694: l_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
2695: l_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
2696: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2697:
2698: l_nw_items_list2 IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2699: l_nw_ctr number := 1;
2700: z number := 0;

Line 2698: l_nw_items_list2 IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;

2694: l_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
2695: l_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
2696: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2697:
2698: l_nw_items_list2 IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2699: l_nw_ctr number := 1;
2700: z number := 0;
2701:
2702: l_num_of_dist_items_incr number := 0;

Line 2705: l_dist_items IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_DIST_ITEM_DATA;

2701:
2702: l_num_of_dist_items_incr number := 0;
2703:
2704: /*
2705: l_dist_items IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_DIST_ITEM_DATA;
2706: l_dist_bus_rules IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_DIST_RULES;
2707: */
2708:
2709: l_dist_items SYSTEM.WR_ITEM_DATA_NST;

Line 2706: l_dist_bus_rules IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_DIST_RULES;

2702: l_num_of_dist_items_incr number := 0;
2703:
2704: /*
2705: l_dist_items IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_DIST_ITEM_DATA;
2706: l_dist_bus_rules IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_DIST_RULES;
2707: */
2708:
2709: l_dist_items SYSTEM.WR_ITEM_DATA_NST;
2710: l_dist_bus_rules SYSTEM.DIST_BUS_RULES_NST;

Line 2796: -- IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE('DIST_FROM',l_where_clause);

2792:
2793: x_uwqm_workitem_data := SYSTEM.WR_ITEM_DATA_NST();
2794:
2795: -- Get the Where Clause
2796: -- IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE('DIST_FROM',l_where_clause);
2797:
2798: -- Build the complete select stmt
2799: l_sql_stmt := 'SELECT /*+ first_rows */
2800: WORK_ITEM_ID,

Line 3611: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR

3607: END GET_DIST_WR_ITEMS;
3608:
3609: /**
3610: ** Called by PROCEDURE - DISTRIBUTE_AND_DELIVER_WR_ITEM, DISTRIBUTE_WORK_ITEMS
3611: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR
3612: ** table of objects SYSTEM.WR_ITEM_DATA_NST
3613: ** The In var - p_var_in_type_code indicates if its a record - 'REC' or an object - 'OBJ'
3614: ** Copies the Work Item data from table of objects - SYSTEM.WR_ITEM_DATA_NST or rec - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC
3615: ** to table of records of type - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST

Line 3614: ** Copies the Work Item data from table of objects - SYSTEM.WR_ITEM_DATA_NST or rec - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC

3610: ** Called by PROCEDURE - DISTRIBUTE_AND_DELIVER_WR_ITEM, DISTRIBUTE_WORK_ITEMS
3611: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR
3612: ** table of objects SYSTEM.WR_ITEM_DATA_NST
3613: ** The In var - p_var_in_type_code indicates if its a record - 'REC' or an object - 'OBJ'
3614: ** Copies the Work Item data from table of objects - SYSTEM.WR_ITEM_DATA_NST or rec - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC
3615: ** to table of records of type - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST
3616: **/
3617:
3618: PROCEDURE SET_WR_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,

Line 3615: ** to table of records of type - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST

3611: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR
3612: ** table of objects SYSTEM.WR_ITEM_DATA_NST
3613: ** The In var - p_var_in_type_code indicates if its a record - 'REC' or an object - 'OBJ'
3614: ** Copies the Work Item data from table of objects - SYSTEM.WR_ITEM_DATA_NST or rec - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC
3615: ** to table of records of type - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST
3616: **/
3617:
3618: PROCEDURE SET_WR_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,
3619: p_dist_workitem_data IN SYSTEM.WR_ITEM_DATA_NST,

Line 3620: p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,

3616: **/
3617:
3618: PROCEDURE SET_WR_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,
3619: p_dist_workitem_data IN SYSTEM.WR_ITEM_DATA_NST,
3620: p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,
3621: x_ctr IN OUT NOCOPY NUMBER,
3622: x_uwqm_workitem_data IN OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST) IS
3623:
3624: l_object_function VARCHAR2(40);

Line 3622: x_uwqm_workitem_data IN OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST) IS

3618: PROCEDURE SET_WR_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,
3619: p_dist_workitem_data IN SYSTEM.WR_ITEM_DATA_NST,
3620: p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,
3621: x_ctr IN OUT NOCOPY NUMBER,
3622: x_uwqm_workitem_data IN OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST) IS
3623:
3624: l_object_function VARCHAR2(40);
3625: l_object_parameters VARCHAR2(500);
3626: l_enter_from_task VARCHAR2(10);

Line 3807: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR

3803: ** Distribute Only returns the table of Records in a different format compared to Distribute and Deliver.
3804: ** This was required as Distribute Only can return multiple records. Distribute and Deliver requires the Return Record
3805: ** to be of type IEU_FRM_PVT.T_IEU_MEDIA_DATA for processing on the FORM.
3806: ** Called by PROCEDURE - DISTRIBUTE_AND_DELIVER_WR_ITEM
3807: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR
3808: ** table of objects SYSTEM.WR_ITEM_DATA_NST
3809: ** The In var - p_var_in_type_code indicates if its a record - 'REC' or an object - 'OBJ'
3810: ** Copies the Work Item data from table of objects - SYSTEM.WR_ITEM_DATA_NST or rec - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC
3811: ** to table of records of type - IEU_FRM_PVT.T_IEU_MEDIA_DATA

Line 3810: ** Copies the Work Item data from table of objects - SYSTEM.WR_ITEM_DATA_NST or rec - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC

3806: ** Called by PROCEDURE - DISTRIBUTE_AND_DELIVER_WR_ITEM
3807: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR
3808: ** table of objects SYSTEM.WR_ITEM_DATA_NST
3809: ** The In var - p_var_in_type_code indicates if its a record - 'REC' or an object - 'OBJ'
3810: ** Copies the Work Item data from table of objects - SYSTEM.WR_ITEM_DATA_NST or rec - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC
3811: ** to table of records of type - IEU_FRM_PVT.T_IEU_MEDIA_DATA
3812: **/
3813:
3814: PROCEDURE SET_DIST_AND_DEL_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,

Line 3816: p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,

3812: **/
3813:
3814: PROCEDURE SET_DIST_AND_DEL_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,
3815: p_dist_workitem_data IN SYSTEM.WR_ITEM_DATA_NST,
3816: p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,
3817: x_ctr IN OUT NOCOPY NUMBER,
3818: x_workitem_action_data IN OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA) IS
3819:
3820:

Line 4276: p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,

4272: ** This extra where clause will be appened to actual where clause to fetch the set of distributable items
4273: **/
4274: PROCEDURE GET_WS_WHERE_CLAUSE
4275: (p_type IN VARCHAR2,
4276: p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,
4277: p_resource_id IN NUMBER,
4278: x_dist_from_where OUT NOCOPY VARCHAR2,
4279: x_dist_to_where OUT NOCOPY VARCHAR2,
4280: x_bindvar_from_list OUT NOCOPY IEU_UWQ_BINDVAR_LIST,

Line 4325: p_grp_id_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_GRP_ID_LIST;

4321: l_dt_grp_own_ctr number := 0;
4322: l_dt_grp_asg_ctr number := 0;
4323:
4324: z number := 1;
4325: p_grp_id_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_GRP_ID_LIST;
4326: l_df_grp_id_clause varchar2(4000);
4327: l_df_grp_id_ctr number := 0;
4328:
4329: l_delete_flag_yes varchar2(1);

Line 4802: (p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,

4798:
4799: END GET_WS_WHERE_CLAUSE;
4800:
4801: PROCEDURE GET_WS_WHERE_CLAUSE
4802: (p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,
4803: p_resource_id IN NUMBER,
4804: x_dist_from_where OUT NOCOPY VARCHAR2,
4805: x_dist_to_where OUT NOCOPY VARCHAR2
4806: ) IS

Line 4819: p_grp_id_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_GRP_ID_LIST;

4815: X_RETURN_STATUS OUT NOCOPY VARCHAR2
4816: )
4817: IS
4818:
4819: p_grp_id_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_GRP_ID_LIST;
4820: l_df_grp_id_clause varchar2(1000);
4821: l_df_grp_id_ctr number := 0;
4822: z number := 1;
4823: l_sql_stmt varchar2(4000);

Line 4902: END IEU_UWQ_GET_NEXT_WORK_PVT;

4898:
4899: END CLEANUP_DISTRIBUTING_STATUS;
4900:
4901:
4902: END IEU_UWQ_GET_NEXT_WORK_PVT;
4903: