APPS.IEU_NEXT_WORK_IEUSCPOP dependencies on IEU_NEXT_WORK_IEUSCPOP

Line 1: PACKAGE BODY IEU_NEXT_WORK_IEUSCPOP AS

1: PACKAGE BODY IEU_NEXT_WORK_IEUSCPOP AS
2: /* $Header: IEUGNWDB.pls 115.6 2004/06/03 15:57:48 pkumble noship $ */
3:
4:
5: PROCEDURE EXECUTE_NEXT_WORK_PROC(

Line 9: x_wr_item_data_list IN OUT nocopy IEU_NEXT_WORK_IEUSCPOP.IEU_WR_ITEM_DATA)

5: PROCEDURE EXECUTE_NEXT_WORK_PROC(
6: p_resource_id IN number,
7: p_ws_id_str IN VARCHAR2,
8: p_disp_cnt IN number,
9: x_wr_item_data_list IN OUT nocopy IEU_NEXT_WORK_IEUSCPOP.IEU_WR_ITEM_DATA)
10: IS
11: l_extra_where_clause varchar2(4000);
12: l_sql_stmt varchar2(4000);
13:

Line 17: l_nw_cur IEU_NEXT_WORK_IEUSCPOP.l_get_work;

13:
14: l_ctr number;
15: l_nw_ctr number;
16:
17: l_nw_cur IEU_NEXT_WORK_IEUSCPOP.l_get_work;
18: l_nw_item IEU_NEXT_WORK_IEUSCPOP.IEU_WR_ITEM_DATA_REC := null;
19: -- l_nw_items_list IEU_NEXT_WORK_IEUSCPOP.IEU_WR_ITEM_DATA;
20:
21: BEGIN

Line 18: l_nw_item IEU_NEXT_WORK_IEUSCPOP.IEU_WR_ITEM_DATA_REC := null;

14: l_ctr number;
15: l_nw_ctr number;
16:
17: l_nw_cur IEU_NEXT_WORK_IEUSCPOP.l_get_work;
18: l_nw_item IEU_NEXT_WORK_IEUSCPOP.IEU_WR_ITEM_DATA_REC := null;
19: -- l_nw_items_list IEU_NEXT_WORK_IEUSCPOP.IEU_WR_ITEM_DATA;
20:
21: BEGIN
22:

Line 19: -- l_nw_items_list IEU_NEXT_WORK_IEUSCPOP.IEU_WR_ITEM_DATA;

15: l_nw_ctr number;
16:
17: l_nw_cur IEU_NEXT_WORK_IEUSCPOP.l_get_work;
18: l_nw_item IEU_NEXT_WORK_IEUSCPOP.IEU_WR_ITEM_DATA_REC := null;
19: -- l_nw_items_list IEU_NEXT_WORK_IEUSCPOP.IEU_WR_ITEM_DATA;
20:
21: BEGIN
22:
23: -- insert into p_temp(msg) values('inside'); commit;

Line 93: END IEU_NEXT_WORK_IEUSCPOP;

89: -- insert into p_temp(msg) values('profile flag '||l_enabled_flag);commit;
90: x_enabled_flag := l_enabled_flag;
91: end;
92:
93: END IEU_NEXT_WORK_IEUSCPOP;