DBA Data[Home] [Help]

APPS.HXC_RETRIEVE_ABSENCES dependencies on HXC_ABS_STATUS_TABLE

Line 1315: p_abs_status_tab OUT NOCOPY HXC_ABS_STATUS_TABLE)

1311:
1312: PROCEDURE get_abs_statuses ( p_person_id IN NUMBER,
1313: p_start_date IN VARCHAR2,
1314: p_end_date IN VARCHAR2,
1315: p_abs_status_tab OUT NOCOPY HXC_ABS_STATUS_TABLE)
1316: IS
1317:
1318: l_abs_status_rec HXC_ABS_STATUS_TYPE;
1319: l_abs_status_tab ABS_STATUS_TAB;

Line 1329: p_abs_status_tab := HXC_ABS_STATUS_TABLE();

1325: fnd_date.canonical_to_date(p_start_date), --TO_DATE(p_start_date,'yyyy/mm/dd'),
1326: fnd_date.canonical_to_date(p_end_date), --TO_DATE(p_end_date,'yyyy/mm/dd'),
1327: l_abs_status_tab);
1328:
1329: p_abs_status_tab := HXC_ABS_STATUS_TABLE();
1330:
1331: IF l_abs_status_tab.COUNT > 0 THEN
1332:
1333: FOR i IN l_abs_status_tab.FIRST..l_abs_status_tab.LAST