APPS.QA_ERES_UTIL dependencies on QA_PLAN_CHAR_ACTION_TRIGGERS

Line 150: l_qpcat_id QA_PLAN_CHAR_ACTION_TRIGGERS.plan_char_action_trigger_id%TYPE;

146: l_char_id QA_CHARS.char_id%TYPE;
147:
148: l_message QA_PLAN_CHAR_ACTIONS.message%TYPE;
149: l_user_id NUMBER;
150: l_qpcat_id QA_PLAN_CHAR_ACTION_TRIGGERS.plan_char_action_trigger_id%TYPE;
151: l_qpca_id QA_PLAN_CHAR_ACTIONS.plan_char_action_id%TYPE;
152:
153: CURSOR get_prompt_seq( c_plan_id NUMBER ) IS
154: SELECT MAX( prompt_sequence ) + 10

Line 243: SELECT qa_plan_char_action_triggers_s.nextval

239: -- the user from updating a Qa Result when the eSignature
240: -- status element is PENDING.
241:
242: -- Get the Plan Element Action Trigger ID
243: SELECT qa_plan_char_action_triggers_s.nextval
244: INTO l_qpcat_id
245: FROM dual;
246:
247: -- Create a new Plan Element Action Trigger

Line 248: INSERT INTO qa_plan_char_action_triggers

244: INTO l_qpcat_id
245: FROM dual;
246:
247: -- Create a new Plan Element Action Trigger
248: INSERT INTO qa_plan_char_action_triggers
249: (
250: plan_char_action_trigger_id,
251: last_update_date,
252: last_updated_by,