[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Purpose : This routine validates the parameters that are being passed to the insert API.
It Checks for Mandatory Parameters and Check constraints. While making a call to the
Check_constraints routine of the TBH , it is possible to encounter an Exception if the
validation fails.So, calls to check_constraint routines are handled gracefully within
blocks.If an error is encountered , the Check_cons routine adds the generic message
IGS_GE_INVALID_VALUE to the stack , and then raises the Exception. So , in the Insert
API Exception section, generic message 'IGS_GE_INVALID_VALUE' is deleted from the Stack
and a more specific message is added , if required.
Known limitations,
enhancements,
remarks :
Change History
Who When What
------------------------------------------------------------------*/
-- Cursor to fetch parameter for querying label GRADE
CURSOR get_grade IS
SELECT message_text
FROM fnd_new_messages
WHERE message_name = 'IGS_EN_GRADE' ;
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
Purpose : This routine is private API. The insert API makes a call to this routine to validate
SUA details regarding Unit and Program Transfer. If the validations are successful ,
SUA AND SPA Transfer Details are created in the respectively tables. NOte that SPA
transfer details can already exist in the table if a Transferred Unit Attempt has
already been import for another SUA.
Known limitations,
enhancements,
remarks :
Change History
Who When What
svenkata 2-JAN-03 The values of WHO columns was being set inside the block for Student Program Transfer.Moved the code
to the main block-Bug# 2732542
kkillams 29-04-2003 Modified the get_sua_trn cursor due to change in the pk of student unit attempt w.r.t. bug number 2829262
------------------------------------------------------------------*/
--
-- cursor to determine if Student Program Attempt Transfer details already exist .
CURSOR get_sca_trn IS
SELECT 'x'
FROM igs_ps_stdnt_trn
WHERE person_id = p_person_id AND
course_cd= p_sua_dtls_rec.program_cd AND
transfer_course_cd = p_sua_dtls_rec.transfer_program_cd AND
TRUNC(transfer_dt) = TRUNC( p_sua_dtls_rec.transfer_dt);
SELECT 'x'
FROM igs_ps_stdnt_unt_trn
WHERE person_id = p_person_id AND
course_cd = p_sua_dtls_rec.program_cd AND
transfer_course_cd = p_sua_dtls_rec.transfer_program_cd AND
transfer_dt = p_sua_dtls_rec.transfer_dt AND
uoo_id = p_uoo_id;
l_last_update_date igs_ps_stdnt_trn.last_update_date%TYPE;
l_last_updated_by igs_ps_stdnt_trn.last_updated_by%TYPE;
l_last_update_login igs_ps_stdnt_trn.last_update_login%TYPE;
l_last_update_date := SYSDATE;
l_last_updated_by := FND_GLOBAL.USER_ID;
l_last_update_login :=FND_GLOBAL.LOGIN_ID;
IF l_last_updated_by IS NULL THEN
l_last_updated_by := -1;
IF l_last_update_login IS NULL THEN
l_last_update_login := -1;
INSERT INTO IGS_PS_STDNT_TRN (
PERSON_ID,
COURSE_CD,
TRANSFER_COURSE_CD,
TRANSFER_DT,
COMMENTS,
STATUS_DATE,
STATUS_FLAG,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) VALUES (
p_person_id,
p_sua_dtls_rec.program_cd ,
p_sua_dtls_rec.transfer_program_cd,
p_sua_dtls_rec.transfer_dt,
NULL ,
p_sua_dtls_rec.transfer_dt,
'T',
l_last_update_date,
l_last_updated_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
INSERT INTO igs_ps_stdnt_unt_trn (
PERSON_ID,
COURSE_CD,
TRANSFER_COURSE_CD,
TRANSFER_DT,
UOO_ID,
UNIT_CD,
CAL_TYPE,
CI_SEQUENCE_NUMBER,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
p_person_id,
p_sua_dtls_rec.program_cd ,
p_sua_dtls_rec.transfer_program_cd,
p_sua_dtls_rec.transfer_dt,
p_uoo_id,
p_sua_dtls_rec.unit_cd,
p_cal_type ,
p_ci_Sequence_number,
l_last_update_date,
l_last_updated_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
Purpose : This routine is private to the API. There is a call to this routine from the insert
API to carry out all validations after inserting Student Unit Attempt Details .This
routine does the following :
1. If DISCONTINUED_DT is not null then insert corresponding discontinuation grade
into IGS_AS_SU_STMPTOUT_ALL
2. Increment Unit section actual enrollment .
3. Insert Student Unit Attempt Outcome details
4. Re-derive the Program Attempt status. Update the SPA record with the new status.
Known limitations,
enhancements,
remarks :
Change History
Who When What
svenkata 18-Nov-2002 Bug# 2715256- Adminisntrative Unit Status was passed incorrectly to the routine
igs_en_gen_010.enrp_ins_suao_discon.Added NVL clause.
svenkata 18-Nov-2002 Bug# 2715240 - The value of the column MARK was not passed correctly to the API call
of Student Unit Attempt Outcome.
svenkata 30-Dec-2002 Mirroring of all secondary Program Attempts if status of Primary Program Attempt
| is changed.Bug# 2728047.
kkillams 27-Mar-03 Modified usec_cur Cursor, replaced * with enrollment_actual and waitlist_actual
w.r.t. bug 2749648
kkillams 25-04-2003 Impacted object, due to change in the signature of the igs_en_gen_010.enrp_ins_suao_discon function
w.r.t. bug number 2829262
rvivekan 11-July -2003 Added INVALID and UNCONFIRM to scenarios for enrollment_actual increment Bug 3036949
ptandon 23-Sep-2003 Passed the value of fields LOCATION_CD and UNIT_CLASS in l_suao_rec parameter in call to procedure
igs_as_suao_lgcy_pub.create_unit_outcome. Bug# 3149520.
ptandon 24-Sep-2003 In call to igs_en_gen_legacy.get_course_att_status, the value of parameter p_discontinued_dt
was being incorrectly passed as p_sua_dtls_rec.discontinued_dt. Replaced it by value of
discontinued_dt fetched from get_spa cursor. Bug# 3152211.
ptandon 02-Dec-2003 Inserted call to the Term Records Legacy API as per Term Records Fee Calc build. Bug# 2829263.
------------------------------------------------------------------*/
--
-- Cursor to get the Enrollment Actual for a Unit section.
CURSOR usec_upd_enr_act IS
SELECT ROWID,uoo.enrollment_actual, uoo.waitlist_actual
FROM igs_ps_unit_ofr_opt uoo
WHERE uoo_id = p_uoo_id
FOR UPDATE NOWAIT;
SELECT ROWID , spa.*
FROM igs_en_stdnt_ps_att spa
WHERE spa.person_id = p_person_id AND
spa.course_cd = p_sua_dtls_rec.program_cd
FOR UPDATE NOWAIT;
SELECT sca.course_type
FROM igs_en_sca_v sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = p_sua_dtls_rec.program_cd ;
SELECT spa.ROWID
FROM igs_en_stdnt_ps_att spa , igs_en_sca_v sca
WHERE spa.person_id = p_person_id AND
spa.person_id = sca.person_id AND
sca.course_cd = spa.course_cd AND
sca.course_type = p_course_type AND
spa.primary_program_type = 'SECONDARY' AND
spa.course_attempt_status NOT IN ('UNCONFIRM' , 'DISCONTIN' , 'COMPLETED')
FOR UPDATE NOWAIT ;
UPDATE igs_ps_unit_ofr_opt_all SET enrollment_actual = l_enrollment_actual WHERE ROWID = l_usec_row.ROWID;
UPDATE igs_ps_unit_ofr_opt_all SET waitlist_actual = l_waitlist_actual WHERE ROWID = l_usec_row.ROWID ;
UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after ,
LAST_DATE_OF_ATTENDANCE = l_last_dt_of_att WHERE ROWID = l_spa_row.ROWID;
UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after WHERE ROWID = l_spa_row.ROWID;
UPDATE IGS_EN_STDNT_PS_ATT_ALL SET COURSE_ATTEMPT_STATUS = l_course_attempt_status_after WHERE ROWID = get_spa_sec_prgm_rec.ROWID ;
Purpose : This routine is private to the API. There is a call to this routine from the insert
API to carry out all validations before inserting Student Unit Attempt Details .
Known limitations,
enhancements,
remarks :
Change History
Who When What
sarakshi 13-Jul-2004 Bug#3729462, Added predicate DELETE_FLAG='N' to the cursor c_get_wlst_alwd_oopt .
svenkata 30-Dec-2002 Error message was displayed twice.The message_name returned was compared against NULL incorrectly
after call to routine igs_en_val_sua.enrp_val_discont_aus. Bug#2727931
pradhakr 20-Jan-2003 Added a parameter no_assessment_ind to the procedue call IGS_EN_VAL_SUA.enrp_val_sua_ovrd_cp
as part of ENCR26 build.
ptandon 17-Oct-2003 Added two OUT parameters p_sup_unit_cd and p_sup_unit_version_number and modified the code to add
the validation for the superior-subordinate as part of Placements build. Enh Bug# 3052438.
rvivekan 17-nov-2003 Bug3264064. Changed the datatype of variables holding the concatenated administrative unit status list
to varchar(2000)
vkarthik 10-dec-2003 Bug3140571. Added a cursor to pick up version for the given person and course and another to get
max_wlst_per_stud given the course and version. Made use of these cursors to include program level
EN waitlist
bdeviset 27-oct-2004 Bug#3972537.The call igs_en_val_sua.enrp_val_sua_intrmt is not made if unit_attempt_status is
either dropped or discontinued.
bdeviset 16-NOV-2004 Bug#4000939.Added a check to see if the load calendar (corresponding to the teaching calendar) end date
is greater than the commencement date of the program attempt for ENROLLED,DISCONTIN,WAITLIST and INVALID.
ckasu 30-DEC-2004 modified code inorder to consider Term Records while getting primary program type as a part of bug#4095276
ckasu 20-JUL-2006 modified b=y ckasu as a part of bug #4642089 inorder to validate whethet Subtitle updation is allowed or not
------------------------------------------------------------------*/
--
-- Cursor to check if the auditable_ind is available at the unit section level.
CURSOR get_audit_usec IS
SELECT NVL(auditable_ind, 'N')
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = p_uoo_id;
SELECT NVL(waitlist_allowed,'N') waitlist_allowed,NVL(max_students_per_waitlist,9999) max_students_per_waitlist
FROM igs_ps_usec_lim_wlst
WHERE cp_uoo_id=uoo_id;
SELECT NVL(uop.waitlist_allowed,'N') waitlist_allowed ,NVL(uop.max_students_per_waitlist,9999) max_students_per_waitlist
FROM igs_ps_unit_ofr_pat uop,
igs_ps_unit_ofr_opt uoo
WHERE uop.unit_cd=uoo.unit_cd
AND uop.version_number=uoo.version_number
AND uop.cal_type=uoo.cal_type
AND uop.ci_sequence_number=uoo.ci_sequence_number
AND uoo.uoo_id=cp_uoo_id
AND uop.delete_flag='N';
SELECT waitlist_actual
FROM igs_ps_unit_ofr_opt
WHERE uoo_id=p_uoo_id;
SELECT version_number
FROM igs_en_stdnt_ps_att
WHERE
person_id = cp_person_id AND
course_cd = cp_course_cd;
SELECT max_wlst_per_stud
FROM igs_ps_ver
WHERE
course_cd = cp_course_cd AND
version_number = cp_version_number;
SELECT NVL(max_waitlists_student_num,9999) max_waitlists
FROM IGS_EN_INST_WL_STPS;
SELECT COUNT(ROWID) waitlists
FROM igs_en_su_attempt
WHERE person_id = cp_person_id AND
unit_attempt_status ='WAITLISTED' AND
(cal_type,ci_sequence_number) IN
(SELECT teach_cal_type,teach_ci_sequence_number
FROM igs_ca_load_to_teach_v
WHERE load_cal_type = cp_load_cal_type AND
load_ci_sequence_number = cp_load_ci_sequence_number);
SELECT discontinued_dt
FROM igs_en_Stdnt_ps_att
WHERE course_cd = p_sua_dtls_rec.program_cd
AND person_id = p_person_id;
SELECT NVL(RELATION_TYPE,'NONE')
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = cp_uoo_id;
SELECT unit_cd,version_number
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = (SELECT sup_uoo_id
FROM igs_ps_unit_ofr_opt
WHERE uoo_id = cp_uoo_id);
SELECT load_cal_type, load_ci_sequence_number,load_end_dt
FROM IGS_CA_TEACH_TO_LOAD_V
WHERE teach_cal_type = cp_cal_type
AND teach_ci_sequence_number = cp_sequence_number
ORDER BY LOAD_START_DT asc;
SELECT NVL(subtitle_modifiable_flag,'N')
FROM igs_ps_usec_ref
WHERE uoo_id = p_uoo_id;
FND_MSG_PUB.DELETE_MSG(l_msg_count);
Legacy Data onto OSS Tables. The routine validates data passed to it and inserts them
into the corresponding OSS tables.
Known limitations,
enhancements,
remarks :
Change History
Who When What
svenkata 16-dec-02 Bug # 2708674 - columns No assessment indicator , student career transcript and student
career statistics not defaulted.
svenkata 30-Dec-02 Derived the Status of the Unit as COMPLETED if Grade is mentioned.Bug# 2727922
kkillams 29-04-2003 Impacted object, due to change in the signature of the igs_en_gen_007.enrp_get_sua_status function
w.r.t. bug number 2829262
rvangala 01-OCT-2003 Added core_indicator value in the INSERT statements, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
ptandon 17-OCT-2003 Modified call to validate_sua to take into consideration two new OUT parameters p_sup_unit_cd and
p_sup_unit_version_number and pass these values in the insert statements for IGS_EN_SU_ATTEMPT_ALL as part
of Placements build. Enh Bug# 3052438.
------------------------------------------------------------------*/
--
-- Cursor to get transfer Details
CURSOR get_sua_trn (p_uoo_id IN NUMBER , p_person_id IN NUMBER , p_transfer_program_cd IN VARCHAR2 , P_unit_cd IN VARCHAR2 ) IS
SELECT enrolled_dt, discontinued_dt, administrative_unit_status, dcnt_reason_cd,
no_assessment_ind, override_enrolled_cp, override_achievable_cp,
grading_schema_code, gs_version_number, subtitle, attribute_category ,
attribute1 , attribute2 , attribute3 , attribute4 , attribute5 , attribute6,
attribute7 , attribute8 , attribute9 , attribute10 , attribute11 , attribute12 ,
attribute13 , attribute14 , attribute15 , attribute16 , attribute17 , attribute18 ,
attribute19 , attribute20,upd_audit_flag,ss_source_ind
FROM igs_en_su_attempt sua
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_transfer_program_cd AND
sua.unit_cd = p_unit_cd AND
sua.uoo_id = p_uoo_id;
SELECT uoo_id
FROM igs_ps_unit_ofr_opt
WHERE uoo_id=cp_uoo_id
FOR UPDATE;
SELECT NVL(MAX(administrative_priority),0)+1
FROM igs_en_su_attempt
WHERE uoo_id=cp_uoo_id
AND waitlist_dt<=cp_waitlist_dt
AND unit_attempt_status='WAITLISTED';
l_insert_flag BOOLEAN := TRUE;
l_last_update_date igs_en_su_attempt.last_update_date%TYPE;
l_last_updated_by igs_en_su_attempt.last_updated_by%TYPE;
l_last_update_login igs_en_su_attempt.last_update_login%TYPE;
l_program_update_date igs_en_su_attempt.program_update_date%TYPE;
l_last_update_date := SYSDATE;
l_last_updated_by := FND_GLOBAL.USER_ID;
l_last_update_login :=FND_GLOBAL.LOGIN_ID;
IF l_last_updated_by IS NULL THEN
l_last_updated_by := -1;
IF l_last_update_login IS NULL THEN
l_last_update_login := -1;
l_program_update_date := NULL;
l_program_update_date := SYSDATE;
INSERT INTO IGS_EN_SU_ATTEMPT_ALL (
person_id,
course_cd,
unit_cd,
version_number,
cal_type,
ci_sequence_number,
location_cd,
unit_class,
ci_start_dt,
ci_end_dt,
uoo_id,
enrolled_dt,
unit_attempt_status,
administrative_unit_status,
discontinued_dt,
rule_waived_dt,
rule_waived_person_id,
no_assessment_ind,
sup_unit_cd,
sup_version_number,
exam_location_cd,
alternative_title,
override_enrolled_cp,
override_eftsu,
override_achievable_cp,
override_outcome_due_dt,
override_credit_reason,
administrative_priority,
waitlist_dt,
dcnt_reason_cd,
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,
gs_version_number,
enr_method_type ,
failed_unit_rule ,
cart ,
rsv_seat_ext_id ,
org_unit_cd ,
grading_schema_code ,
subtitle,
session_id,
deg_aud_detail_id,
student_career_transcript,
student_career_statistics,
waitlist_manual_ind ,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
wlst_priority_weight_num,
wlst_preference_weight_num,
--added by rvangala 01-OCT-2003. Enh Bug# 3052432
core_indicator_code,
upd_audit_flag,
ss_source_ind)
VALUES (
l_person_id,
p_sua_dtls_rec.program_cd,
p_sua_dtls_rec.unit_cd,
NVL ( p_sua_dtls_rec.version_number , l_version_number),
l_cal_type,
l_ci_sequence_number,
p_sua_dtls_rec.location_cd,
p_sua_dtls_rec.unit_class,
l_ci_start_dt,
l_ci_end_dt,
l_uoo_id,
p_sua_dtls_rec.enrolled_dt,
l_unit_attempt_status,
NVL ( p_sua_dtls_rec.administrative_unit_status , l_adm_unit_status_ret),
p_sua_dtls_rec.discontinued_dt,
NULL ,
NULL ,
NVL( p_sua_dtls_rec.no_assessment_ind , l_no_assessment_ind ),
l_sup_unit_cd ,
l_sup_unit_version_number ,
NULL ,
NULL ,
l_override_enrollment_cp,
NULL ,
l_override_achievable_cp,
NULL ,
NULL ,
l_wlst_position,
p_sua_dtls_rec.waitlisted_dt,
p_sua_dtls_rec.dcnt_reason_cd,
l_last_update_date,
l_last_updated_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login,
l_request_id,
l_program_id,
l_program_application_id,
l_program_update_date,
NULL ,
p_sua_dtls_rec.gs_version_number ,
NULL ,
NULL ,
l_cart_status ,
NULL ,
l_org_unit_cd ,
p_sua_dtls_rec.grading_schema_code,
p_sua_dtls_rec.subtitle,
NULL ,
NULL ,
NVL( p_sua_dtls_rec.student_career_transcript , l_student_career_transcript ),
NVL( p_sua_dtls_rec.student_career_statistics, l_student_career_statistics ),
NULL ,
p_sua_dtls_rec.attribute_category,
p_sua_dtls_rec.attribute1,
p_sua_dtls_rec.attribute2,
p_sua_dtls_rec.attribute3,
p_sua_dtls_rec.attribute4,
p_sua_dtls_rec.attribute5,
p_sua_dtls_rec.attribute6,
p_sua_dtls_rec.attribute7,
p_sua_dtls_rec.attribute8,
p_sua_dtls_rec.attribute9,
p_sua_dtls_rec.attribute10,
p_sua_dtls_rec.attribute11,
p_sua_dtls_rec.attribute12,
p_sua_dtls_rec.attribute13,
p_sua_dtls_rec.attribute14,
p_sua_dtls_rec.attribute15,
p_sua_dtls_rec.attribute16,
p_sua_dtls_rec.attribute17,
p_sua_dtls_rec.attribute18,
p_sua_dtls_rec.attribute19,
p_sua_dtls_rec.attribute20,
l_pri_weight,
l_pref_weight,
--added by rvangala 01-OCT-2003. Enh Bug# 3052432
p_sua_dtls_rec.core_indicator,
'N',
'A'
);
INSERT INTO IGS_EN_SU_ATTEMPT_ALL (
person_id,
course_cd,
unit_cd,
version_number,
cal_type,
ci_sequence_number,
location_cd,
unit_class,
ci_start_dt,
ci_end_dt,
uoo_id,
enrolled_dt,
unit_attempt_status,
administrative_unit_status,
discontinued_dt,
rule_waived_dt,
rule_waived_person_id,
no_assessment_ind,
sup_unit_cd,
sup_version_number,
exam_location_cd,
alternative_title,
override_enrolled_cp,
override_eftsu,
override_achievable_cp,
override_outcome_due_dt,
override_credit_reason,
administrative_priority,
waitlist_dt,
dcnt_reason_cd,
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,
gs_version_number,
enr_method_type ,
failed_unit_rule ,
cart ,
rsv_seat_ext_id ,
org_unit_cd ,
grading_schema_code ,
subtitle,
session_id,
deg_aud_detail_id,
student_career_transcript,
student_career_statistics,
waitlist_manual_ind ,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
wlst_priority_weight_num,
wlst_preference_weight_num,
--added by rvangala 01-OCT-2003. Enh Bug# 3052432
core_indicator_code,
upd_audit_flag,
ss_source_ind)
VALUES (
l_person_id,
p_sua_dtls_rec.program_cd,
p_sua_dtls_rec.unit_cd,
NVL ( p_sua_dtls_rec.version_number , l_version_number),
l_cal_type,
l_ci_sequence_number,
p_sua_dtls_rec.location_cd,
p_sua_dtls_rec.unit_class,
l_ci_start_dt,
l_ci_end_dt,
l_uoo_id,
sua_trnsfr_rec(1).enrolled_dt,
cst_duplicate ,
NULL ,
NULL ,
NULL ,
NULL ,
NVL( p_sua_dtls_rec.no_assessment_ind , l_no_assessment_ind ),
l_sup_unit_cd ,
l_sup_unit_version_number ,
NULL ,
NULL ,
NVL(IGS_EN_GEN_015.enrp_get_appr_cr_pt(l_person_id,l_uoo_id),sua_trnsfr_rec(1).override_enrolled_cp),
NULL ,
NVL(IGS_EN_GEN_015.enrp_get_appr_cr_pt(l_person_id,l_uoo_id),sua_trnsfr_rec(1).override_achievable_cp),
NULL ,
NULL ,
l_wlst_position,
p_sua_dtls_rec.waitlisted_dt,
NULL ,
l_last_update_date,
l_last_updated_by,
l_last_update_date,
l_last_updated_by,
l_last_update_login,
l_request_id,
l_program_id,
l_program_application_id,
l_program_update_date,
NULL ,
sua_trnsfr_rec(1).gs_version_number ,
NULL ,
NULL ,
l_cart_status ,
NULL ,
l_org_unit_cd ,
sua_trnsfr_rec(1).grading_schema_code,
sua_trnsfr_rec(1).subtitle,
NULL ,
NULL ,
NVL( p_sua_dtls_rec.student_career_transcript , l_student_career_transcript ),
NVL( p_sua_dtls_rec.student_career_statistics, l_student_career_statistics ),
NULL ,
sua_trnsfr_rec(1).attribute_category,
sua_trnsfr_rec(1).attribute1,
sua_trnsfr_rec(1).attribute2,
sua_trnsfr_rec(1).attribute3,
sua_trnsfr_rec(1).attribute4,
sua_trnsfr_rec(1).attribute5,
sua_trnsfr_rec(1).attribute6,
sua_trnsfr_rec(1).attribute7,
sua_trnsfr_rec(1).attribute8,
sua_trnsfr_rec(1).attribute9,
sua_trnsfr_rec(1).attribute10,
sua_trnsfr_rec(1).attribute11,
sua_trnsfr_rec(1).attribute12,
sua_trnsfr_rec(1).attribute13,
sua_trnsfr_rec(1).attribute14,
sua_trnsfr_rec(1).attribute15,
sua_trnsfr_rec(1).attribute16,
sua_trnsfr_rec(1).attribute17,
sua_trnsfr_rec(1).attribute18,
sua_trnsfr_rec(1).attribute19,
sua_trnsfr_rec(1).attribute20,
l_pri_weight,
l_pref_weight,
--added by rvangala 01-OCT-2003. Enh Bug# 3052432
p_sua_dtls_rec.core_indicator,
'N',
'A');