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 510: FROM pn_space_assign_cust_all

506: CURSOR Allocated_Area_Cust_C(p_Location_Id IN NUMBER
507: ,p_As_of_date IN DATE
508: ,p_location_type IN VARCHAR2) IS
509: (SELECT NVL(SUM(allocated_area), 0) AS Area
510: FROM pn_space_assign_cust_all
511: WHERE cust_assign_start_date <= p_As_of_date
512: AND NVL(cust_assign_end_date, l_date) >= p_As_of_date
513: AND location_Id IN (SELECT location_id
514: FROM pn_locations_all

Line 549: FROM pn_space_assign_cust_all c

545:
546: CURSOR Allocated_Area_Child_Cust_C(p_Location_Id IN NUMBER
547: ,p_As_of_date IN DATE) IS
548: (SELECT NVL(SUM(c.allocated_area), 0) AS Area
549: FROM pn_space_assign_cust_all c
550: WHERE c.cust_assign_start_date <= p_as_of_date
551: AND NVL(c.cust_assign_end_date, l_date) >= p_as_of_date
552: AND c.location_id = p_location_id
553: AND EXISTS (SELECT NULL

Line 1161: FROM pn_space_assign_cust_all

1157:
1158: CURSOR Utilised_Capacity_Cust_C( p_location_id IN NUMBER
1159: ,p_As_Of_Date IN DATE) IS
1160: (SELECT SUM(NVL(UTILIZED_AREA,0)) AS Area
1161: FROM pn_space_assign_cust_all
1162: WHERE location_id IN (SELECT a.location_id
1163: FROM pn_locations_all a
1164: WHERE p_as_of_date BETWEEN active_start_date AND
1165: active_end_date

Line 1186: FROM pn_space_assign_cust_all

1182:
1183: CURSOR Utilised_Capacity_Child_Cust_C( p_location_id IN NUMBER,
1184: p_As_Of_Date IN DATE) IS
1185: (SELECT SUM(NVL(UTILIZED_AREA,0)) AS Area
1186: FROM pn_space_assign_cust_all
1187: WHERE location_id = p_location_id
1188: AND p_as_of_date BETWEEN cust_assign_start_date AND
1189: NVL(cust_assign_end_date, g_end_of_time)
1190: );

Line 1699: FROM pn_space_assign_cust_all

1695: AND NVL(emp_assign_end_date, l_date) >= l_as_of_date;
1696:
1697: SELECT NVL(count (*), 0)
1698: INTO l_occupancyCountCust
1699: FROM pn_space_assign_cust_all
1700: WHERE location_id = p_locationId
1701: AND cust_assign_start_date <= l_as_of_date
1702: AND NVL(cust_assign_end_date, l_date) >= l_as_of_date;
1703:

Line 2430: FROM pn_space_assign_cust_all

2426: AND rownum = 1 ;
2427:
2428: SELECT 1
2429: INTO l_retnum_cust
2430: FROM pn_space_assign_cust_all
2431: WHERE location_id = p_location_id
2432: AND cust_assign_start_date <= l_as_of_date
2433: AND NVL(cust_assign_end_date, l_date) >= l_as_of_date
2434: AND rownum = 1 ;

Line 4588: FROM pn_space_assign_cust_all

4584: AND l_as_of_date BETWEEN PRIOR active_start_date AND PRIOR active_end_date);
4585:
4586: CURSOR cust_assign_future (l_date DATE) IS
4587: SELECT 'Y'
4588: FROM pn_space_assign_cust_all
4589: WHERE cust_assign_start_date > l_date
4590: --Bug#5959164 AND allocated_area_pct > 0
4591: AND location_id IN (SELECT location_id
4592: FROM pn_locations_all

Line 4600: FROM pn_space_assign_cust_all

4596: AND l_as_of_date BETWEEN PRIOR active_start_date AND PRIOR active_end_date);
4597:
4598: CURSOR cust_assign_current (l_date DATE) IS
4599: SELECT 'Y'
4600: FROM pn_space_assign_cust_all
4601: WHERE l_date BETWEEN cust_assign_start_date AND cust_assign_end_date
4602: AND location_id IN (SELECT location_id
4603: FROM pn_locations_all
4604: WHERE l_as_of_date BETWEEN active_start_date AND active_end_date

Line 4611: FROM pn_space_assign_cust_all

4607: AND l_as_of_date BETWEEN PRIOR active_start_date AND PRIOR active_end_date);
4608:
4609: CURSOR cust_assign_current_open (l_date DATE) IS
4610: SELECT 'Y'
4611: FROM pn_space_assign_cust_all
4612: WHERE l_date >= cust_assign_start_date AND cust_assign_end_date IS NULL -- for open assignments time
4613: AND location_id IN (SELECT location_id
4614: FROM pn_locations_all
4615: WHERE l_as_of_date BETWEEN active_start_date AND active_end_date

Line 6102: FROM pn_space_assign_cust_all

6098: AND TRUNC(emp_assign_start_date) > TRUNC(p_str_dt);
6099:
6100: SELECT MIN(cust_assign_start_date)
6101: INTO l_cust_min_str_dt
6102: FROM pn_space_assign_cust_all
6103: WHERE location_id = p_loc_id
6104: AND TRUNC(cust_assign_start_date) > TRUNC(p_str_dt);
6105:
6106: IF NVL(TRUNC(l_emp_min_str_dt),TO_DATE('12/31/4712','mm/dd/yyyy')) <

Line 6193: FROM pn_space_assign_cust_all

6189: SELECT NVL(SUM(allocated_area), 0)
6190: ,NVL(SUM(allocated_area_pct), 0)
6191: INTO l_allocated_area_cust
6192: ,l_allocated_area_pct_cust
6193: FROM pn_space_assign_cust_all
6194: WHERE location_id = p_loc_id
6195: AND cust_assign_start_date <= NVL(p_new_end_dt,TO_DATE('12/31/4712','mm/dd/yyyy'))
6196: AND NVL(cust_assign_end_date,TO_DATE('12/31/4712','mm/dd/yyyy')) >= p_str_dt;
6197:

Line 6486: l_new_cust_alloc_pct PN_SPACE_ASSIGN_CUST.allocated_area_pct%TYPE;

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

Line 6488: l_new_cust_alloc_area PN_SPACE_ASSIGN_CUST.allocated_area%TYPE;

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

Line 6494: cust_rec pn_space_assign_cust_all%ROWTYPE;

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

Line 6510: FROM pn_space_assign_cust_all

6506: CURSOR get_cust_assgn(p_loc_id IN NUMBER,
6507: p_str_dt IN DATE,
6508: p_end_dt IN DATE) IS
6509: SELECT *
6510: FROM pn_space_assign_cust_all
6511: WHERE location_id = p_loc_id
6512: AND cust_assign_start_date <= p_end_dt
6513: AND NVL(cust_assign_end_date, g_end_of_time) >= p_str_dt;
6514:

Line 6529: FROM pn_space_assign_cust_all

6525: CURSOR get_cust_assgn1(p_loc_id IN NUMBER,
6526: p_str_dt IN DATE,
6527: p_end_dt IN DATE) IS
6528: SELECT *
6529: FROM pn_space_assign_cust_all
6530: WHERE location_id = p_loc_id
6531: AND NVL(cust_assign_end_date, g_end_of_time) >= p_str_dt;
6532:
6533: -- 102403 -- date track space assignment

Line 6765: FROM PN_SPACE_ASSIGN_CUST_ALL

6761: );
6762:
6763: CURSOR c_space_cust is
6764: SELECT NVL(SUM(Allocated_Area), 0),NVL(SUM(UTILIZED_AREA),0)
6765: FROM PN_SPACE_ASSIGN_CUST_ALL
6766: WHERE cust_assign_start_date <= l_as_of_date
6767: AND NVL(cust_assign_end_date, l_date) >= l_as_of_date
6768: AND Location_Id IN (SELECT Location_Id
6769: FROM pn_locations_all

Line 6881: FROM pn_space_assign_cust_all

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
6882: WHERE location_id = p_Location_Id
6883: ORDER BY 1;
6884:
6885: BEGIN

Line 7101: FROM pn_space_assign_cust_all

7097: )
7098: IS
7099: CURSOR pn_space_assign_cust_cursor IS
7100: SELECT *
7101: FROM pn_space_assign_cust_all
7102: WHERE location_id IN
7103: ( SELECT location_id
7104: FROM pn_locations_all
7105: START WITH location_id = p_location_id

Line 7279: FROM pn_space_assign_cust_all

7275: AND emp_assign_start_date < p_start_date
7276: AND NVL(emp_assign_end_date,to_date('12/31/4712','mm/dd/yyyy')) >= p_start_date_old
7277: UNION
7278: SELECT 'x'
7279: FROM pn_space_assign_cust_all
7280: WHERE location_id IN (SELECT location_id
7281: FROM pn_locations_all
7282: START WITH location_id = p_location_id
7283: CONNECT BY PRIOR location_id = parent_location_id )

Line 7304: FROM pn_space_assign_cust_all

7300: AND NVL(emp_assign_end_date,to_date('12/31/4712','mm/dd/yyyy')) > p_end_date
7301: AND emp_assign_start_date <= p_end_date_old
7302: UNION
7303: SELECT 'x'
7304: FROM pn_space_assign_cust_all
7305: WHERE location_id IN (SELECT location_id
7306: FROM pn_locations_all
7307: START WITH location_id = p_location_id
7308: CONNECT BY PRIOR location_id = parent_location_id )