DBA Data[Home] [Help]

APPS.AHL_SIMULATION_PLANS_PKG dependencies on AHL_SIMULATION_PLANS_B_S

Line 292: update AHL_SIMULATION_PLANS_B set

288: X_STATUS_CODE in VARCHAR2,
289: X_SIMULATION_TYPE in VARCHAR2
290: ) is
291: begin
292: update AHL_SIMULATION_PLANS_B set
293: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
294: PRIMARY_PLAN_FLAG = X_PRIMARY_PLAN_FLAG,
295: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
296: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 460: SELECT ahl_simulation_plans_b_s.NEXTVAL

456: FROM AHL_SIMULATION_PLANS_B
457: WHERE simulation_plan_id = X_SIMULATION_PLAN_ID;
458: --
459: CURSOR c_get_simulation_id IS
460: SELECT ahl_simulation_plans_b_s.NEXTVAL
461: FROM dual;
462: --
463: CURSOR c_chk_pri_plan_exists IS
464: SELECT 'x'