APPS.IEU_DIAG_AUDIT_TRACK_PVT dependencies on IEU_DIAG_GROUP_NST

Line 1091: x_groups OUT NOCOPY IEU_DIAG_GROUP_NST,

1087: x_msg_count OUT NOCOPY NUMBER,
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:

Line 1153: x_groups := IEU_DIAG_GROUP_NST();

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,
1157: DECODE(a.WORKITEM_DIST_STATUS_ID_CURR, '0', 'Not Distributable', '1', 'Distributable',