eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_CO_GEN_002 dependencies on IGS_CO_S_LTR

Line 43: FROM IGS_CO_S_LTR sl

39: AND cort.CORRESPONDENCE_TYPE = cori.CORRESPONDENCE_TYPE;
40: CURSOR c_sl(
41: cp_correspondence_type IGS_CO_ITM.CORRESPONDENCE_TYPE%TYPE) IS
42: SELECT 'x'
43: FROM IGS_CO_S_LTR sl
44: WHERE sl.CORRESPONDENCE_TYPE = cp_correspondence_type;
45: CURSOR c_cdo(
46: cp_correspondence_type IGS_CO_DTL_OLE.CORRESPONDENCE_TYPE%TYPE,
47: cp_reference_number IGS_CO_DTL_OLE.reference_number%TYPE) IS

Line 307: v_code_block IGS_CO_S_LTR_PARAM.code_block%TYPE;

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;
311: v_aal_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;

Line 309: IGS_CO_S_LTR_PARAM.S_LETTER_PARAMETER_TYPE%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;
311: v_aal_sequence_number IGS_CO_S_PER_LT_PARM.sequence_number%TYPE;
312: v_extra_context VARCHAR2(100);
313: v_message_name varchar2(30);

Line 324: IGS_CO_S_LTR_PARAM slpt

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 (
328: cp_s_letter_parameter_type

Line 329: IGS_CO_S_LTR_PARAM.S_LETTER_PARAMETER_TYPE%TYPE) IS

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 (
328: cp_s_letter_parameter_type
329: IGS_CO_S_LTR_PARAM.S_LETTER_PARAMETER_TYPE%TYPE) IS
330: SELECT slpta.bind_variable
331: FROM IGS_CO_S_LTR_PR_ARG slpta
332: WHERE slpta.S_LETTER_PARAMETER_TYPE = cp_s_letter_parameter_type AND
333: slpta.direction = cst_in;

Line 331: FROM IGS_CO_S_LTR_PR_ARG slpta

327: CURSOR c_slpta_in (
328: cp_s_letter_parameter_type
329: IGS_CO_S_LTR_PARAM.S_LETTER_PARAMETER_TYPE%TYPE) IS
330: SELECT slpta.bind_variable
331: FROM IGS_CO_S_LTR_PR_ARG slpta
332: WHERE slpta.S_LETTER_PARAMETER_TYPE = cp_s_letter_parameter_type AND
333: slpta.direction = cst_in;
334: CURSOR c_slpta_out(
335: cp_s_letter_parameter_type

Line 336: IGS_CO_S_LTR_PARAM.S_LETTER_PARAMETER_TYPE%TYPE) IS

332: WHERE slpta.S_LETTER_PARAMETER_TYPE = cp_s_letter_parameter_type AND
333: slpta.direction = cst_in;
334: CURSOR c_slpta_out(
335: cp_s_letter_parameter_type
336: IGS_CO_S_LTR_PARAM.S_LETTER_PARAMETER_TYPE%TYPE) IS
337: SELECT slpta.bind_variable
338: FROM IGS_CO_S_LTR_PR_ARG slpta
339: WHERE slpta.S_LETTER_PARAMETER_TYPE = cp_s_letter_parameter_type AND
340: slpta.direction = cst_out;

Line 338: FROM IGS_CO_S_LTR_PR_ARG slpta

334: CURSOR c_slpta_out(
335: cp_s_letter_parameter_type
336: IGS_CO_S_LTR_PARAM.S_LETTER_PARAMETER_TYPE%TYPE) IS
337: SELECT slpta.bind_variable
338: FROM IGS_CO_S_LTR_PR_ARG slpta
339: WHERE slpta.S_LETTER_PARAMETER_TYPE = cp_s_letter_parameter_type AND
340: slpta.direction = cst_out;
341: BEGIN
342: -- Initialise output parameters

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,

Line 373: -- Put the block of code from the IGS_CO_S_LTR_PARAM table

369: RETURN TRUE;
370: END IF;
371: -- Open a cursor for dynamic SQL
372: v_dbms := DBMS_SQL.OPEN_CURSOR;
373: -- Put the block of code from the IGS_CO_S_LTR_PARAM table
374: -- into the dynmaic SQL cursor
375: DBMS_SQL.PARSE(
376: v_dbms,
377: v_code_block,

Line 473: ELSE -- IGS_CO_S_LTR_PARAM = 'PHRASE'

469: X_MODE=>'R',
470: x_letter_order_number => p_letter_order_number,
471: X_ORG_ID => FND_PROFILE.value('ORG_ID'));
472: END IF;
473: ELSE -- IGS_CO_S_LTR_PARAM = 'PHRASE'
474: IF p_record_number <> 1 THEN
475: p_stored_ind := 'N';
476: RETURN TRUE;
477: END IF;