APPS.QA_ERES_UTIL dependencies on QA_CHARS

Line 157: l_prompt QA_CHARS.prompt%TYPE;

153: -- This procedure enables a given collection plan for Deferred
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;

Line 161: l_char_id QA_CHARS.char_id%TYPE;

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;
165: l_qpcat_id QA_PLAN_CHAR_ACTION_TRIGGERS.plan_char_action_trigger_id%TYPE;

Line 184: qa_chars qc

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
188: AND qc.datatype in (1,2,3,6);

Line 196: l_prompt := QA_CHARS_API.prompt( l_char_id );

192: -- Get the Char ID of eSignature Status element
193: l_char_id := QA_SS_CONST.esignature_status;
194:
195: -- Get the Prompt for the eSignature Status element
196: l_prompt := QA_CHARS_API.prompt( l_char_id );
197:
198: -- Get the Next Prompt Sequence for the Given Plan
199: OPEN get_prompt_seq( p_plan_id );
200: FETCH get_prompt_seq INTO l_prompt_seq;