APPS.QA_ERES_UTIL dependencies on QA_PLAN_CHAR_ACTION_TRIGGERS

Line 165: l_qpcat_id QA_PLAN_CHAR_ACTION_TRIGGERS.plan_char_action_trigger_id%TYPE;

161: l_char_id QA_CHARS.char_id%TYPE;
162:
163: l_message QA_PLAN_CHAR_ACTIONS.message%TYPE;
164: l_user_id NUMBER;
165: l_qpcat_id QA_PLAN_CHAR_ACTION_TRIGGERS.plan_char_action_trigger_id%TYPE;
166: l_qpca_id QA_PLAN_CHAR_ACTIONS.plan_char_action_id%TYPE;
167:
168: CURSOR get_prompt_seq( c_plan_id NUMBER ) IS
169: SELECT MAX( prompt_sequence ) + 10

Line 258: SELECT qa_plan_char_action_triggers_s.nextval

254: -- the user from updating a Qa Result when the eSignature
255: -- status element is PENDING.
256:
257: -- Get the Plan Element Action Trigger ID
258: SELECT qa_plan_char_action_triggers_s.nextval
259: INTO l_qpcat_id
260: FROM dual;
261:
262: -- Create a new Plan Element Action Trigger

Line 263: INSERT INTO qa_plan_char_action_triggers

259: INTO l_qpcat_id
260: FROM dual;
261:
262: -- Create a new Plan Element Action Trigger
263: INSERT INTO qa_plan_char_action_triggers
264: (
265: plan_char_action_trigger_id,
266: last_update_date,
267: last_updated_by,