APPS.PN_SPACE_ASSIGN_CUST_PKG dependencies on PN_RECOVERY_EXTRACT_PKG

Line 1115: l_num_table pn_recovery_extract_pkg.number_table_TYPE;

1111: AND p_start_date between active_start_date
1112: AND NVL(active_end_date,to_date('12/31/4712','MM/DD/YYYY'))
1113: ;
1114:
1115: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
1116: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
1117: l_date DATE := NULL;
1118: p_date1 DATE := NULL;
1119: l_start_date DATE := NULL;

Line 1116: l_date_table pn_recovery_extract_pkg.date_table_TYPE;

1112: AND NVL(active_end_date,to_date('12/31/4712','MM/DD/YYYY'))
1113: ;
1114:
1115: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
1116: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
1117: l_date DATE := NULL;
1118: p_date1 DATE := NULL;
1119: l_start_date DATE := NULL;
1120: l_end_date DATE := NULL;

Line 1171: pn_recovery_extract_pkg.process_vacancy(

1167: ||', Type/Id: '||main_rec.assign_type_id
1168: );
1169:
1170: -- Populates the date table with the dates needed to spilt the employee assignments
1171: pn_recovery_extract_pkg.process_vacancy(
1172: p_start_date => main_rec.start_date,
1173: p_end_date => main_rec.end_date,
1174: p_area => NVL(main_rec.allocated_area, 0),
1175: p_date_table => l_date_table,