APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on AHL_SPACE_ASSIGNMENTS

Line 1509: FROM ahl_space_assignments

1505: AND STATUS_CODE <> 'DELETED';
1506: --
1507: CURSOR Get_space_Assign_cur (c_visit_id IN NUMBER) IS
1508: SELECT space_id,space_assignment_id
1509: FROM ahl_space_assignments
1510: WHERE visit_id = c_visit_id;
1511:
1512: --Added by mpothuku on 12/27/04
1513:

Line 2269: SELECT AHL_SPACE_ASSIGNMENTS_S.NEXTVAL INTO l_space_assignment_id

2265: EXIT WHEN Get_space_Assign_cur%NOTFOUND;
2266: IF Get_space_Assign_cur%FOUND THEN
2267: --Create record in space assignments with new visit id
2268: --Get space assignment id
2269: SELECT AHL_SPACE_ASSIGNMENTS_S.NEXTVAL INTO l_space_assignment_id
2270: FROM dual;
2271: --insert the record
2272: INSERT INTO AHL_SPACE_ASSIGNMENTS
2273: (

Line 2272: INSERT INTO AHL_SPACE_ASSIGNMENTS

2268: --Get space assignment id
2269: SELECT AHL_SPACE_ASSIGNMENTS_S.NEXTVAL INTO l_space_assignment_id
2270: FROM dual;
2271: --insert the record
2272: INSERT INTO AHL_SPACE_ASSIGNMENTS
2273: (
2274: SPACE_ASSIGNMENT_ID,
2275: SPACE_ID,
2276: VISIT_ID,

Line 2448: FROM ahl_space_assignments

2444: --
2445: CURSOR Check_space_cur (c_visit_id IN NUMBER)
2446: IS
2447: SELECT space_assignment_id
2448: FROM ahl_space_assignments
2449: WHERE visit_id = c_visit_id;
2450: --
2451: -- Added by mpothuku on 12/27/04 to find any task links for a task
2452: CURSOR c_links (x_id IN NUMBER) IS

Line 2602: DELETE FROM ahl_space_assignments

2598: LOOP
2599: FETCH Check_space_cur INTO l_space_assignment_id;
2600: EXIT WHEN Check_space_cur%NOTFOUND;
2601: IF Check_space_cur%FOUND THEN
2602: DELETE FROM ahl_space_assignments
2603: WHERE space_assignment_id = l_space_assignment_id;
2604: END IF;
2605: END LOOP;
2606: CLOSE Check_space_cur;

Line 3349: FROM ahl_space_assignments

3345: --Check for space assignments
3346: CURSOR check_space_cur (c_visit_id IN NUMBER)
3347: IS
3348: SELECT space_assignment_id
3349: FROM ahl_space_assignments
3350: WHERE visit_id = c_visit_id;
3351: --
3352: -- Added by mpothuku on 12/27/04
3353: -- To find any task links for a task