APPS.AHL_LTP_SPACE_UNAVL_PVT dependencies on AHL_SPACE_UNAVAILABLE_VL

Line 256: FROM ahl_space_unavailable_vl

252: ATTRIBUTE12,
253: ATTRIBUTE13,
254: ATTRIBUTE14,
255: ATTRIBUTE15
256: FROM ahl_space_unavailable_vl
257: WHERE space_unavailability_id = p_space_restriction_rec.space_unavailability_id
258: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
259: --
260: -- This is the only exception for using %ROWTYPE.

Line 788: -- p_space_restriction_rec: the record representing AHL_SPACE_UNAVAILABLE_VL view..

784: -- PURPOSE
785: -- Create Space Restriction Record
786: --
787: -- PARAMETERS
788: -- p_space_restriction_rec: the record representing AHL_SPACE_UNAVAILABLE_VL view..
789: -- x_space_unavailability_id: the space_unavailability_id.
790: --
791: -- NOTES
792: --------------------------------------------------------------------

Line 824: FROM AHL_SPACE_UNAVAILABLE_VL

820: c_start_date IN DATE,
821: c_end_date IN DATE)
822: IS
823: SELECT space_id
824: FROM AHL_SPACE_UNAVAILABLE_VL
825: WHERE space_id = c_space_id
826: AND trunc(start_date) = c_start_date
827: AND trunc(end_date) = c_end_date;
828: --

Line 1268: -- p_space_restriction_rec: the record representing AHL_SPACE_UNAVAILABLE_VL

1264: -- PURPOSE
1265: -- Update Space Restriction Record.
1266: --
1267: -- PARAMETERS
1268: -- p_space_restriction_rec: the record representing AHL_SPACE_UNAVAILABLE_VL
1269: --
1270: -- NOTES
1271: --------------------------------------------------------------------
1272: PROCEDURE Update_Space_Restriction (

Line 1290: FROM AHL_SPACE_UNAVAILABLE_VL

1286: c_start_date IN DATE,
1287: c_end_date IN DATE)
1288: IS
1289: SELECT space_id
1290: FROM AHL_SPACE_UNAVAILABLE_VL
1291: WHERE space_id = c_space_id
1292: AND trunc(start_date) = c_start_date
1293: AND trunc(end_date) = c_end_date;
1294: --

Line 1298: FROM AHL_SPACE_UNAVAILABLE_VL

1294: --
1295: CURSOR get_space_capb_cur (c_space_unavabl_id IN NUMBER)
1296: IS
1297: SELECT start_date,end_date
1298: FROM AHL_SPACE_UNAVAILABLE_VL
1299: WHERE space_unavailability_id = c_space_unavabl_id;
1300: --
1301: CURSOR get_space_detail_cur (c_space_id IN NUMBER)
1302: IS

Line 1583: FROM ahl_space_unavailable_vl

1579: CURSOR c_space_restrict_cur
1580: (c_space_unavailability_id IN NUMBER)
1581: IS
1582: SELECT space_unavailability_id,object_version_number
1583: FROM ahl_space_unavailable_vl
1584: WHERE space_unavailability_id = c_space_unavailability_id
1585: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1586:
1587: BEGIN