APPS.IGS_EN_GEN_003 dependencies on IGS_PE_STAT_DETAILS_PKG

Line 723: --Removed columns from igs_pe_stat_details_pkg call as a part of bug number 2203778

719: --Procedure added as a part of self service setup DLD to set values of matriculation term,
720: --recent admittance term and catalog terms based on the profile values setup for the passed person
721: --as a part of enh bug 2043044
722:
723: --Removed columns from igs_pe_stat_details_pkg call as a part of bug number 2203778
724:
725: PROCEDURE UPD_MAT_MRADM_CAT_TERMS(
726: p_person_id IN NUMBER,
727: p_program_cd IN VARCHAR2,

Line 847: Igs_Pe_Stat_Details_Pkg.Insert_Row (

843: Fetch c_psd INTO lv_psd_rec;
844: IF c_psd%FOUND then
845: CLOSE c_psd;
846: ELSE
847: Igs_Pe_Stat_Details_Pkg.Insert_Row (
848: x_rowid => lv_rowid,
849: x_person_id => p_person_id,
850: x_effective_start_date => SYSDATE,
851: x_effective_end_date => NULL,

Line 938: Igs_Pe_Stat_Details_Pkg.update_row (

934: --If matriculation term is present and catalog profile option is MATRICULATION TERM then
935: --update the catalog fields of the IGS_PE_STAT_DETAILS with the values fetched above beside updating the matricualtion fields also
936:
937:
938: Igs_Pe_Stat_Details_Pkg.update_row (
939: x_rowid => lv_psd_rec.rowid,
940: x_person_id => lv_psd_rec.person_id ,
941: x_effective_start_date => lv_psd_rec.effective_start_date,
942: x_effective_end_date => lv_psd_rec.effective_end_date,

Line 983: Igs_Pe_Stat_Details_Pkg.update_row (

979: X_ATTRIBUTE20 => lv_psd_rec.ATTRIBUTE20);
980:
981: ELSE
982: --Just updating the matriculation fields
983: Igs_Pe_Stat_Details_Pkg.update_row (
984: x_rowid => lv_psd_rec.rowid,
985: x_person_id => lv_psd_rec.person_id ,
986: x_effective_start_date => lv_psd_rec.effective_start_date,
987: x_effective_end_date => lv_psd_rec.effective_end_date,

Line 1052: Igs_Pe_Stat_Details_Pkg.update_row (

1048:
1049: IF lv_profile_cat_cd = 'MR_ADM_TERM' THEN
1050: --Updating the catalog fields also alongwith recent admittacne term fields
1051: --if recent admittance term is present and catalog prfile is set to Recent admittance term
1052: Igs_Pe_Stat_Details_Pkg.update_row (
1053: x_rowid => lv_psd_rec.rowid,
1054: x_person_id => lv_psd_rec.person_id ,
1055: x_effective_start_date => lv_psd_rec.effective_start_date,
1056: x_effective_end_date => lv_psd_rec.effective_end_date,

Line 1097: Igs_Pe_Stat_Details_Pkg.update_row (

1093: X_ATTRIBUTE20 => lv_psd_rec.ATTRIBUTE20);
1094:
1095: ELSE
1096: --only update the recent admittance fields
1097: Igs_Pe_Stat_Details_Pkg.update_row (
1098: x_rowid => lv_psd_rec.rowid,
1099: x_person_id => lv_psd_rec.person_id ,
1100: x_effective_start_date => lv_psd_rec.effective_start_date,
1101: x_effective_end_date => lv_psd_rec.effective_end_date,