APPS.QA_ERES_UTIL dependencies on QA_PLAN_CHAR_ACTIONS

Line 163: l_message QA_PLAN_CHAR_ACTIONS.message%TYPE;

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

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

Line 301: SELECT qa_plan_char_actions_s.nextval

297: NULL
298: );
299:
300: -- Generate the Plan Element Action ID
301: SELECT qa_plan_char_actions_s.nextval
302: INTO l_qpca_id
303: FROM dual;
304:
305: -- Get the Rejection Message

Line 308: INSERT INTO qa_plan_char_actions

304:
305: -- Get the Rejection Message
306: l_message := FND_MESSAGE.get_string( 'QA', 'QA_ERES_CANNOT_UPDATE_RESULT' );
307:
308: INSERT INTO qa_plan_char_actions
309: (
310: plan_char_action_id,
311: last_update_date,
312: last_updated_by,