eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PNP_UTIL_FUNC dependencies on PN_SPACE_ASSIGN_EMP_ALL

Line 305: FROM PN_SPACE_ASSIGN_EMP_ALL

301: ,p_Cost_Center IN NUMBER
302: ,p_As_Of_Date IN DATE)
303: IS
304: (SELECT NVL(SUM(Allocated_Area), 0) AS area
305: FROM PN_SPACE_ASSIGN_EMP_ALL
306: WHERE Cost_Center_Code = p_Cost_Center
307: AND emp_assign_start_date <= p_As_Of_Date
308: AND NVL(emp_assign_end_date, l_date) >= p_As_Of_Date
309: AND Location_Id IN (

Line 469: FROM pn_space_assign_emp_all

465: CURSOR Allocated_Area_Emp_C(p_Location_Id IN NUMBER
466: ,p_As_of_date IN DATE
467: ,p_location_type IN VARCHAR2) IS
468: (SELECT NVL(SUM(allocated_area), 0) AS Area
469: FROM pn_space_assign_emp_all
470: WHERE emp_assign_start_date <= p_as_of_date
471: AND NVL(emp_assign_end_date, l_date) >= p_as_of_date
472: AND location_id IN (SELECT Location_Id
473: FROM pn_locations_all

Line 536: FROM pn_space_assign_emp_all e

532:
533: CURSOR Allocated_Area_Child_Emp_C(p_Location_Id IN NUMBER
534: ,p_As_of_date IN DATE) IS
535: (SELECT NVL(SUM(e.allocated_area), 0) AS Area
536: FROM pn_space_assign_emp_all e
537: WHERE E.emp_assign_start_date >= p_as_of_date
538: AND NVL(e.emp_assign_end_date, l_date) >= p_as_of_date
539: AND e.location_id = p_location_id
540: AND EXISTS (SELECT NULL

Line 584: l_query := l_query || ' FROM pn_space_assign_emp_all ';

580: l_Allocated_Area_Emp := emp_area.area;
581: END LOOP;
582: */
583: l_query := 'SELECT NVL(SUM(allocated_area), 0) AS Area ';
584: l_query := l_query || ' FROM pn_space_assign_emp_all ';
585: l_query := l_query || ' WHERE emp_assign_start_date <= :p_as_of_date ';
586: l_query := l_query || ' AND NVL(emp_assign_end_date, :l_date) >= :p_as_of_date AND location_id IN ';
587: for loc in c_location_id( p_Location_Id
588: ,l_As_Of_Date

Line 1126: FROM pn_space_assign_emp_all

1122: /* Commented and modified for bug 6470318
1123: CURSOR Utilised_Capacity_Emp_C( p_location_id IN NUMBER,
1124: p_As_Of_Date IN DATE) IS
1125: (SELECT SUM(NVL(UTILIZED_AREA,0)) AS Area
1126: FROM pn_space_assign_emp_all
1127: WHERE location_id IN (SELECT a.location_id
1128: FROM pn_locations_all a
1129: WHERE p_As_Of_Date BETWEEN active_start_date AND
1130: active_end_date

Line 1177: FROM pn_space_assign_emp_all

1173:
1174: CURSOR Utilised_Capacity_Child_Emp_C( p_location_id IN NUMBER,
1175: p_As_Of_Date IN DATE) IS
1176: (SELECT SUM(NVL(UTILIZED_AREA,0)) AS Area
1177: FROM pn_space_assign_emp_all
1178: WHERE location_id = p_location_id
1179: AND p_as_of_date BETWEEN emp_assign_start_date AND
1180: NVL(emp_assign_end_date, g_end_of_time)
1181: );

Line 1206: l_query := l_query || ' FROM pn_space_assign_emp_all ';

1202: LOOP
1203: l_UtilizedCapacityEmp := emp_area.area;
1204: END LOOP;*/
1205: l_query := 'SELECT SUM(NVL(UTILIZED_AREA,0)) AS Area ';
1206: l_query := l_query || ' FROM pn_space_assign_emp_all ';
1207: l_query := l_query || ' WHERE :p_as_of_date BETWEEN emp_assign_start_date AND NVL(emp_assign_end_date, :g_end_of_time) ';
1208: l_query := l_query || ' AND location_id IN ';
1209: for loc in c_location_id( p_Location_Id
1210: ,l_As_Of_Date)

Line 1692: FROM pn_space_assign_emp_all

1688: BEGIN
1689:
1690: SELECT NVL(count (*), 0)
1691: INTO l_occupancyCountEmp
1692: FROM pn_space_assign_emp_all
1693: WHERE location_id = p_locationId
1694: AND emp_assign_start_date <= l_as_of_date
1695: AND NVL(emp_assign_end_date, l_date) >= l_as_of_date;
1696:

Line 2422: FROM pn_space_assign_emp_all

2418: BEGIN
2419:
2420: SELECT 1
2421: INTO l_retnum_emp
2422: FROM pn_space_assign_emp_all
2423: WHERE location_id = p_location_id
2424: AND emp_assign_start_date <= l_as_of_date
2425: AND NVL(emp_assign_end_date, l_date) >= l_as_of_date
2426: AND rownum = 1 ;

Line 4554: FROM pn_space_assign_emp_all

4550: l_as_of_date DATE := pnp_util_func.get_as_of_date(p_as_of_date);
4551:
4552: CURSOR emp_assign_future (l_date DATE) IS
4553: SELECT 'Y'
4554: FROM pn_space_assign_emp_all
4555: WHERE emp_assign_start_date > l_date
4556: --Bug#5959164 AND allocated_area_pct > 0
4557: AND location_id IN (SELECT location_id
4558: FROM pn_locations_all

Line 4566: FROM pn_space_assign_emp_all

4562: AND l_as_of_date BETWEEN PRIOR active_start_date AND PRIOR active_end_date);
4563:
4564: CURSOR emp_assign_current (l_date DATE) IS
4565: SELECT 'Y'
4566: FROM pn_space_assign_emp_all
4567: WHERE l_date BETWEEN emp_assign_start_date AND emp_assign_end_date
4568: AND location_id IN (SELECT location_id
4569: FROM pn_locations_all
4570: WHERE l_as_of_date BETWEEN active_start_date AND active_end_date

Line 4577: FROM pn_space_assign_emp_all

4573: AND l_as_of_date BETWEEN PRIOR active_start_date AND PRIOR active_end_date);
4574:
4575: CURSOR emp_assign_current_open (l_date DATE) IS
4576: SELECT 'Y'
4577: FROM pn_space_assign_emp_all
4578: WHERE l_date >= emp_assign_start_date AND emp_assign_end_date IS NULL -- for open assignments time
4579: AND location_id IN (SELECT location_id
4580: FROM pn_locations_all
4581: WHERE l_as_of_date BETWEEN active_start_date AND active_end_date

Line 6096: FROM pn_space_assign_emp_all

6092: BEGIN
6093:
6094: SELECT MIN(emp_assign_start_date)
6095: INTO l_emp_min_str_dt
6096: FROM pn_space_assign_emp_all
6097: WHERE location_id = p_loc_id
6098: AND TRUNC(emp_assign_start_date) > TRUNC(p_str_dt);
6099:
6100: SELECT MIN(cust_assign_start_date)

Line 6184: FROM pn_space_assign_emp_all

6180: SELECT NVL(SUM(allocated_area), 0)
6181: ,NVL(SUM(allocated_area_pct), 0)
6182: INTO l_allocated_area_emp
6183: ,l_allocated_area_pct_emp
6184: FROM pn_space_assign_emp_all
6185: WHERE location_id = p_loc_id
6186: AND emp_assign_start_date <= NVL(p_new_end_dt,TO_DATE('12/31/4712','mm/dd/yyyy'))
6187: AND NVL(emp_assign_end_date,TO_DATE('12/31/4712','mm/dd/yyyy')) >= p_str_dt;
6188:

Line 6485: l_new_emp_alloc_pct PN_SPACE_ASSIGN_EMP.allocated_area_pct%TYPE;

6481: p_assgn_area IN NUMBER,
6482: p_str_dt IN DATE,
6483: p_end_dt IN DATE) IS
6484:
6485: l_new_emp_alloc_pct PN_SPACE_ASSIGN_EMP.allocated_area_pct%TYPE;
6486: l_new_cust_alloc_pct PN_SPACE_ASSIGN_CUST.allocated_area_pct%TYPE;
6487: l_new_emp_alloc_area PN_SPACE_ASSIGN_EMP.allocated_area%TYPE;
6488: l_new_cust_alloc_area PN_SPACE_ASSIGN_CUST.allocated_area%TYPE;
6489: l_assgn_str_dt DATE;

Line 6487: l_new_emp_alloc_area PN_SPACE_ASSIGN_EMP.allocated_area%TYPE;

6483: p_end_dt IN DATE) IS
6484:
6485: l_new_emp_alloc_pct PN_SPACE_ASSIGN_EMP.allocated_area_pct%TYPE;
6486: l_new_cust_alloc_pct PN_SPACE_ASSIGN_CUST.allocated_area_pct%TYPE;
6487: l_new_emp_alloc_area PN_SPACE_ASSIGN_EMP.allocated_area%TYPE;
6488: l_new_cust_alloc_area PN_SPACE_ASSIGN_CUST.allocated_area%TYPE;
6489: l_assgn_str_dt DATE;
6490: l_assgn_end_dt DATE;
6491: l_date DATE;

Line 6493: emp_rec pn_space_assign_emp_all%ROWTYPE;

6489: l_assgn_str_dt DATE;
6490: l_assgn_end_dt DATE;
6491: l_date DATE;
6492: l_mode VARCHAR2(15);
6493: emp_rec pn_space_assign_emp_all%ROWTYPE;
6494: cust_rec pn_space_assign_cust_all%ROWTYPE;
6495: l_return_status VARCHAR2(30);
6496:
6497: CURSOR get_emp_assgn(p_loc_id IN NUMBER,

Line 6501: FROM pn_space_assign_emp_all

6497: CURSOR get_emp_assgn(p_loc_id IN NUMBER,
6498: p_str_dt IN DATE,
6499: p_end_dt IN DATE) IS
6500: SELECT *
6501: FROM pn_space_assign_emp_all
6502: WHERE location_id = p_loc_id
6503: AND emp_assign_start_date <= p_end_dt
6504: AND NVL(emp_assign_end_date, g_end_of_time) >= p_str_dt;
6505:

Line 6521: FROM pn_space_assign_emp_all

6517: CURSOR get_emp_assgn1(p_loc_id IN NUMBER,
6518: p_str_dt IN DATE,
6519: p_end_dt IN DATE) IS
6520: SELECT *
6521: FROM pn_space_assign_emp_all
6522: WHERE location_id = p_loc_id
6523: AND NVL(emp_assign_end_date, g_end_of_time) >= p_str_dt;
6524:
6525: CURSOR get_cust_assgn1(p_loc_id IN NUMBER,

Line 6749: FROM PN_SPACE_ASSIGN_EMP_ALL

6745: PRIOR active_end_date;
6746:
6747: CURSOR c_space_emp is
6748: SELECT NVL(SUM(Allocated_Area), 0),NVL(SUM(UTILIZED_AREA),0)
6749: FROM PN_SPACE_ASSIGN_EMP_ALL
6750: WHERE emp_assign_start_date <= l_as_of_date
6751: AND NVL(emp_assign_end_date, l_date) >= l_as_of_date
6752: AND Location_Id IN (SELECT Location_Id
6753: FROM pn_locations_all

Line 6877: FROM pn_space_assign_emp_all

6873: INVALID_ASSIGNABLE_AREA EXCEPTION;
6874:
6875: CURSOR start_date_cur IS
6876: SELECT emp_assign_start_date
6877: FROM pn_space_assign_emp_all
6878: WHERE location_id = p_Location_Id
6879: UNION
6880: SELECT cust_assign_start_date
6881: FROM pn_space_assign_cust_all

Line 7113: FROM pn_space_assign_emp_all

7109: --Bug#5959164 AND NVL(allocated_area,0) > 0;
7110:
7111: CURSOR pn_space_assign_emp_cursor IS
7112: SELECT *
7113: FROM pn_space_assign_emp_all
7114: WHERE location_id IN
7115: ( SELECT location_id
7116: FROM pn_locations_all
7117: START WITH location_id = p_location_id

Line 7268: FROM pn_space_assign_emp_all

7264: CURSOR validate_start_date_cursor IS
7265: SELECT 'x'
7266: FROM DUAL
7267: WHERE EXISTS (SELECT 'x'
7268: FROM pn_space_assign_emp_all
7269: WHERE location_id IN (SELECT location_id
7270: FROM pn_locations_all
7271: START WITH location_id = p_location_id
7272: CONNECT BY PRIOR location_id = parent_location_id )

Line 7293: FROM pn_space_assign_emp_all

7289: CURSOR validate_end_date_cursor IS
7290: SELECT 'x'
7291: FROM DUAL
7292: WHERE EXISTS (SELECT 'x'
7293: FROM pn_space_assign_emp_all
7294: WHERE location_id IN (SELECT location_id
7295: FROM pn_locations_all
7296: START WITH location_id = p_location_id
7297: CONNECT BY PRIOR location_id = parent_location_id )