[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
INSERT INTO igs_gr_graduand
(
PERSON_ID,
CREATE_DT,
GRD_CAL_TYPE,
GRD_CI_SEQUENCE_NUMBER,
COURSE_CD,
AWARD_COURSE_CD,
AWARD_CRS_VERSION_NUMBER,
AWARD_CD,
GRADUAND_STATUS,
GRADUAND_APPR_STATUS,
S_GRADUAND_TYPE,
GRADUATION_NAME,
PROXY_AWARD_IND,
PROXY_AWARD_PERSON_ID,
PREVIOUS_QUALIFICATIONS,
CONVOCATION_MEMBERSHIP_IND,
SUR_FOR_COURSE_CD,
SUR_FOR_CRS_VERSION_NUMBER,
SUR_FOR_AWARD_CD,
COMMENTS,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_UPDATE_DATE,
ORG_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20
)
VALUES
(
L_PERSON_ID,
p_lgcy_grd_rec.CREATE_DT,
l_cal_type ,
l_sequence_number ,
UPPER(p_lgcy_grd_rec.program_cd),
UPPER(p_lgcy_grd_rec.award_program_cd),
p_lgcy_grd_rec.AWARD_prog_VERSION_NUMBER,
UPPER(p_lgcy_grd_rec.award_cd),
p_lgcy_grd_rec.GRADUAND_STATUS,
p_lgcy_grd_rec.GRADUAND_APPR_STATUS,
UPPER(p_lgcy_grd_rec.s_graduand_type),
p_lgcy_grd_rec.GRADUATION_NAME,
l_proxy_award_ind,
l_proxy_award_person_id,
p_lgcy_grd_rec.PREVIOUS_QUALIFICATIONS,
p_lgcy_grd_rec.CONVOCATION_MEMBERSHIP_IND,
UPPER(p_lgcy_grd_rec.sur_for_program_cd),
p_lgcy_grd_rec.SUR_FOR_prog_VERSION_NUMBER,
UPPER(p_lgcy_grd_rec.sur_for_award_cd),
p_lgcy_grd_rec.COMMENTS,
SYSDATE ,--p_lgcy_grd_rec.CREATION_DATE,
NVL(FND_GLOBAL.USER_ID,-1),--p_lgcy_grd_rec.CREATED_BY,
SYSDATE,--p_lgcy_grd_rec.LAST_UPDATE_DATE,
NVL(FND_GLOBAL.USER_ID,-1),--p_lgcy_grd_rec.LAST_UPDATED_BY,
NVL(FND_GLOBAL.LOGIN_ID,-1),--p_lgcy_grd_rec.LAST_UPDATE_LOGIN,
NULL,--p_lgcy_grd_rec.REQUEST_ID,
NULL,--p_lgcy_grd_rec.PROGRAM_ID,
NULL,--p_lgcy_grd_rec.PROGRAM_APPLICATION_ID,
NULL,--p_lgcy_grd_rec.PROGRAM_UPDATE_DATE,
NULL,--p_lgcy_grd_rec.ORG_ID,
p_lgcy_grd_rec.ATTRIBUTE_CATEGORY,
p_lgcy_grd_rec.ATTRIBUTE1,
p_lgcy_grd_rec.ATTRIBUTE2,
p_lgcy_grd_rec.ATTRIBUTE3,
p_lgcy_grd_rec.ATTRIBUTE4,
p_lgcy_grd_rec.ATTRIBUTE5,
p_lgcy_grd_rec.ATTRIBUTE6,
p_lgcy_grd_rec.ATTRIBUTE7,
p_lgcy_grd_rec.ATTRIBUTE8,
p_lgcy_grd_rec.ATTRIBUTE9,
p_lgcy_grd_rec.ATTRIBUTE10,
p_lgcy_grd_rec.ATTRIBUTE11,
p_lgcy_grd_rec.ATTRIBUTE12,
p_lgcy_grd_rec.ATTRIBUTE13,
p_lgcy_grd_rec.ATTRIBUTE14,
p_lgcy_grd_rec.ATTRIBUTE15,
p_lgcy_grd_rec.ATTRIBUTE16,
p_lgcy_grd_rec.ATTRIBUTE17,
p_lgcy_grd_rec.ATTRIBUTE18,
p_lgcy_grd_rec.ATTRIBUTE19,
p_lgcy_grd_rec.ATTRIBUTE20
);
|| inserting a record in the table IGS_GR_GRADUAND_ALL
||
||
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
****************************************************************************************************************/
IS
--Initialize API return status to true
l_return_value BOOLEAN := FND_API.TO_BOOLEAN(FND_API.G_TRUE);
SELECT S_AWARD_TYPE
FROM igs_ps_awd
WHERE award_cd = p_award_cd;
SELECT gst.s_graduand_status
FROM IGS_GR_STAT gst
WHERE gst.graduand_status = p_lgcy_grd_rec.graduand_status;
SELECT gas.s_graduand_appr_status
FROM IGS_GR_APRV_STAT gas
WHERE gas.graduand_appr_status = p_lgcy_grd_rec.graduand_appr_status;
SELECT sca.version_number,
sca.course_rqrmnt_complete_ind
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = P_person_id AND
sca.course_cd = p_lgcy_grd_rec.program_cd;
SELECT 'x'
FROM IGS_PS_STDNT_APV_ALT scaae
WHERE scaae.person_id = p_person_id AND
scaae.course_cd = p_lgcy_grd_rec.program_cd AND
scaae.version_number = cp_sca_version_number AND
scaae.exit_course_cd = p_lgcy_grd_rec.award_program_cd AND
scaae.exit_version_number = p_lgcy_grd_rec.award_prog_version_number AND
scaae.rqrmnts_complete_ind = 'Y';
SELECT 'x'
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = p_lgcy_grd_rec.sur_for_program_cd AND
sca.version_number = p_lgcy_grd_rec.sur_for_prog_version_number;
SELECT S_GRADUAND_STATUS
FROM IGS_GR_STAT
WHERE GRADUAND_STATUS = p_lgcy_grd_rec.graduand_status;
|| inserting a record in the table IGS_GR_GRADUAND
||
||
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
****************************************************************************************************************/
IS
--Initialize API return status to true
l_return_value BOOLEAN := FND_API.TO_BOOLEAN(FND_API.G_TRUE);