[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_education_id OUT NOCOPY NUMBER,
x_person_id IN NUMBER,
x_current_inst IN VARCHAR2,
x_degree_attempted IN VARCHAR2,
x_program_code IN VARCHAR2,
x_degree_earned IN VARCHAR2,
x_comments IN VARCHAR2,
x_start_date IN DATE,
x_end_date IN DATE,
x_planned_completion_date IN DATE,
x_recalc_total_cp_attempted IN NUMBER,
x_recalc_total_cp_earned IN NUMBER,
x_recalc_total_unit_gp IN NUMBER,
x_recalc_tot_gpa_units_attemp IN NUMBER,
x_recalc_inst_gpa IN VARCHAR2,
x_recalc_grading_scale_id IN NUMBER,
x_selfrep_total_cp_attempted IN NUMBER,
x_selfrep_total_cp_earned IN NUMBER,
x_selfrep_total_unit_gp IN NUMBER,
X_selfrep_tot_gpa_uts_attemp IN NUMBER,
x_selfrep_inst_gpa IN VARCHAR2,
x_selfrep_grading_scale_id IN NUMBER,
x_selfrep_weighted_gpa IN VARCHAR2,
x_selfrep_rank_in_class IN NUMBER,
x_selfrep_weighed_rank IN VARCHAR2,
x_type_of_school IN VARCHAR2,
x_institution_code IN VARCHAR2,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_selfrep_class_size IN NUMBER DEFAULT NULL,
x_transcript_required IN VARCHAR2 DEFAULT NULL,
x_school_party_id IN NUMBER,
x_status IN VARCHAR2,
x_object_version_number OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_mode IN VARCHAR2 ,
x_school_attended_name IN VARCHAR2 DEFAULT NULL,
x_program_type_attempted IN VARCHAR2 ,
x_program_type_earned IN VARCHAR2
)
AS
l_education_rec HZ_PERSON_INFO_V2PUB.EDUCATION_REC_TYPE;
SELECT party_id
FROM igs_pe_hz_parties
WHERE oss_org_unit_cd = p_party_number;
SELECT party_name
FROM hz_parties hz, igs_pe_hz_parties php
WHERE php.oss_org_unit_cd = p_party_number
AND php.party_id = hz.party_id ;
SELECT dg.degree_cd
FROM igs_ps_degrees dg,
igs_ps_type_all ps
WHERE dg.degree_cd = p_degree
AND dg.closed_ind ='N'
AND dg.program_type = ps.course_type;
SELECT birth_date
FROM igs_pe_person_base_v
WHERE person_id = p_person_id;
|| Purpose : Handles the INSERT DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| samaresh.in 20-NOV-2001 Added a Check to see if
|| current institution already exists
|| for the person id
|| vdixit.in 23-JULY-2001 Added new column transcript_required
|| to the tbh calls
|| pkpatel 30-Jun-2005 Bug 4327807 (Person SS Enhancement)
|| Removed the check for single current institution. Multiple current institutions will be allowed.
|| Removed the cursor to get the object version number. In insert its not needed.
*/
BEGIN
l_mode := NVL(x_mode ,'R');
Igs_Ad_Hz_Acad_Hist_Pkg.Insert_Row
( X_ROWID => l_RowId,
X_RECALC_TOTAL_CP_ATTEMPTED => X_RECALC_TOTAL_CP_ATTEMPTED,
X_RECALC_TOTAL_CP_EARNED => X_RECALC_TOTAL_CP_EARNED,
X_RECALC_TOTAL_UNIT_GP => X_RECALC_TOTAL_UNIT_GP,
X_RECALC_TOT_GPA_UTS_ATTEMPTED => x_recalc_tot_gpa_units_attemp,
X_RECALC_INST_GPA => X_RECALC_INST_GPA,
X_RECALC_GRADING_SCALE_ID => X_RECALC_GRADING_SCALE_ID,
X_SELFREP_TOTAL_CP_ATTEMPTED => X_SELFREP_TOTAL_CP_ATTEMPTED,
X_SELFREP_TOTAL_CP_EARNED => X_SELFREP_TOTAL_CP_EARNED,
X_SELFREP_TOTAL_UNIT_GP => X_SELFREP_TOTAL_UNIT_GP,
X_SELFREP_TOT_GPA_UTS_ATTEMP => X_SELFREP_TOT_GPA_UTS_ATTEMP,
X_SELFREP_INST_GPA => X_SELFREP_INST_GPA,
X_SELFREP_GRADING_SCALE_ID => X_SELFREP_GRADING_SCALE_ID,
X_SELFREP_WEIGHTED_GPA => X_SELFREP_WEIGHTED_GPA,
X_SELFREP_RANK_IN_CLASS => X_SELFREP_RANK_IN_CLASS,
X_SELFREP_WEIGHED_RANK => X_SELFREP_WEIGHED_RANK,
X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
X_SELFREP_CLASS_SIZE => X_SELFREP_CLASS_SIZE,
X_ATTRIBUTE1 => X_ATTRIBUTE1,
X_ATTRIBUTE2 => X_ATTRIBUTE2,
X_ATTRIBUTE3 => X_ATTRIBUTE3,
X_ATTRIBUTE4 => X_ATTRIBUTE4,
X_ATTRIBUTE5 => X_ATTRIBUTE5,
X_ATTRIBUTE6 => X_ATTRIBUTE6,
X_ATTRIBUTE7 => X_ATTRIBUTE7,
X_ATTRIBUTE8 => X_ATTRIBUTE8,
X_ATTRIBUTE9 => X_ATTRIBUTE9,
X_ATTRIBUTE10 => X_ATTRIBUTE10,
X_ATTRIBUTE11 => X_ATTRIBUTE11,
X_ATTRIBUTE12 => X_ATTRIBUTE12,
X_ATTRIBUTE13 => X_ATTRIBUTE13,
X_ATTRIBUTE14 => X_ATTRIBUTE14,
X_ATTRIBUTE15 => X_ATTRIBUTE15,
X_ATTRIBUTE16 => X_ATTRIBUTE16,
X_ATTRIBUTE17 => X_ATTRIBUTE17,
X_ATTRIBUTE18 => X_ATTRIBUTE18,
X_ATTRIBUTE19 => X_ATTRIBUTE19,
X_ATTRIBUTE20 => X_ATTRIBUTE20,
X_HZ_ACAD_HIST_ID => lv_Hz_Acad_Hist_Id,
X_EDUCATION_ID => lv_Education_Id,
X_CURRENT_INST => X_CURRENT_INST,
X_DEGREE_ATTEMPTED => X_DEGREE_ATTEMPTED,
X_COMMENTS => X_COMMENTS,
X_PLANNED_COMPLETION_DATE => X_PLANNED_COMPLETION_DATE,
X_TRANSCRIPT_REQUIRED => X_TRANSCRIPT_REQUIRED ,
X_MODE => 'R');
END insert_row;
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_education_id IN NUMBER,
x_person_id IN NUMBER,
x_current_inst IN VARCHAR2,
x_degree_attempted IN VARCHAR2,
x_program_code IN VARCHAR2,
x_degree_earned IN VARCHAR2,
x_comments IN VARCHAR2,
x_start_date IN DATE,
x_end_date IN DATE,
x_planned_completion_date IN DATE,
x_recalc_total_cp_attempted IN NUMBER,
x_recalc_total_cp_earned IN NUMBER,
x_recalc_total_unit_gp IN NUMBER,
x_recalc_tot_gpa_units_attemp IN NUMBER,
x_recalc_inst_gpa IN VARCHAR2,
x_recalc_grading_scale_id IN NUMBER,
x_selfrep_total_cp_attempted IN NUMBER,
x_selfrep_total_cp_earned IN NUMBER,
x_selfrep_total_unit_gp IN NUMBER,
x_selfrep_tot_gpa_uts_attemp IN NUMBER,
x_selfrep_inst_gpa IN VARCHAR2,
x_selfrep_grading_scale_id IN NUMBER,
x_selfrep_weighted_gpa IN VARCHAR2,
x_selfrep_rank_in_class IN NUMBER,
x_selfrep_weighed_rank IN VARCHAR2,
x_type_of_school IN VARCHAR2,
x_institution_code IN VARCHAR2,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_selfrep_class_size IN NUMBER DEFAULT NULL,
x_transcript_required IN VARCHAR2 DEFAULT NULL,
x_school_party_id IN NUMBER,
x_status IN VARCHAR2,
x_object_version_number IN OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_mode IN VARCHAR2 ,
x_school_attended_name IN VARCHAR2 DEFAULT NULL,
x_program_type_attempted IN VARCHAR2 ,
x_program_type_earned IN VARCHAR2
) AS
/*
|| Created By : [email protected]
|| Created On : 07-SEP-2000
|| Purpose : Handles the UPDATE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
||
|| apadegal.in 10-Jun-2005 Modified the validation logic for
|| UK Degree Earned and Degree Attempted
||
|| samaresh.in 20-NOV-2001 Added a Check to see if
|| current institution already exists
|| for the person id
|| vdixit.in 23-JULY-2001 Added new column transcript_required
|| to the tbh calls
|| pkpatel 30-Jun-2005 Bug 4327807 (Person SS Enhancement)
|| Removed the check for single current institution. Multiple current institutions will be allowed.
|| Removed the cursor to get the Created_By_Module. In update no need to pass it.
||
*/
l_education_rec hz_person_info_v2pub.education_rec_type;
SELECT status,TRANSCRIPT_REQUIRED from IGS_AD_ACAD_HISTORY_V
WHERE row_id = cp_rowid;
SELECT ROWID, HZ_ACAD_HIST_ID
FROM IGS_AD_HZ_ACAD_HIST
WHERE EDUCATION_ID = x_Education_Id;
SELECT party_id
FROM igs_pe_hz_parties
WHERE oss_org_unit_cd = p_party_number;
SELECT party_name
FROM hz_parties hz, igs_pe_hz_parties php
WHERE php.oss_org_unit_cd = p_party_number
AND php.party_id = hz.party_id ;
SELECT '1'
FROM igs_av_adv_standing
WHERE person_id = p_person_id
AND exemption_institution_cd = p_party_number;
SELECT dg.degree_cd
FROM igs_ps_degrees dg
WHERE dg.degree_cd = p_degree
AND dg.closed_ind ='N'
AND dg.program_type IS NOT NULL;
SELECT degree_attempted, degree_earned, program_code
FROM IGS_AD_ACAD_HISTORY_V ach
WHERE ach.education_id = x_education_id;
SELECT birth_date
FROM igs_pe_person_base_v
WHERE person_id = p_person_id;
SELECT DISTINCT 1
FROM igs_ad_transcript_v trans, igs_ad_code_classes code
WHERE trans.transcript_source = code.code_id
AND trans.education_id = p_education_id
AND code.class = 'TRANSCRIPT_SOURCE'
AND code.class_type_code = 'ADM_CODE_CLASSES'
AND code.system_status = 'THIRD_PARTY_TRANSFER_EVAL';
hz_person_info_v2pub.Update_education(
p_init_msg_list => FND_API.G_TRUE,
p_education_rec => l_education_rec,
p_object_version_number => x_object_version_number,
x_return_status => lv_return_status,
x_msg_count => lv_msg_count,
x_msg_data => lv_msg_data );
END update_row;