APPS.IGS_PR_GEN_006 dependencies on IGS_PE_PERSENC_EFFCT_PKG

Line 3307: igs_pe_persenc_effct_pkg.update_row(

3303: p_local_message_text := v_message_text;
3304: p_local_message_level := v_message_level;
3305: END IF;
3306: END IF;
3307: igs_pe_persenc_effct_pkg.update_row(
3308: X_ROWID => v_pee_rec.ROWID,
3309: X_PERSON_ID => v_pee_rec.PERSON_ID,
3310: X_ENCUMBRANCE_TYPE => v_pee_rec.ENCUMBRANCE_TYPE,
3311: X_PEN_START_DT => v_pee_rec.PEN_START_DT,

Line 3677: IGS_PE_PERSENC_EFFCT_PKG.UPDATE_ROW(

3673: X_EXPIRY_DT => gcst_sysdatetime,--gjha1
3674: X_MODE => 'R'
3675: );
3676: END LOOP; -- c_pur
3677: IGS_PE_PERSENC_EFFCT_PKG.UPDATE_ROW(
3678: X_ROWID => v_pee_rec.ROWID,
3679: X_PERSON_ID => v_pee_rec.PERSON_ID,
3680: X_ENCUMBRANCE_TYPE => v_pee_rec.ENCUMBRANCE_TYPE,
3681: X_PEN_START_DT => v_pee_rec.PEN_START_DT,

Line 3893: IGS_PE_PERSENC_EFFCT_PKG.UPDATE_ROW(

3889: cst_rstr_le_cp) AND
3890: NVL(v_pee_rec.restricted_enrolment_cp, -1) <>
3891: NVL(v_spo_rec.restricted_enrolment_cp, -1) THEN
3892:
3893: IGS_PE_PERSENC_EFFCT_PKG.UPDATE_ROW(
3894: X_ROWID => v_pee_rec.ROWID,
3895: X_PERSON_ID => v_pee_rec.PERSON_ID,
3896: X_ENCUMBRANCE_TYPE => v_pee_rec.ENCUMBRANCE_TYPE,
3897: X_PEN_START_DT => v_pee_rec.PEN_START_DT,

Line 3914: IGS_PE_PERSENC_EFFCT_PKG.UPDATE_ROW(

3910: NVL(v_pee_rec.restricted_attendance_type,'NULL') <>
3911: NVL(v_spo_rec.restricted_attendance_type,'NULL') AND
3912: v_spo_rec.closed_ind = 'N' THEN
3913:
3914: IGS_PE_PERSENC_EFFCT_PKG.UPDATE_ROW(
3915: X_ROWID => v_pee_rec.ROWID,
3916: X_PERSON_ID => v_pee_rec.PERSON_ID,
3917: X_ENCUMBRANCE_TYPE => v_pee_rec.ENCUMBRANCE_TYPE,
3918: X_PEN_START_DT => v_pee_rec.PEN_START_DT,

Line 4677: IGS_PE_PERSENC_EFFCT_pkg.INSERT_ROW (

4673: OPEN c_decode2;
4674: FETCH c_decode2 INTO v_decode_val2 ;
4675: CLOSE c_decode2;
4676:
4677: IGS_PE_PERSENC_EFFCT_pkg.INSERT_ROW (
4678: X_ROWID =>lv_rowid,
4679: X_PERSON_ID =>p_person_id,
4680: X_ENCUMBRANCE_TYPE =>v_spo_rec.encumbrance_type,
4681: X_PEN_START_DT=> gcst_sysdatetime, --gjha Changed it from gcst_sysdatetime --Modified by Prajeesh to sysdatetime