[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT WIDTH , precision , column_type
FROM FND_COLUMNS
WHERE table_id IN
(SELECT TABLE_ID
FROM FND_TABLES
WHERE table_name = p_table_name AND APPLICATION_ID = 8405)
AND column_name = p_param_name
AND APPLICATION_ID = 8405;
SELECT rowid row_id, appl_pgmapprv_id
FROM Igs_Ad_Appl_Pgmapprv a
WHERE person_id = p_person_id
AND admission_appl_number = p_admission_appl_number
AND nominated_course_cd = p_nominated_program_cd
AND sequence_number = p_sequence_number
AND pgm_approver_id = p_pgm_approver_id ;
Igs_Ad_Appl_Pgmapprv_Pkg.Insert_Row (
X_ROWID => lv_rowid,
x_APPL_PGMAPPRV_ID => l_appl_pgmapprv_id ,
x_PERSON_ID => p_person_id,
x_ADMISSION_APPL_NUMBER => p_admission_appl_number,
x_NOMINATED_COURSE_CD => p_nominated_program_cd,
x_SEQUENCE_NUMBER => p_sequence_number,
x_PGM_APPROVER_ID => p_pgm_approver_id,
x_ASSIGN_TYPE => 'M',
x_ASSIGN_DATE => SYSDATE,
x_PROGRAM_APPROVAL_DATE => p_program_approval_date,
x_PROGRAM_APPROVAL_STATUS => p_program_approval_status,
x_APPROVAL_NOTES => p_approval_notes,
X_Mode => 'R'
);
Igs_Ad_Appl_Pgmapprv_Pkg.update_row (
X_ROWID => lv_rowid,
x_APPL_PGMAPPRV_ID => l_appl_pgmapprv_id,
x_PERSON_ID => p_person_id,
x_ADMISSION_APPL_NUMBER => p_admission_appl_number,
x_NOMINATED_COURSE_CD => p_nominated_program_cd,
x_SEQUENCE_NUMBER => p_sequence_number,
x_PGM_APPROVER_ID => p_pgm_approver_id,
x_ASSIGN_TYPE => 'M',
x_ASSIGN_DATE => SYSDATE,
x_PROGRAM_APPROVAL_DATE => p_program_approval_date,
x_PROGRAM_APPROVAL_STATUS => p_program_approval_status,
x_APPROVAL_NOTES => p_approval_notes,
X_Mode => 'R');
SELECT count(*), rating_type_id, rating_scale_id,evaluator_id
FROM igs_ad_appl_eval
WHERE person_id = l_person_id
AND admission_appl_number = l_adm_apl_num
AND nominated_course_cd = l_nom_crs_cd
AND sequence_number = l_seq_number
GROUP BY rating_type_id, rating_scale_id,evaluator_id
HAVING count(*) > 1;
SELECT rowid
FROM igs_ad_appl_eval
WHERE rating_type_id = l_rating_type_id
AND evaluator_id = l_evaluator_id
AND person_id = l_person_id
AND admission_appl_number = l_adm_apl_num
AND nominated_course_cd = l_nom_crs_cd
AND sequence_number = l_seq_number
AND rowid <>
(SELECT max(rowid)
FROM igs_ad_appl_eval
WHERE rating_type_id = l_rating_type_id
AND evaluator_id = l_evaluator_id
AND person_id = l_person_id
AND admission_appl_number = l_adm_apl_num
AND nominated_course_cd = l_nom_crs_cd
AND sequence_number = l_seq_number
);
SELECT 'X'
FROM igs_ad_appl_eval
WHERE person_id = l_person_id
AND admission_appl_number = l_adm_apl_num
AND nominated_course_cd = l_nom_crs_cd
AND sequence_number = l_seq_num ;
SELECT a.ROWID, a.*
FROM igs_ad_ps_appl_inst a
WHERE person_id = p_person_id
AND admission_appl_number = p_admission_appl_number
AND nominated_course_cd = p_nominated_program_cd
AND sequence_number = p_sequence_number;
SELECT distinct sequential_concurrent_ind
FROM igs_ad_apl_rev_prf_all
WHERE appl_rev_profile_id = l_appl_rev_profile_id;
SELECT *
FROM igs_ad_appl_arp_v
WHERE person_id = l_person_id
AND admission_appl_number = l_adm_apl_num
AND nominated_course_cd = l_nom_crs_cd
AND sequence_number = l_seq_num ;
SELECT rating
FROM igs_ad_appl_eval_v
WHERE person_id = l_person_id
AND admission_appl_number = l_adm_apl_num
AND nominated_course_cd = l_nom_crs_cd
AND sequence_number = l_seq_num
AND rating IS NOT NULL;
SELECT
doc.s_adm_doc_status
FROM
igs_ad_ps_appl_inst apl, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */
igs_ad_doc_stat doc
WHERE person_id = l_person_id
AND admission_appl_number = l_adm_apl_num
AND nominated_course_cd = l_nom_crs_cd
AND sequence_number = l_seq_number
AND doc.adm_doc_status = apl.adm_doc_status;
/* The following code is to handle the update of the recview profile record.
OPEN eval_type_cur(l_exist_arp.appl_rev_profile_id);
-- insert row of Review Proifile
igs_ad_appl_arp_pkg.insert_row (
x_mode => 'I',
x_rowid => lv_rowid,
x_appl_arp_id => l_appl_arp_id,
x_person_id => p_PERSON_ID,
x_admission_appl_number => p_ADMISSION_APPL_NUMBER,
x_nominated_course_cd => p_nominated_program_cd,
x_sequence_number => p_SEQUENCE_NUMBER,
x_appl_rev_profile_id => p_APPL_REV_PROFILE_ID,
x_appl_revprof_revgr_id => p_APPL_REVPROF_REVGR_ID
);
ELSE -- this case will never happen as we are not allowing the update of review profile
-- insert row of Review Proifile
igs_ad_appl_arp_pkg.update_Row (
x_mode => 'I',
x_rowid => l_exist_arp.row_id,
x_appl_arp_id => l_exist_arp.appl_arp_id,
x_person_id => p_PERSON_ID,
x_admission_appl_number => p_ADMISSION_APPL_NUMBER,
x_nominated_course_cd => p_nominated_program_cd,
x_sequence_number => p_SEQUENCE_NUMBER,
x_appl_rev_profile_id => p_APPL_REV_PROFILE_ID,
x_appl_revprof_revgr_id => p_APPL_REVPROF_REVGR_ID
);
igs_ad_appl_eval_pkg.delete_row(del_dup_rec.rowid);