APPS.AMW_CONTROL_PVT dependencies on AMW_CONTROLS_ALL_VL

Line 105: l_approval_status amw_controls_all_vl.approval_status%TYPE;

101: WHERE controlname LIKE p_control_rec.NAME
102: AND approval_status = 'D';
103: ---AND update_switcher = 'UpdateEnabled';
104: updenb update_enabled%ROWTYPE;
105: l_approval_status amw_controls_all_vl.approval_status%TYPE;
106: CURSOR rev_enabled IS
107: SELECT act.NAME, act.description, ac.control_rev_id, ac.control_id, ac.rev_num,
108: ac.object_version_number, ac.approval_status,
109: ac.curr_approved_flag, ac.latest_revision_flag, ac.requestor_id

Line 529: l_row_id amw_controls_all_vl.row_id%TYPE;

525: CURSOR c_rev_id_exists (l_rev_id IN NUMBER) IS
526: SELECT 1
527: FROM amw_controls_b
528: WHERE control_rev_id = l_rev_id;
529: l_row_id amw_controls_all_vl.row_id%TYPE;
530: CURSOR c IS
531: SELECT ROWID
532: FROM amw_controls_b
533: WHERE control_rev_id = x_control_rev_id;