APPS.IGS_CO_LTR_PR_RSTCN_PKG dependencies on IGS_CO_LTR_PARM_TYPE

Line 77: v_s_letter_parameter_type IGS_CO_LTR_PARM_TYPE.s_letter_parameter_type%TYPE;

73: p_updating IN BOOLEAN DEFAULT FALSE,
74: p_deleting IN BOOLEAN DEFAULT FALSE
75: ) AS
76: v_message_name varchar2(30);
77: v_s_letter_parameter_type IGS_CO_LTR_PARM_TYPE.s_letter_parameter_type%TYPE;
78: CURSOR c_lpt (cp_letter_parameter_type
79: IGS_CO_LTR_PARM_TYPE.letter_parameter_type %TYPE) IS
80: SELECT s_letter_parameter_type
81: FROM IGS_CO_LTR_PARM_TYPE

Line 79: IGS_CO_LTR_PARM_TYPE.letter_parameter_type %TYPE) IS

75: ) AS
76: v_message_name varchar2(30);
77: v_s_letter_parameter_type IGS_CO_LTR_PARM_TYPE.s_letter_parameter_type%TYPE;
78: CURSOR c_lpt (cp_letter_parameter_type
79: IGS_CO_LTR_PARM_TYPE.letter_parameter_type %TYPE) IS
80: SELECT s_letter_parameter_type
81: FROM IGS_CO_LTR_PARM_TYPE
82: WHERE letter_parameter_type = cp_letter_parameter_type;
83: BEGIN

Line 81: FROM IGS_CO_LTR_PARM_TYPE

77: v_s_letter_parameter_type IGS_CO_LTR_PARM_TYPE.s_letter_parameter_type%TYPE;
78: CURSOR c_lpt (cp_letter_parameter_type
79: IGS_CO_LTR_PARM_TYPE.letter_parameter_type %TYPE) IS
80: SELECT s_letter_parameter_type
81: FROM IGS_CO_LTR_PARM_TYPE
82: WHERE letter_parameter_type = cp_letter_parameter_type;
83: BEGIN
84: IF p_inserting THEN
85: -- Validate Letter Parameter Type closed.

Line 181: ELSIF NOT igs_co_ltr_parm_type_pkg.get_pk_for_validation (

177:
178: IF (((old_references.letter_parameter_type = new_references.letter_parameter_type)) OR
179: ((new_references.letter_parameter_type IS NULL))) THEN
180: NULL;
181: ELSIF NOT igs_co_ltr_parm_type_pkg.get_pk_for_validation (
182: new_references.letter_parameter_type
183: ) THEN
184: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
185: igs_ge_msg_stack.add;

Line 264: PROCEDURE get_fk_igs_co_ltr_parm_type (

260:
261: END get_fk_igs_co_type;
262:
263:
264: PROCEDURE get_fk_igs_co_ltr_parm_type (
265: x_letter_parameter_type IN VARCHAR2
266: ) AS
267: /*
268: || Created By : [email protected]

Line 296: END get_fk_igs_co_ltr_parm_type;

292: RETURN;
293: END IF;
294: CLOSE cur_rowid;
295:
296: END get_fk_igs_co_ltr_parm_type;
297:
298:
299: PROCEDURE before_dml (
300: p_action IN VARCHAR2,