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_CUST_ALL

Line 325: FROM PN_SPACE_ASSIGN_CUST_ALL

321: ,p_Cost_Center IN NUMBER
322: ,p_As_Of_Date IN DATE)
323: IS
324: (SELECT NVL(SUM(Allocated_Area), 0) AS area
325: FROM PN_SPACE_ASSIGN_CUST_ALL
326: WHERE cust_assign_start_date <= p_As_Of_Date
327: AND NVL(cust_assign_end_date, l_date) >= p_As_Of_Date
328: AND Location_Id IN (
329: SELECT Location_Id

Line 486: FROM pn_space_assign_cust_all

482: CURSOR Allocated_Area_Cust_C(p_Location_Id IN NUMBER
483: ,p_As_of_date IN DATE
484: ,p_location_type IN VARCHAR2) IS
485: (SELECT NVL(SUM(allocated_area), 0) AS Area
486: FROM pn_space_assign_cust_all
487: WHERE cust_assign_start_date <= p_As_of_date
488: AND NVL(cust_assign_end_date, l_date) >= p_As_of_date
489: AND location_Id IN (SELECT location_id
490: FROM pn_locations_all

Line 525: FROM pn_space_assign_cust_all c

521:
522: CURSOR Allocated_Area_Child_Cust_C(p_Location_Id IN NUMBER
523: ,p_As_of_date IN DATE) IS
524: (SELECT NVL(SUM(c.allocated_area), 0) AS Area
525: FROM pn_space_assign_cust_all c
526: WHERE c.cust_assign_start_date <= p_as_of_date
527: AND NVL(c.cust_assign_end_date, l_date) >= p_as_of_date
528: AND c.location_id = p_location_id
529: AND EXISTS (SELECT NULL

Line 1060: FROM pn_space_assign_cust_all

1056:
1057: CURSOR Utilised_Capacity_Cust_C( p_location_id IN NUMBER
1058: ,p_As_Of_Date IN DATE) IS
1059: (SELECT SUM(NVL(UTILIZED_AREA,0)) AS Area
1060: FROM pn_space_assign_cust_all
1061: WHERE location_id IN (SELECT a.location_id
1062: FROM pn_locations_all a
1063: WHERE p_as_of_date BETWEEN active_start_date AND
1064: active_end_date

Line 1085: FROM pn_space_assign_cust_all

1081:
1082: CURSOR Utilised_Capacity_Child_Cust_C( p_location_id IN NUMBER,
1083: p_As_Of_Date IN DATE) IS
1084: (SELECT SUM(NVL(UTILIZED_AREA,0)) AS Area
1085: FROM pn_space_assign_cust_all
1086: WHERE location_id = p_location_id
1087: AND p_as_of_date BETWEEN cust_assign_start_date AND
1088: NVL(cust_assign_end_date, g_end_of_time)
1089: );

Line 1544: FROM pn_space_assign_cust_all

1540: AND NVL(emp_assign_end_date, l_date) >= l_as_of_date;
1541:
1542: SELECT NVL(count (*), 0)
1543: INTO l_occupancyCountCust
1544: FROM pn_space_assign_cust_all
1545: WHERE location_id = p_locationId
1546: AND cust_assign_start_date <= l_as_of_date
1547: AND NVL(cust_assign_end_date, l_date) >= l_as_of_date;
1548:

Line 2275: FROM pn_space_assign_cust_all

2271: AND rownum = 1 ;
2272:
2273: SELECT 1
2274: INTO l_retnum_cust
2275: FROM pn_space_assign_cust_all
2276: WHERE location_id = p_location_id
2277: AND cust_assign_start_date <= l_as_of_date
2278: AND NVL(cust_assign_end_date, l_date) >= l_as_of_date
2279: AND rownum = 1 ;

Line 4430: FROM pn_space_assign_cust_all

4426: AND l_as_of_date BETWEEN PRIOR active_start_date AND PRIOR active_end_date);
4427:
4428: CURSOR cust_assign_future (l_date DATE) IS
4429: SELECT 'Y'
4430: FROM pn_space_assign_cust_all
4431: WHERE cust_assign_start_date > l_date
4432: --Bug#5959164 AND allocated_area_pct > 0
4433: AND location_id IN (SELECT location_id
4434: FROM pn_locations_all

Line 4442: FROM pn_space_assign_cust_all

4438: AND l_as_of_date BETWEEN PRIOR active_start_date AND PRIOR active_end_date);
4439:
4440: CURSOR cust_assign_current (l_date DATE) IS
4441: SELECT 'Y'
4442: FROM pn_space_assign_cust_all
4443: WHERE l_date BETWEEN cust_assign_start_date AND cust_assign_end_date
4444: AND location_id IN (SELECT location_id
4445: FROM pn_locations_all
4446: WHERE l_as_of_date BETWEEN active_start_date AND active_end_date

Line 4453: FROM pn_space_assign_cust_all

4449: AND l_as_of_date BETWEEN PRIOR active_start_date AND PRIOR active_end_date);
4450:
4451: CURSOR cust_assign_current_open (l_date DATE) IS
4452: SELECT 'Y'
4453: FROM pn_space_assign_cust_all
4454: WHERE l_date >= cust_assign_start_date AND cust_assign_end_date IS NULL -- for open assignments time
4455: AND location_id IN (SELECT location_id
4456: FROM pn_locations_all
4457: WHERE l_as_of_date BETWEEN active_start_date AND active_end_date

Line 5941: FROM pn_space_assign_cust_all

5937: AND TRUNC(emp_assign_start_date) > TRUNC(p_str_dt);
5938:
5939: SELECT MIN(cust_assign_start_date)
5940: INTO l_cust_min_str_dt
5941: FROM pn_space_assign_cust_all
5942: WHERE location_id = p_loc_id
5943: AND TRUNC(cust_assign_start_date) > TRUNC(p_str_dt);
5944:
5945: IF NVL(TRUNC(l_emp_min_str_dt),TO_DATE('12/31/4712','mm/dd/yyyy')) <

Line 6032: FROM pn_space_assign_cust_all

6028: SELECT NVL(SUM(allocated_area), 0)
6029: ,NVL(SUM(allocated_area_pct), 0)
6030: INTO l_allocated_area_cust
6031: ,l_allocated_area_pct_cust
6032: FROM pn_space_assign_cust_all
6033: WHERE location_id = p_loc_id
6034: AND cust_assign_start_date <= NVL(p_new_end_dt,TO_DATE('12/31/4712','mm/dd/yyyy'))
6035: AND NVL(cust_assign_end_date,TO_DATE('12/31/4712','mm/dd/yyyy')) >= p_str_dt;
6036:

Line 6325: l_new_cust_alloc_pct PN_SPACE_ASSIGN_CUST.allocated_area_pct%TYPE;

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;
6329: l_assgn_end_dt DATE;

Line 6327: l_new_cust_alloc_area PN_SPACE_ASSIGN_CUST.allocated_area%TYPE;

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;
6331: l_mode VARCHAR2(15);

Line 6333: cust_rec pn_space_assign_cust_all%ROWTYPE;

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,
6337: p_str_dt IN DATE,

Line 6349: FROM pn_space_assign_cust_all

6345: CURSOR get_cust_assgn(p_loc_id IN NUMBER,
6346: p_str_dt IN DATE,
6347: p_end_dt IN DATE) IS
6348: SELECT *
6349: FROM pn_space_assign_cust_all
6350: WHERE location_id = p_loc_id
6351: AND cust_assign_start_date <= p_end_dt
6352: AND NVL(cust_assign_end_date, g_end_of_time) >= p_str_dt;
6353:

Line 6368: FROM pn_space_assign_cust_all

6364: CURSOR get_cust_assgn1(p_loc_id IN NUMBER,
6365: p_str_dt IN DATE,
6366: p_end_dt IN DATE) IS
6367: SELECT *
6368: FROM pn_space_assign_cust_all
6369: WHERE location_id = p_loc_id
6370: AND NVL(cust_assign_end_date, g_end_of_time) >= p_str_dt;
6371:
6372: -- 102403 -- date track space assignment

Line 6604: FROM PN_SPACE_ASSIGN_CUST_ALL

6600: );
6601:
6602: CURSOR c_space_cust is
6603: SELECT NVL(SUM(Allocated_Area), 0),NVL(SUM(UTILIZED_AREA),0)
6604: FROM PN_SPACE_ASSIGN_CUST_ALL
6605: WHERE cust_assign_start_date <= l_as_of_date
6606: AND NVL(cust_assign_end_date, l_date) >= l_as_of_date
6607: AND Location_Id IN (SELECT Location_Id
6608: FROM pn_locations_all

Line 6720: FROM pn_space_assign_cust_all

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
6721: WHERE location_id = p_Location_Id
6722: ORDER BY 1;
6723:
6724: BEGIN

Line 6940: FROM pn_space_assign_cust_all

6936: )
6937: IS
6938: CURSOR pn_space_assign_cust_cursor IS
6939: SELECT *
6940: FROM pn_space_assign_cust_all
6941: WHERE location_id IN
6942: ( SELECT location_id
6943: FROM pn_locations_all
6944: START WITH location_id = p_location_id

Line 7118: FROM pn_space_assign_cust_all

7114: AND emp_assign_start_date < p_start_date
7115: AND NVL(emp_assign_end_date,to_date('12/31/4712','mm/dd/yyyy')) >= p_start_date_old
7116: UNION
7117: SELECT 'x'
7118: FROM pn_space_assign_cust_all
7119: WHERE location_id IN (SELECT location_id
7120: FROM pn_locations_all
7121: START WITH location_id = p_location_id
7122: CONNECT BY PRIOR location_id = parent_location_id )

Line 7143: FROM pn_space_assign_cust_all

7139: AND NVL(emp_assign_end_date,to_date('12/31/4712','mm/dd/yyyy')) > p_end_date
7140: AND emp_assign_start_date <= p_end_date_old
7141: UNION
7142: SELECT 'x'
7143: FROM pn_space_assign_cust_all
7144: WHERE location_id IN (SELECT location_id
7145: FROM pn_locations_all
7146: START WITH location_id = p_location_id
7147: CONNECT BY PRIOR location_id = parent_location_id )