APPS.PN_TENANCIES_PKG dependencies on PN_RECOVERY_EXTRACT_PKG

Line 1491: -- DESCRIPTION: o Calls procedure pn_recovery_extract_pkg.process_vacancy to

1487: END get_allocated_area_pct;
1488:
1489: -------------------------------------------------------------------
1490: -- PROCEDURE : POPULATE_SPACE_ASSIGN_INFO
1491: -- DESCRIPTION: o Calls procedure pn_recovery_extract_pkg.process_vacancy to
1492: -- get available allocable area. The assignment record could be split
1493: -- based on the number of space and emp assignments existing for
1494: -- the location and if the assignable area has changed.
1495: -- o Populates space_assign_info_tbl with the start date, end date and

Line 1534: l_num_table pn_recovery_extract_pkg.number_table_TYPE;

1530: AND emp_assign_start_date <= p_to_date
1531: AND NVL(emp_assign_end_date, p_to_date) >= p_from_date;
1532:
1533: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
1534: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
1535: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
1536: l_start_date DATE := NULL;
1537: l_end_date DATE := NULL;
1538: i NUMBER := 0;

Line 1535: l_date_table pn_recovery_extract_pkg.date_table_TYPE;

1531: AND NVL(emp_assign_end_date, p_to_date) >= p_from_date;
1532:
1533: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
1534: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
1535: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
1536: l_start_date DATE := NULL;
1537: l_end_date DATE := NULL;
1538: i NUMBER := 0;
1539: j NUMBER := 0;

Line 1553: pn_recovery_extract_pkg.process_vacancy(

1549: IF l_loc_type_code IN ('OFFICE', 'SECTION') THEN
1550:
1551: FOR i IN 0 .. loc_info_tbl.count-1
1552: LOOP
1553: pn_recovery_extract_pkg.process_vacancy(
1554: p_start_date => loc_info_tbl(i).active_start_date,
1555: p_end_date => loc_info_tbl(i).active_end_date,
1556: p_area => loc_info_tbl(i).assignable_area,
1557: p_date_table => l_date_table,

Line 1564: pn_recovery_extract_pkg.process_vacancy(

1560: END LOOP;
1561:
1562: FOR rec_cust_info IN csr_cust_info
1563: LOOP
1564: pn_recovery_extract_pkg.process_vacancy(
1565: p_start_date => rec_cust_info.cust_assign_start_date,
1566: p_end_date => rec_cust_info.cust_assign_end_date,
1567: p_area => rec_cust_info.allocated_area,
1568: p_date_table => l_date_table,

Line 1575: pn_recovery_extract_pkg.process_vacancy(

1571: END LOOP;
1572:
1573: FOR rec_emp_info IN csr_emp_info
1574: LOOP
1575: pn_recovery_extract_pkg.process_vacancy(
1576: p_start_date => rec_emp_info.emp_assign_start_date,
1577: p_end_date => rec_emp_info.emp_assign_end_date,
1578: p_area => rec_emp_info.allocated_area,
1579: p_date_table => l_date_table,

Line 1784: l_num_table pn_recovery_extract_pkg.number_table_TYPE;

1780: )
1781: IS
1782:
1783: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
1784: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
1785: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
1786: l_start_date DATE := NULL;
1787: l_end_date DATE := NULL;
1788: i NUMBER := 0;

Line 1785: l_date_table pn_recovery_extract_pkg.date_table_TYPE;

1781: IS
1782:
1783: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
1784: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
1785: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
1786: l_start_date DATE := NULL;
1787: l_end_date DATE := NULL;
1788: i NUMBER := 0;
1789: j NUMBER := 0;

Line 1803: pn_recovery_extract_pkg.process_vacancy(

1799: IF l_loc_type_code IN ('OFFICE', 'SECTION') THEN
1800:
1801: FOR i IN 0 .. loc_info_tbl.count-1
1802: LOOP
1803: pn_recovery_extract_pkg.process_vacancy(
1804: p_start_date => loc_info_tbl(i).active_start_date,
1805: p_end_date => loc_info_tbl(i).active_end_date,
1806: p_area => loc_info_tbl(i).assignable_area,
1807: p_date_table => l_date_table,

Line 3211: l_num_table pn_recovery_extract_pkg.number_table_TYPE;

3207: AND emp_assign_start_date <= p_to_date
3208: AND NVL(emp_assign_end_date, p_to_date) >= p_from_date;
3209:
3210: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
3211: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
3212: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
3213: i NUMBER := 0;
3214: j NUMBER := 0;
3215:

Line 3212: l_date_table pn_recovery_extract_pkg.date_table_TYPE;

3208: AND NVL(emp_assign_end_date, p_to_date) >= p_from_date;
3209:
3210: l_loc_type_code pn_locations_all.location_type_lookup_code%TYPE;
3211: l_num_table pn_recovery_extract_pkg.number_table_TYPE;
3212: l_date_table pn_recovery_extract_pkg.date_table_TYPE;
3213: i NUMBER := 0;
3214: j NUMBER := 0;
3215:
3216: BEGIN

Line 3228: pn_recovery_extract_pkg.process_vacancy(

3224: IF l_loc_type_code IN ('OFFICE', 'SECTION') THEN
3225:
3226: FOR i IN 0 .. loc_info_tbl.count-1
3227: LOOP
3228: pn_recovery_extract_pkg.process_vacancy(
3229: p_start_date => loc_info_tbl(i).active_start_date,
3230: p_end_date => loc_info_tbl(i).active_end_date,
3231: p_area => loc_info_tbl(i).assignable_area,
3232: p_date_table => l_date_table,

Line 3239: pn_recovery_extract_pkg.process_vacancy(

3235: END LOOP;
3236:
3237: FOR rec_cust_info IN csr_cust_info
3238: LOOP
3239: pn_recovery_extract_pkg.process_vacancy(
3240: p_start_date => rec_cust_info.cust_assign_start_date,
3241: p_end_date => rec_cust_info.cust_assign_end_date,
3242: p_area => rec_cust_info.allocated_area,
3243: p_date_table => l_date_table,

Line 3250: pn_recovery_extract_pkg.process_vacancy(

3246: END LOOP;
3247:
3248: FOR rec_emp_info IN csr_emp_info
3249: LOOP
3250: pn_recovery_extract_pkg.process_vacancy(
3251: p_start_date => rec_emp_info.emp_assign_start_date,
3252: p_end_date => rec_emp_info.emp_assign_end_date,
3253: p_area => rec_emp_info.allocated_area,
3254: p_date_table => l_date_table,