APPS.QA_ERES_UTIL dependencies on QA_PLAN_CHARS

Line 120: FROM QA_PLAN_CHARS

116: RETURN VARCHAR2
117: IS
118: CURSOR check_plan_element( c_plan_id NUMBER ) IS
119: SELECT 'Y'
120: FROM QA_PLAN_CHARS
121: WHERE char_id = 2147483572
122: AND enabled_flag = 1
123: AND plan_id = c_plan_id;
124:

Line 143: l_prompt_seq QA_PLAN_CHARS.prompt_sequence%TYPE;

139: -- Esignatures by adding the 'eSignature Status' element to the plan.
140: PROCEDURE add_esig_status ( p_plan_id IN NUMBER )
141: IS
142: l_prompt QA_CHARS.prompt%TYPE;
143: l_prompt_seq QA_PLAN_CHARS.prompt_sequence%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:

Line 145: l_result_column QA_PLAN_CHARS.result_column_name%TYPE;

141: IS
142: l_prompt QA_CHARS.prompt%TYPE;
143: l_prompt_seq QA_PLAN_CHARS.prompt_sequence%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;

Line 155: FROM QA_PLAN_CHARS

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
156: WHERE plan_id = c_plan_id;
157:
158: -- Bug 4958731: SQL Repository Fix
159:

Line 168: FROM qa_plan_chars qpc,

164: -- this SQL always returns a value ( 0 in such cases ).
165: CURSOR get_result_column( c_plan_id NUMBER ) IS
166: SELECT
167: nvl( max( to_number(substr(result_column_name,10,3)) ), 0 )
168: FROM qa_plan_chars qpc,
169: qa_chars qc
170: WHERE qpc.plan_id = c_plan_id
171: AND qc.char_id = qpc.char_id
172: AND qc.hardcoded_column is null

Line 199: INSERT INTO QA_PLAN_CHARS

195:
196: l_user_id := FND_GLOBAL.user_id;
197:
198: -- Insert the eSignature status plan element
199: INSERT INTO QA_PLAN_CHARS
200: (
201: plan_id,
202: char_id,
203: last_update_date,