The following lines contain the word 'select', 'insert', 'update' or 'delete':
sgurusam 20-Jun-05 Added PLAN_SHT_STATUS value as 'NONE' in insert the statement
of table igs_en_spa_terms
******************************************************************************/
g_pkg_name CONSTANT VARCHAR2(30) := 'IGS_EN_SPAT_LGCY_PUB';
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);
SELECT 'X'
FROM igs_en_spa_terms spa_terms, igs_ps_ver ps_ver
WHERE
spa_terms.person_id = pc_person_id AND
spa_terms.term_cal_type = pc_term_cal_type AND
spa_terms.term_sequence_number = pc_term_sequence_number AND
spa_terms.program_cd <> pc_program_cd AND
ps_ver.course_type = pc_course_type AND
spa_terms.program_cd = ps_ver.course_cd AND
spa_terms.program_version = ps_ver.version_number;
SELECT 'X'
FROM igs_en_spa_terms
WHERE
person_id = pc_person_id AND
term_cal_type = pc_term_cal_type AND
term_sequence_number = pc_term_sequence_number AND
program_cd <> pc_program_cd AND
key_program_flag = 'Y';
SELECT course_type
FROM igs_ps_ver
WHERE
course_cd = cp_program_cd AND
version_number = cp_program_version;
|| Purpose : public procedure that inserts the records into spat
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
------------------------------------------------------------------------------*/
CURSOR c_igs_en_spa_terms_s IS
SELECT igs_en_spa_terms_s.NEXTVAL
FROM dual;
l_program_update_date igs_en_spa_terms.program_update_date%TYPE;
l_program_update_date := NULL;
l_program_update_date := SYSDATE;
INSERT INTO igs_en_spa_terms (
term_record_id,
person_id,
program_cd,
program_version,
acad_cal_type,
term_cal_type,
term_sequence_number,
key_program_flag,
location_cd,
attendance_mode,
attendance_type,
fee_cat,
coo_id,
class_standing_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
request_id,
program_application_id,
program_id,
program_update_date,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
plan_sht_status)
VALUES (
l_spa_terms_term_record_id,
l_person_id,
p_spat_rec.program_cd,
p_spat_rec.program_version,
p_spat_rec.acad_cal_type,
l_term_cal_type,
l_term_sequence_number,
p_spat_rec.key_program_flag,
p_spat_rec.location_cd,
p_spat_rec.attendance_mode,
p_spat_rec.attendance_type,
p_spat_rec.fee_cat,
l_coo_id,
l_class_standing_id,
NVL(FND_GLOBAL.USER_ID, -1), -- created_by
SYSDATE, -- creation_date
NVL(FND_GLOBAL.USER_ID,-1), -- last_updated_by
SYSDATE, -- last_update_date
NVL(FND_GLOBAL.LOGIN_ID, -1), -- last_update_login
l_request_id, -- request_id
l_program_application_id, -- program_application_id
l_program_id, -- program_id
l_program_update_date, -- program_update_date
p_spat_rec.attribute_category,
p_spat_rec.attribute1,
p_spat_rec.attribute2,
p_spat_rec.attribute3,
p_spat_rec.attribute4,
p_spat_rec.attribute5,
p_spat_rec.attribute6,
p_spat_rec.attribute7,
p_spat_rec.attribute8,
p_spat_rec.attribute9,
p_spat_rec.attribute10,
p_spat_rec.attribute11,
p_spat_rec.attribute12,
p_spat_rec.attribute13,
p_spat_rec.attribute14,
p_spat_rec.attribute15,
p_spat_rec.attribute16,
p_spat_rec.attribute17,
p_spat_rec.attribute18,
p_spat_rec.attribute19,
p_spat_rec.attribute20,
'NONE');