APPS.IGS_PR_GEN_006 dependencies on IGS_PE_UNT_SET_EXCL_PKG

Line 3202: igs_pe_unt_set_excl_pkg.UPDATE_ROW(

3198: v_pen_rec.start_dt,
3199: v_pee_rec.s_encmb_effect_type,
3200: v_pee_rec.pee_start_dt,
3201: v_pee_rec.sequence_number) LOOP
3202: igs_pe_unt_set_excl_pkg.UPDATE_ROW(
3203: X_ROWID => v_puse_rec.ROWID,
3204: X_PERSON_ID => v_puse_rec.PERSON_ID,
3205: X_ENCUMBRANCE_TYPE => v_puse_rec.ENCUMBRANCE_TYPE,
3206: X_PEN_START_DT => v_puse_rec.PEN_START_DT,

Line 3589: igs_pe_unt_set_excl_pkg.UPDATE_ROW(

3585: v_pee_rec.pen_start_dt,
3586: v_pee_rec.s_encmb_effect_type,
3587: v_pee_rec.pee_start_dt,
3588: v_pee_rec.sequence_number) LOOP
3589: igs_pe_unt_set_excl_pkg.UPDATE_ROW(
3590: X_ROWID => v_puse_rec.ROWID,
3591: X_PERSON_ID => v_puse_rec.PERSON_ID,
3592: X_ENCUMBRANCE_TYPE => v_puse_rec.ENCUMBRANCE_TYPE,
3593: X_PEN_START_DT => v_puse_rec.PEN_START_DT,

Line 4180: igs_pe_unt_set_excl_pkg.UPDATE_ROW(

4176: END IF;
4177: END LOOP;
4178:
4179: IF NOT v_unit_set_found THEN
4180: igs_pe_unt_set_excl_pkg.UPDATE_ROW(
4181: X_ROWID => v_puse_rec.ROWID,
4182: X_PERSON_ID => v_puse_rec.PERSON_ID,
4183: X_ENCUMBRANCE_TYPE => v_puse_rec.ENCUMBRANCE_TYPE,
4184: X_PEN_START_DT => v_puse_rec.PEN_START_DT,

Line 4222: igs_pe_unt_set_excl_pkg.UPDATE_ROW(

4218: v_spus_table(v_index1).version_number,
4219: gcst_sysdate);
4220: FETCH c_puse_dup INTO v_puse_dup_rec;
4221: IF c_puse_dup%FOUND THEN
4222: igs_pe_unt_set_excl_pkg.UPDATE_ROW(
4223: X_ROWID => v_puse_dup_rec.ROWID,
4224: X_PERSON_ID => v_puse_dup_rec.PERSON_ID,
4225: X_ENCUMBRANCE_TYPE => v_puse_dup_rec.ENCUMBRANCE_TYPE,
4226: X_PEN_START_DT => v_puse_dup_rec.PEN_START_DT,

Line 4243: igs_pe_unt_set_excl_pkg.INSERT_ROW (

4239: CLOSE c_puse_dup;
4240: DECLARE
4241: lv_rowid VARCHAR2(25);
4242: BEGIN
4243: igs_pe_unt_set_excl_pkg.INSERT_ROW (
4244: X_ROWID =>lv_rowid,
4245: X_PERSON_ID =>p_person_id,
4246: X_ENCUMBRANCE_TYPE=> v_pee_rec.encumbrance_type,
4247: X_PEN_START_DT=> v_pee_rec.pen_start_dt,

Line 4742: igs_pe_unt_set_excl_pkg.INSERT_ROW (

4738: FOR v_spus_rec IN c_spus LOOP
4739: DECLARE
4740: lv_rowid VARCHAR2(25);
4741: BEGIN
4742: igs_pe_unt_set_excl_pkg.INSERT_ROW (
4743: X_ROWID =>lv_rowid,
4744: X_PERSON_ID =>p_person_id,
4745: X_ENCUMBRANCE_TYPE=> v_spo_rec.encumbrance_type,
4746: X_PEN_START_DT=> gcst_sysdatetime, --gjha Changed it from sysdatetime --modified by Prajeesh