APPS.PNT_LOCATIONS_PKG dependencies on PN_RECOVERY_EXTRACT_PKG

Line 86: l_num_table pn_recovery_extract_pkg.number_table_TYPE;

82: AND p_act_str_dt between prior active_start_date and
83: NVL(prior active_end_date,TO_DATE('12/31/4712','MM/DD/YYYY'));
84:
85: i NUMBER := 0;
86: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
87: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
88: l_max_area NUMBER := 0;
89:
90: BEGIN

Line 87: l_date_table pn_recovery_extract_pkg.date_table_TYPE;

83: NVL(prior active_end_date,TO_DATE('12/31/4712','MM/DD/YYYY'));
84:
85: i NUMBER := 0;
86: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
87: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
88: l_max_area NUMBER := 0;
89:
90: BEGIN
91: loc_info_tbl.delete;

Line 103: pn_recovery_extract_pkg.process_vacancy(

99: END LOOP;
100:
101: FOR i IN 0 .. loc_info_tbl.count-1
102: LOOP
103: pn_recovery_extract_pkg.process_vacancy(
104: p_start_date => loc_info_tbl(i).active_start_date,
105: p_end_date => loc_info_tbl(i).active_end_date,
106: p_area => loc_info_tbl(i).area,
107: p_date_table => l_date_table,