[Home] [Help]
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:
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,
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,
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,