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.4.12020000.2 2013/05/06 06:02:13 spamujul ship $ */
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 1079: -- IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE('DIST_TO',l_where_clause);

1075: end if;
1076:
1077: --- *** Get the Distributed Work Item with sorted by pty and due_date *** ---
1078:
1079: -- IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE('DIST_TO',l_where_clause);
1080:
1081: -- Build the complete select stmt
1082: /* Bug 10164373, 10634614 added alisas items to the below query*/
1083: l_sql_stmt := 'SELECT /*+ first_rows */

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

1231: -- CLOSE l_del_wr_cur;
1232:
1233: --- *** Get the Distributable Work Item with sorted by pty and due_date *** ---
1234:
1235: -- IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE('DIST_FROM',l_where_clause);
1236:
1237: -- Get the Distributed Work Item with sorted by pty and due_date
1238:
1239: -- Build the complete select stmt

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

1454: --dbms_output.put_line('Delivery Only');
1455:
1456:
1457:
1458: IEU_UWQ_GET_NEXT_WORK_PVT.SET_DIST_AND_DEL_ITEM_DATA_REC(p_var_in_type_code => 'REC',
1459: p_dist_workitem_data => null,
1460: p_dist_del_workitem_data => l_del_nw_item,
1461: x_ctr => l_ctr,
1462: x_workitem_action_data => x_uwqm_workitem_data);

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

1679: --dbms_output.put_line('Delivery Only');
1680:
1681:
1682:
1683: IEU_UWQ_GET_NEXT_WORK_PVT.SET_DIST_AND_DEL_ITEM_DATA_REC(p_var_in_type_code => 'REC',
1684: p_dist_workitem_data => null,
1685: p_dist_del_workitem_data => l_del_nw_item,
1686: x_ctr => l_ctr,
1687: x_workitem_action_data => x_uwqm_workitem_data);

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

2303:
2304: -- If a work item was distributed, copy the Work Item data from table of obj - l_dist_workitem_data
2305: -- to table of Rec - x_uwqm_workitem_data
2306:
2307: IEU_UWQ_GET_NEXT_WORK_PVT.SET_DIST_AND_DEL_ITEM_DATA_REC(p_var_in_type_code => 'OBJ',
2308: -- p_dist_workitem_data => l_dist_workitem_data,
2309: p_dist_workitem_data => l_dist_items,
2310: p_dist_del_workitem_data => null,
2311: x_ctr => l_ctr,

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

2410: l_ieu_comment_code3 := 'DIST_FAILURE_DELIVERY_ONLY';
2411: end if;/* Audit Log Val is detailed */
2412:
2413:
2414: IEU_UWQ_GET_NEXT_WORK_PVT.SET_DIST_AND_DEL_ITEM_DATA_REC(p_var_in_type_code => 'REC',
2415: p_dist_workitem_data => null,
2416: p_dist_del_workitem_data => l_del_nw_item,
2417: x_ctr => l_ctr,
2418: x_workitem_action_data => x_uwqm_workitem_data);

Line 2544: x_uwqm_workitem_data OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST,

2540: p_source_lang IN VARCHAR2,
2541: p_num_of_dist_items IN NUMBER, -- Number of Items Requested to be Distributed
2542: p_extra_where_clause IN VARCHAR2,
2543: p_bindvar_list IN IEU_UWQ_BINDVAR_LIST,
2544: x_uwqm_workitem_data OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST,
2545: x_num_of_items_distributed OUT NOCOPY NUMBER, -- Number of Items finally Distributed
2546: x_msg_count OUT NOCOPY NUMBER,
2547: x_msg_data OUT NOCOPY VARCHAR2,
2548: x_return_status OUT NOCOPY VARCHAR2) IS

Line 2606: IEU_UWQ_GET_NEXT_WORK_PVT.GET_DIST_WR_ITEMS

