APPS.IGS_FI_LB_CR_TYPES_PKG dependencies on IGS_FI_CR_TYPES

Line 82: CURSOR cur_cr_type_name(cp_n_cr_type_id igs_fi_cr_types.credit_type_id%TYPE) IS

78: || Change History :
79: || Who When What
80: || (reverse chronological order - newest change first)
81: */
82: CURSOR cur_cr_type_name(cp_n_cr_type_id igs_fi_cr_types.credit_type_id%TYPE) IS
83: SELECT credit_type_name
84: FROM igs_fi_cr_types
85: WHERE credit_type_id = cp_n_cr_type_id;
86: l_v_cr_type_name igs_fi_cr_types.credit_type_name%TYPE;

Line 84: FROM igs_fi_cr_types

80: || (reverse chronological order - newest change first)
81: */
82: CURSOR cur_cr_type_name(cp_n_cr_type_id igs_fi_cr_types.credit_type_id%TYPE) IS
83: SELECT credit_type_name
84: FROM igs_fi_cr_types
85: WHERE credit_type_id = cp_n_cr_type_id;
86: l_v_cr_type_name igs_fi_cr_types.credit_type_name%TYPE;
87:
88: BEGIN

Line 86: l_v_cr_type_name igs_fi_cr_types.credit_type_name%TYPE;

82: CURSOR cur_cr_type_name(cp_n_cr_type_id igs_fi_cr_types.credit_type_id%TYPE) IS
83: SELECT credit_type_name
84: FROM igs_fi_cr_types
85: WHERE credit_type_id = cp_n_cr_type_id;
86: l_v_cr_type_name igs_fi_cr_types.credit_type_name%TYPE;
87:
88: BEGIN
89:
90: IF ( get_uk_for_validation (

Line 133: ELSIF NOT igs_fi_cr_types_pkg.get_pk_for_validation (

129:
130: IF (((old_references.credit_type_id = new_references.credit_type_id)) OR
131: ((new_references.credit_type_id IS NULL))) THEN
132: NULL;
133: ELSIF NOT igs_fi_cr_types_pkg.get_pk_for_validation (
134: new_references.credit_type_id
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;

Line 218: -- Removed get_fk_igs_fi_cr_types_all as deletion is not allowed on IGS_FI_CR_TYPES_ALL Table

214:
215: END get_uk_for_validation ;
216:
217: -- Removed get_fk_igs_fi_lockboxes as Deletion is not allowed in IGS_FI_LOCKBOXES Table
218: -- Removed get_fk_igs_fi_cr_types_all as deletion is not allowed on IGS_FI_CR_TYPES_ALL Table
219:
220: PROCEDURE before_dml (
221: p_action IN VARCHAR2,
222: x_rowid IN VARCHAR2,