APPS.IGS_EN_GEN_003 dependencies on IGS_PE_STAT_DETAILS

Line 9: has been transferred to lookups so new columns are added in igs_pe_stat_details table

5: pkpatel 26-MAR-2003 Bug 2261717
6: Tuned functions Enrp_Get_Encmbrd_Ind,
7: npalanis 11-SEP-2002 Bug - 2608360
8: the pe code classes for religion , soci eco status and further education
9: has been transferred to lookups so new columns are added in igs_pe_stat_details table
10: to store codes therefore the tbh calls is modified.
11: ssawhney 30-APR V2API OVN change, igs_pe_stat_pkg signature modified.
12:
13: */

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 833: FROM IGS_PE_STAT_DETAILS

829: ATTRIBUTE17,
830: ATTRIBUTE18,
831: ATTRIBUTE19,
832: ATTRIBUTE20
833: FROM IGS_PE_STAT_DETAILS
834: WHERE person_id = cp_person_id;
835: lv_psd_rec c_psd%ROWTYPE;
836:
837:

Line 841: --If for the person corresponding record does not exist in IGS_PE_STAT_DETAILS table then create a record in IGS_PE_STAT_DETAILS table

837:
838:
839:
840: BEGIN
841: --If for the person corresponding record does not exist in IGS_PE_STAT_DETAILS table then create a record in IGS_PE_STAT_DETAILS table
842: OPEN c_psd(p_person_id);
843: Fetch c_psd INTO lv_psd_rec;
844: IF c_psd%FOUND then
845: CLOSE c_psd;

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 935: --update the catalog fields of the IGS_PE_STAT_DETAILS with the values fetched above beside updating the matricualtion fields also

931: OPEN c_psd(p_person_id);
932: FETCH c_psd into lv_psd_rec;
933: IF lv_profile_cat_cd = 'MATRICULATION' THEN
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,

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,