APPS.AHL_SIMULATION_PLANS_PKG dependencies on AHL_SIMULATION_PLANS_B

Line 32: cursor C is select ROWID from AHL_SIMULATION_PLANS_B

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from AHL_SIMULATION_PLANS_B
33: where SIMULATION_PLAN_ID = X_SIMULATION_PLAN_ID
34: ;
35: begin
36: insert into AHL_SIMULATION_PLANS_B (

Line 36: insert into AHL_SIMULATION_PLANS_B (

32: cursor C is select ROWID from AHL_SIMULATION_PLANS_B
33: where SIMULATION_PLAN_ID = X_SIMULATION_PLAN_ID
34: ;
35: begin
36: insert into AHL_SIMULATION_PLANS_B (
37: SIMULATION_PLAN_ID,
38: OBJECT_VERSION_NUMBER,
39: PRIMARY_PLAN_FLAG,
40: ATTRIBUTE_CATEGORY,

Line 170: from AHL_SIMULATION_PLANS_B

166: ATTRIBUTE12,
167: ATTRIBUTE13,
168: ATTRIBUTE14,
169: ATTRIBUTE15
170: from AHL_SIMULATION_PLANS_B
171: where SIMULATION_PLAN_ID = X_SIMULATION_PLAN_ID
172: for update of SIMULATION_PLAN_ID nowait;
173: recinfo c%rowtype;
174:

Line 276: update AHL_SIMULATION_PLANS_B set

272: X_LAST_UPDATED_BY in NUMBER,
273: X_LAST_UPDATE_LOGIN in NUMBER
274: ) is
275: begin
276: update AHL_SIMULATION_PLANS_B set
277: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
278: PRIMARY_PLAN_FLAG = X_PRIMARY_PLAN_FLAG,
279: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
280: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 330: delete from AHL_SIMULATION_PLANS_B

326: if (sql%notfound) then
327: raise no_data_found;
328: end if;
329:
330: delete from AHL_SIMULATION_PLANS_B
331: where SIMULATION_PLAN_ID = X_SIMULATION_PLAN_ID;
332:
333: if (sql%notfound) then
334: raise no_data_found;

Line 344: from AHL_SIMULATION_PLANS_B B

340: begin
341: delete from AHL_SIMULATION_PLANS_TL T
342: where not exists
343: (select NULL
344: from AHL_SIMULATION_PLANS_B B
345: where B.SIMULATION_PLAN_ID = T.SIMULATION_PLAN_ID
346: );
347:
348: update AHL_SIMULATION_PLANS_TL T set (

Line 431: FROM AHL_SIMULATION_PLANS_B

427: IS
428:
429: CURSOR c_obj_verno IS
430: SELECT object_version_number
431: FROM AHL_SIMULATION_PLANS_B
432: WHERE simulation_plan_id = X_SIMULATION_PLAN_ID;
433: --
434: CURSOR c_chk_simulation_exists IS
435: SELECT 'x'

Line 436: FROM AHL_SIMULATION_PLANS_B

432: WHERE simulation_plan_id = X_SIMULATION_PLAN_ID;
433: --
434: CURSOR c_chk_simulation_exists IS
435: SELECT 'x'
436: FROM AHL_SIMULATION_PLANS_B
437: WHERE simulation_plan_id = X_SIMULATION_PLAN_ID;
438: --
439: CURSOR c_get_simulation_id IS
440: SELECT ahl_simulation_plans_b_s.NEXTVAL

Line 440: SELECT ahl_simulation_plans_b_s.NEXTVAL

436: FROM AHL_SIMULATION_PLANS_B
437: WHERE simulation_plan_id = X_SIMULATION_PLAN_ID;
438: --
439: CURSOR c_get_simulation_id IS
440: SELECT ahl_simulation_plans_b_s.NEXTVAL
441: FROM dual;
442: --
443: l_user_id NUMBER := 0;
444: l_obj_verno NUMBER;