The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER ,
x_export_to_oss_status IN VARCHAR2,
x_error_code IN VARCHAR2,
x_request_id IN NUMBER,
x_batch_id IN NUMBER,
x_extra_round_nbr IN NUMBER,
x_system_code IN VARCHAR2 ,
x_part_time IN VARCHAR2 ,
x_interview IN DATE ,
x_late_application IN VARCHAR2 ,
x_modular IN VARCHAR2 ,
x_residential IN VARCHAR2,
-- smaddali added this column for ucfd203 build bug #2669208
x_ucas_cycle IN NUMBER
) AS
/*
|| Created By : [email protected]
|| Created On : 21-FEB-2002
|| Purpose : Initialises the Old and New references for the columns of the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| smaddali 10-jun-03 adding ucas_cycle and obsoleting timestamp columns for ucfd203 bug#2669208
|| (reverse chronological order - newest change first)
*/
CURSOR cur_old_ref_values IS
SELECT *
FROM IGS_UC_APP_CHOICES
WHERE rowid = x_rowid;
IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
CLOSE cur_old_ref_values;
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
IF (p_action = 'UPDATE') THEN
new_references.creation_date := old_references.creation_date;
new_references.last_update_date := x_last_update_date;
new_references.last_updated_by := x_last_updated_by;
new_references.last_update_login := x_last_update_login;
SELECT DISTINCT current_inst_code
FROM igs_uc_defaults
WHERE current_inst_code IS NOT NULL;
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
SELECT rowid
FROM igs_uc_app_choices
WHERE app_choice_id = x_app_choice_id ;
SELECT rowid
FROM igs_uc_app_choices
WHERE app_no = x_app_no
AND choice_no = x_choice_no
AND ucas_cycle = x_ucas_cycle
AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
SELECT rowid
FROM igs_uc_app_choices
WHERE ((app_id = x_app_id));
SELECT rowid
FROM igs_uc_app_choices
WHERE ((condition_category = x_condition_category) AND
(condition_code = x_condition_name));
SELECT rowid
FROM igs_uc_app_choices
WHERE ((ucas_program_code = x_ucas_program_code) AND
(institute_code = x_institute_code) AND
(campus = x_campus) AND
(system_code = x_system_code));
x_last_update_date IN DATE ,
x_last_updated_by IN NUMBER ,
x_last_update_login IN NUMBER ,
x_export_to_oss_status IN VARCHAR2,
x_error_code IN VARCHAR2,
x_request_id IN NUMBER,
x_batch_id IN NUMBER,
-- The below column is added newly in UCFD06 - 24SEP2002 - Bug#2574566
x_extra_round_nbr IN NUMBER,
-- The below columns are added newly in UCFD102 - Bug#2643048
x_system_code IN VARCHAR2 ,
x_part_time IN VARCHAR2 ,
x_interview IN DATE ,
x_late_application IN VARCHAR2 ,
x_modular IN VARCHAR2 ,
x_residential IN VARCHAR2 ,
-- smaddali added this column for ucfd203 build bug #2669208
x_ucas_cycle IN NUMBER
) IS
/*
|| Created By : [email protected]
|| Created On : 21-FEB-2002
|| Purpose : Initialises the columns, Checks Constraints, Calls the
|| Trigger Handlers for the table, before any DML operation.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| smaddali 10-jun-03 adding ucas_cycle and obsoleting timestamps for bug#2669208 ucfd203 build
|| (reverse chronological order - newest change first)
*/
BEGIN
set_column_values (
p_action,
x_rowid,
x_app_choice_id,
x_app_id,
x_app_no,
x_choice_no,
x_last_change,
x_institute_code,
x_ucas_program_code,
x_oss_program_code,
x_oss_program_version,
x_oss_attendance_type,
x_oss_attendance_mode,
x_campus,
x_oss_location,
x_faculty,
x_entry_year,
x_entry_month,
x_point_of_entry,
x_home,
x_deferred,
x_route_b_pref_round,
x_route_b_actual_round,
x_condition_category,
x_condition_code,
x_decision,
x_decision_date,
x_decision_number,
x_reply,
x_summary_of_cond,
x_choice_cancelled,
x_action,
x_substitution,
x_date_substituted,
x_prev_institution,
x_prev_course,
x_prev_campus,
x_ucas_amendment,
x_withdrawal_reason,
x_offer_course,
x_offer_campus,
x_offer_crse_length,
x_offer_entry_month,
x_offer_entry_year,
x_offer_entry_point,
x_offer_text,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login ,
x_export_to_oss_status ,
x_error_code ,
x_request_id ,
x_batch_id ,
x_extra_round_nbr ,
x_system_code ,
x_part_time ,
x_interview ,
x_late_application ,
x_modular ,
x_residential ,
-- smaddali added new column for ucfd203 - bug#2669208
x_ucas_cycle );
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation(
new_references.app_choice_id
)
) THEN
fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'UPDATE') THEN
-- Call all the procedures related to Before Update.
check_uniqueness;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation (
new_references.app_choice_id
)
) THEN
fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
check_uniqueness;
ELSIF (p_action = 'DELETE') THEN
-- Call all the procedures related to Before Delete.
check_child_existance;
ELSIF (p_action = 'VALIDATE_DELETE') THEN
check_child_existance;
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2,
x_app_choice_id IN OUT NOCOPY NUMBER,
x_app_id IN NUMBER,
x_app_no IN NUMBER,
x_choice_no IN NUMBER,
x_last_change IN DATE,
x_institute_code IN VARCHAR2,
x_ucas_program_code IN VARCHAR2,
x_oss_program_code IN VARCHAR2,
x_oss_program_version IN NUMBER,
x_oss_attendance_type IN VARCHAR2,
x_oss_attendance_mode IN VARCHAR2,
x_campus IN VARCHAR2,
x_oss_location IN VARCHAR2,
x_faculty IN VARCHAR2,
x_entry_year IN NUMBER,
x_entry_month IN NUMBER,
x_point_of_entry IN NUMBER,
x_home IN VARCHAR2,
x_deferred IN VARCHAR2,
x_route_b_pref_round IN NUMBER,
x_route_b_actual_round IN NUMBER,
x_condition_category IN VARCHAR2,
x_condition_code IN VARCHAR2,
x_decision IN VARCHAR2,
x_decision_date IN DATE,
x_decision_number IN NUMBER,
x_reply IN VARCHAR2,
x_summary_of_cond IN VARCHAR2,
x_choice_cancelled IN VARCHAR2,
x_action IN VARCHAR2,
x_substitution IN VARCHAR2,
x_date_substituted IN DATE,
x_prev_institution IN VARCHAR2,
x_prev_course IN VARCHAR2,
x_prev_campus IN VARCHAR2,
x_ucas_amendment IN VARCHAR2,
x_withdrawal_reason IN VARCHAR2,
x_offer_course IN VARCHAR2,
x_offer_campus IN VARCHAR2,
x_offer_crse_length IN NUMBER,
x_offer_entry_month IN VARCHAR2,
x_offer_entry_year IN VARCHAR2,
x_offer_entry_point IN VARCHAR2,
x_offer_text IN VARCHAR2,
x_mode IN VARCHAR2 ,
x_export_to_oss_status IN VARCHAR2,
x_error_code IN VARCHAR2,
x_request_id IN NUMBER,
x_batch_id IN NUMBER,
-- The below column is added newly in UCFD06 - 24SEP2002 - Bug#2574566
x_extra_round_nbr IN NUMBER,
-- The below column is added newly in UCFD102 - Bug#2643048
x_system_code IN VARCHAR2 ,
x_part_time IN VARCHAR2 ,
x_interview IN DATE ,
x_late_application IN VARCHAR2 ,
x_modular IN VARCHAR2 ,
x_residential IN VARCHAR2 ,
-- smaddali added this column for ucfd203 build bug #2669208
x_ucas_cycle IN NUMBER
) IS
/*
|| Created By : [email protected]
|| Created On : 21-FEB-2002
|| Purpose : Handles the INSERT DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| smaddali 10-jun-03 adding ucas_cycle and obsoleting timestamps for bug#2669208 ucfd203 build
|| (reverse chronological order - newest change first)
*/
CURSOR c IS
SELECT rowid
FROM igs_uc_app_choices
WHERE app_choice_id = x_app_choice_id;
x_last_update_date DATE;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_last_update_date := SYSDATE;
x_last_updated_by := 1;
x_last_update_login := 0;
x_last_updated_by := fnd_global.user_id;
IF (x_last_updated_by IS NULL) THEN
x_last_updated_by := -1;
x_last_update_login := fnd_global.login_id;
IF (x_last_update_login IS NULL) THEN
x_last_update_login := -1;
SELECT igs_uc_app_choices_s.NEXTVAL
INTO x_app_choice_id
FROM dual;
p_action => 'INSERT',
x_rowid => x_rowid,
x_app_choice_id => x_app_choice_id,
x_app_id => x_app_id,
x_app_no => x_app_no,
x_choice_no => x_choice_no,
x_last_change => x_last_change,
x_institute_code => x_institute_code,
x_ucas_program_code => x_ucas_program_code,
x_oss_program_code => x_oss_program_code,
x_oss_program_version => x_oss_program_version,
x_oss_attendance_type => x_oss_attendance_type,
x_oss_attendance_mode => x_oss_attendance_mode,
x_campus => x_campus,
x_oss_location => x_oss_location,
x_faculty => x_faculty,
x_entry_year => x_entry_year,
x_entry_month => x_entry_month,
x_point_of_entry => x_point_of_entry,
x_home => x_home,
x_deferred => x_deferred,
x_route_b_pref_round => x_route_b_pref_round,
x_route_b_actual_round => x_route_b_actual_round,
x_condition_category => x_condition_category,
x_condition_code => x_condition_code,
x_decision => x_decision,
x_decision_date => x_decision_date,
x_decision_number => x_decision_number,
x_reply => x_reply,
x_summary_of_cond => x_summary_of_cond,
x_choice_cancelled => x_choice_cancelled,
x_action => x_action,
x_substitution => x_substitution,
x_date_substituted => x_date_substituted,
x_prev_institution => x_prev_institution,
x_prev_course => x_prev_course,
x_prev_campus => x_prev_campus,
x_ucas_amendment => x_ucas_amendment,
x_withdrawal_reason => x_withdrawal_reason,
x_offer_course => x_offer_course,
x_offer_campus => x_offer_campus,
x_offer_crse_length => x_offer_crse_length,
x_offer_entry_month => x_offer_entry_month,
x_offer_entry_year => x_offer_entry_year,
x_offer_entry_point => x_offer_entry_point,
x_offer_text => x_offer_text,
x_creation_date => x_last_update_date,
x_created_by => x_last_updated_by,
x_last_update_date => x_last_update_date,
x_last_updated_by => x_last_updated_by,
x_last_update_login => x_last_update_login ,
x_export_to_oss_status =>x_export_to_oss_status,
x_error_code =>x_error_code ,
x_request_id =>x_request_id,
x_batch_id =>x_batch_id,
x_extra_round_nbr => x_extra_round_nbr,
x_system_code => x_system_code,
x_part_time => x_part_time ,
x_interview => x_interview ,
x_late_application => x_late_application ,
x_modular => x_modular ,
x_residential => x_residential ,
-- smaddali added new column for ucfd203 - bug#2669208
x_ucas_cycle => x_ucas_cycle
);
INSERT INTO igs_uc_app_choices (
app_choice_id,
app_id,
app_no,
choice_no,
last_change,
institute_code,
ucas_program_code,
oss_program_code,
oss_program_version,
oss_attendance_type,
oss_attendance_mode,
campus,
oss_location,
faculty,
entry_year,
entry_month,
point_of_entry,
home,
deferred,
route_b_pref_round,
route_b_actual_round,
condition_category,
condition_code,
decision,
decision_date,
decision_number,
reply,
summary_of_cond,
choice_cancelled,
action,
substitution,
date_substituted,
prev_institution,
prev_course,
prev_campus,
ucas_amendment,
withdrawal_reason,
offer_course,
offer_campus,
offer_crse_length,
offer_entry_month,
offer_entry_year,
offer_entry_point,
offer_text,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
export_to_oss_status ,
error_code ,
request_id ,
batch_id,
extra_round_nbr,
system_code,
part_time,
interview,
late_application,
modular,
residential,
-- smaddali added new column for ucfd203 - bug#2669208
ucas_cycle
)
VALUES (
new_references.app_choice_id,
new_references.app_id,
new_references.app_no,
new_references.choice_no,
new_references.last_change,
new_references.institute_code,
new_references.ucas_program_code,
new_references.oss_program_code,
new_references.oss_program_version,
new_references.oss_attendance_type,
new_references.oss_attendance_mode,
new_references.campus,
new_references.oss_location,
new_references.faculty,
new_references.entry_year,
new_references.entry_month,
new_references.point_of_entry,
new_references.home,
new_references.deferred,
new_references.route_b_pref_round,
new_references.route_b_actual_round,
new_references.condition_category,
new_references.condition_code,
new_references.decision,
new_references.decision_date,
new_references.decision_number,
new_references.reply,
new_references.summary_of_cond,
new_references.choice_cancelled,
new_references.action,
new_references.substitution,
new_references.date_substituted,
new_references.prev_institution,
new_references.prev_course,
new_references.prev_campus,
new_references.ucas_amendment,
new_references.withdrawal_reason,
new_references.offer_course,
new_references.offer_campus,
new_references.offer_crse_length,
new_references.offer_entry_month,
new_references.offer_entry_year,
new_references.offer_entry_point,
new_references.offer_text,
x_last_update_date,
x_last_updated_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login ,
new_references.export_to_oss_status,
new_references.error_code ,
new_references.request_id ,
new_references.batch_id,
new_references.extra_round_nbr,
new_references.system_code,
new_references.part_time,
new_references.interview,
new_references.late_application,
new_references.modular,
new_references.residential,
-- smaddali added new column for ucfd203 - bug#2669208
new_references.ucas_cycle
);
END insert_row;
SELECT
app_id,
app_no,
choice_no,
last_change,
institute_code,
ucas_program_code,
oss_program_code,
oss_program_version,
oss_attendance_type,
oss_attendance_mode,
campus,
oss_location,
faculty,
entry_year,
entry_month,
point_of_entry,
home,
deferred,
route_b_pref_round,
route_b_actual_round,
condition_category,
condition_code,
decision,
decision_date,
decision_number,
reply,
summary_of_cond,
choice_cancelled,
action,
substitution,
date_substituted,
prev_institution,
prev_course,
prev_campus,
ucas_amendment,
withdrawal_reason,
offer_course,
offer_campus,
offer_crse_length,
offer_entry_month,
offer_entry_year,
offer_entry_point,
offer_text,
export_to_oss_status ,
error_code ,
request_id ,
batch_id,
extra_round_nbr,
-- The below column is added newly in UCFD102 - Bug#2643048
system_code,
part_time,
interview,
late_application,
modular,
residential,
-- smaddali added new column for ucfd203 - bug#2669208
ucas_cycle
FROM igs_uc_app_choices
WHERE rowid = x_rowid
FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_app_choice_id IN NUMBER,
x_app_id IN NUMBER,
x_app_no IN NUMBER,
x_choice_no IN NUMBER,
x_last_change IN DATE,
x_institute_code IN VARCHAR2,
x_ucas_program_code IN VARCHAR2,
x_oss_program_code IN VARCHAR2,
x_oss_program_version IN NUMBER,
x_oss_attendance_type IN VARCHAR2,
x_oss_attendance_mode IN VARCHAR2,
x_campus IN VARCHAR2,
x_oss_location IN VARCHAR2,
x_faculty IN VARCHAR2,
x_entry_year IN NUMBER,
x_entry_month IN NUMBER,
x_point_of_entry IN NUMBER,
x_home IN VARCHAR2,
x_deferred IN VARCHAR2,
x_route_b_pref_round IN NUMBER,
x_route_b_actual_round IN NUMBER,
x_condition_category IN VARCHAR2,
x_condition_code IN VARCHAR2,
x_decision IN VARCHAR2,
x_decision_date IN DATE,
x_decision_number IN NUMBER,
x_reply IN VARCHAR2,
x_summary_of_cond IN VARCHAR2,
x_choice_cancelled IN VARCHAR2,
x_action IN VARCHAR2,
x_substitution IN VARCHAR2,
x_date_substituted IN DATE,
x_prev_institution IN VARCHAR2,
x_prev_course IN VARCHAR2,
x_prev_campus IN VARCHAR2,
x_ucas_amendment IN VARCHAR2,
x_withdrawal_reason IN VARCHAR2,
x_offer_course IN VARCHAR2,
x_offer_campus IN VARCHAR2,
x_offer_crse_length IN NUMBER,
x_offer_entry_month IN VARCHAR2,
x_offer_entry_year IN VARCHAR2,
x_offer_entry_point IN VARCHAR2,
x_offer_text IN VARCHAR2,
x_mode IN VARCHAR2 ,
x_export_to_oss_status IN VARCHAR2,
x_error_code IN VARCHAR2,
x_request_id IN NUMBER,
x_batch_id IN NUMBER,
-- The below column is added newly in UCFD06 - 24SEP2002 - Bug#2574566
x_extra_round_nbr IN NUMBER,
-- The below column is added newly in UCFD102- Bug#2643048
x_system_code IN VARCHAR2 ,
x_part_time IN VARCHAR2 ,
x_interview IN DATE ,
x_late_application IN VARCHAR2 ,
x_modular IN VARCHAR2 ,
x_residential IN VARCHAR2 ,
-- smaddali added this column for ucfd203 build bug #2669208
x_ucas_cycle IN NUMBER
) IS
/*
|| Created By : [email protected]
|| Created On : 21-FEB-2002
|| Purpose : Handles the UPDATE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| smaddali 10-jun-03 adding ucas_cycle and obsoleting timestamps for bug#2669208 ucfd203 build
|| (reverse chronological order - newest change first)
*/
x_last_update_date DATE ;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_last_update_date := SYSDATE;
x_last_updated_by := 1;
x_last_update_login := 0;
x_last_updated_by := fnd_global.user_id;
IF x_last_updated_by IS NULL THEN
x_last_updated_by := -1;
x_last_update_login := fnd_global.login_id;
IF (x_last_update_login IS NULL) THEN
x_last_update_login := -1;
p_action => 'UPDATE',
x_rowid => x_rowid,
x_app_choice_id => x_app_choice_id,
x_app_id => x_app_id,
x_app_no => x_app_no,
x_choice_no => x_choice_no,
x_last_change => x_last_change,
x_institute_code => x_institute_code,
x_ucas_program_code => x_ucas_program_code,
x_oss_program_code => x_oss_program_code,
x_oss_program_version => x_oss_program_version,
x_oss_attendance_type => x_oss_attendance_type,
x_oss_attendance_mode => x_oss_attendance_mode,
x_campus => x_campus,
x_oss_location => x_oss_location,
x_faculty => x_faculty,
x_entry_year => x_entry_year,
x_entry_month => x_entry_month,
x_point_of_entry => x_point_of_entry,
x_home => x_home,
x_deferred => x_deferred,
x_route_b_pref_round => x_route_b_pref_round,
x_route_b_actual_round => x_route_b_actual_round,
x_condition_category => x_condition_category,
x_condition_code => x_condition_code,
x_decision => x_decision,
x_decision_date => x_decision_date,
x_decision_number => x_decision_number,
x_reply => x_reply,
x_summary_of_cond => x_summary_of_cond,
x_choice_cancelled => x_choice_cancelled,
x_action => x_action,
x_substitution => x_substitution,
x_date_substituted => x_date_substituted,
x_prev_institution => x_prev_institution,
x_prev_course => x_prev_course,
x_prev_campus => x_prev_campus,
x_ucas_amendment => x_ucas_amendment,
x_withdrawal_reason => x_withdrawal_reason,
x_offer_course => x_offer_course,
x_offer_campus => x_offer_campus,
x_offer_crse_length => x_offer_crse_length,
x_offer_entry_month => x_offer_entry_month,
x_offer_entry_year => x_offer_entry_year,
x_offer_entry_point => x_offer_entry_point,
x_offer_text => x_offer_text,
x_creation_date => x_last_update_date,
x_created_by => x_last_updated_by,
x_last_update_date => x_last_update_date,
x_last_updated_by => x_last_updated_by,
x_last_update_login => x_last_update_login ,
x_export_to_oss_status =>x_export_to_oss_status,
x_error_code =>x_error_code ,
x_request_id =>x_request_id,
x_batch_id =>x_batch_id,
x_extra_round_nbr =>x_extra_round_nbr,
x_system_code =>x_system_code ,
x_part_time =>x_part_time,
x_interview =>x_interview,
x_late_application =>x_late_application,
x_modular =>x_modular,
x_residential =>x_residential,
-- smaddali added new column for ucfd203 - bug#2669208
x_ucas_cycle => x_ucas_cycle
);
UPDATE igs_uc_app_choices
SET
app_id = new_references.app_id,
app_no = new_references.app_no,
choice_no = new_references.choice_no,
last_change = new_references.last_change,
institute_code = new_references.institute_code,
ucas_program_code = new_references.ucas_program_code,
oss_program_code = new_references.oss_program_code,
oss_program_version = new_references.oss_program_version,
oss_attendance_type = new_references.oss_attendance_type,
oss_attendance_mode = new_references.oss_attendance_mode,
campus = new_references.campus,
oss_location = new_references.oss_location,
faculty = new_references.faculty,
entry_year = new_references.entry_year,
entry_month = new_references.entry_month,
point_of_entry = new_references.point_of_entry,
home = new_references.home,
deferred = new_references.deferred,
route_b_pref_round = new_references.route_b_pref_round,
route_b_actual_round = new_references.route_b_actual_round,
condition_category = new_references.condition_category,
condition_code = new_references.condition_code,
decision = new_references.decision,
decision_date = new_references.decision_date,
decision_number = new_references.decision_number,
reply = new_references.reply,
summary_of_cond = new_references.summary_of_cond,
choice_cancelled = new_references.choice_cancelled,
action = new_references.action,
substitution = new_references.substitution,
date_substituted = new_references.date_substituted,
prev_institution = new_references.prev_institution,
prev_course = new_references.prev_course,
prev_campus = new_references.prev_campus,
ucas_amendment = new_references.ucas_amendment,
withdrawal_reason = new_references.withdrawal_reason,
offer_course = new_references.offer_course,
offer_campus = new_references.offer_campus,
offer_crse_length = new_references.offer_crse_length,
offer_entry_month = new_references.offer_entry_month,
offer_entry_year = new_references.offer_entry_year,
offer_entry_point = new_references.offer_entry_point,
offer_text = new_references.offer_text,
last_update_date = new_references.last_update_date,
last_updated_by = new_references.last_updated_by,
last_update_login = new_references.last_update_login ,
export_to_oss_status = new_references.export_to_oss_status,
error_code = new_references.error_code ,
request_id = new_references.request_id,
batch_id = new_references.batch_id,
extra_round_nbr = new_references.extra_round_nbr,
-- The below column is added newly in UCFD102- Bug#2643048
system_code = new_references.system_code,
part_time = new_references.part_time ,
interview = new_references.interview ,
late_application = new_references.late_application ,
modular = new_references.modular,
residential = new_references.residential,
-- smaddali added new column for ucfd203 - bug#2669208
ucas_cycle = new_references.ucas_cycle
WHERE rowid = x_rowid;
END update_row;
|| Purpose : Adds a row if there is no existing row, otherwise updates existing row in the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| smaddali 10-jun-03 adding ucas_cycle and obsoleting timestamps for bug#2669208 ucfd203 build
|| (reverse chronological order - newest change first)
*/
CURSOR c1 IS
SELECT rowid
FROM igs_uc_app_choices
WHERE app_choice_id = x_app_choice_id;
insert_row (
x_rowid,
x_app_choice_id,
x_app_id,
x_app_no,
x_choice_no,
x_last_change,
x_institute_code,
x_ucas_program_code,
x_oss_program_code,
x_oss_program_version,
x_oss_attendance_type,
x_oss_attendance_mode,
x_campus,
x_oss_location,
x_faculty,
x_entry_year,
x_entry_month,
x_point_of_entry,
x_home,
x_deferred,
x_route_b_pref_round,
x_route_b_actual_round,
x_condition_category,
x_condition_code,
x_decision,
x_decision_date,
x_decision_number,
x_reply,
x_summary_of_cond,
x_choice_cancelled,
x_action,
x_substitution,
x_date_substituted,
x_prev_institution,
x_prev_course,
x_prev_campus,
x_ucas_amendment,
x_withdrawal_reason,
x_offer_course,
x_offer_campus,
x_offer_crse_length,
x_offer_entry_month,
x_offer_entry_year,
x_offer_entry_point,
x_offer_text,
x_mode ,
x_export_to_oss_status ,
x_error_code ,
x_request_id ,
x_batch_id ,
x_extra_round_nbr,
x_system_code ,
x_part_time ,
x_interview ,
x_late_application ,
x_modular ,
x_residential ,
-- smaddali added new column for ucfd203 - bug#2669208
x_ucas_cycle
);
update_row (
x_rowid,
x_app_choice_id,
x_app_id,
x_app_no,
x_choice_no,
x_last_change,
x_institute_code,
x_ucas_program_code,
x_oss_program_code,
x_oss_program_version,
x_oss_attendance_type,
x_oss_attendance_mode,
x_campus,
x_oss_location,
x_faculty,
x_entry_year,
x_entry_month,
x_point_of_entry,
x_home,
x_deferred,
x_route_b_pref_round,
x_route_b_actual_round,
x_condition_category,
x_condition_code,
x_decision,
x_decision_date,
x_decision_number,
x_reply,
x_summary_of_cond,
x_choice_cancelled,
x_action,
x_substitution,
x_date_substituted,
x_prev_institution,
x_prev_course,
x_prev_campus,
x_ucas_amendment,
x_withdrawal_reason,
x_offer_course,
x_offer_campus,
x_offer_crse_length,
x_offer_entry_month,
x_offer_entry_year,
x_offer_entry_point,
x_offer_text,
x_mode ,
x_export_to_oss_status ,
x_error_code ,
x_request_id ,
x_batch_id ,
x_extra_round_nbr,
x_system_code ,
x_part_time ,
x_interview ,
x_late_application ,
x_modular ,
x_residential ,
-- smaddali added new column for ucfd203 - bug#2669208
x_ucas_cycle
);
PROCEDURE delete_row (
x_rowid IN VARCHAR2,
x_mode IN VARCHAR2
) IS
/*
|| Created By : [email protected]
|| Created On : 21-FEB-2002
|| Purpose : Handles the DELETE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
*/
BEGIN
before_dml (
p_action => 'DELETE',
x_rowid => x_rowid
);
DELETE FROM igs_uc_app_choices
WHERE rowid = x_rowid;
END delete_row;