APPS.AHL_LTP_SPACE_CAPB_PVT dependencies on AHL_SPACES_VL

Line 201: FROM AHL_SPACES_VL

197: IF (p_space_id IS NOT NULL)
198: THEN
199: SELECT space_id
200: INTO x_space_id
201: FROM AHL_SPACES_VL
202: WHERE space_id = p_space_id;
203: ELSE
204: SELECT space_id
205: INTO x_space_id

Line 206: FROM AHL_SPACES_VL

202: WHERE space_id = p_space_id;
203: ELSE
204: SELECT space_id
205: INTO x_space_id
206: FROM AHL_SPACES_VL
207: WHERE SPACE_NAME = p_space_name;
208: END IF;
209: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
210: EXCEPTION

Line 300: FROM ahl_spaces_vl

296: ATTRIBUTE12,
297: ATTRIBUTE13,
298: ATTRIBUTE14,
299: ATTRIBUTE15
300: FROM ahl_spaces_vl
301: WHERE space_id = p_space_rec.space_id;
302: --
303: CURSOR check_dup_name (c_space_name IN VARCHAR2,
304: c_dept_id IN NUMBER)

Line 307: AHL_SPACES_VL

303: CURSOR check_dup_name (c_space_name IN VARCHAR2,
304: c_dept_id IN NUMBER)
305: IS
306: SELECT space_id FROM
307: AHL_SPACES_VL
308: WHERE space_name = c_space_name
309: AND bom_department_id = c_dept_id;
310: -- This is the only exception for using %ROWTYPE.
311: l_space_rec c_space_rec%ROWTYPE;

Line 500: FROM AHL_SPACES_VL

496: CURSOR space_name_cur (c_space_name IN VARCHAR2,
497: c_dept_id IN NUMBER)
498: IS
499: SELECT space_name
500: FROM AHL_SPACES_VL
501: WHERE space_name = c_space_name
502: AND bom_department_id = c_dept_id;
503: --
504: l_table_name VARCHAR2(30);

Line 570: 'ahl_spaces_vl',

566: AND (p_space_rec.space_id = FND_API.G_MISS_NUM OR
567: p_space_rec.space_id IS NULL)
568: THEN
569: IF Ahl_Utility_Pvt.check_uniqueness(
570: 'ahl_spaces_vl',
571: 'space_name = ' || p_space_rec.space_name
572: ) = Fnd_Api.g_false
573: THEN
574: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)

Line 766: -- p_x_space_rec: the record representing AHL_SPACES_VL view..

762: -- PURPOSE
763: -- Create Space Record
764: --
765: -- PARAMETERS
766: -- p_x_space_rec: the record representing AHL_SPACES_VL view..
767: --
768: -- NOTES
769: --------------------------------------------------------------------
770:

Line 1226: -- p_space_rec: the record representing AHL_SPACES_VL

1222: -- PURPOSE
1223: -- Update Space Record.
1224: --
1225: -- PARAMETERS
1226: -- p_space_rec: the record representing AHL_SPACES_VL
1227: --
1228: -- NOTES
1229: --------------------------------------------------------------------
1230: PROCEDURE Update_Space (

Line 1246: FROM AHL_SPACES_VL

1242: CURSOR space_name_cur (c_space_id IN NUMBER,
1243: c_dept_id IN NUMBER)
1244: IS
1245: SELECT space_name, space_id
1246: FROM AHL_SPACES_VL
1247: WHERE space_id = c_space_id
1248: AND bom_department_id = c_dept_id;
1249: --
1250:

Line 1559: FROM ahl_spaces_vl

1555: CURSOR c_space_cur
1556: (c_space_id IN NUMBER)
1557: IS
1558: SELECT space_id,object_version_number
1559: FROM ahl_spaces_vl
1560: WHERE space_id = c_space_id
1561: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1562: --
1563: CURSOR c_space_visit_cur (c_space_id IN NUMBER)