APPS.IGS_PR_GEN_006 dependencies on IGS_PR_OU_FND

Line 735: gv_err_ins_popf VARCHAR2(255); -- IGS_PR_OU_FND

731: gv_err_ins_pro VARCHAR2(255); -- IGS_PR_RU_OU
732: gv_err_ins_poc VARCHAR2(255); -- IGS_PR_OU_RS
733: gv_err_ins_pous VARCHAR2(255); -- IGS_PR_OU_UNIT_SET
734: gv_err_ins_popu VARCHAR2(255); -- IGS_PR_OU_UNIT
735: gv_err_ins_popf VARCHAR2(255); -- IGS_PR_OU_FND
736: gv_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;
737: BEGIN -- IGS_PR_ins_copy_pra
738: -- Copy a IGS_PR_RU_APPL structure. This is used when parent object
739: -- such as course versions are rolled over and need new generations of these

Line 793: FROM IGS_PR_OU_FND popf

789: -- Start of new code added as per the FA110 PR Enh. Bug# 2658550.
790: --
791: CURSOR c_popf IS
792: SELECT popf.fund_Code
793: FROM IGS_PR_OU_FND popf
794: WHERE popf.progression_rule_cat = p_progression_rule_cat AND
795: popf.pra_sequence_number = p_pra_sequence_number AND
796: popf.pro_sequence_number = p_pro_sequence_number;
797: --

Line 919: IGS_PR_OU_FND_PKG.INSERT_ROW (

915: BEGIN
916: DECLARE
917: lv_rowid VARCHAR2(25);
918: BEGIN
919: IGS_PR_OU_FND_PKG.INSERT_ROW (
920: X_ROWID => lv_rowid,
921: X_PROGRESSION_RULE_CAT =>p_progression_rule_cat,
922: X_PRA_SEQUENCE_NUMBER =>p_new_pra_sequence_number,
923: X_PRO_SEQUENCE_NUMBER =>p_new_pro_sequence_number,

Line 1375: gv_err_ins_popf := 'IGS_PR_OU_FND';

1371: gv_err_ins_pro := 'IGS_PR_RU_OU ';
1372: gv_err_ins_poc := 'IGS_PR_OU_RS ';
1373: gv_err_ins_pous := 'IGS_PR_OU_UNIT_SET ';
1374: gv_err_ins_popu := 'IGS_PR_OU_UNIT ';
1375: gv_err_ins_popf := 'IGS_PR_OU_FND';
1376: END IF;
1377: RETURN gv_new_pra_sequence_number;
1378: EXCEPTION
1379: WHEN OTHERS THEN

Line 2951: cp_fund_code igs_pr_ou_fnd.fund_code%TYPE,

2947: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,
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