2602: -- dbms_output.put_line('calling get_next_wr_item..requesting '||l_num_of_dist_items ||' items');
2603:
2604: l_dist_deliver_num_of_attempts := l_dist_items_ctr;
2605:
2606: IEU_UWQ_GET_NEXT_WORK_PVT.GET_DIST_WR_ITEMS
2607: ( p_api_version => p_api_version,
2608: p_resource_id => p_resource_id,
2609: p_language => p_language,
2610: p_source_lang => p_source_lang,

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

2630: -- l_num_of_items_distributed - Items distributed this time
2631:
2632: x_num_of_items_distributed := x_num_of_items_distributed + l_num_of_items_distributed;
2633:
2634: IEU_UWQ_GET_NEXT_WORK_PVT.SET_WR_ITEM_DATA_REC(p_var_in_type_code => 'OBJ',
2635: p_dist_workitem_data => l_dist_workitem_data,
2636: p_dist_del_workitem_data => null,
2637: x_ctr => l_ctr,
2638: x_uwqm_workitem_data => x_uwqm_workitem_data);

Line 2722: l_next_wr_items IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

2718: l_sql_stmt VARCHAR2(4000);
2719: l_dist_status NUMBER := 1;
2720: l_open_status_id NUMBER := 0;
2721: l_resource_id NUMBER := 100001713;
2722: l_next_wr_items IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
2723:
2724:
2725: -- Table of records for all OUT variables
2726: l_work_item_num NUMBER;

Line 2728: l_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;

2724:
2725: -- Table of records for all OUT variables
2726: l_work_item_num NUMBER;
2727:
2728: l_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
2729: l_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
2730: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2731:
2732: l_nw_items_list2 IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;

Line 2729: l_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;

2725: -- Table of records for all OUT variables
2726: l_work_item_num NUMBER;
2727:
2728: l_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
2729: l_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
2730: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2731:
2732: l_nw_items_list2 IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2733: l_nw_ctr number := 1;

Line 2730: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;

2726: l_work_item_num NUMBER;
2727:
2728: l_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
2729: l_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
2730: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2731:
2732: l_nw_items_list2 IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2733: l_nw_ctr number := 1;
2734: z number := 0;

Line 2732: l_nw_items_list2 IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;

2728: l_wr_cur IEU_UWQ_GET_NEXT_WORK_PVT.l_get_work;
2729: l_nw_item IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC := null;
2730: l_nw_items_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2731:
2732: l_nw_items_list2 IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA;
2733: l_nw_ctr number := 1;
2734: z number := 0;
2735:
2736: l_num_of_dist_items_incr number := 0;

Line 2739: l_dist_items IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_DIST_ITEM_DATA;

2735:
2736: l_num_of_dist_items_incr number := 0;
2737:
2738: /*
2739: l_dist_items IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_DIST_ITEM_DATA;
2740: l_dist_bus_rules IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_DIST_RULES;
2741: */
2742:
2743: l_dist_items SYSTEM.WR_ITEM_DATA_NST;

Line 2740: l_dist_bus_rules IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_DIST_RULES;

2736: l_num_of_dist_items_incr number := 0;
2737:
2738: /*
2739: l_dist_items IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_DIST_ITEM_DATA;
2740: l_dist_bus_rules IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_DIST_RULES;
2741: */
2742:
2743: l_dist_items SYSTEM.WR_ITEM_DATA_NST;
2744: l_dist_bus_rules SYSTEM.DIST_BUS_RULES_NST;

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

2826:
2827: x_uwqm_workitem_data := SYSTEM.WR_ITEM_DATA_NST();
2828:
2829: -- Get the Where Clause
2830: -- IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE('DIST_FROM',l_where_clause);
2831:
2832: -- Build the complete select stmt
2833: l_sql_stmt := 'SELECT /*+ first_rows */
2834: WORK_ITEM_ID,

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

3641: END GET_DIST_WR_ITEMS;
3642:
3643: /**
3644: ** Called by PROCEDURE - DISTRIBUTE_AND_DELIVER_WR_ITEM, DISTRIBUTE_WORK_ITEMS
3645: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR
3646: ** table of objects SYSTEM.WR_ITEM_DATA_NST
3647: ** The In var - p_var_in_type_code indicates if its a record - 'REC' or an object - 'OBJ'
3648: ** 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
3649: ** to table of records of type - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST

Line 3648: ** 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

3644: ** Called by PROCEDURE - DISTRIBUTE_AND_DELIVER_WR_ITEM, DISTRIBUTE_WORK_ITEMS
3645: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR
3646: ** table of objects SYSTEM.WR_ITEM_DATA_NST
3647: ** The In var - p_var_in_type_code indicates if its a record - 'REC' or an object - 'OBJ'
3648: ** 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
3649: ** to table of records of type - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST
3650: **/
3651:
3652: PROCEDURE SET_WR_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,

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

3645: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR
3646: ** table of objects SYSTEM.WR_ITEM_DATA_NST
3647: ** The In var - p_var_in_type_code indicates if its a record - 'REC' or an object - 'OBJ'
3648: ** 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
3649: ** to table of records of type - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST
3650: **/
3651:
3652: PROCEDURE SET_WR_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,
3653: p_dist_workitem_data IN SYSTEM.WR_ITEM_DATA_NST,

Line 3654: p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,

3650: **/
3651:
3652: PROCEDURE SET_WR_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,
3653: p_dist_workitem_data IN SYSTEM.WR_ITEM_DATA_NST,
3654: p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,
3655: x_ctr IN OUT NOCOPY NUMBER,
3656: x_uwqm_workitem_data IN OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST) IS
3657:
3658: l_object_function VARCHAR2(40);

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

