The following lines contain the word 'select', 'insert', 'update' or 'delete':
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_message_count);
FND_MSG_PUB.DELETE_MSG(l_count);
|| the IGS_EN_STDNT_PS_ATT.INSERT_ROW is called.Bug# 4071165
------------------------------------------------------------------------------*/
l_api_name CONSTANT VARCHAR2(30) := 'create_spa';
SELECT research_type_ind FROM igs_ps_type
WHERE course_type = p_prg_type;
CURSOR cur_re_seq IS SELECT igs_re_candidature_seq_num_s.NEXTVAL FROM DUAL;
l_program_update_date igs_en_stdnt_ps_att_all.program_update_date%TYPE;
l_program_update_date := NULL;
l_PROGRAM_UPDATE_DATE := SYSDATE;
INSERT INTO igs_en_stdnt_ps_att_all(
person_id,
course_cd,
version_number,
cal_type,
location_cd,
attendance_mode,
attendance_type,
coo_id,
student_confirmed_ind,
commencement_dt,
course_attempt_status,
progression_status,
derived_att_type,
derived_att_mode,
provisional_ind,
discontinued_dt,
discontinuation_reason_cd,
lapsed_dt,
funding_source,
exam_location_cd,
derived_completion_yr,
derived_completion_perd,
nominated_completion_yr,
nominated_completion_perd,
rule_check_ind,
waive_option_check_ind,
last_rule_check_dt,
publish_outcomes_ind,
course_rqrmnt_complete_ind,
course_rqrmnts_complete_dt,
s_completed_source_type,
override_time_limitation,
advanced_standing_ind,
fee_cat,
correspondence_cat,
self_help_group_ind,
logical_delete_dt,
adm_admission_appl_number,
adm_nominated_course_cd,
adm_sequence_number,
igs_pr_class_std_id,
last_date_of_attendance,
dropped_by,
primary_program_type,
primary_prog_type_source,
catalog_cal_type,
catalog_seq_num,
key_program,
override_cmpl_dt,
manual_ovr_cmpl_dt_ind,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
request_id,
program_application_id,
program_id,
program_update_date,
org_id,
future_dated_trans_flag)
VALUES ( l_person_id,
l_sca_re_rec.program_cd,
l_sca_re_rec.version_number,
l_sca_re_rec.cal_type,
l_sca_re_rec.location_cd,
l_sca_re_rec.attendance_mode,
l_sca_re_rec.attendance_type,
l_coo_id,
l_sca_re_rec.student_confirmed_ind,
l_sca_re_rec.commencement_dt,
l_course_att_status,
NULL,
NULL,
NULL,
l_sca_re_rec.provisional_ind,
l_sca_re_rec.discontinued_dt,
l_sca_re_rec.discontinuation_reason_cd,
l_sca_re_rec.lapsed_dt,
l_sca_re_rec.funding_source,
l_sca_re_rec.exam_location_cd,
NULL,
NULL,
l_sca_re_rec.nominated_completion_yr,
l_sca_re_rec.nominated_completion_perd,
l_sca_re_rec.rule_check_ind,
l_sca_re_rec.waive_option_check_ind,
l_sca_re_rec.last_rule_check_dt,
l_sca_re_rec.publish_outcomes_ind,
l_sca_re_rec.course_rqrmnt_complete_ind,
l_sca_re_rec.course_rqrmnts_complete_dt,
l_sca_re_rec.s_completed_source_type,
NULL,
l_sca_re_rec.advanced_standing_ind,
l_sca_re_rec.fee_cat,
l_sca_re_rec.correspondence_cat,
l_sca_re_rec.self_help_group_ind,
NULL,
l_sca_re_rec.adm_admission_appl_number,
l_sca_re_rec.adm_nominated_course_cd,
l_sca_re_rec.adm_sequence_number,
l_igs_pr_class_std_id,
NULL,
l_dropped_by,
l_sca_re_rec.primary_program_type,
l_sca_re_rec.primary_prog_type_source,
l_catalog_cal_type,
l_catalog_seq_num,
l_sca_re_rec.key_program,
l_sca_re_rec.override_cmpl_dt,
l_sca_re_rec.manual_ovr_cmpl_dt_ind,
l_sca_re_rec.attribute_category,
l_sca_re_rec.attribute1,
l_sca_re_rec.attribute2,
l_sca_re_rec.attribute3,
l_sca_re_rec.attribute4,
l_sca_re_rec.attribute5,
l_sca_re_rec.attribute6,
l_sca_re_rec.attribute7,
l_sca_re_rec.attribute8,
l_sca_re_rec.attribute9,
l_sca_re_rec.attribute10,
l_sca_re_rec.attribute11,
l_sca_re_rec.attribute12,
l_sca_re_rec.attribute13,
l_sca_re_rec.attribute14,
l_sca_re_rec.attribute15,
l_sca_re_rec.attribute16,
l_sca_re_rec.attribute17,
l_sca_re_rec.attribute18,
l_sca_re_rec.attribute19,
l_sca_re_rec.attribute20,
NVL(FND_GLOBAL.USER_ID,-1),
SYSDATE,
NVL(FND_GLOBAL.USER_ID,-1),
SYSDATE,
NVL(FND_GLOBAL.LOGIN_ID,-1),
l_request_id,
l_program_application_id,
l_program_id,
l_program_update_date,
igs_ge_gen_003.get_org_id,
'N');
INSERT INTO igs_re_candidature_all(person_id,
sequence_number,
sca_course_cd,
acai_admission_appl_number,
acai_nominated_course_cd,
acai_sequence_number,
attendance_percentage,
govt_type_of_activity_cd,
max_submission_dt,
min_submission_dt,
research_topic,
industry_links,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
request_id,
program_application_id,
program_id,
program_update_date,
org_id) VALUES(
l_person_id,
l_sequence_number,
l_sca_re_rec.program_cd,
l_sca_re_rec.adm_admission_appl_number,
l_sca_re_rec.adm_nominated_course_cd,
l_sca_re_rec.adm_sequence_number,
l_sca_re_rec.re_attendance_percentage,
l_sca_re_rec.re_govt_type_of_activity_cd,
l_sca_re_rec.re_max_submission_dt,
l_sca_re_rec.re_min_submission_dt,
l_sca_re_rec.re_research_topic,
l_sca_re_rec.re_industry_links,
NVL(FND_GLOBAL.USER_ID,-1),
SYSDATE,
NVL(FND_GLOBAL.USER_ID,-1),
SYSDATE,
NVL(FND_GLOBAL.LOGIN_ID,-1),
l_request_id,
l_program_application_id,
l_program_id,
l_program_update_date,
igs_ge_gen_003.get_org_id);