DBA Data[Home] [Help]

APPS.QA_SSQR_JRAD_PKG dependencies on QA_PLANS

Line 3292: FROM qa_plans

3288: PRAGMA AUTONOMOUS_TRANSACTION;
3289:
3290: CURSOR plan IS
3291: SELECT template_plan_id
3292: FROM qa_plans
3293: WHERE plan_id = p_plan_id;
3294:
3295: CURSOR valueLookups(c_char_id NUMBER) IS
3296: SELECT short_code

Line 3418: FROM qa_plans

3414: --
3415:
3416: SELECT jrad_upgrade_ver
3417: INTO l_jrad_upgrade_ver
3418: FROM qa_plans
3419: WHERE plan_id = p_plan_id
3420: FOR UPDATE;
3421:
3422: SELECT jrad_upgrade_ver

Line 3424: FROM qa_plans

3420: FOR UPDATE;
3421:
3422: SELECT jrad_upgrade_ver
3423: INTO l_seed_ver
3424: FROM qa_plans
3425: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;
3426:
3427: fnd_msg_pub.initialize;
3428:

Line 3516: UPDATE qa_plans

3512: --
3513: PROCEDURE jrad_upgraded(p_plan_id IN NUMBER) IS
3514:
3515: BEGIN
3516: UPDATE qa_plans
3517: SET jrad_upgrade_ver =
3518: (SELECT nvl(jrad_upgrade_ver, 1)
3519: FROM qa_plans
3520: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN)

Line 3519: FROM qa_plans

3515: BEGIN
3516: UPDATE qa_plans
3517: SET jrad_upgrade_ver =
3518: (SELECT nvl(jrad_upgrade_ver, 1)
3519: FROM qa_plans
3520: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN)
3521: WHERE plan_id = p_plan_id;
3522: END jrad_upgraded;
3523: