APPS.IGS_EN_VAL_PEN dependencies on IGS_PE_PERS_ENCUMB

Line 116: v_psn_encmb_rec IGS_PE_PERS_ENCUMB%ROWTYPE;

112: p_message_name OUT NOCOPY VARCHAR2)
113: RETURN BOOLEAN AS
114: BEGIN
115: DECLARE
116: v_psn_encmb_rec IGS_PE_PERS_ENCUMB%ROWTYPE;
117: v_encmb_type_rec IGS_FI_ENCMB_TYPE%ROWTYPE;
118: CURSOR c_psn_encmb_rec (
119: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,
120: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

Line 119: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,

115: DECLARE
116: v_psn_encmb_rec IGS_PE_PERS_ENCUMB%ROWTYPE;
117: v_encmb_type_rec IGS_FI_ENCMB_TYPE%ROWTYPE;
118: CURSOR c_psn_encmb_rec (
119: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,
120: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
121: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE) IS
122: SELECT *
123: FROM IGS_PE_PERS_ENCUMB

Line 120: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,

116: v_psn_encmb_rec IGS_PE_PERS_ENCUMB%ROWTYPE;
117: v_encmb_type_rec IGS_FI_ENCMB_TYPE%ROWTYPE;
118: CURSOR c_psn_encmb_rec (
119: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,
120: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
121: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE) IS
122: SELECT *
123: FROM IGS_PE_PERS_ENCUMB
124: WHERE person_id = cp_person_id AND

Line 121: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE) IS

117: v_encmb_type_rec IGS_FI_ENCMB_TYPE%ROWTYPE;
118: CURSOR c_psn_encmb_rec (
119: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,
120: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
121: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE) IS
122: SELECT *
123: FROM IGS_PE_PERS_ENCUMB
124: WHERE person_id = cp_person_id AND
125: encumbrance_type = cp_encumbrance_type AND

Line 123: FROM IGS_PE_PERS_ENCUMB

119: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,
120: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
121: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE) IS
122: SELECT *
123: FROM IGS_PE_PERS_ENCUMB
124: WHERE person_id = cp_person_id AND
125: encumbrance_type = cp_encumbrance_type AND
126: start_dt <> cp_start_dt AND
127: expiry_dt IS NULL;

Line 136: -- 'open ended' IGS_PE_PERS_ENCUMB records for

132: WHERE encumbrance_type = cp_encumbrance_type AND
133: s_encumbrance_cat = 'ADMIN';
134: BEGIN
135: -- This module checks if there are no other
136: -- 'open ended' IGS_PE_PERS_ENCUMB records for
137: -- the nominated encumbrance type.
138: p_message_name := null;
139: OPEN c_encmb_type_rec(p_encumbrance_type);
140: FETCH c_encmb_type_rec INTO v_encmb_type_rec;