APPS.IEU_DIAG_AUDIT_TRACK_PVT dependencies on IEU_DIAG_NOTMEMBER_NST

Line 25: l_results IEU_DIAG_NOTMEMBER_NST;

21: owner_name varchar2(2000);
22: assignee_name varchar2(2000);
23: priority varchar2(2000);
24: title varchar2(2000);
25: l_results IEU_DIAG_NOTMEMBER_NST;
26: l_tmp number;
27: l_temp_count number;
28: work_item_number number;
29: l_ws_code varchar2(2000);

Line 220: l_results IEU_DIAG_NOTMEMBER_NST;

216: owner_name varchar2(2000);
217: assignee_name varchar2(2000);
218: priority varchar2(2000);
219:
220: l_results IEU_DIAG_NOTMEMBER_NST;
221: l_tmp number;
222: l_temp_count number;
223: work_item_number number;
224: l_ws_code varchar2(2000);

Line 447: l_results IEU_DIAG_NOTMEMBER_NST;

443: owner_name_prev varchar2(2000);
444: assignee_name_prev varchar2(2000);
445: owner_name_curr varchar2(2000);
446: assignee_name_curr varchar2(2000);
447: l_results IEU_DIAG_NOTMEMBER_NST;
448: l_tmp number;
449: l_temp_count number;
450: work_item_number number;
451: title varchar2(2000);

Line 675: l_results IEU_DIAG_NOTMEMBER_NST;

671: owner_name_prev varchar2(2000);
672: assignee_name_prev varchar2(2000);
673: owner_name_curr varchar2(2000);
674: assignee_name_curr varchar2(2000);
675: l_results IEU_DIAG_NOTMEMBER_NST;
676: l_tmp number;
677: l_temp_count number;
678: work_item_number number;
679: title varchar2(2000);

Line 914: l_results IEU_DIAG_NOTMEMBER_NST;

910: owner_name varchar2(2000);
911: assignee_name varchar2(2000);
912: priority varchar2(2000);
913:
914: l_results IEU_DIAG_NOTMEMBER_NST;
915: l_tmp number;
916: l_temp_count number;
917: work_item_number number;
918: l_ws_name varchar2(2000);

Line 1092: x_results OUT NOCOPY IEU_DIAG_NOTMEMBER_NST

1088: x_msg_data OUT NOCOPY VARCHAR2,
1089: p_from_date IN DATE, -- format : 10-JAN-04
1090: p_to_date IN DATE,
1091: x_groups OUT NOCOPY IEU_DIAG_GROUP_NST,
1092: x_results OUT NOCOPY IEU_DIAG_NOTMEMBER_NST
1093: )AS
1094: l_msg_count NUMBER(2);
1095:
1096: l_msg_data VARCHAR2(2000);

Line 1107: l_results IEU_DIAG_NOTMEMBER_NST;

1103: l_from_date date ;
1104: l_to_date DATE ;
1105: l_date date;
1106:
1107: l_results IEU_DIAG_NOTMEMBER_NST;
1108: l_tmp number;
1109: l_temp_count number;
1110: work_item_number number;
1111: cursor cur_items IS

Line 1152: x_results := IEU_DIAG_NOTMEMBER_NST();

1148: fnd_msg_pub.delete_msg();
1149: x_return_status := fnd_api.g_ret_sts_success;
1150: x_msg_data := 'begin--> from '||p_from_date||' to '|| p_to_date;
1151: FND_MSG_PUB.initialize;
1152: x_results := IEU_DIAG_NOTMEMBER_NST();
1153: x_groups := IEU_DIAG_GROUP_NST();
1154: SELECT count(*) INTO l_tmp FROM ( select distinct a.workitem_pk_id, a.MODULE ,
1155: DECODE(a.WORKITEM_STATUS_ID_CURR,'0', 'Not Distributable', '1', 'Distributable',
1156: '2', 'Distributing', '3', 'Distributed') WORKITEM_STATUS_ID_CURR,