APPS.QA_ERES_UTIL dependencies on QA_PLAN_CHARS

Line 135: FROM QA_PLAN_CHARS

131: RETURN VARCHAR2
132: IS
133: CURSOR check_plan_element( c_plan_id NUMBER ) IS
134: SELECT 'Y'
135: FROM QA_PLAN_CHARS
136: WHERE char_id = 2147483572
137: AND enabled_flag = 1
138: AND plan_id = c_plan_id;
139:

Line 158: l_prompt_seq QA_PLAN_CHARS.prompt_sequence%TYPE;

154: -- Esignatures by adding the 'eSignature Status' element to the plan.
155: PROCEDURE add_esig_status ( p_plan_id IN NUMBER )
156: IS
157: l_prompt QA_CHARS.prompt%TYPE;
158: l_prompt_seq QA_PLAN_CHARS.prompt_sequence%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:

Line 160: l_result_column QA_PLAN_CHARS.result_column_name%TYPE;

156: IS
157: l_prompt QA_CHARS.prompt%TYPE;
158: l_prompt_seq QA_PLAN_CHARS.prompt_sequence%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;

Line 170: FROM QA_PLAN_CHARS

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
171: WHERE plan_id = c_plan_id;
172:
173: -- Bug 4958731: SQL Repository Fix
174:

Line 183: FROM qa_plan_chars qpc,

179: -- this SQL always returns a value ( 0 in such cases ).
180: CURSOR get_result_column( c_plan_id NUMBER ) IS
181: SELECT
182: nvl( max( to_number(substr(result_column_name,10,3)) ), 0 )
183: FROM qa_plan_chars qpc,
184: qa_chars qc
185: WHERE qpc.plan_id = c_plan_id
186: AND qc.char_id = qpc.char_id
187: AND qc.hardcoded_column is null

Line 214: INSERT INTO QA_PLAN_CHARS

210:
211: l_user_id := FND_GLOBAL.user_id;
212:
213: -- Insert the eSignature status plan element
214: INSERT INTO QA_PLAN_CHARS
215: (
216: plan_id,
217: char_id,
218: last_update_date,