The following lines contain the word 'select', 'insert', 'update' or 'delete':
The parameter FELONY_CONVICTED_FLAG is added in update_row procedure of igs_pe_hz_parties_pkg package.
mmkumar 18-JUL-2005 Party number impact, passed NULL for OSS_ORG_UNIT_CD in call to update_row of IGS_PE_HZ_PARTIES_PKG
**********************************************************************/
g_pkg_name CONSTANT VARCHAR2(30) := 'PE_INFO';
Purpose : To check if student has to update the latest information
x_result is an out NOCOPY variable which will indicate whether the information returned is TRUE or FALSE and does
the information needs to be verified.
This pe_info_verify was a function and is now made into a procedure and the boolean of the function will
be taken care in x_result.
If the x_return is TRUE taht means that the STUDENT needs to verify his information again.
Known Limitations,Enhancements or Remarks
Change History :
Who When What
ssawhney function converted to procedure
ssawhney 22-AUG-2002 Bug 2524217 : defaults removed in params, p_commit defaulted in spec.
pkpatel 25-FEB-2003 Bug 2750800 : Modified the Cursor cur_term_date for performance tuning
gmaheswa 14-Jul-2005 Bug 4327807 : Added logic for Hiding Verification page in self-service.
**********************************************************************/
AS
--Cursor to fetch the Min Load Calendar Start Date and Max Load Calendar End Date so that the student last verified date
--and also the Load Calendar is ACTIVE and the dates lie between the start and end dates
--can be checked to lie within the Load Calendar Dates
CURSOR cur_term_date IS
SELECT MAX(ci.start_dt)
FROM IGS_CA_INST_ALL ci,
IGS_CA_TYPE ct,
IGS_CA_STAT ca
WHERE ci.cal_type = ct.cal_type
AND ct.s_cal_cat = 'LOAD'
AND SYSDATE BETWEEN ci.start_dt AND ci.end_dt
AND ci.cal_status = ca.cal_status
AND ca.s_cal_status='ACTIVE';
SELECT pe_info_verify_time
FROM IGS_PE_HZ_PARTIES
WHERE party_id = p_person_id;
Purpose : To Update the Last Verified Date as
SYSDATE whenever Student Updates his/her latest info
Known Limitations,Enhancements or Remarks
Change History :
Who When What
ssawhney API standards implementation
ssawhney 22aug2002 Bug 2524217 : defaults removed in params, p_commit defaulted in spec.
pkpatel 25-OCT-2002 Bug No: 2613704
Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg
pkpatel 2-DEC-2002 Bug No: 2599109
Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg
**********************************************************************/
AS
--Cursor to fetch the Person ID from HZ Parties to update the Latest Verification Date
CURSOR cur_get_person IS
SELECT rowid,hz.*
FROM igs_pe_hz_parties hz
WHERE hz.party_id =p_person_id
FOR UPDATE OF hz.party_id NOWAIT;
igs_pe_hz_parties_pkg.update_row(
x_rowid =>l_cur_person.rowid,
x_party_id =>l_cur_person.party_id,
x_deceased_ind =>l_cur_person.deceased_ind,
x_archive_exclusion_ind =>l_cur_person.archive_exclusion_ind,
x_archive_dt =>l_cur_person.archive_dt,
x_purge_exclusion_ind =>l_cur_person.purge_exclusion_ind,
x_purge_dt =>l_cur_person.purge_dt,
x_oracle_username =>l_cur_person.oracle_username,
x_proof_of_ins =>l_cur_person.proof_of_ins,
x_proof_of_immu =>l_cur_person.proof_of_immu,
x_level_of_qual =>l_cur_person.level_of_qual ,
x_military_service_reg =>l_cur_person.military_service_reg ,
x_veteran =>l_cur_person.veteran ,
x_institution_cd =>l_cur_person.institution_cd,
x_oi_local_institution_ind =>l_cur_person.oi_local_institution_ind ,
x_oi_os_ind =>l_cur_person.oi_os_ind ,
x_oi_govt_institution_cd =>l_cur_person.oi_govt_institution_cd ,
x_oi_inst_control_type =>l_cur_person.oi_inst_control_type,
x_oi_institution_type =>l_cur_person.oi_institution_type ,
x_oi_institution_status =>l_cur_person.oi_institution_status ,
x_ou_start_dt =>l_cur_person.ou_start_dt ,
x_ou_end_dt =>l_cur_person.ou_end_dt ,
x_ou_member_type =>l_cur_person.ou_member_type ,
x_ou_org_status =>l_cur_person.ou_org_status ,
x_ou_org_type =>l_cur_person.ou_org_type ,
x_inst_org_ind =>l_cur_person.inst_org_ind ,
x_inst_priority_cd =>l_cur_person.inst_priority_cd ,
x_inst_eps_code =>l_cur_person.inst_eps_code ,
x_inst_phone_country_code =>l_cur_person.inst_phone_country_code ,
x_inst_phone_area_code =>l_cur_person.inst_phone_area_code,
x_inst_phone_number =>l_cur_person.inst_phone_number ,
x_adv_studies_classes =>l_cur_person.adv_studies_classes ,
x_honors_classes =>l_cur_person.honors_classes ,
x_class_size =>l_cur_person.class_size ,
x_sec_school_location_id =>l_cur_person.sec_school_location_id ,
x_percent_plan_higher_edu =>l_cur_person.percent_plan_higher_edu ,
x_fund_authorization =>l_cur_person.fund_authorization ,
x_pe_info_verify_time =>TRUNC(SYSDATE) ,
x_birth_city =>l_cur_person.birth_city ,
x_birth_country =>l_cur_person.birth_country ,
x_oss_org_unit_cd => NULL,
x_felony_convicted_flag =>l_cur_person.felony_convicted_flag ,
x_mode =>'R'
);