APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on AHL_SPACE_ASSIGNMENTS

Line 323: FROM ahl_space_assignments

319: ATTRIBUTE12,
320: ATTRIBUTE13,
321: ATTRIBUTE14,
322: ATTRIBUTE15
323: FROM ahl_space_assignments
324: WHERE space_assignment_id = p_space_assign_rec.space_assignment_id;
325: --
326: -- This is the only exception for using %ROWTYPE.
327: l_space_assign_rec c_space_assign_rec%ROWTYPE;

Line 477: FROM AHL_SPACE_ASSIGNMENTS

473: CURSOR check_unique (c_visit_id IN NUMBER,
474: c_space_id IN NUMBER)
475: IS
476: SELECT space_assignment_id
477: FROM AHL_SPACE_ASSIGNMENTS
478: WHERE VISIT_ID = p_space_assign_rec.visit_id
479: AND SPACE_ID = p_space_assign_rec.space_id;
480: --
481: CURSOR visit_item_cur (c_visit_id IN NUMBER)

Line 734: -- p_x_space_assign_rec: the record representing AHL_SPACE_ASSIGNMENTS..

730: -- PURPOSE
731: -- Create Space Assignment Record
732: --
733: -- PARAMETERS
734: -- p_x_space_assign_rec: the record representing AHL_SPACE_ASSIGNMENTS..
735: --
736: -- NOTES
737: --
738: PROCEDURE Create_Space_Assignment (

Line 765: SELECT AHL_SPACE_ASSIGNMENTS_S.NEXTVAL

761: l_space_assign_rec Space_Assignment_Rec;
762: --
763: CURSOR c_seq
764: IS
765: SELECT AHL_SPACE_ASSIGNMENTS_S.NEXTVAL
766: FROM dual;
767: --
768: CURSOR c_id_exists (x_id IN NUMBER) IS
769: SELECT 1

Line 772: FROM ahl_space_assignments

768: CURSOR c_id_exists (x_id IN NUMBER) IS
769: SELECT 1
770: FROM dual
771: WHERE EXISTS (SELECT 1
772: FROM ahl_space_assignments
773: WHERE space_assignment_id = x_id);
774: --
775: BEGIN
776: --------------------Initialize ----------------------------------

Line 816: DELETE FROM AHL_SPACE_ASSIGNMENTS

812: p_x_space_assign_rec.visit_id <> FND_API.G_MISS_NUM ) THEN
813: --
814: AHL_DEBUG_PUB.debug( 'inside schedule flag:'||p_x_space_assign_rec.space_name);
815: --
816: DELETE FROM AHL_SPACE_ASSIGNMENTS
817: WHERE visit_id = p_x_space_assign_rec.visit_id;
818: --
819: END IF;
820: --

Line 1056: INSERT INTO AHL_SPACE_ASSIGNMENTS

1052: Ahl_Debug_Pub.debug( 'Before insert state'||l_space_assignment_id);
1053:
1054: ----------------------------DML Operation---------------------------------
1055: --insert the record
1056: INSERT INTO AHL_SPACE_ASSIGNMENTS
1057: (
1058: SPACE_ASSIGNMENT_ID,
1059: SPACE_ID,
1060: VISIT_ID,

Line 1317: UPDATE AHL_SPACE_ASSIGNMENTS

1313: x_msg_data => l_msg_data );
1314:
1315: ----------------------------DML Operation---------------------------------
1316: --Call table handler generated package to update a record
1317: UPDATE AHL_SPACE_ASSIGNMENTS
1318: SET visit_id = l_Space_assign_rec.visit_id,
1319: space_id = l_Space_assign_rec.space_id,
1320: object_version_number = l_Space_assign_rec.object_version_number+1,
1321: attribute_category = l_Space_assign_rec.attribute_category,

Line 1457: FROM ahl_space_assignments

1453: CURSOR c_space_assign_cur
1454: (c_space_assignment_id IN NUMBER)
1455: IS
1456: SELECT space_assignment_id,object_version_number
1457: FROM ahl_space_assignments
1458: WHERE space_assignment_id = c_space_assignment_id;
1459:
1460: CURSOR c_visit_spaces_cur
1461: (c_visit_id IN NUMBER)

