DBA Data[Home] [Help]

APPS.IGS_PR_GEN_006 dependencies on IGS_PE_FUND_EXCL_PKG

Line 3269: igs_pe_fund_excl_pkg.update_row(

3265: v_pen_rec.start_dt,
3266: v_pee_rec.s_encmb_effect_type,
3267: v_pee_rec.pee_start_dt,
3268: v_pee_rec.sequence_number) LOOP
3269: igs_pe_fund_excl_pkg.update_row(
3270: X_ROWID => v_pur_rec.rowid ,
3271: X_FUND_EXCL_ID => v_pur_rec.fund_excl_id ,
3272: X_PERSON_ID => v_pur_rec.person_id ,
3273: X_ENCUMBRANCE_TYPE => v_pur_rec.encumbrance_type ,

Line 3634: igs_pe_fund_excl_pkg.update_row(

3630: v_pee_rec.pen_start_dt,
3631: v_pee_rec.s_encmb_effect_type,
3632: v_pee_rec.pee_start_dt,
3633: v_pee_rec.sequence_number) LOOP
3634: igs_pe_fund_excl_pkg.update_row(
3635: X_ROWID => v_pfe_rec.rowid ,
3636: X_FUND_EXCL_ID => v_pfe_rec.fund_excl_id ,
3637: X_PERSON_ID => v_pfe_rec.person_id ,
3638: X_ENCUMBRANCE_TYPE => v_pfe_rec.encumbrance_type ,

Line 4490: igs_pe_fund_excl_pkg.update_row(

4486: EXIT;
4487: END IF;
4488: END LOOP;
4489: IF NOT v_fund_cd_found THEN
4490: igs_pe_fund_excl_pkg.update_row(
4491: X_ROWID => v_pfe_rec.rowid ,
4492: X_FUND_EXCL_ID => v_pfe_rec.fund_excl_id ,
4493: X_PERSON_ID => v_pfe_rec.person_id ,
4494: X_ENCUMBRANCE_TYPE => v_pfe_rec.encumbrance_type ,

Line 4528: igs_pe_fund_excl_pkg.update_row(

4524: gcst_sysdate);
4525: FETCH c_pfe_dup INTO v_pfe_dup_rec;
4526:
4527: IF c_pfe_dup%FOUND THEN
4528: igs_pe_fund_excl_pkg.update_row(
4529: X_ROWID => v_pfe_dup_rec.rowid ,
4530: X_FUND_EXCL_ID => v_pfe_dup_rec.fund_excl_id ,
4531: X_PERSON_ID => v_pfe_dup_rec.person_id ,
4532: X_ENCUMBRANCE_TYPE => v_pfe_dup_rec.encumbrance_type ,

Line 4548: igs_pe_fund_excl_pkg.insert_row (

4544: DECLARE
4545: l_rowid VARCHAR2(25);
4546: l_fund_excl_id igs_pe_fund_excl.fund_excl_id%TYPE;
4547: BEGIN
4548: igs_pe_fund_excl_pkg.insert_row (
4549: X_ROWID => l_rowid,
4550: X_FUND_EXCL_ID => l_fund_excl_id,
4551: X_PERSON_ID => p_person_id,
4552: X_ENCUMBRANCE_TYPE => v_pee_rec.encumbrance_type,

Line 4807: igs_pe_fund_excl_pkg.insert_row (

4803: DECLARE
4804: l_rowid VARCHAR2(25);
4805: l_fund_excl_id igs_pe_fund_excl.fund_excl_id%TYPE;
4806: BEGIN
4807: igs_pe_fund_excl_pkg.insert_row (
4808: X_ROWID => l_rowid,
4809: X_FUND_EXCL_ID => l_fund_excl_id,
4810: X_PERSON_ID => p_person_id,
4811: X_ENCUMBRANCE_TYPE => v_spo_rec.encumbrance_type,