APPS.IGS_CO_GEN_002 dependencies on IGS_CO_LTR_PARM_TYPE

Line 305: IGS_CO_LTR_PARM_TYPE.S_LETTER_PARAMETER_TYPE%TYPE;

301: v_dbms_return INTEGER;
302: v_value VARCHAR2(2000);
303: v_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;
304: v_lpt_s_letter_parameter_type
305: IGS_CO_LTR_PARM_TYPE.S_LETTER_PARAMETER_TYPE%TYPE;
306: v_letter_text IGS_CO_LTR_PARM_TYPE.letter_text%TYPE;
307: v_code_block IGS_CO_S_LTR_PARAM.code_block%TYPE;
308: v_slpt_s_letter_parameter_type
309: IGS_CO_S_LTR_PARAM.S_LETTER_PARAMETER_TYPE%TYPE;

Line 306: v_letter_text IGS_CO_LTR_PARM_TYPE.letter_text%TYPE;

302: v_value VARCHAR2(2000);
303: v_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;
304: v_lpt_s_letter_parameter_type
305: IGS_CO_LTR_PARM_TYPE.S_LETTER_PARAMETER_TYPE%TYPE;
306: v_letter_text IGS_CO_LTR_PARM_TYPE.letter_text%TYPE;
307: v_code_block IGS_CO_S_LTR_PARAM.code_block%TYPE;
308: v_slpt_s_letter_parameter_type
309: IGS_CO_S_LTR_PARAM.S_LETTER_PARAMETER_TYPE%TYPE;
310: v_adm_appl_num IGS_AD_APPL.admission_appl_number%TYPE;

Line 323: FROM IGS_CO_LTR_PARM_TYPE lpt,

319: SELECT lpt.S_LETTER_PARAMETER_TYPE,
320: lpt.letter_text,
321: slpt.code_block,
322: slpt.S_LETTER_PARAMETER_TYPE
323: FROM IGS_CO_LTR_PARM_TYPE lpt,
324: IGS_CO_S_LTR_PARAM slpt
325: WHERE lpt.LETTER_PARAMETER_TYPE = p_letter_parameter_type AND
326: slpt.S_LETTER_PARAMETER_TYPE = lpt.S_LETTER_PARAMETER_TYPE;
327: CURSOR c_slpta_in (

Line 345: -- Get IGS_CO_S_LTR_PARAM from IGS_CO_LTR_PARM_TYPE

341: BEGIN
342: -- Initialise output parameters
343: p_message_name := Null;
344: p_stored_ind := 'N';
345: -- Get IGS_CO_S_LTR_PARAM from IGS_CO_LTR_PARM_TYPE
346: OPEN c_lpt;
347: FETCH c_lpt INTO v_lpt_s_letter_parameter_type,
348: v_letter_text,
349: v_code_block,