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_PE_STAT_PKG dependencies on IGS_PE_STAT_DETAILS

Line 14: --bayadav 31-Jan-2002 Added one DFF in IGS_PE_STAT_DETAILS and DFF columns in IGS_AD_STAT_INT table.

10: -- CDCRUZ Sep 24,2002 New Col's added for
11: -- Person DLD
12: -- Columns Added - MATR_CAL_TYPE/MATR_SEQUENCE_NUMBER/INIT_CAL_TYPE/INIT_SEQUENCE_NUMBER
13: -- RECENT_CAL_TYPE/RECENT_SEQUENCE_NUMBER/CATALOG_CAL_TYPE/CATALOG_SEQUENCE_NUMBER
14: --bayadav 31-Jan-2002 Added one DFF in IGS_PE_STAT_DETAILS and DFF columns in IGS_AD_STAT_INT table.
15: -- Due to which 1)Using the columns attribute1 to attribute20 parameters of this TBH
16: -- to transfer the data from IGS_AD_STAT_INT DFF columns to IGS_PE_STAT_DETAILS
17: -- DFF columns
18: -- 2)Changing the earlier use of these parameters attribute1 to attribute20 for HZ table to NULL .Bug number:2203778

Line 16: -- to transfer the data from IGS_AD_STAT_INT DFF columns to IGS_PE_STAT_DETAILS

12: -- Columns Added - MATR_CAL_TYPE/MATR_SEQUENCE_NUMBER/INIT_CAL_TYPE/INIT_SEQUENCE_NUMBER
13: -- RECENT_CAL_TYPE/RECENT_SEQUENCE_NUMBER/CATALOG_CAL_TYPE/CATALOG_SEQUENCE_NUMBER
14: --bayadav 31-Jan-2002 Added one DFF in IGS_PE_STAT_DETAILS and DFF columns in IGS_AD_STAT_INT table.
15: -- Due to which 1)Using the columns attribute1 to attribute20 parameters of this TBH
16: -- to transfer the data from IGS_AD_STAT_INT DFF columns to IGS_PE_STAT_DETAILS
17: -- DFF columns
18: -- 2)Changing the earlier use of these parameters attribute1 to attribute20 for HZ table to NULL .Bug number:2203778
19: --bayadav 6-Feb-2002 Removed seven columns from igs_pe_stat_details_pkg call as a aprt of bug:2203778
20: -- 1 Person_profile_id 2 acad_dismissal 3 non_acad_dismissal 4 resid_stat_id 5 criminal_convict 6 country_cd3 7 state_of_residence

Line 19: --bayadav 6-Feb-2002 Removed seven columns from igs_pe_stat_details_pkg call as a aprt of bug:2203778

15: -- Due to which 1)Using the columns attribute1 to attribute20 parameters of this TBH
16: -- to transfer the data from IGS_AD_STAT_INT DFF columns to IGS_PE_STAT_DETAILS
17: -- DFF columns
18: -- 2)Changing the earlier use of these parameters attribute1 to attribute20 for HZ table to NULL .Bug number:2203778
19: --bayadav 6-Feb-2002 Removed seven columns from igs_pe_stat_details_pkg call as a aprt of bug:2203778
20: -- 1 Person_profile_id 2 acad_dismissal 3 non_acad_dismissal 4 resid_stat_id 5 criminal_convict 6 country_cd3 7 state_of_residence
21: -- and added Person_id
22: ------------------------------------------------------------------
23:

Line 540: --bayadav 31-Jan-2002 Added one DFF in IGS_PE_STAT_DETAILS and DFF columns in IGS_AD_STAT_INT table.

536: Know limitations, enhancements or remarks
537: Change History
538: Who When What
539: --sbaliga 7-May-2002 Modified code as part of#2338473
540: --bayadav 31-Jan-2002 Added one DFF in IGS_PE_STAT_DETAILS and DFF columns in IGS_AD_STAT_INT table.
541: -- Due to which 1)Using the columns attribute1 to attribute20 parameters of this TBH
542: -- to transfer the data from IGS_AD_STAT_INT DFF columns to IGS_PE_STAT_DETAILS DFF columns
543: -- 2)Changing the earlier use of these parameters attribute1 to attribute20 for HZ table to NULL.Bug number:2203778
544: --pkpatel 27-JUN-2003 Bug 3019813(Made the Hz_Party_v2Pub.update_person call only while HZ related attrubures are modified)

Line 542: -- to transfer the data from IGS_AD_STAT_INT DFF columns to IGS_PE_STAT_DETAILS DFF columns

