APPS.IGS_PR_GEN_006 dependencies on IGS_PE_PERS_UNT_EXCL_PKG

Line 3225: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(

3221: v_pen_rec.start_dt,
3222: v_pee_rec.s_encmb_effect_type,
3223: v_pee_rec.pee_start_dt,
3224: v_pee_rec.sequence_number) LOOP
3225: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(
3226: X_ROWID => v_pue_rec.ROWID,
3227: X_PERSON_ID => v_pue_rec.PERSON_ID,
3228: X_ENCUMBRANCE_TYPE => v_pue_rec.ENCUMBRANCE_TYPE,
3229: X_PEN_START_DT => v_pue_rec.PEN_START_DT,

Line 3611: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(

3607: v_pee_rec.pen_start_dt,
3608: v_pee_rec.s_encmb_effect_type,
3609: v_pee_rec.pee_start_dt,
3610: v_pee_rec.sequence_number) LOOP
3611: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(
3612: X_ROWID => v_pue_rec.ROWID,
3613: X_PERSON_ID => v_pue_rec.PERSON_ID,
3614: X_ENCUMBRANCE_TYPE => v_pue_rec.ENCUMBRANCE_TYPE,
3615: X_PEN_START_DT => v_pue_rec.PEN_START_DT,

Line 4287: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(

4283: EXIT;
4284: END IF;
4285: END LOOP;
4286: IF NOT v_unit_cd_found THEN
4287: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(
4288: X_ROWID => v_pue_rec.ROWID,
4289: X_PERSON_ID => v_pue_rec.PERSON_ID,
4290: X_ENCUMBRANCE_TYPE => v_pue_rec.ENCUMBRANCE_TYPE,
4291: X_PEN_START_DT => v_pue_rec.PEN_START_DT,

Line 4324: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(

4320: v_spu_table(v_index1),
4321: gcst_sysdate);
4322: FETCH c_pue_dup INTO v_pue_dup_rec;
4323: IF c_pue_dup%FOUND THEN
4324: igs_pe_pers_unt_excl_pkg.UPDATE_ROW(
4325: X_ROWID => v_pue_dup_rec.ROWID,
4326: X_PERSON_ID => v_pue_dup_rec.PERSON_ID,
4327: X_ENCUMBRANCE_TYPE => v_pue_dup_rec.ENCUMBRANCE_TYPE,
4328: X_PEN_START_DT => v_pue_dup_rec.PEN_START_DT,

Line 4343: igs_pe_pers_unt_excl_PKG.INSERT_ROW (

4339: CLOSE c_pue_dup;
4340: DECLARE
4341: LV_ROWID VARCHAR2(25);
4342: BEGIN
4343: igs_pe_pers_unt_excl_PKG.INSERT_ROW (
4344: X_ROWID =>LV_ROWID,
4345: X_PERSON_ID =>p_person_id,
4346: X_ENCUMBRANCE_TYPE =>v_pee_rec.encumbrance_type,
4347: X_PEN_START_DT =>v_pee_rec.pen_start_dt,

Line 4763: igs_pe_pers_unt_excl_PKG.INSERT_ROW (

4759: FOR v_spu_rec IN c_spu (cst_excluded) LOOP
4760: DECLARE
4761: LV_ROWID VARCHAR2(25);
4762: BEGIN
4763: igs_pe_pers_unt_excl_PKG.INSERT_ROW (
4764: X_ROWID =>LV_ROWID,
4765: X_PERSON_ID =>p_person_id,
4766: X_ENCUMBRANCE_TYPE =>v_spo_rec.encumbrance_type,
4767: X_PEN_START_DT =>gcst_sysdatetime, --gjha Changed it from sysdatetime --Modified by Prajeesh