APPS.IGS_CO_GEN_002 dependencies on IGS_CO_LTR_PARAM

Line 283: -- This module calculates the value for a IGS_CO_LTR_PARAM and inserts

279: p_message_name OUT NOCOPY varchar2,
280: p_letter_order_number IN number)
281: RETURN BOOLEAN AS
282: BEGIN -- corp_ins_splp
283: -- This module calculates the value for a IGS_CO_LTR_PARAM and inserts
284: -- a record into the IGS_CO_S_PER_LT_PARM table.
285: DECLARE
286: cst_in CONSTANT VARCHAR2(2) := 'IN';
287: cst_out CONSTANT VARCHAR2(3) := 'OUT';

Line 490: from igs_co_ltr_param

486: p_letter_context_parameter,2,'|'));
487: declare
488: p_letter_order_number NUMBER(3);
489: cursor get_lon IS SELECT letter_order_number
490: from igs_co_ltr_param
491: where correspondence_type = p_correspondence_type and letter_parameter_type = p_letter_parameter_type and
492: letter_reference_number = p_letter_reference_number;
493:
494: begin