APPS.QA_ERES_UTIL dependencies on QA_PLAN_CHAR_ACTIONS

Line 148: l_message QA_PLAN_CHAR_ACTIONS.message%TYPE;

144: l_result_seq NUMBER;
145: l_result_column QA_PLAN_CHARS.result_column_name%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:

Line 151: l_qpca_id QA_PLAN_CHAR_ACTIONS.plan_char_action_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
155: FROM QA_PLAN_CHARS

Line 286: SELECT qa_plan_char_actions_s.nextval

282: NULL
283: );
284:
285: -- Generate the Plan Element Action ID
286: SELECT qa_plan_char_actions_s.nextval
287: INTO l_qpca_id
288: FROM dual;
289:
290: -- Get the Rejection Message

Line 293: INSERT INTO qa_plan_char_actions

289:
290: -- Get the Rejection Message
291: l_message := FND_MESSAGE.get_string( 'QA', 'QA_ERES_CANNOT_UPDATE_RESULT' );
292:
293: INSERT INTO qa_plan_char_actions
294: (
295: plan_char_action_id,
296: last_update_date,
297: last_updated_by,