538: Who When What
539: --sbaliga 7-May-2002 Modified code as part of#2338473
540: --bayadav 31-Jan-2002 Added one DFF in IGS_PE_STAT_DETAILS and DFF columns in IGS_AD_STAT_INT table.
541: -- Due to which 1)Using the columns attribute1 to attribute20 parameters of this TBH
542: -- to transfer the data from IGS_AD_STAT_INT DFF columns to IGS_PE_STAT_DETAILS DFF columns
543: -- 2)Changing the earlier use of these parameters attribute1 to attribute20 for HZ table to NULL.Bug number:2203778
544: --pkpatel 27-JUN-2003 Bug 3019813(Made the Hz_Party_v2Pub.update_person call only while HZ related attrubures are modified)
545: svisweas 26-may-2000 get_fk_igs_lookups_view procedure from tbh.
546: (reverse chronological order - newest change first)

Line 705: Igs_Pe_Stat_Details_Pkg.insert_row (

701: -- removed this check as its always going to pass, so no use keeping it as
702: -- z_prof will never be same as x_per prof and x_per prof will always be null
703: -- IF Z_PROFILE_ID <> X_PERSON_PROFILE_ID OR X_PERSON_PROFILE_ID IS NULL THEN
704:
705: Igs_Pe_Stat_Details_Pkg.insert_row (
706: x_rowid => lvRowID,
707: x_person_id => X_PERSON_ID,
708: x_effective_start_date => x_effective_start_date,
709: x_effective_end_date => x_effective_end_date,

Line 854: --bayadav 31-Jan-2002 Added one DFF in IGS_PE_STAT_DETAILS and DFF columns in IGS_AD_STAT_INT table.

850: Know limitations, enhancements or remarks
851: Change History
852: Who When What
853: --sbaliga 7-May-2002 Added code as part of #2338473
854: --bayadav 31-Jan-2002 Added one DFF in IGS_PE_STAT_DETAILS and DFF columns in IGS_AD_STAT_INT table.
855: -- Due to which 1)Using the columns attribute1 to attribute20 parameters of this TBH
856: -- to transfer the data from IGS_AD_STAT_INT DFF columns to IGS_PE_STAT_DETAILS DFF columns
857: -- 2)Changing the earlier use of these parameters attribute1 to attribute20 for HZ table to NULL.Bug number:2203778
858: svisweas 26-may-2000 get_fk_igs_lookups_view procedure from tbh.

Line 856: -- to transfer the data from IGS_AD_STAT_INT DFF columns to IGS_PE_STAT_DETAILS DFF columns

852: Who When What
853: --sbaliga 7-May-2002 Added code as part of #2338473
854: --bayadav 31-Jan-2002 Added one DFF in IGS_PE_STAT_DETAILS and DFF columns in IGS_AD_STAT_INT table.
855: -- Due to which 1)Using the columns attribute1 to attribute20 parameters of this TBH
856: -- to transfer the data from IGS_AD_STAT_INT DFF columns to IGS_PE_STAT_DETAILS DFF columns
857: -- 2)Changing the earlier use of these parameters attribute1 to attribute20 for HZ table to NULL.Bug number:2203778
858: svisweas 26-may-2000 get_fk_igs_lookups_view procedure from tbh.
859: --pkpatel 27-JUN-2003 Bug 3019813(Made the Hz_Party_v2Pub.update_person call only while HZ related attrubures are modified)
860: (reverse chronological order - newest change first)

Line 888: FROM IGS_PE_STAT_DETAILS

884:
885:
886: CURSOR c_profile IS
887: SELECT rowid
888: FROM IGS_PE_STAT_DETAILS
889: WHERE person_id = X_PERSON_ID;
890:
891: profile_rec c_profile%ROWTYPE;
892: l_effective_Start_date DATE;

Line 1044: Igs_Pe_Stat_Details_Pkg.update_row (

1040: OPEN c_profile;
1041: FETCH c_profile INTO profile_rec;
1042: IF c_profile%FOUND THEN
1043:
1044: Igs_Pe_Stat_Details_Pkg.update_row (
1045: x_rowid => profile_rec.rowid, -- xxx_rowid,
1046: x_person_id => X_PERSON_ID,
1047: x_effective_start_date => NVL(x_effective_start_date, l_effective_start_date),
1048: x_effective_end_date => x_effective_end_date,

Line 1095: Igs_Pe_Stat_Details_Pkg.insert_row (

1091:
1092:
1093: XXX_rowid := NULL;
1094:
1095: Igs_Pe_Stat_Details_Pkg.insert_row (
1096: x_rowid => lvRowID,
1097: x_person_id => X_PERSON_ID,
1098: x_effective_start_date => NVL(x_effective_start_date, l_effective_start_date),
1099: x_effective_end_date => x_effective_end_date,