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 467: FROM pn_space_assign_emp_all

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

Line 512: FROM pn_space_assign_emp_all e

508:
509: CURSOR Allocated_Area_Child_Emp_C(p_Location_Id IN NUMBER
510: ,p_As_of_date IN DATE) IS
511: (SELECT NVL(SUM(e.allocated_area), 0) AS Area
512: FROM pn_space_assign_emp_all e
513: WHERE E.emp_assign_start_date <= p_as_of_date
514: AND NVL(e.emp_assign_end_date, l_date) >= p_as_of_date
515: AND e.location_id = p_location_id
516: AND EXISTS (SELECT NULL

Line 1044: FROM pn_space_assign_emp_all

1040:
1041: CURSOR Utilised_Capacity_Emp_C( p_location_id IN NUMBER,
1042: p_As_Of_Date IN DATE) IS
1043: (SELECT SUM(NVL(UTILIZED_AREA,0)) AS Area
1044: FROM pn_space_assign_emp_all
1045: WHERE location_id IN (SELECT a.location_id
1046: FROM pn_locations_all a
1047: WHERE p_As_Of_Date BETWEEN active_start_date AND
1048: active_end_date

Line 1076: FROM pn_space_assign_emp_all

1072:
1073: CURSOR Utilised_Capacity_Child_Emp_C( p_location_id IN NUMBER,
1074: p_As_Of_Date IN DATE) IS
1075: (SELECT SUM(NVL(UTILIZED_AREA,0)) AS Area
1076: FROM pn_space_assign_emp_all
1077: WHERE location_id = p_location_id
1078: AND p_as_of_date BETWEEN emp_assign_start_date AND
1079: NVL(emp_assign_end_date, g_end_of_time)
1080: );

Line 1537: FROM pn_space_assign_emp_all

1533: BEGIN
1534:
1535: SELECT NVL(count (*), 0)
1536: INTO l_occupancyCountEmp
1537: FROM pn_space_assign_emp_all
1538: WHERE location_id = p_locationId
1539: AND emp_assign_start_date <= l_as_of_date
1540: AND NVL(emp_assign_end_date, l_date) >= l_as_of_date;
1541:

Line 2267: FROM pn_space_assign_emp_all

2263: BEGIN
2264:
2265: SELECT 1
2266: INTO l_retnum_emp
2267: FROM pn_space_assign_emp_all
2268: WHERE location_id = p_location_id
2269: AND emp_assign_start_date <= l_as_of_date
2270: AND NVL(emp_assign_end_date, l_date) >= l_as_of_date
2271: AND rownum = 1 ;

Line 4396: FROM pn_space_assign_emp_all

4392: l_as_of_date DATE := pnp_util_func.get_as_of_date(p_as_of_date);
4393:
4394: CURSOR emp_assign_future (l_date DATE) IS
4395: SELECT 'Y'
4396: FROM pn_space_assign_emp_all
4397: WHERE emp_assign_start_date > l_date
4398: --Bug#5959164 AND allocated_area_pct > 0
4399: AND location_id IN (SELECT location_id
4400: FROM pn_locations_all

Line 4408: FROM pn_space_assign_emp_all

4404: AND l_as_of_date BETWEEN PRIOR active_start_date AND PRIOR active_end_date);
4405:
4406: CURSOR emp_assign_current (l_date DATE) IS
4407: SELECT 'Y'
4408: FROM pn_space_assign_emp_all
4409: WHERE l_date BETWEEN emp_assign_start_date AND emp_assign_end_date
4410: AND location_id IN (SELECT location_id
4411: FROM pn_locations_all
4412: WHERE l_as_of_date BETWEEN active_start_date AND active_end_date

Line 4419: FROM pn_space_assign_emp_all

4415: AND l_as_of_date BETWEEN PRIOR active_start_date AND PRIOR active_end_date);
4416:
4417: CURSOR emp_assign_current_open (l_date DATE) IS
4418: SELECT 'Y'
4419: FROM pn_space_assign_emp_all
4420: WHERE l_date >= emp_assign_start_date AND emp_assign_end_date IS NULL -- for open assignments time
4421: AND location_id IN (SELECT location_id
4422: FROM pn_locations_all
4423: WHERE l_as_of_date BETWEEN active_start_date AND active_end_date

Line 5935: FROM pn_space_assign_emp_all

5931: BEGIN
5932:
5933: SELECT MIN(emp_assign_start_date)
5934: INTO l_emp_min_str_dt
5935: FROM pn_space_assign_emp_all
5936: WHERE location_id = p_loc_id
5937: AND TRUNC(emp_assign_start_date) > TRUNC(p_str_dt);
5938:
5939: SELECT MIN(cust_assign_start_date)

Line 6023: FROM pn_space_assign_emp_all

6019: SELECT NVL(SUM(allocated_area), 0)
6020: ,NVL(SUM(allocated_area_pct), 0)
6021: INTO l_allocated_area_emp
6022: ,l_allocated_area_pct_emp
6023: FROM pn_space_assign_emp_all
6024: WHERE location_id = p_loc_id
6025: AND emp_assign_start_date <= NVL(p_new_end_dt,TO_DATE('12/31/4712','mm/dd/yyyy'))
6026: AND NVL(emp_assign_end_date,TO_DATE('12/31/4712','mm/dd/yyyy')) >= p_str_dt;
6027:

Line 6324: l_new_emp_alloc_pct PN_SPACE_ASSIGN_EMP.allocated_area_pct%TYPE;

6320: p_assgn_area IN NUMBER,
6321: p_str_dt IN DATE,
6322: p_end_dt IN DATE) IS
6323:
6324: l_new_emp_alloc_pct PN_SPACE_ASSIGN_EMP.allocated_area_pct%TYPE;
6325: l_new_cust_alloc_pct PN_SPACE_ASSIGN_CUST.allocated_area_pct%TYPE;
6326: l_new_emp_alloc_area PN_SPACE_ASSIGN_EMP.allocated_area%TYPE;
6327: l_new_cust_alloc_area PN_SPACE_ASSIGN_CUST.allocated_area%TYPE;
6328: l_assgn_str_dt DATE;

Line 6326: l_new_emp_alloc_area PN_SPACE_ASSIGN_EMP.allocated_area%TYPE;

6322: p_end_dt IN DATE) IS
6323:
6324: l_new_emp_alloc_pct PN_SPACE_ASSIGN_EMP.allocated_area_pct%TYPE;
6325: l_new_cust_alloc_pct PN_SPACE_ASSIGN_CUST.allocated_area_pct%TYPE;
6326: l_new_emp_alloc_area PN_SPACE_ASSIGN_EMP.allocated_area%TYPE;
6327: l_new_cust_alloc_area PN_SPACE_ASSIGN_CUST.allocated_area%TYPE;
6328: l_assgn_str_dt DATE;
6329: l_assgn_end_dt DATE;
6330: l_date DATE;

Line 6332: emp_rec pn_space_assign_emp_all%ROWTYPE;

6328: l_assgn_str_dt DATE;
6329: l_assgn_end_dt DATE;
6330: l_date DATE;
6331: l_mode VARCHAR2(15);
6332: emp_rec pn_space_assign_emp_all%ROWTYPE;
6333: cust_rec pn_space_assign_cust_all%ROWTYPE;
6334: l_return_status VARCHAR2(30);
6335:
6336: CURSOR get_emp_assgn(p_loc_id IN NUMBER,

Line 6340: FROM pn_space_assign_emp_all

6336: CURSOR get_emp_assgn(p_loc_id IN NUMBER,
6337: p_str_dt IN DATE,
6338: p_end_dt IN DATE) IS
6339: SELECT *
6340: FROM pn_space_assign_emp_all
6341: WHERE location_id = p_loc_id
6342: AND emp_assign_start_date <= p_end_dt
6343: AND NVL(emp_assign_end_date, g_end_of_time) >= p_str_dt;
6344:

Line 6360: FROM pn_space_assign_emp_all

6356: CURSOR get_emp_assgn1(p_loc_id IN NUMBER,
6357: p_str_dt IN DATE,
6358: p_end_dt IN DATE) IS
6359: SELECT *
6360: FROM pn_space_assign_emp_all
6361: WHERE location_id = p_loc_id
6362: AND NVL(emp_assign_end_date, g_end_of_time) >= p_str_dt;
6363:
6364: CURSOR get_cust_assgn1(p_loc_id IN NUMBER,

Line 6588: FROM PN_SPACE_ASSIGN_EMP_ALL

6584: PRIOR active_end_date;
6585:
6586: CURSOR c_space_emp is
6587: SELECT NVL(SUM(Allocated_Area), 0),NVL(SUM(UTILIZED_AREA),0)
6588: FROM PN_SPACE_ASSIGN_EMP_ALL
6589: WHERE emp_assign_start_date <= l_as_of_date
6590: AND NVL(emp_assign_end_date, l_date) >= l_as_of_date
6591: AND Location_Id IN (SELECT Location_Id
6592: FROM pn_locations_all

Line 6716: FROM pn_space_assign_emp_all

6712: INVALID_ASSIGNABLE_AREA EXCEPTION;
6713:
6714: CURSOR start_date_cur IS
6715: SELECT emp_assign_start_date
6716: FROM pn_space_assign_emp_all
6717: WHERE location_id = p_Location_Id
6718: UNION
6719: SELECT cust_assign_start_date
6720: FROM pn_space_assign_cust_all

Line 6952: FROM pn_space_assign_emp_all

6948: --Bug#5959164 AND NVL(allocated_area,0) > 0;
6949:
6950: CURSOR pn_space_assign_emp_cursor IS
6951: SELECT *
6952: FROM pn_space_assign_emp_all
6953: WHERE location_id IN
6954: ( SELECT location_id
6955: FROM pn_locations_all
6956: START WITH location_id = p_location_id

Line 7107: FROM pn_space_assign_emp_all

7103: CURSOR validate_start_date_cursor IS
7104: SELECT 'x'
7105: FROM DUAL
7106: WHERE EXISTS (SELECT 'x'
7107: FROM pn_space_assign_emp_all
7108: WHERE location_id IN (SELECT location_id
7109: FROM pn_locations_all
7110: START WITH location_id = p_location_id
7111: CONNECT BY PRIOR location_id = parent_location_id )

Line 7132: FROM pn_space_assign_emp_all

7128: CURSOR validate_end_date_cursor IS
7129: SELECT 'x'
7130: FROM DUAL
7131: WHERE EXISTS (SELECT 'x'
7132: FROM pn_space_assign_emp_all
7133: WHERE location_id IN (SELECT location_id
7134: FROM pn_locations_all
7135: START WITH location_id = p_location_id
7136: CONNECT BY PRIOR location_id = parent_location_id )