Line 1472: FROM ahl_space_assignments sa,

1468: vt.organization_id,
1469: vt.department_id,
1470: sp.organization_id sporg_id,
1471: sp.bom_department_id spdept_id
1472: FROM ahl_space_assignments sa,
1473: ahl_visits_vl vt,
1474: ahl_spaces_b sp
1475: WHERE sa.visit_id = vt.visit_id
1476: AND sp.space_id = sa.space_id

Line 1545: DELETE FROM AHL_SPACE_ASSIGNMENTS

1541: IF (nvl(l_visit_spaces_rec.organization_id,-1) <> l_visit_spaces_rec.sporg_id
1542: OR nvl(l_visit_spaces_rec.department_id,-1) <> l_visit_spaces_rec.spdept_id )
1543: THEN
1544: --Remove space assignments
1545: DELETE FROM AHL_SPACE_ASSIGNMENTS
1546: WHERE space_assignment_id = l_visit_spaces_rec.space_assignment_id;
1547: ELSE
1548: --Check for space Unnavailabilty condition
1549: OPEN c_check_unavail_cur(l_visit_spaces_rec.space_id,

Line 1556: DELETE FROM AHL_SPACE_ASSIGNMENTS

1552: l_visit_spaces_rec.start_date_time));
1553: FETCH c_check_unavail_cur INTO l_dummy;
1554: IF c_check_unavail_cur%FOUND THEN
1555: --Remove space assignments
1556: DELETE FROM AHL_SPACE_ASSIGNMENTS
1557: WHERE space_Assignment_id = l_visit_spaces_rec.space_assignment_id;
1558: END IF;
1559: CLOSE c_check_unavail_cur;
1560: END IF;

Line 1596: DELETE FROM AHL_SPACE_ASSIGNMENTS

1592: FND_MSG_PUB.add;
1593: RAISE FND_API.g_exc_error;
1594: END IF;
1595: -------------------Call Table handler generated procedure------------
1596: DELETE FROM AHL_SPACE_ASSIGNMENTS
1597: WHERE SPACE_ASSIGNMENT_ID = p_space_assign_rec.space_assignment_id;
1598: END IF;
1599: ---------------------------End of Body---------------------------------------
1600: --Standard check to count messages

Line 1718: FROM AHL_SPACE_ASSIGNMENTS A

1714: CURSOR c_space_assign_cur (c_visit_id IN NUMBER)
1715: IS
1716: SELECT space_assignment_id,
1717: object_version_number
1718: FROM AHL_SPACE_ASSIGNMENTS A
1719: WHERE VISIT_ID = c_visit_id;
1720: */
1721: -- anraj: commented, issue number 144
1722: /*

Line 2023: DELETE FROM ahl_space_assignments

2019: LOOP
2020: FETCH c_space_assign_cur INTO l_space_assign_rec;
2021: EXIT WHEN c_space_assign_cur%NOTFOUND;
2022: --
2023: DELETE FROM ahl_space_assignments
2024: WHERE space_assignment_id = l_space_assign_rec.space_assignment_id;
2025: --
2026: END LOOP;
2027: CLOSE c_space_assign_cur;

Line 2331: FROM AHL_SPACE_ASSIGNMENTS

2327: CURSOR c_space_assign_cur (c_visit_id IN NUMBER)
2328: IS
2329: SELECT space_assignment_id,
2330: object_version_number
2331: FROM AHL_SPACE_ASSIGNMENTS
2332: WHERE VISIT_ID = c_visit_id;
2333: */
2334: --
2335: /*

Line 2489: DELETE FROM AHL_SPACE_ASSIGNMENTS

2485: LOOP
2486: FETCH c_space_assign_cur INTO l_space_assignment_id,l_space_version_number;
2487: EXIT WHEN c_space_assign_cur%NOTFOUND;
2488: -- Remove space assingment record
2489: DELETE FROM AHL_SPACE_ASSIGNMENTS
2490: WHERE space_assignment_id = l_space_assignment_id;
2491: --
2492: END LOOP;
2493: CLOSE c_space_assign_cur;