3652: PROCEDURE SET_WR_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,
3653: p_dist_workitem_data IN SYSTEM.WR_ITEM_DATA_NST,
3654: p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,
3655: x_ctr IN OUT NOCOPY NUMBER,
3656: x_uwqm_workitem_data IN OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST) IS
3657:
3658: l_object_function VARCHAR2(40);
3659: l_object_parameters VARCHAR2(500);
3660: l_enter_from_task VARCHAR2(10);

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

3837: ** Distribute Only returns the table of Records in a different format compared to Distribute and Deliver.
3838: ** This was required as Distribute Only can return multiple records. Distribute and Deliver requires the Return Record
3839: ** to be of type IEU_FRM_PVT.T_IEU_MEDIA_DATA for processing on the FORM.
3840: ** Called by PROCEDURE - DISTRIBUTE_AND_DELIVER_WR_ITEM
3841: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR
3842: ** table of objects SYSTEM.WR_ITEM_DATA_NST
3843: ** The In var - p_var_in_type_code indicates if its a record - 'REC' or an object - 'OBJ'
3844: ** 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
3845: ** to table of records of type - IEU_FRM_PVT.T_IEU_MEDIA_DATA

Line 3844: ** 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

3840: ** Called by PROCEDURE - DISTRIBUTE_AND_DELIVER_WR_ITEM
3841: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR
3842: ** table of objects SYSTEM.WR_ITEM_DATA_NST
3843: ** The In var - p_var_in_type_code indicates if its a record - 'REC' or an object - 'OBJ'
3844: ** 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
3845: ** to table of records of type - IEU_FRM_PVT.T_IEU_MEDIA_DATA
3846: **/
3847:
3848: PROCEDURE SET_DIST_AND_DEL_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,

Line 3850: p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,

3846: **/
3847:
3848: PROCEDURE SET_DIST_AND_DEL_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,
3849: p_dist_workitem_data IN SYSTEM.WR_ITEM_DATA_NST,
3850: p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,
3851: x_ctr IN OUT NOCOPY NUMBER,
3852: x_workitem_action_data IN OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA) IS
3853:
3854:

Line 4310: p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,

4306: ** This extra where clause will be appened to actual where clause to fetch the set of distributable items
4307: **/
4308: PROCEDURE GET_WS_WHERE_CLAUSE
4309: (p_type IN VARCHAR2,
4310: p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,
4311: p_resource_id IN NUMBER,
4312: x_dist_from_where OUT NOCOPY VARCHAR2,
4313: x_dist_to_where OUT NOCOPY VARCHAR2,
4314: x_bindvar_from_list OUT NOCOPY IEU_UWQ_BINDVAR_LIST,

Line 4359: p_grp_id_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_GRP_ID_LIST;

4355: l_dt_grp_own_ctr number := 0;
4356: l_dt_grp_asg_ctr number := 0;
4357:
4358: z number := 1;
4359: p_grp_id_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_GRP_ID_LIST;
4360: l_df_grp_id_clause varchar2(4000);
4361: l_df_grp_id_ctr number := 0;
4362:
4363: l_delete_flag_yes varchar2(1);

Line 4866: (p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,

4862:
4863: END GET_WS_WHERE_CLAUSE;
4864:
4865: PROCEDURE GET_WS_WHERE_CLAUSE
4866: (p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,
4867: p_resource_id IN NUMBER,
4868: x_dist_from_where OUT NOCOPY VARCHAR2,
4869: x_dist_to_where OUT NOCOPY VARCHAR2
4870: ) IS

Line 4883: p_grp_id_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_GRP_ID_LIST;

4879: X_RETURN_STATUS OUT NOCOPY VARCHAR2
4880: )
4881: IS
4882:
4883: p_grp_id_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_GRP_ID_LIST;
4884: l_df_grp_id_clause varchar2(1000);
4885: l_df_grp_id_ctr number := 0;
4886: z number := 1;
4887: l_sql_stmt varchar2(4000);

Line 4966: END IEU_UWQ_GET_NEXT_WORK_PVT;

4962:
4963: END CLEANUP_DISTRIBUTING_STATUS;
4964:
4965:
4966: END IEU_UWQ_GET_NEXT_WORK_PVT;
4967: