eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_GEN_006 dependencies on IGS_PE_FUND_EXCL

Line 2929: FROM igs_pe_fund_excl pfe

2925: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,
2926: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,
2927: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE) IS
2928: SELECT pfe.*, pfe.rowid
2929: FROM igs_pe_fund_excl pfe
2930: WHERE pfe.person_id = p_person_id AND
2931: pfe.encumbrance_type = cp_encumbrance_type AND
2932: pfe.pen_start_dt = cp_pen_start_dt AND
2933: pfe.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 2940: TYPE t_pfe_table IS TABLE OF igs_pe_fund_excl.fund_code%TYPE

2936: (pfe.expiry_dt IS NULL OR
2937: pfe.expiry_dt > gcst_sysdate)
2938: FOR UPDATE NOWAIT;
2939:
2940: TYPE t_pfe_table IS TABLE OF igs_pe_fund_excl.fund_code%TYPE
2941: INDEX BY BINARY_INTEGER;
2942: v_pfe_table t_pfe_table;
2943: v_pfe_index BINARY_INTEGER;
2944:

Line 2952: cp_pfe_start_dt igs_pe_fund_excl.pfe_start_dt%TYPE ) IS

2948: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,
2949: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,
2950: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE,
2951: cp_fund_code igs_pr_ou_fnd.fund_code%TYPE,
2952: cp_pfe_start_dt igs_pe_fund_excl.pfe_start_dt%TYPE ) IS
2953: SELECT pfe.*, pfe.ROWID
2954: FROM igs_pe_fund_excl pfe
2955: WHERE pfe.person_id = p_person_id AND
2956: pfe.encumbrance_type = cp_encumbrance_type AND

Line 2954: FROM igs_pe_fund_excl pfe

2950: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE,
2951: cp_fund_code igs_pr_ou_fnd.fund_code%TYPE,
2952: cp_pfe_start_dt igs_pe_fund_excl.pfe_start_dt%TYPE ) IS
2953: SELECT pfe.*, pfe.ROWID
2954: FROM igs_pe_fund_excl pfe
2955: WHERE pfe.person_id = p_person_id AND
2956: pfe.encumbrance_type = cp_encumbrance_type AND
2957: pfe.pen_start_dt = cp_pen_start_dt AND
2958: pfe.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3134: FROM igs_pe_fund_excl pfe

3130: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3131: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3132: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3133: SELECT pfe.*, pfe.ROWID
3134: FROM igs_pe_fund_excl pfe
3135: WHERE pfe.person_id = p_person_id AND
3136: pfe.encumbrance_type = cp_encumbrance_type AND
3137: pfe.pen_start_dt = cp_pen_start_dt AND
3138: pfe.s_encmb_effect_type = cp_s_encmb_effect_type AND

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 3526: FROM IGS_PE_FUND_EXCL pfe

3522: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3523: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3524: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3525: SELECT pfe.*, pfe.ROWID
3526: FROM IGS_PE_FUND_EXCL pfe
3527: WHERE pfe.person_id = p_person_id AND
3528: pfe.encumbrance_type = cp_encumbrance_type AND
3529: pfe.pen_start_dt = cp_pen_start_dt AND
3530: pfe.s_encmb_effect_type = cp_s_encmb_effect_type AND

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 4546: l_fund_excl_id igs_pe_fund_excl.fund_excl_id%TYPE;

4542: ELSE
4543: CLOSE c_pfe_dup;
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,

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 4805: l_fund_excl_id igs_pe_fund_excl.fund_excl_id%TYPE;

4801: ELSIF v_etde_table(v_index1).s_encmb_effect_type IN (cst_exc_sp_awd, cst_exc_sp_disb)THEN
4802: FOR v_spf_rec IN c_spf LOOP
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,

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,