APPS.PN_SPACE_ALLOCATIONS_PKG dependencies on PN_SPACE_ALLOCATIONS_ALL

Line 45: FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC

41: )
42: IS
43: CURSOR C IS
44: SELECT ROWID
45: FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC
46: WHERE SPACE_ALLOCATION_ID = X_SPACE_ALLOCATION_ID ;
47:
48: BEGIN
49: SELECT PN_SPACE_ALLOCATIONS_S.nextval

Line 53: INSERT INTO PN_SPACE_ALLOCATIONS_ALL

49: SELECT PN_SPACE_ALLOCATIONS_S.nextval
50: INTO X_SPACE_ALLOCATION_ID
51: FROM DUAL;
52:
53: INSERT INTO PN_SPACE_ALLOCATIONS_ALL
54: ( --sdm_MOAC
55: SPACE_ALLOCATION_ID,
56: LAST_UPDATE_DATE,
57: LAST_UPDATED_BY,

Line 182: FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC

178: ATTRIBUTE13,
179: ATTRIBUTE14,
180: ATTRIBUTE15,
181: SPACE_ALLOCATION_ID
182: FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC
183: WHERE SPACE_ALLOCATION_ID = X_SPACE_ALLOCATION_ID
184: FOR UPDATE OF SPACE_ALLOCATION_ID nowait;
185: tlinfo c1%rowtype;
186:

Line 283: UPDATE PN_SPACE_ALLOCATIONS_ALL SET --sdm_MOAC

279: X_LAST_UPDATED_BY IN NUMBER,
280: X_LAST_UPDATE_LOGIN IN NUMBER
281: ) IS
282: BEGIN
283: UPDATE PN_SPACE_ALLOCATIONS_ALL SET --sdm_MOAC
284: LOCATION_ID = X_LOCATION_ID,
285: EMPLOYEE_ID = X_EMPLOYEE_ID,
286: COST_CENTER_CODE = X_COST_CENTER_CODE,
287: ALLOCATED_AREA_PCT = X_ALLOCATED_AREA_PCT,

Line 330: DELETE FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC

326: X_SPACE_ALLOCATION_ID in NUMBER
327: )
328: IS
329: BEGIN
330: DELETE FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC
331: WHERE SPACE_ALLOCATION_ID = X_SPACE_ALLOCATION_ID;
332:
333: IF (sql%notfound) THEN
334: RAISE NO_DATA_FOUND;

Line 354: FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC

350: INTO l_dummy
351: FROM dual
352: WHERE EXISTS
353: ( SELECT '1'
354: FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC
355: WHERE EMPLOYEE_ID = X_EMPLOYEE_ID
356: AND ORG_ID = X_ORG_ID); --sdm_MOAC
357:
358: RETURN TRUE;

Line 380: DELETE FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC

376: ) IS
377:
378: BEGIN
379:
380: DELETE FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC
381: WHERE EMPLOYEE_ID = X_EMPLOYEE_ID
382: AND ORG_ID = X_ORG_ID; --sdm_MOAC
383:
384: IF (sql%notfound) THEN

Line 410: FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC

406: BEGIN
407:
408: SELECT sum(PNP_UTIL_FUNC.get_vacant_area(location_id))
409: INTO x_vacant_area
410: FROM PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC
411: WHERE location_id = x_location_id;
412:
413: x_vacant_area_rtot_db := x_vacant_area ;
414:

Line 436: FROM PN_SPACE_ALLOCATIONS_ALL

432: BEGIN
433:
434: SELECT sum(PNP_UTIL_FUNC.get_utilized_capacity(location_id))
435: INTO x_utilized_capacity
436: FROM PN_SPACE_ALLOCATIONS_ALL
437: WHERE location_id = x_location_id ;
438:
439: x_utilized_capacity_rtot_db := x_utilized_capacity ;
440:

Line 463: FROM pn_space_allocations_all --sdm_MOAC

459: BEGIN
460:
461: SELECT count(*)
462: INTO l_utilized
463: FROM pn_space_allocations_all --sdm_MOAC
464: WHERE location_id = x_location_id;
465:
466:
467: UPDATE PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC

Line 467: UPDATE PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC

463: FROM pn_space_allocations_all --sdm_MOAC
464: WHERE location_id = x_location_id;
465:
466:
467: UPDATE PN_SPACE_ALLOCATIONS_ALL --sdm_MOAC
468: SET allocated_area_pct = round(100 / l_utilized, 2),
469: allocated_area = round(x_usable_area / l_utilized, 2)
470: WHERE location_id = x_location_id;
471: