APPS.QA_SSQR_JRAD_PKG dependencies on QA_PLANS

Line 3387: FROM qa_plans

3383: PRAGMA AUTONOMOUS_TRANSACTION;
3384:
3385: CURSOR plan IS
3386: SELECT template_plan_id
3387: FROM qa_plans
3388: WHERE plan_id = p_plan_id;
3389:
3390: CURSOR valueLookups(c_char_id NUMBER) IS
3391: SELECT short_code, ORA_HASH(short_code) hash_code

Line 3522: FROM qa_plans

3518: --
3519:
3520: SELECT jrad_upgrade_ver
3521: INTO l_jrad_upgrade_ver
3522: FROM qa_plans
3523: WHERE plan_id = p_plan_id
3524: FOR UPDATE;
3525:
3526: SELECT jrad_upgrade_ver

Line 3528: FROM qa_plans

3524: FOR UPDATE;
3525:
3526: SELECT jrad_upgrade_ver
3527: INTO l_seed_ver
3528: FROM qa_plans
3529: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;
3530:
3531: fnd_msg_pub.initialize;
3532:

Line 3620: UPDATE qa_plans

3616: --
3617: PROCEDURE jrad_upgraded(p_plan_id IN NUMBER) IS
3618:
3619: BEGIN
3620: UPDATE qa_plans
3621: SET jrad_upgrade_ver =
3622: (SELECT nvl(jrad_upgrade_ver, 1)
3623: FROM qa_plans
3624: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN)

Line 3623: FROM qa_plans

3619: BEGIN
3620: UPDATE qa_plans
3621: SET jrad_upgrade_ver =
3622: (SELECT nvl(jrad_upgrade_ver, 1)
3623: FROM qa_plans
3624: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN)
3625: WHERE plan_id = p_plan_id;
3626: END jrad_upgraded;
3627: