[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_cl_rec_status_last_update IN DATE DEFAULT NULL,
x_alt_prog_type_code IN VARCHAR2 DEFAULT NULL,
x_alt_appl_ver_code IN NUMBER DEFAULT NULL,
x_mpn_confirm_code IN VARCHAR2 DEFAULT NULL,
x_resp_to_orig_code IN VARCHAR2 DEFAULT NULL,
x_appl_loan_phase_code IN VARCHAR2 DEFAULT NULL,
x_appl_loan_phase_code_chg IN DATE DEFAULT NULL,
x_appl_send_error_codes IN VARCHAR2 DEFAULT NULL,
x_tot_outstd_stafford IN NUMBER DEFAULT NULL,
x_tot_outstd_plus IN NUMBER DEFAULT NULL,
x_alt_borw_tot_debt IN NUMBER DEFAULT NULL,
x_act_interest_rate IN NUMBER DEFAULT NULL,
x_service_type_code IN VARCHAR2 DEFAULT NULL,
x_rev_notice_of_guarnt IN VARCHAR2 DEFAULT NULL,
x_sch_refund_amt IN NUMBER DEFAULT NULL,
x_sch_refund_date IN DATE DEFAULT NULL,
x_uniq_layout_vend_code IN VARCHAR2 DEFAULT NULL,
x_uniq_layout_ident_code IN VARCHAR2 DEFAULT NULL,
x_p_person_id IN NUMBER DEFAULT NULL,
x_p_ssn_chg_date IN DATE DEFAULT NULL,
x_p_dob_chg_date IN DATE DEFAULT NULL,
x_p_permt_addr_chg_date IN DATE DEFAULT NULL,
x_p_default_status IN VARCHAR2 DEFAULT NULL,
x_p_signature_code IN VARCHAR2 DEFAULT NULL,
x_p_signature_date IN DATE DEFAULT NULL,
x_s_ssn_chg_date IN DATE DEFAULT NULL,
x_s_dob_chg_date IN DATE DEFAULT NULL,
x_s_permt_addr_chg_date IN DATE DEFAULT NULL,
x_s_local_addr_chg_date IN DATE DEFAULT NULL,
x_s_default_status IN VARCHAR2 DEFAULT NULL,
x_s_signature_code IN VARCHAR2 DEFAULT NULL,
x_creation_date IN DATE DEFAULT NULL,
x_created_by IN NUMBER DEFAULT NULL,
x_last_update_date IN DATE DEFAULT NULL,
x_last_updated_by IN NUMBER DEFAULT NULL,
x_last_update_login IN NUMBER DEFAULT NULL,
x_pnote_batch_id IN VARCHAR2 DEFAULT NULL,
x_pnote_ack_date IN DATE DEFAULT NULL,
x_pnote_mpn_ind IN VARCHAR2 DEFAULT NULL,
x_elec_mpn_ind IN VARCHAR2 DEFAULT NULL,
x_borr_sign_ind IN VARCHAR2 DEFAULT NULL,
x_stud_sign_ind IN VARCHAR2 DEFAULT NULL,
x_borr_credit_auth_code IN VARCHAR2 DEFAULT NULL,
x_relationship_cd IN VARCHAR2 DEFAULT NULL,
x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
x_cps_trans_num IN NUMBER DEFAULT NULL,
x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
x_note_message IN VARCHAR2 DEFAULT NULL,
x_book_loan_amt IN NUMBER DEFAULT NULL,
x_book_loan_amt_date IN DATE DEFAULT NULL,
x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
x_pymt_servicer_date IN DATE DEFAULT NULL,
x_external_loan_id_txt IN VARCHAR2 ,
x_deferment_request_code IN VARCHAR2 ,
x_eft_authorization_code IN VARCHAR2 ,
x_requested_loan_amt IN NUMBER ,
x_actual_record_type_code IN VARCHAR2 ,
x_reinstatement_amt IN NUMBER ,
x_school_use_txt IN VARCHAR2 ,
x_lender_use_txt IN VARCHAR2 ,
x_guarantor_use_txt IN VARCHAR2 ,
x_fls_approved_amt IN NUMBER ,
x_flu_approved_amt IN NUMBER ,
x_flp_approved_amt IN NUMBER ,
x_alt_approved_amt IN NUMBER ,
x_loan_app_form_code IN VARCHAR2 ,
x_override_grade_level_code IN VARCHAR2 ,
x_b_alien_reg_num_txt IN VARCHAR2 ,
x_esign_src_typ_cd IN VARCHAR2 ,
x_acad_begin_date IN DATE ,
x_acad_end_date IN DATE
) AS
/*
|| Created By : venagara
|| Created On : 02-DEC-2000
|| Purpose : Initialises the Old and New references for the columns of the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| smadathi 14-oct-2004 Bug 3416936.Added new column as per TD.
|| (reverse chronological order - newest change first)
*/
CURSOR cur_old_ref_values IS
SELECT *
FROM IGF_SL_LOR_ALL
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;
new_references.cl_rec_status_last_update := x_cl_rec_status_last_update ;
PROCEDURE AfterRowInsertUpdateDelete1(
p_inserting IN BOOLEAN ,
p_updating IN BOOLEAN ,
p_deleting IN BOOLEAN
) AS
/*-----------------------------------------------------------------
|| Created By : Sanil Madathil
|| Created On : 13-Oct-2004
|| Purpose :
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| bvisvana 02-Mar-2006 Bug# 5006583, FA161 CL4. modified condition for g_v_called_from in ('IGFSL007',' UPDATE_MODE')
|| (reverse chronological order - newest change first)
--------------------------------------------------------------------*/
CURSOR c_igf_sl_loans(cp_n_loan_id igf_sl_loans.loan_id%TYPE) IS
SELECT award_id
FROM igf_sl_loans_all
WHERE loan_id = cp_n_loan_id;
IF g_v_called_from IN ('IGFSL007','UPDATE_MODE') THEN
--bvisvana bug# 5091388
IF ((NVL(new_references.anticip_compl_date,l_null_date_check) <> NVL(old_references.anticip_compl_date,l_null_date_check)) OR
(NVL(new_references.override_grade_level_code,'*') <> NVL(old_references.override_grade_level_code,'*')) OR
((NVL(new_references.grade_level_code,'*') <> NVL(old_references.grade_level_code,'*')) AND g_v_called_from = 'UPDATE_MODE')
) THEN
-- invoke the procedure to create of change record in igf_sl_clchsn_dtls table
igf_sl_cl_create_chg.create_lor_chg_rec
(
p_new_lor_rec => new_references,
p_b_return_status => l_b_return_status,
p_v_message_name => l_v_message_name
);
END AfterRowInsertUpdateDelete1;
fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
SELECT rowid
FROM igf_sl_lor_all
WHERE origination_id = x_origination_id
FOR UPDATE NOWAIT;
SELECT rowid
FROM igf_sl_lor_all
WHERE loan_id = x_loan_id
AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
SELECT rowid
FROM igf_sl_lor_all
WHERE ((p_person_id = x_party_id));
SELECT rowid
FROM igf_sl_lor_all
WHERE ((loan_id = x_loan_id));
SELECT rowid
FROM igf_sl_lor_all
WHERE ((relationship_cd = x_relationship_cd));
x_cl_rec_status_last_update IN DATE DEFAULT NULL,
x_alt_prog_type_code IN VARCHAR2 DEFAULT NULL,
x_alt_appl_ver_code IN NUMBER DEFAULT NULL,
x_mpn_confirm_code IN VARCHAR2 DEFAULT NULL,
x_resp_to_orig_code IN VARCHAR2 DEFAULT NULL,
x_appl_loan_phase_code IN VARCHAR2 DEFAULT NULL,
x_appl_loan_phase_code_chg IN DATE DEFAULT NULL,
x_appl_send_error_codes IN VARCHAR2 DEFAULT NULL,
x_tot_outstd_stafford IN NUMBER DEFAULT NULL,
x_tot_outstd_plus IN NUMBER DEFAULT NULL,
x_alt_borw_tot_debt IN NUMBER DEFAULT NULL,
x_act_interest_rate IN NUMBER DEFAULT NULL,
x_service_type_code IN VARCHAR2 DEFAULT NULL,
x_rev_notice_of_guarnt IN VARCHAR2 DEFAULT NULL,
x_sch_refund_amt IN NUMBER DEFAULT NULL,
x_sch_refund_date IN DATE DEFAULT NULL,
x_uniq_layout_vend_code IN VARCHAR2 DEFAULT NULL,
x_uniq_layout_ident_code IN VARCHAR2 DEFAULT NULL,
x_p_person_id IN NUMBER DEFAULT NULL,
x_p_ssn_chg_date IN DATE DEFAULT NULL,
x_p_dob_chg_date IN DATE DEFAULT NULL,
x_p_permt_addr_chg_date IN DATE DEFAULT NULL,
x_p_default_status IN VARCHAR2 DEFAULT NULL,
x_p_signature_code IN VARCHAR2 DEFAULT NULL,
x_p_signature_date IN DATE DEFAULT NULL,
x_s_ssn_chg_date IN DATE DEFAULT NULL,
x_s_dob_chg_date IN DATE DEFAULT NULL,
x_s_permt_addr_chg_date IN DATE DEFAULT NULL,
x_s_local_addr_chg_date IN DATE DEFAULT NULL,
x_s_default_status IN VARCHAR2 DEFAULT NULL,
x_s_signature_code IN VARCHAR2 DEFAULT NULL,
x_creation_date IN DATE DEFAULT NULL,
x_created_by IN NUMBER DEFAULT NULL,
x_last_update_date IN DATE DEFAULT NULL,
x_last_updated_by IN NUMBER DEFAULT NULL,
x_last_update_login IN NUMBER DEFAULT NULL,
x_pnote_batch_id IN VARCHAR2 DEFAULT NULL,
x_pnote_ack_date IN DATE DEFAULT NULL,
x_pnote_mpn_ind IN VARCHAR2 DEFAULT NULL,
x_elec_mpn_ind IN VARCHAR2 DEFAULT NULL,
x_borr_sign_ind IN VARCHAR2 DEFAULT NULL,
x_stud_sign_ind IN VARCHAR2 DEFAULT NULL,
x_borr_credit_auth_code IN VARCHAR2 DEFAULT NULL,
x_relationship_cd IN VARCHAR2 DEFAULT NULL,
x_interest_rebate_percent_num IN NUMBER DEFAULT NULL,
x_cps_trans_num IN NUMBER DEFAULT NULL,
x_atd_entity_id_txt IN VARCHAR2 DEFAULT NULL,
x_rep_entity_id_txt IN VARCHAR2 DEFAULT NULL,
x_crdt_decision_status IN VARCHAR2 DEFAULT NULL,
x_note_message IN VARCHAR2 DEFAULT NULL,
x_book_loan_amt IN NUMBER DEFAULT NULL,
x_book_loan_amt_date IN DATE DEFAULT NULL,
x_pymt_servicer_amt IN NUMBER DEFAULT NULL,
x_pymt_servicer_date IN DATE DEFAULT NULL,
x_external_loan_id_txt IN VARCHAR2 ,
x_deferment_request_code IN VARCHAR2 ,
x_eft_authorization_code IN VARCHAR2 ,
x_requested_loan_amt IN NUMBER ,
x_actual_record_type_code IN VARCHAR2 ,
x_reinstatement_amt IN NUMBER ,
x_school_use_txt IN VARCHAR2 ,
x_lender_use_txt IN VARCHAR2 ,
x_guarantor_use_txt IN VARCHAR2 ,
x_fls_approved_amt IN NUMBER ,
x_flu_approved_amt IN NUMBER ,
x_flp_approved_amt IN NUMBER ,
x_alt_approved_amt IN NUMBER ,
x_loan_app_form_code IN VARCHAR2 ,
x_override_grade_level_code IN VARCHAR2 ,
x_b_alien_reg_num_txt IN VARCHAR2 ,
x_esign_src_typ_cd IN VARCHAR2 ,
x_acad_begin_date IN DATE ,
x_acad_end_date IN DATE
) AS
/*
|| Created By : venagara
|| Created On : 02-DEC-2000
|| 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
|| smadathi 14-oct-2004 Bug 3416936.Added new column as per TD.
|| (reverse chronological order - newest change first)
*/
BEGIN
set_column_values (
p_action,
x_rowid,
x_origination_id,
x_loan_id,
x_sch_cert_date,
x_orig_status_flag,
x_orig_batch_id,
x_orig_batch_date,
x_chg_batch_id,
x_orig_ack_date,
x_credit_override,
x_credit_decision_date,
x_req_serial_loan_code,
x_act_serial_loan_code,
x_pnote_delivery_code,
x_pnote_status,
x_pnote_status_date,
x_pnote_id,
x_pnote_print_ind,
x_pnote_accept_amt,
x_pnote_accept_date,
x_unsub_elig_for_heal,
x_disclosure_print_ind,
x_orig_fee_perct,
x_borw_confirm_ind,
x_borw_interest_ind,
x_borw_outstd_loan_code,
x_unsub_elig_for_depnt,
x_guarantee_amt,
x_guarantee_date,
x_guarnt_amt_redn_code,
x_guarnt_status_code,
x_guarnt_status_date,
x_lend_apprv_denied_code,
x_lend_apprv_denied_date,
x_lend_status_code,
x_lend_status_date,
x_guarnt_adj_ind,
x_grade_level_code,
x_enrollment_code,
x_anticip_compl_date,
x_borw_lender_id,
x_duns_borw_lender_id,
x_guarantor_id,
x_duns_guarnt_id,
x_prc_type_code,
x_cl_seq_number,
x_last_resort_lender,
x_lender_id,
x_duns_lender_id,
x_lend_non_ed_brc_id,
x_recipient_id,
x_recipient_type,
x_duns_recip_id,
x_recip_non_ed_brc_id,
x_rec_type_ind,
x_cl_loan_type,
x_cl_rec_status,
x_cl_rec_status_last_update,
x_alt_prog_type_code,
x_alt_appl_ver_code,
x_mpn_confirm_code,
x_resp_to_orig_code,
x_appl_loan_phase_code,
x_appl_loan_phase_code_chg,
x_appl_send_error_codes,
x_tot_outstd_stafford,
x_tot_outstd_plus,
x_alt_borw_tot_debt,
x_act_interest_rate,
x_service_type_code,
x_rev_notice_of_guarnt,
x_sch_refund_amt,
x_sch_refund_date,
x_uniq_layout_vend_code,
x_uniq_layout_ident_code,
x_p_person_id,
x_p_ssn_chg_date,
x_p_dob_chg_date,
x_p_permt_addr_chg_date,
x_p_default_status,
x_p_signature_code,
x_p_signature_date,
x_s_ssn_chg_date,
x_s_dob_chg_date,
x_s_permt_addr_chg_date,
x_s_local_addr_chg_date,
x_s_default_status,
x_s_signature_code,
x_creation_date,
x_created_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login,
x_pnote_batch_id,
x_pnote_ack_date,
x_pnote_mpn_ind,
x_elec_mpn_ind,
x_borr_sign_ind,
x_stud_sign_ind,
x_borr_credit_auth_code,
x_relationship_cd,
x_interest_rebate_percent_num,
x_cps_trans_num,
x_atd_entity_id_txt,
x_rep_entity_id_txt,
x_crdt_decision_status,
x_note_message,
x_book_loan_amt,
x_book_loan_amt_date,
x_pymt_servicer_amt,
x_pymt_servicer_date,
x_external_loan_id_txt ,
x_deferment_request_code ,
x_eft_authorization_code ,
x_requested_loan_amt ,
x_actual_record_type_code ,
x_reinstatement_amt ,
x_school_use_txt ,
x_lender_use_txt ,
x_guarantor_use_txt ,
x_fls_approved_amt ,
x_flu_approved_amt ,
x_flp_approved_amt ,
x_alt_approved_amt ,
x_loan_app_form_code ,
x_override_grade_level_code ,
x_b_alien_reg_num_txt ,
x_esign_src_typ_cd ,
x_acad_begin_date ,
x_acad_end_date
);
IF (p_action = 'INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation(
new_references.origination_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 = 'DELETE') THEN
-- Call all the procedures related to Before Delete.
check_child_existance;
ELSIF (p_action = 'VALIDATE_INSERT') THEN
-- Call all the procedures related to Before Insert.
IF ( get_pk_for_validation (
new_references.origination_id
)
) THEN
fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
ELSIF (p_action = 'VALIDATE_UPDATE') THEN
check_uniqueness;
ELSIF (p_action = 'VALIDATE_DELETE') THEN
check_child_existance;
|| to insert records
|| Change History :
|| Who When What
|| smadathi 14-oct-2004 Bug 3416936.Added new column as per TD.
|| (reverse chronological order - newest change first)
*/
l_pnote_stat_h_rowid VARCHAR2(30) := NULL;
IF (p_action = 'UPDATE') THEN
-- Call all the procedures related to After Update.
AfterRowInsertUpdateDelete1
(
p_inserting => FALSE,
p_updating => TRUE ,
p_deleting => FALSE
);
IF (p_action = 'UPDATE') AND ( new_references.pnote_status = old_references.pnote_status ) THEN
null;
igf_sl_pnote_stat_h_pkg.insert_row (
x_mode => 'R',
x_rowid => l_pnote_stat_h_rowid,
x_dlpnh_id => l_dlpnh_id,
x_loan_id => new_references.loan_id,
x_pnote_status => new_references.pnote_status,
x_pnote_status_date => SYSDATE
);
PROCEDURE insert_row (
x_rowid IN OUT NOCOPY VARCHAR2,
x_origination_id IN OUT NOCOPY NUMBER,
x_loan_id IN NUMBER,
x_sch_cert_date IN DATE,
x_orig_status_flag IN VARCHAR2,
x_orig_batch_id IN VARCHAR2,
x_orig_batch_date IN DATE,
x_chg_batch_id IN VARCHAR2,
x_orig_ack_date IN DATE,
x_credit_override IN VARCHAR2,
x_credit_decision_date IN DATE,
x_req_serial_loan_code IN VARCHAR2,
x_act_serial_loan_code IN VARCHAR2,
x_pnote_delivery_code IN VARCHAR2,
x_pnote_status IN VARCHAR2,
x_pnote_status_date IN DATE,
x_pnote_id IN VARCHAR2,
x_pnote_print_ind IN VARCHAR2,
x_pnote_accept_amt IN NUMBER,
x_pnote_accept_date IN DATE,
x_unsub_elig_for_heal IN VARCHAR2,
x_disclosure_print_ind IN VARCHAR2,
x_orig_fee_perct IN NUMBER,
x_borw_confirm_ind IN VARCHAR2,
x_borw_interest_ind IN VARCHAR2,
x_borw_outstd_loan_code IN VARCHAR2,
x_unsub_elig_for_depnt IN VARCHAR2,
x_guarantee_amt IN NUMBER,
x_guarantee_date IN DATE,
x_guarnt_amt_redn_code IN VARCHAR2,
x_guarnt_status_code IN VARCHAR2,
x_guarnt_status_date IN DATE,
x_lend_apprv_denied_code IN VARCHAR2,
x_lend_apprv_denied_date IN DATE,
x_lend_status_code IN VARCHAR2,
x_lend_status_date IN DATE,
x_guarnt_adj_ind IN VARCHAR2,
x_grade_level_code IN VARCHAR2,
x_enrollment_code IN VARCHAR2,
x_anticip_compl_date IN DATE,
x_borw_lender_id IN VARCHAR2,
x_duns_borw_lender_id IN VARCHAR2,
x_guarantor_id IN VARCHAR2,
x_duns_guarnt_id IN VARCHAR2,
x_prc_type_code IN VARCHAR2,
x_cl_seq_number IN NUMBER,
x_last_resort_lender IN VARCHAR2,
x_lender_id IN VARCHAR2,
x_duns_lender_id IN VARCHAR2,
x_lend_non_ed_brc_id IN VARCHAR2,
x_recipient_id IN VARCHAR2,
x_recipient_type IN VARCHAR2,
x_duns_recip_id IN VARCHAR2,
x_recip_non_ed_brc_id IN VARCHAR2,
x_rec_type_ind IN VARCHAR2,
x_cl_loan_type IN VARCHAR2,
x_cl_rec_status IN VARCHAR2,
x_cl_rec_status_last_update IN DATE,
x_alt_prog_type_code IN VARCHAR2,
x_alt_appl_ver_code IN NUMBER,
x_mpn_confirm_code IN VARCHAR2,
x_resp_to_orig_code IN VARCHAR2,
x_appl_loan_phase_code IN VARCHAR2,
x_appl_loan_phase_code_chg IN DATE,
x_appl_send_error_codes IN VARCHAR2,
x_tot_outstd_stafford IN NUMBER,
x_tot_outstd_plus IN NUMBER,
x_alt_borw_tot_debt IN NUMBER,
x_act_interest_rate IN NUMBER,
x_service_type_code IN VARCHAR2,
x_rev_notice_of_guarnt IN VARCHAR2,
x_sch_refund_amt IN NUMBER,
x_sch_refund_date IN DATE,
x_uniq_layout_vend_code IN VARCHAR2,
x_uniq_layout_ident_code IN VARCHAR2,
x_p_person_id IN NUMBER,
x_p_ssn_chg_date IN DATE,
x_p_dob_chg_date IN DATE,
x_p_permt_addr_chg_date IN DATE,
x_p_default_status IN VARCHAR2,
x_p_signature_code IN VARCHAR2,
x_p_signature_date IN DATE,
x_s_ssn_chg_date IN DATE,
x_s_dob_chg_date IN DATE,
x_s_permt_addr_chg_date IN DATE,
x_s_local_addr_chg_date IN DATE,
x_s_default_status IN VARCHAR2,
x_s_signature_code IN VARCHAR2,
x_mode IN VARCHAR2 DEFAULT 'R',
x_pnote_batch_id IN VARCHAR2,
x_pnote_ack_date IN DATE,
x_pnote_mpn_ind IN VARCHAR2,
x_elec_mpn_ind IN VARCHAR2,
x_borr_sign_ind IN VARCHAR2,
x_stud_sign_ind IN VARCHAR2,
x_borr_credit_auth_code IN VARCHAR2,
x_relationship_cd IN VARCHAR2,
x_interest_rebate_percent_num IN NUMBER,
x_cps_trans_num IN NUMBER,
x_atd_entity_id_txt IN VARCHAR2,
x_rep_entity_id_txt IN VARCHAR2,
x_crdt_decision_status IN VARCHAR2,
x_note_message IN VARCHAR2,
x_book_loan_amt IN NUMBER,
x_book_loan_amt_date IN DATE,
x_pymt_servicer_amt IN NUMBER,
x_pymt_servicer_date IN DATE ,
x_external_loan_id_txt IN VARCHAR2 ,
x_deferment_request_code IN VARCHAR2 ,
x_eft_authorization_code IN VARCHAR2 ,
x_requested_loan_amt IN NUMBER ,
x_actual_record_type_code IN VARCHAR2 ,
x_reinstatement_amt IN NUMBER ,
x_school_use_txt IN VARCHAR2 ,
x_lender_use_txt IN VARCHAR2 ,
x_guarantor_use_txt IN VARCHAR2 ,
x_fls_approved_amt IN NUMBER ,
x_flu_approved_amt IN NUMBER ,
x_flp_approved_amt IN NUMBER ,
x_alt_approved_amt IN NUMBER ,
x_loan_app_form_code IN VARCHAR2 ,
x_override_grade_level_code IN VARCHAR2 ,
x_b_alien_reg_num_txt IN VARCHAR2 ,
x_esign_src_typ_cd IN VARCHAR2 ,
x_acad_begin_date IN DATE ,
x_acad_end_date IN DATE
) AS
/*
|| Created By : venagara
|| Created On : 02-DEC-2000
|| Purpose : Handles the INSERT DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| smadathi 14-oct-2004 Bug 3416936.Added new column as per TD.
|| viramali 12-MAY-01 added call to after_dml
*/
CURSOR c IS
SELECT rowid
FROM igf_sl_lor_all
WHERE origination_id = x_origination_id;
x_last_update_date DATE;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_program_update_date DATE;
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;
x_program_update_date := NULL;
x_program_update_date := SYSDATE;
SELECT igf_sl_lor_s.nextval INTO x_origination_id FROM DUAL;
p_action => 'INSERT',
x_rowid => x_rowid,
x_origination_id => x_origination_id,
x_loan_id => x_loan_id,
x_sch_cert_date => x_sch_cert_date,
x_orig_status_flag => x_orig_status_flag,
x_orig_batch_id => x_orig_batch_id,
x_orig_batch_date => x_orig_batch_date,
x_chg_batch_id => x_chg_batch_id,
x_orig_ack_date => x_orig_ack_date,
x_credit_override => x_credit_override,
x_credit_decision_date => x_credit_decision_date,
x_req_serial_loan_code => x_req_serial_loan_code,
x_act_serial_loan_code => x_act_serial_loan_code,
x_pnote_delivery_code => x_pnote_delivery_code,
x_pnote_status => x_pnote_status,
x_pnote_status_date => x_pnote_status_date,
x_pnote_id => x_pnote_id,
x_pnote_print_ind => x_pnote_print_ind,
x_pnote_accept_amt => x_pnote_accept_amt,
x_pnote_accept_date => x_pnote_accept_date,
x_unsub_elig_for_heal => x_unsub_elig_for_heal,
x_disclosure_print_ind => x_disclosure_print_ind,
x_orig_fee_perct => x_orig_fee_perct,
x_borw_confirm_ind => x_borw_confirm_ind,
x_borw_interest_ind => x_borw_interest_ind,
x_borw_outstd_loan_code => x_borw_outstd_loan_code,
x_unsub_elig_for_depnt => x_unsub_elig_for_depnt,
x_guarantee_amt => x_guarantee_amt,
x_guarantee_date => x_guarantee_date,
x_guarnt_amt_redn_code => x_guarnt_amt_redn_code,
x_guarnt_status_code => x_guarnt_status_code,
x_guarnt_status_date => x_guarnt_status_date,
x_lend_apprv_denied_code => x_lend_apprv_denied_code,
x_lend_apprv_denied_date => x_lend_apprv_denied_date,
x_lend_status_code => x_lend_status_code,
x_lend_status_date => x_lend_status_date,
x_guarnt_adj_ind => x_guarnt_adj_ind,
x_grade_level_code => x_grade_level_code,
x_enrollment_code => x_enrollment_code,
x_anticip_compl_date => x_anticip_compl_date,
x_borw_lender_id => x_borw_lender_id,
x_duns_borw_lender_id => x_duns_borw_lender_id,
x_guarantor_id => x_guarantor_id,
x_duns_guarnt_id => x_duns_guarnt_id,
x_prc_type_code => x_prc_type_code,
x_cl_seq_number => x_cl_seq_number,
x_last_resort_lender => x_last_resort_lender,
x_lender_id => x_lender_id,
x_duns_lender_id => x_duns_lender_id,
x_lend_non_ed_brc_id => x_lend_non_ed_brc_id,
x_recipient_id => x_recipient_id,
x_recipient_type => x_recipient_type,
x_duns_recip_id => x_duns_recip_id,
x_recip_non_ed_brc_id => x_recip_non_ed_brc_id,
x_rec_type_ind => x_rec_type_ind,
x_cl_loan_type => x_cl_loan_type,
x_cl_rec_status => x_cl_rec_status,
x_cl_rec_status_last_update => x_cl_rec_status_last_update,
x_alt_prog_type_code => x_alt_prog_type_code,
x_alt_appl_ver_code => x_alt_appl_ver_code,
x_mpn_confirm_code => x_mpn_confirm_code,
x_resp_to_orig_code => x_resp_to_orig_code,
x_appl_loan_phase_code => x_appl_loan_phase_code,
x_appl_loan_phase_code_chg => x_appl_loan_phase_code_chg,
x_appl_send_error_codes => x_appl_send_error_codes,
x_tot_outstd_stafford => x_tot_outstd_stafford,
x_tot_outstd_plus => x_tot_outstd_plus,
x_alt_borw_tot_debt => x_alt_borw_tot_debt,
x_act_interest_rate => x_act_interest_rate,
x_service_type_code => x_service_type_code,
x_rev_notice_of_guarnt => x_rev_notice_of_guarnt,
x_sch_refund_amt => x_sch_refund_amt,
x_sch_refund_date => x_sch_refund_date,
x_uniq_layout_vend_code => x_uniq_layout_vend_code,
x_uniq_layout_ident_code => x_uniq_layout_ident_code,
x_p_person_id => x_p_person_id,
x_p_ssn_chg_date => x_p_ssn_chg_date,
x_p_dob_chg_date => x_p_dob_chg_date,
x_p_permt_addr_chg_date => x_p_permt_addr_chg_date,
x_p_default_status => x_p_default_status,
x_p_signature_code => x_p_signature_code,
x_p_signature_date => x_p_signature_date,
x_s_ssn_chg_date => x_s_ssn_chg_date,
x_s_dob_chg_date => x_s_dob_chg_date,
x_s_permt_addr_chg_date => x_s_permt_addr_chg_date,
x_s_local_addr_chg_date => x_s_local_addr_chg_date,
x_s_default_status => x_s_default_status,
x_s_signature_code => x_s_signature_code,
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_pnote_batch_id => x_pnote_batch_id,
x_pnote_ack_date => x_pnote_ack_date,
x_pnote_mpn_ind => x_pnote_mpn_ind,
x_elec_mpn_ind => x_elec_mpn_ind,
x_borr_sign_ind => x_borr_sign_ind,
x_stud_sign_ind => x_stud_sign_ind,
x_borr_credit_auth_code => x_borr_credit_auth_code,
x_relationship_cd => x_relationship_cd,
x_interest_rebate_percent_num => x_interest_rebate_percent_num,
x_cps_trans_num => x_cps_trans_num,
x_atd_entity_id_txt => x_atd_entity_id_txt,
x_rep_entity_id_txt => x_rep_entity_id_txt,
x_crdt_decision_status => x_crdt_decision_status,
x_note_message => x_note_message,
x_book_loan_amt => x_book_loan_amt,
x_book_loan_amt_date => x_book_loan_amt_date,
x_pymt_servicer_amt => x_pymt_servicer_amt,
x_pymt_servicer_date => x_pymt_servicer_date,
x_external_loan_id_txt => x_external_loan_id_txt ,
x_deferment_request_code => x_deferment_request_code ,
x_eft_authorization_code => x_eft_authorization_code ,
x_requested_loan_amt => x_requested_loan_amt ,
x_actual_record_type_code => x_actual_record_type_code ,
x_reinstatement_amt => x_reinstatement_amt ,
x_school_use_txt => x_school_use_txt ,
x_lender_use_txt => x_lender_use_txt ,
x_guarantor_use_txt => x_guarantor_use_txt ,
x_fls_approved_amt => x_fls_approved_amt ,
x_flu_approved_amt => x_flu_approved_amt ,
x_flp_approved_amt => x_flp_approved_amt ,
x_alt_approved_amt => x_alt_approved_amt ,
x_loan_app_form_code => x_loan_app_form_code ,
x_override_grade_level_code => x_override_grade_level_code ,
x_b_alien_reg_num_txt => x_b_alien_reg_num_txt ,
x_esign_src_typ_cd => x_esign_src_typ_cd ,
x_acad_begin_date => x_acad_begin_date ,
x_acad_end_date => x_acad_end_date
);
INSERT INTO igf_sl_lor_all(
origination_id,
loan_id,
sch_cert_date,
orig_status_flag,
orig_batch_id,
orig_batch_date,
orig_ack_date,
credit_override,
credit_decision_date,
req_serial_loan_code,
act_serial_loan_code,
pnote_delivery_code,
pnote_status,
pnote_status_date,
pnote_id,
pnote_print_ind,
pnote_accept_amt,
pnote_accept_date,
unsub_elig_for_heal,
disclosure_print_ind,
orig_fee_perct,
borw_confirm_ind,
borw_interest_ind,
borw_outstd_loan_code,
unsub_elig_for_depnt,
guarantee_amt,
guarantee_date,
guarnt_amt_redn_code,
guarnt_status_code,
guarnt_status_date,
lend_status_code,
lend_status_date,
guarnt_adj_ind,
grade_level_code,
enrollment_code,
anticip_compl_date,
prc_type_code,
cl_seq_number,
last_resort_lender,
rec_type_ind,
cl_loan_type,
alt_prog_type_code,
alt_appl_ver_code,
resp_to_orig_code,
tot_outstd_stafford,
tot_outstd_plus,
alt_borw_tot_debt,
act_interest_rate,
service_type_code,
rev_notice_of_guarnt,
sch_refund_amt,
sch_refund_date,
uniq_layout_vend_code,
uniq_layout_ident_code,
p_person_id,
p_permt_addr_chg_date,
p_default_status,
p_signature_code,
p_signature_date,
s_permt_addr_chg_date,
s_default_status,
s_signature_code,
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,
pnote_batch_id,
pnote_ack_date,
pnote_mpn_ind,
elec_mpn_ind,
borr_sign_ind,
stud_sign_ind,
borr_credit_auth_code,
relationship_cd,
interest_rebate_percent_num,
cps_trans_num,
atd_entity_id_txt,
rep_entity_id_txt,
crdt_decision_status,
note_message,
book_loan_amt,
book_loan_amt_date,
pymt_servicer_amt,
pymt_servicer_date,
external_loan_id_txt ,
deferment_request_code ,
eft_authorization_code ,
requested_loan_amt ,
actual_record_type_code ,
reinstatement_amt ,
school_use_txt ,
lender_use_txt ,
guarantor_use_txt ,
fls_approved_amt ,
flu_approved_amt ,
flp_approved_amt ,
alt_approved_amt ,
loan_app_form_code ,
override_grade_level_code ,
appl_loan_phase_code ,
appl_loan_phase_code_chg ,
cl_rec_status ,
cl_rec_status_last_update ,
mpn_confirm_code ,
lend_apprv_denied_code ,
lend_apprv_denied_date ,
b_alien_reg_num_txt ,
esign_src_typ_cd ,
acad_begin_date ,
acad_end_date
) VALUES (
new_references.origination_id,
new_references.loan_id,
new_references.sch_cert_date,
new_references.orig_status_flag,
new_references.orig_batch_id,
new_references.orig_batch_date,
new_references.orig_ack_date,
new_references.credit_override,
new_references.credit_decision_date,
new_references.req_serial_loan_code,
new_references.act_serial_loan_code,
new_references.pnote_delivery_code,
new_references.pnote_status,
new_references.pnote_status_date,
new_references.pnote_id,
new_references.pnote_print_ind,
new_references.pnote_accept_amt,
new_references.pnote_accept_date,
new_references.unsub_elig_for_heal,
new_references.disclosure_print_ind,
new_references.orig_fee_perct,
new_references.borw_confirm_ind,
new_references.borw_interest_ind,
new_references.borw_outstd_loan_code,
new_references.unsub_elig_for_depnt,
new_references.guarantee_amt,
new_references.guarantee_date,
new_references.guarnt_amt_redn_code,
new_references.guarnt_status_code,
new_references.guarnt_status_date,
new_references.lend_status_code,
new_references.lend_status_date,
new_references.guarnt_adj_ind,
new_references.grade_level_code,
new_references.enrollment_code,
new_references.anticip_compl_date,
new_references.prc_type_code,
new_references.cl_seq_number,
new_references.last_resort_lender,
new_references.rec_type_ind,
new_references.cl_loan_type,
new_references.alt_prog_type_code,
new_references.alt_appl_ver_code,
new_references.resp_to_orig_code,
new_references.tot_outstd_stafford,
new_references.tot_outstd_plus,
new_references.alt_borw_tot_debt,
new_references.act_interest_rate,
new_references.service_type_code,
new_references.rev_notice_of_guarnt,
new_references.sch_refund_amt,
new_references.sch_refund_date,
new_references.uniq_layout_vend_code,
new_references.uniq_layout_ident_code,
new_references.p_person_id,
new_references.p_permt_addr_chg_date,
new_references.p_default_status,
new_references.p_signature_code,
new_references.p_signature_date,
new_references.s_permt_addr_chg_date,
new_references.s_default_status,
new_references.s_signature_code,
x_last_update_date,
x_last_updated_by,
x_last_update_date,
x_last_updated_by,
x_last_update_login ,
x_request_id,
x_program_id,
x_program_application_id,
x_program_update_date,
l_org_id,
new_references.pnote_batch_id,
new_references.pnote_ack_date,
new_references.pnote_mpn_ind,
new_references.elec_mpn_ind,
new_references.borr_sign_ind,
new_references.stud_sign_ind,
new_references.borr_credit_auth_code,
new_references.relationship_cd,
new_references.interest_rebate_percent_num,
new_references.cps_trans_num,
new_references.atd_entity_id_txt,
new_references.rep_entity_id_txt,
new_references.crdt_decision_status,
new_references.note_message,
new_references.book_loan_amt,
new_references.book_loan_amt_date,
new_references.pymt_servicer_amt,
new_references.pymt_servicer_date,
new_references.external_loan_id_txt ,
new_references.deferment_request_code ,
new_references.eft_authorization_code ,
new_references.requested_loan_amt ,
new_references.actual_record_type_code ,
new_references.reinstatement_amt ,
new_references.school_use_txt ,
new_references.lender_use_txt ,
new_references.guarantor_use_txt ,
new_references.fls_approved_amt ,
new_references.flu_approved_amt ,
new_references.flp_approved_amt ,
new_references.alt_approved_amt ,
new_references.loan_app_form_code ,
new_references.override_grade_level_code,
new_references.appl_loan_phase_code ,
new_references.appl_loan_phase_code_chg ,
new_references.cl_rec_status ,
new_references.cl_rec_status_last_update,
new_references.mpn_confirm_code ,
new_references.lend_apprv_denied_code ,
new_references.lend_apprv_denied_date ,
new_references.b_alien_reg_num_txt ,
new_references.esign_src_typ_cd ,
new_references.acad_begin_date ,
new_references.acad_end_date
);
p_action => 'INSERT',
x_rowid => x_rowid
);
END insert_row;
x_cl_rec_status_last_update IN DATE,
x_alt_prog_type_code IN VARCHAR2,
x_alt_appl_ver_code IN NUMBER,
x_mpn_confirm_code IN VARCHAR2,
x_resp_to_orig_code IN VARCHAR2,
x_appl_loan_phase_code IN VARCHAR2,
x_appl_loan_phase_code_chg IN DATE,
x_appl_send_error_codes IN VARCHAR2,
x_tot_outstd_stafford IN NUMBER,
x_tot_outstd_plus IN NUMBER,
x_alt_borw_tot_debt IN NUMBER,
x_act_interest_rate IN NUMBER,
x_service_type_code IN VARCHAR2,
x_rev_notice_of_guarnt IN VARCHAR2,
x_sch_refund_amt IN NUMBER,
x_sch_refund_date IN DATE,
x_uniq_layout_vend_code IN VARCHAR2,
x_uniq_layout_ident_code IN VARCHAR2,
x_p_person_id IN NUMBER,
x_p_ssn_chg_date IN DATE,
x_p_dob_chg_date IN DATE,
x_p_permt_addr_chg_date IN DATE,
x_p_default_status IN VARCHAR2,
x_p_signature_code IN VARCHAR2,
x_p_signature_date IN DATE,
x_s_ssn_chg_date IN DATE,
x_s_dob_chg_date IN DATE,
x_s_permt_addr_chg_date IN DATE,
x_s_local_addr_chg_date IN DATE,
x_s_default_status IN VARCHAR2,
x_s_signature_code IN VARCHAR2,
x_pnote_batch_id IN VARCHAR2,
x_pnote_ack_date IN DATE,
x_pnote_mpn_ind IN VARCHAR2,
x_elec_mpn_ind IN VARCHAR2,
x_borr_sign_ind IN VARCHAR2,
x_stud_sign_ind IN VARCHAR2,
x_borr_credit_auth_code IN VARCHAR2,
x_relationship_cd IN VARCHAR2,
x_interest_rebate_percent_num IN NUMBER,
x_cps_trans_num IN NUMBER,
x_atd_entity_id_txt IN VARCHAR2,
x_rep_entity_id_txt IN VARCHAR2,
x_crdt_decision_status IN VARCHAR2,
x_note_message IN VARCHAR2,
x_book_loan_amt IN NUMBER,
x_book_loan_amt_date IN DATE,
x_pymt_servicer_amt IN NUMBER,
x_pymt_servicer_date IN DATE ,
x_external_loan_id_txt IN VARCHAR2 ,
x_deferment_request_code IN VARCHAR2 ,
x_eft_authorization_code IN VARCHAR2 ,
x_requested_loan_amt IN NUMBER ,
x_actual_record_type_code IN VARCHAR2 ,
x_reinstatement_amt IN NUMBER ,
x_school_use_txt IN VARCHAR2 ,
x_lender_use_txt IN VARCHAR2 ,
x_guarantor_use_txt IN VARCHAR2 ,
x_fls_approved_amt IN NUMBER ,
x_flu_approved_amt IN NUMBER ,
x_flp_approved_amt IN NUMBER ,
x_alt_approved_amt IN NUMBER ,
x_loan_app_form_code IN VARCHAR2 ,
x_override_grade_level_code IN VARCHAR2 ,
x_b_alien_reg_num_txt IN VARCHAR2 ,
x_esign_src_typ_cd IN VARCHAR2 ,
x_acad_begin_date IN DATE ,
x_acad_end_date IN DATE
) AS
/*
|| Created By : venagara
|| Created On : 02-DEC-2000
|| Purpose : Handles the LOCK mechanism for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| smadathi 14-oct-2004 Bug 3416936.Added new column as per TD.
||veramach 23-SEP-2003 Bug 3104228: Removed checks for lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
|| cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
|| p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
|| chg_batch_id,appl_send_error_codes from lock_row
|| (reverse chronological order - newest change first)
*/
CURSOR c1 IS
SELECT
loan_id,
sch_cert_date,
orig_status_flag,
orig_batch_id,
orig_batch_date,
orig_ack_date,
credit_override,
credit_decision_date,
req_serial_loan_code,
act_serial_loan_code,
pnote_delivery_code,
pnote_status,
pnote_status_date,
pnote_id,
pnote_print_ind,
pnote_accept_amt,
pnote_accept_date,
unsub_elig_for_heal,
disclosure_print_ind,
orig_fee_perct,
borw_confirm_ind,
borw_interest_ind,
borw_outstd_loan_code,
unsub_elig_for_depnt,
guarantee_amt,
guarantee_date,
guarnt_amt_redn_code,
guarnt_status_code,
guarnt_status_date,
lend_status_code,
lend_status_date,
guarnt_adj_ind,
grade_level_code,
enrollment_code,
anticip_compl_date,
prc_type_code,
cl_seq_number,
last_resort_lender,
rec_type_ind,
cl_loan_type,
alt_prog_type_code,
alt_appl_ver_code,
resp_to_orig_code,
tot_outstd_stafford,
tot_outstd_plus,
alt_borw_tot_debt,
act_interest_rate,
service_type_code,
rev_notice_of_guarnt,
sch_refund_amt,
sch_refund_date,
uniq_layout_vend_code,
uniq_layout_ident_code,
p_person_id,
p_permt_addr_chg_date,
p_default_status,
p_signature_code,
p_signature_date,
s_permt_addr_chg_date,
s_default_status,
s_signature_code,
org_id,
pnote_batch_id,
pnote_ack_date,
pnote_mpn_ind,
elec_mpn_ind,
borr_sign_ind,
stud_sign_ind,
borr_credit_auth_code,
relationship_cd,
interest_rebate_percent_num,
cps_trans_num,
atd_entity_id_txt,
rep_entity_id_txt,
crdt_decision_status,
note_message,
book_loan_amt,
book_loan_amt_date,
pymt_servicer_amt,
pymt_servicer_date,
external_loan_id_txt ,
deferment_request_code ,
eft_authorization_code ,
requested_loan_amt ,
actual_record_type_code ,
reinstatement_amt ,
school_use_txt ,
lender_use_txt ,
guarantor_use_txt ,
fls_approved_amt ,
flu_approved_amt ,
flp_approved_amt ,
alt_approved_amt ,
loan_app_form_code ,
override_grade_level_code ,
appl_loan_phase_code ,
appl_loan_phase_code_chg ,
cl_rec_status ,
cl_rec_status_last_update ,
mpn_confirm_code ,
lend_apprv_denied_code ,
lend_apprv_denied_date ,
b_alien_reg_num_txt ,
esign_src_typ_cd ,
acad_begin_date ,
acad_end_date
FROM igf_sl_lor_all
WHERE rowid = x_rowid
FOR UPDATE NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
AND ((tlinfo.cl_rec_status_last_update = x_cl_rec_status_last_update) OR ((tlinfo.cl_rec_status_last_update IS NULL) AND (x_cl_rec_status_last_update IS NULL)))
AND ((tlinfo.mpn_confirm_code = x_mpn_confirm_code) OR ((tlinfo.mpn_confirm_code IS NULL) AND (x_mpn_confirm_code IS NULL)))
AND ((tlinfo.lend_apprv_denied_code = x_lend_apprv_denied_code) OR ((tlinfo.lend_apprv_denied_code IS NULL) AND (x_lend_apprv_denied_code IS NULL)))
AND ((TRUNC(tlinfo.lend_apprv_denied_date) = TRUNC(x_lend_apprv_denied_date)) OR ((tlinfo.lend_apprv_denied_date IS NULL) AND (x_lend_apprv_denied_date IS NULL)))
AND ((tlinfo.b_alien_reg_num_txt = x_b_alien_reg_num_txt) OR ((tlinfo.b_alien_reg_num_txt IS NULL) AND (x_b_alien_reg_num_txt IS NULL)))
AND ((tlinfo.esign_src_typ_cd = x_esign_src_typ_cd) OR ((tlinfo.esign_src_typ_cd IS NULL) AND (x_esign_src_typ_cd IS NULL)))
AND ((TRUNC(tlinfo.acad_begin_date) = TRUNC(x_acad_begin_date)) OR ((tlinfo.acad_begin_date IS NULL) AND (x_acad_begin_date IS NULL)))
AND ((TRUNC(tlinfo.acad_end_date) = TRUNC(x_acad_end_date)) OR ((tlinfo.acad_end_date IS NULL) AND (x_acad_end_date IS NULL)))
) THEN
NULL;
PROCEDURE update_row (
x_rowid IN VARCHAR2,
x_origination_id IN NUMBER,
x_loan_id IN NUMBER,
x_sch_cert_date IN DATE,
x_orig_status_flag IN VARCHAR2,
x_orig_batch_id IN VARCHAR2,
x_orig_batch_date IN DATE,
x_chg_batch_id IN VARCHAR2,
x_orig_ack_date IN DATE,
x_credit_override IN VARCHAR2,
x_credit_decision_date IN DATE,
x_req_serial_loan_code IN VARCHAR2,
x_act_serial_loan_code IN VARCHAR2,
x_pnote_delivery_code IN VARCHAR2,
x_pnote_status IN VARCHAR2,
x_pnote_status_date IN DATE,
x_pnote_id IN VARCHAR2,
x_pnote_print_ind IN VARCHAR2,
x_pnote_accept_amt IN NUMBER,
x_pnote_accept_date IN DATE,
x_unsub_elig_for_heal IN VARCHAR2,
x_disclosure_print_ind IN VARCHAR2,
x_orig_fee_perct IN NUMBER,
x_borw_confirm_ind IN VARCHAR2,
x_borw_interest_ind IN VARCHAR2,
x_borw_outstd_loan_code IN VARCHAR2,
x_unsub_elig_for_depnt IN VARCHAR2,
x_guarantee_amt IN NUMBER,
x_guarantee_date IN DATE,
x_guarnt_amt_redn_code IN VARCHAR2,
x_guarnt_status_code IN VARCHAR2,
x_guarnt_status_date IN DATE,
x_lend_apprv_denied_code IN VARCHAR2,
x_lend_apprv_denied_date IN DATE,
x_lend_status_code IN VARCHAR2,
x_lend_status_date IN DATE,
x_guarnt_adj_ind IN VARCHAR2,
x_grade_level_code IN VARCHAR2,
x_enrollment_code IN VARCHAR2,
x_anticip_compl_date IN DATE,
x_borw_lender_id IN VARCHAR2,
x_duns_borw_lender_id IN VARCHAR2,
x_guarantor_id IN VARCHAR2,
x_duns_guarnt_id IN VARCHAR2,
x_prc_type_code IN VARCHAR2,
x_cl_seq_number IN NUMBER,
x_last_resort_lender IN VARCHAR2,
x_lender_id IN VARCHAR2,
x_duns_lender_id IN VARCHAR2,
x_lend_non_ed_brc_id IN VARCHAR2,
x_recipient_id IN VARCHAR2,
x_recipient_type IN VARCHAR2,
x_duns_recip_id IN VARCHAR2,
x_recip_non_ed_brc_id IN VARCHAR2,
x_rec_type_ind IN VARCHAR2,
x_cl_loan_type IN VARCHAR2,
x_cl_rec_status IN VARCHAR2,
x_cl_rec_status_last_update IN DATE,
x_alt_prog_type_code IN VARCHAR2,
x_alt_appl_ver_code IN NUMBER,
x_mpn_confirm_code IN VARCHAR2,
x_resp_to_orig_code IN VARCHAR2,
x_appl_loan_phase_code IN VARCHAR2,
x_appl_loan_phase_code_chg IN DATE,
x_appl_send_error_codes IN VARCHAR2,
x_tot_outstd_stafford IN NUMBER,
x_tot_outstd_plus IN NUMBER,
x_alt_borw_tot_debt IN NUMBER,
x_act_interest_rate IN NUMBER,
x_service_type_code IN VARCHAR2,
x_rev_notice_of_guarnt IN VARCHAR2,
x_sch_refund_amt IN NUMBER,
x_sch_refund_date IN DATE,
x_uniq_layout_vend_code IN VARCHAR2,
x_uniq_layout_ident_code IN VARCHAR2,
x_p_person_id IN NUMBER,
x_p_ssn_chg_date IN DATE,
x_p_dob_chg_date IN DATE,
x_p_permt_addr_chg_date IN DATE,
x_p_default_status IN VARCHAR2,
x_p_signature_code IN VARCHAR2,
x_p_signature_date IN DATE,
x_s_ssn_chg_date IN DATE,
x_s_dob_chg_date IN DATE,
x_s_permt_addr_chg_date IN DATE,
x_s_local_addr_chg_date IN DATE,
x_s_default_status IN VARCHAR2,
x_s_signature_code IN VARCHAR2,
x_mode IN VARCHAR2 DEFAULT 'R',
x_pnote_batch_id IN VARCHAR2,
x_pnote_ack_date IN DATE,
x_pnote_mpn_ind IN VARCHAR2,
x_elec_mpn_ind IN VARCHAR2,
x_borr_sign_ind IN VARCHAR2,
x_stud_sign_ind IN VARCHAR2,
x_borr_credit_auth_code IN VARCHAR2,
x_relationship_cd IN VARCHAR2,
x_interest_rebate_percent_num IN NUMBER,
x_cps_trans_num IN NUMBER,
x_atd_entity_id_txt IN VARCHAR2,
x_rep_entity_id_txt IN VARCHAR2,
x_crdt_decision_status IN VARCHAR2,
x_note_message IN VARCHAR2,
x_book_loan_amt IN NUMBER,
x_book_loan_amt_date IN DATE,
x_pymt_servicer_amt IN NUMBER,
x_pymt_servicer_date IN DATE ,
x_external_loan_id_txt IN VARCHAR2 ,
x_deferment_request_code IN VARCHAR2 ,
x_eft_authorization_code IN VARCHAR2 ,
x_requested_loan_amt IN NUMBER ,
x_actual_record_type_code IN VARCHAR2 ,
x_reinstatement_amt IN NUMBER ,
x_school_use_txt IN VARCHAR2 ,
x_lender_use_txt IN VARCHAR2 ,
x_guarantor_use_txt IN VARCHAR2 ,
x_fls_approved_amt IN NUMBER ,
x_flu_approved_amt IN NUMBER ,
x_flp_approved_amt IN NUMBER ,
x_alt_approved_amt IN NUMBER ,
x_loan_app_form_code IN VARCHAR2 ,
x_override_grade_level_code IN VARCHAR2 ,
x_called_from IN VARCHAR2 ,
x_b_alien_reg_num_txt IN VARCHAR2 ,
x_esign_src_typ_cd IN VARCHAR2 ,
x_acad_begin_date IN DATE,
x_acad_end_date IN DATE
) AS
/*
|| Created By : venagara
|| Created On : 02-DEC-2000
|| Purpose : Handles the UPDATE DML logic for the table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| smadathi 14-oct-2004 Bug 3416936.Added new column as per TD.
|| viramali 12-MAY-01 added call to after_dml
*/
x_last_update_date DATE ;
x_last_updated_by NUMBER;
x_last_update_login NUMBER;
x_program_update_date DATE;
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_origination_id => x_origination_id,
x_loan_id => x_loan_id,
x_sch_cert_date => x_sch_cert_date,
x_orig_status_flag => x_orig_status_flag,
x_orig_batch_id => x_orig_batch_id,
x_orig_batch_date => x_orig_batch_date,
x_chg_batch_id => x_chg_batch_id,
x_orig_ack_date => x_orig_ack_date,
x_credit_override => x_credit_override,
x_credit_decision_date => x_credit_decision_date,
x_req_serial_loan_code => x_req_serial_loan_code,
x_act_serial_loan_code => x_act_serial_loan_code,
x_pnote_delivery_code => x_pnote_delivery_code,
x_pnote_status => x_pnote_status,
x_pnote_status_date => x_pnote_status_date,
x_pnote_id => x_pnote_id,
x_pnote_print_ind => x_pnote_print_ind,
x_pnote_accept_amt => x_pnote_accept_amt,
x_pnote_accept_date => x_pnote_accept_date,
x_unsub_elig_for_heal => x_unsub_elig_for_heal,
x_disclosure_print_ind => x_disclosure_print_ind,
x_orig_fee_perct => x_orig_fee_perct,
x_borw_confirm_ind => x_borw_confirm_ind,
x_borw_interest_ind => x_borw_interest_ind,
x_borw_outstd_loan_code => x_borw_outstd_loan_code,
x_unsub_elig_for_depnt => x_unsub_elig_for_depnt,
x_guarantee_amt => x_guarantee_amt,
x_guarantee_date => x_guarantee_date,
x_guarnt_amt_redn_code => x_guarnt_amt_redn_code,
x_guarnt_status_code => x_guarnt_status_code,
x_guarnt_status_date => x_guarnt_status_date,
x_lend_apprv_denied_code => x_lend_apprv_denied_code,
x_lend_apprv_denied_date => x_lend_apprv_denied_date,
x_lend_status_code => x_lend_status_code,
x_lend_status_date => x_lend_status_date,
x_guarnt_adj_ind => x_guarnt_adj_ind,
x_grade_level_code => x_grade_level_code,
x_enrollment_code => x_enrollment_code,
x_anticip_compl_date => x_anticip_compl_date,
x_borw_lender_id => x_borw_lender_id,
x_duns_borw_lender_id => x_duns_borw_lender_id,
x_guarantor_id => x_guarantor_id,
x_duns_guarnt_id => x_duns_guarnt_id,
x_prc_type_code => x_prc_type_code,
x_cl_seq_number => x_cl_seq_number,
x_last_resort_lender => x_last_resort_lender,
x_lender_id => x_lender_id,
x_duns_lender_id => x_duns_lender_id,
x_lend_non_ed_brc_id => x_lend_non_ed_brc_id,
x_recipient_id => x_recipient_id,
x_recipient_type => x_recipient_type,
x_duns_recip_id => x_duns_recip_id,
x_recip_non_ed_brc_id => x_recip_non_ed_brc_id,
x_rec_type_ind => x_rec_type_ind,
x_cl_loan_type => x_cl_loan_type,
x_cl_rec_status => x_cl_rec_status,
x_cl_rec_status_last_update => x_cl_rec_status_last_update,
x_alt_prog_type_code => x_alt_prog_type_code,
x_alt_appl_ver_code => x_alt_appl_ver_code,
x_mpn_confirm_code => x_mpn_confirm_code,
x_resp_to_orig_code => x_resp_to_orig_code,
x_appl_loan_phase_code => x_appl_loan_phase_code,
x_appl_loan_phase_code_chg => x_appl_loan_phase_code_chg,
x_appl_send_error_codes => x_appl_send_error_codes,
x_tot_outstd_stafford => x_tot_outstd_stafford,
x_tot_outstd_plus => x_tot_outstd_plus,
x_alt_borw_tot_debt => x_alt_borw_tot_debt,
x_act_interest_rate => x_act_interest_rate,
x_service_type_code => x_service_type_code,
x_rev_notice_of_guarnt => x_rev_notice_of_guarnt,
x_sch_refund_amt => x_sch_refund_amt,
x_sch_refund_date => x_sch_refund_date,
x_uniq_layout_vend_code => x_uniq_layout_vend_code,
x_uniq_layout_ident_code => x_uniq_layout_ident_code,
x_p_person_id => x_p_person_id,
x_p_ssn_chg_date => x_p_ssn_chg_date,
x_p_dob_chg_date => x_p_dob_chg_date,
x_p_permt_addr_chg_date => x_p_permt_addr_chg_date,
x_p_default_status => x_p_default_status,
x_p_signature_code => x_p_signature_code,
x_p_signature_date => x_p_signature_date,
x_s_ssn_chg_date => x_s_ssn_chg_date,
x_s_dob_chg_date => x_s_dob_chg_date,
x_s_permt_addr_chg_date => x_s_permt_addr_chg_date,
x_s_local_addr_chg_date => x_s_local_addr_chg_date,
x_s_default_status => x_s_default_status,
x_s_signature_code => x_s_signature_code,
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_pnote_batch_id => x_pnote_batch_id,
x_pnote_ack_date => x_pnote_ack_date,
x_pnote_mpn_ind => x_pnote_mpn_ind,
x_elec_mpn_ind => x_elec_mpn_ind,
x_borr_sign_ind => x_borr_sign_ind,
x_stud_sign_ind => x_stud_sign_ind,
x_borr_credit_auth_code => x_borr_credit_auth_code,
x_relationship_cd => x_relationship_cd,
x_interest_rebate_percent_num => x_interest_rebate_percent_num,
x_cps_trans_num => x_cps_trans_num,
x_atd_entity_id_txt => x_atd_entity_id_txt,
x_rep_entity_id_txt => x_rep_entity_id_txt,
x_crdt_decision_status => x_crdt_decision_status,
x_note_message => x_note_message,
x_book_loan_amt => x_book_loan_amt,
x_book_loan_amt_date => x_book_loan_amt_date,
x_pymt_servicer_amt => x_pymt_servicer_amt,
x_pymt_servicer_date => x_pymt_servicer_date,
x_external_loan_id_txt => x_external_loan_id_txt ,
x_deferment_request_code => x_deferment_request_code ,
x_eft_authorization_code => x_eft_authorization_code ,
x_requested_loan_amt => x_requested_loan_amt ,
x_actual_record_type_code => x_actual_record_type_code ,
x_reinstatement_amt => x_reinstatement_amt ,
x_school_use_txt => x_school_use_txt ,
x_lender_use_txt => x_lender_use_txt ,
x_guarantor_use_txt => x_guarantor_use_txt ,
x_fls_approved_amt => x_fls_approved_amt ,
x_flu_approved_amt => x_flu_approved_amt ,
x_flp_approved_amt => x_flp_approved_amt ,
x_alt_approved_amt => x_alt_approved_amt ,
x_loan_app_form_code => x_loan_app_form_code ,
x_override_grade_level_code => x_override_grade_level_code ,
x_b_alien_reg_num_txt => x_b_alien_reg_num_txt ,
x_esign_src_typ_cd => x_esign_src_typ_cd ,
x_acad_begin_date => x_acad_begin_date ,
x_acad_end_date => x_acad_end_date
);
x_program_update_date := old_references.program_update_date;
x_program_update_date := SYSDATE;
UPDATE igf_sl_lor_all
SET
loan_id = new_references.loan_id,
sch_cert_date = new_references.sch_cert_date,
orig_status_flag = new_references.orig_status_flag,
orig_batch_id = new_references.orig_batch_id,
orig_batch_date = new_references.orig_batch_date,
orig_ack_date = new_references.orig_ack_date,
credit_override = new_references.credit_override,
credit_decision_date = new_references.credit_decision_date,
req_serial_loan_code = new_references.req_serial_loan_code,
act_serial_loan_code = new_references.act_serial_loan_code,
pnote_delivery_code = new_references.pnote_delivery_code,
pnote_status = new_references.pnote_status,
pnote_status_date = new_references.pnote_status_date,
pnote_id = new_references.pnote_id,
pnote_print_ind = new_references.pnote_print_ind,
pnote_accept_amt = new_references.pnote_accept_amt,
pnote_accept_date = new_references.pnote_accept_date,
unsub_elig_for_heal = new_references.unsub_elig_for_heal,
disclosure_print_ind = new_references.disclosure_print_ind,
orig_fee_perct = new_references.orig_fee_perct,
borw_confirm_ind = new_references.borw_confirm_ind,
borw_interest_ind = new_references.borw_interest_ind,
borw_outstd_loan_code = new_references.borw_outstd_loan_code,
unsub_elig_for_depnt = new_references.unsub_elig_for_depnt,
guarantee_amt = new_references.guarantee_amt,
guarantee_date = new_references.guarantee_date,
guarnt_amt_redn_code = new_references.guarnt_amt_redn_code,
guarnt_status_code = new_references.guarnt_status_code,
guarnt_status_date = new_references.guarnt_status_date,
lend_status_code = new_references.lend_status_code,
lend_status_date = new_references.lend_status_date,
guarnt_adj_ind = new_references.guarnt_adj_ind,
grade_level_code = new_references.grade_level_code,
enrollment_code = new_references.enrollment_code,
anticip_compl_date = new_references.anticip_compl_date,
prc_type_code = new_references.prc_type_code,
cl_seq_number = new_references.cl_seq_number,
last_resort_lender = new_references.last_resort_lender,
rec_type_ind = new_references.rec_type_ind,
cl_loan_type = new_references.cl_loan_type,
alt_prog_type_code = new_references.alt_prog_type_code,
alt_appl_ver_code = new_references.alt_appl_ver_code,
resp_to_orig_code = new_references.resp_to_orig_code,
tot_outstd_stafford = new_references.tot_outstd_stafford,
tot_outstd_plus = new_references.tot_outstd_plus,
alt_borw_tot_debt = new_references.alt_borw_tot_debt,
act_interest_rate = new_references.act_interest_rate,
service_type_code = new_references.service_type_code,
rev_notice_of_guarnt = new_references.rev_notice_of_guarnt,
sch_refund_amt = new_references.sch_refund_amt,
sch_refund_date = new_references.sch_refund_date,
uniq_layout_vend_code = new_references.uniq_layout_vend_code,
uniq_layout_ident_code = new_references.uniq_layout_ident_code,
p_person_id = new_references.p_person_id,
p_permt_addr_chg_date = new_references.p_permt_addr_chg_date,
p_default_status = new_references.p_default_status,
p_signature_code = new_references.p_signature_code,
p_signature_date = new_references.p_signature_date,
s_permt_addr_chg_date = new_references.s_permt_addr_chg_date,
s_default_status = new_references.s_default_status,
s_signature_code = new_references.s_signature_code,
last_update_date = x_last_update_date,
last_updated_by = x_last_updated_by,
last_update_login = x_last_update_login ,
request_id = x_request_id,
program_id = x_program_id,
program_application_id = x_program_application_id,
program_update_date = x_program_update_date,
pnote_batch_id = new_references.pnote_batch_id,
pnote_ack_date = new_references.pnote_ack_date,
pnote_mpn_ind = new_references.pnote_mpn_ind,
elec_mpn_ind = new_references.elec_mpn_ind,
borr_sign_ind = new_references.borr_sign_ind,
stud_sign_ind = new_references.stud_sign_ind,
borr_credit_auth_code = new_references.borr_credit_auth_code,
relationship_cd = new_references.relationship_cd,
interest_rebate_percent_num = new_references.interest_rebate_percent_num,
cps_trans_num = new_references.cps_trans_num,
atd_entity_id_txt = new_references.atd_entity_id_txt,
rep_entity_id_txt = new_references.rep_entity_id_txt,
crdt_decision_status = new_references.crdt_decision_status,
note_message = new_references.note_message,
book_loan_amt = new_references.book_loan_amt,
book_loan_amt_date = new_references.book_loan_amt_date,
pymt_servicer_amt = new_references.pymt_servicer_amt,
pymt_servicer_date = new_references.pymt_servicer_date,
external_loan_id_txt = new_references.external_loan_id_txt ,
deferment_request_code = new_references.deferment_request_code ,
eft_authorization_code = new_references.eft_authorization_code ,
requested_loan_amt = new_references.requested_loan_amt ,
actual_record_type_code = new_references.actual_record_type_code ,
reinstatement_amt = new_references.reinstatement_amt ,
school_use_txt = new_references.school_use_txt ,
lender_use_txt = new_references.lender_use_txt ,
guarantor_use_txt = new_references.guarantor_use_txt ,
fls_approved_amt = new_references.fls_approved_amt ,
flu_approved_amt = new_references.flu_approved_amt ,
flp_approved_amt = new_references.flp_approved_amt ,
alt_approved_amt = new_references.alt_approved_amt ,
loan_app_form_code = new_references.loan_app_form_code ,
override_grade_level_code = new_references.override_grade_level_code ,
appl_loan_phase_code = new_references.appl_loan_phase_code ,
appl_loan_phase_code_chg = new_references.appl_loan_phase_code_chg ,
cl_rec_status = new_references.cl_rec_status ,
cl_rec_status_last_update = new_references.cl_rec_status_last_update ,
mpn_confirm_code = new_references.mpn_confirm_code ,
lend_apprv_denied_code = new_references.lend_apprv_denied_code ,
lend_apprv_denied_date = new_references.lend_apprv_denied_date ,
b_alien_reg_num_txt = new_references.b_alien_reg_num_txt ,
esign_src_typ_cd = new_references.esign_src_typ_cd ,
acad_begin_date = new_references.acad_begin_date ,
acad_end_date = new_references.acad_end_date
WHERE rowid = x_rowid;
p_action =>'UPDATE',
x_rowid => x_rowid
);
END update_row;
x_cl_rec_status_last_update IN DATE,
x_alt_prog_type_code IN VARCHAR2,
x_alt_appl_ver_code IN NUMBER,
x_mpn_confirm_code IN VARCHAR2,
x_resp_to_orig_code IN VARCHAR2,
x_appl_loan_phase_code IN VARCHAR2,
x_appl_loan_phase_code_chg IN DATE,
x_appl_send_error_codes IN VARCHAR2,
x_tot_outstd_stafford IN NUMBER,
x_tot_outstd_plus IN NUMBER,
x_alt_borw_tot_debt IN NUMBER,
x_act_interest_rate IN NUMBER,
x_service_type_code IN VARCHAR2,
x_rev_notice_of_guarnt IN VARCHAR2,
x_sch_refund_amt IN NUMBER,
x_sch_refund_date IN DATE,
x_uniq_layout_vend_code IN VARCHAR2,
x_uniq_layout_ident_code IN VARCHAR2,
x_p_person_id IN NUMBER,
x_p_ssn_chg_date IN DATE,
x_p_dob_chg_date IN DATE,
x_p_permt_addr_chg_date IN DATE,
x_p_default_status IN VARCHAR2,
x_p_signature_code IN VARCHAR2,
x_p_signature_date IN DATE,
x_s_ssn_chg_date IN DATE,
x_s_dob_chg_date IN DATE,
x_s_permt_addr_chg_date IN DATE,
x_s_local_addr_chg_date IN DATE,
x_s_default_status IN VARCHAR2,
x_s_signature_code IN VARCHAR2,
x_mode IN VARCHAR2 DEFAULT 'R',
x_pnote_batch_id IN VARCHAR2,
x_pnote_ack_date IN DATE,
x_pnote_mpn_ind IN VARCHAR2,
x_elec_mpn_ind IN VARCHAR2,
x_borr_sign_ind IN VARCHAR2,
x_stud_sign_ind IN VARCHAR2,
x_borr_credit_auth_code IN VARCHAR2,
x_relationship_cd IN VARCHAR2,
x_interest_rebate_percent_num IN NUMBER,
x_cps_trans_num IN NUMBER,
x_atd_entity_id_txt IN VARCHAR2,
x_rep_entity_id_txt IN VARCHAR2,
x_crdt_decision_status IN VARCHAR2,
x_note_message IN VARCHAR2,
x_book_loan_amt IN NUMBER,
x_book_loan_amt_date IN DATE,
x_pymt_servicer_amt IN NUMBER,
x_pymt_servicer_date IN DATE ,
x_external_loan_id_txt IN VARCHAR2 ,
x_deferment_request_code IN VARCHAR2 ,
x_eft_authorization_code IN VARCHAR2 ,
x_requested_loan_amt IN NUMBER ,
x_actual_record_type_code IN VARCHAR2 ,
x_reinstatement_amt IN NUMBER ,
x_school_use_txt IN VARCHAR2 ,
x_lender_use_txt IN VARCHAR2 ,
x_guarantor_use_txt IN VARCHAR2 ,
x_fls_approved_amt IN NUMBER ,
x_flu_approved_amt IN NUMBER ,
x_flp_approved_amt IN NUMBER ,
x_alt_approved_amt IN NUMBER ,
x_loan_app_form_code IN VARCHAR2 ,
x_override_grade_level_code IN VARCHAR2 ,
x_b_alien_reg_num_txt IN VARCHAR2 ,
x_esign_src_typ_cd IN VARCHAR2 ,
x_acad_begin_date IN DATE ,
x_acad_end_date IN DATE
) AS
/*
|| Created By : venagara
|| Created On : 02-DEC-2000
|| 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
|| smadathi 14-oct-2004 Bug 3416936.Added new column as per TD.
|| (reverse chronological order - newest change first)
*/
CURSOR c1 IS
SELECT rowid
FROM igf_sl_lor_all
WHERE origination_id = x_origination_id;
insert_row (
x_rowid,
x_origination_id,
x_loan_id,
x_sch_cert_date,
x_orig_status_flag,
x_orig_batch_id,
x_orig_batch_date,
x_chg_batch_id,
x_orig_ack_date,
x_credit_override,
x_credit_decision_date,
x_req_serial_loan_code,
x_act_serial_loan_code,
x_pnote_delivery_code,
x_pnote_status,
x_pnote_status_date,
x_pnote_id,
x_pnote_print_ind,
x_pnote_accept_amt,
x_pnote_accept_date,
x_unsub_elig_for_heal,
x_disclosure_print_ind,
x_orig_fee_perct,
x_borw_confirm_ind,
x_borw_interest_ind,
x_borw_outstd_loan_code,
x_unsub_elig_for_depnt,
x_guarantee_amt,
x_guarantee_date,
x_guarnt_amt_redn_code,
x_guarnt_status_code,
x_guarnt_status_date,
x_lend_apprv_denied_code,
x_lend_apprv_denied_date,
x_lend_status_code,
x_lend_status_date,
x_guarnt_adj_ind,
x_grade_level_code,
x_enrollment_code,
x_anticip_compl_date,
x_borw_lender_id,
x_duns_borw_lender_id,
x_guarantor_id,
x_duns_guarnt_id,
x_prc_type_code,
x_cl_seq_number,
x_last_resort_lender,
x_lender_id,
x_duns_lender_id,
x_lend_non_ed_brc_id,
x_recipient_id,
x_recipient_type,
x_duns_recip_id,
x_recip_non_ed_brc_id,
x_rec_type_ind,
x_cl_loan_type,
x_cl_rec_status,
x_cl_rec_status_last_update,
x_alt_prog_type_code,
x_alt_appl_ver_code,
x_mpn_confirm_code,
x_resp_to_orig_code,
x_appl_loan_phase_code,
x_appl_loan_phase_code_chg,
x_appl_send_error_codes,
x_tot_outstd_stafford,
x_tot_outstd_plus,
x_alt_borw_tot_debt,
x_act_interest_rate,
x_service_type_code,
x_rev_notice_of_guarnt,
x_sch_refund_amt,
x_sch_refund_date,
x_uniq_layout_vend_code,
x_uniq_layout_ident_code,
x_p_person_id,
x_p_ssn_chg_date,
x_p_dob_chg_date,
x_p_permt_addr_chg_date,
x_p_default_status,
x_p_signature_code,
x_p_signature_date,
x_s_ssn_chg_date,
x_s_dob_chg_date,
x_s_permt_addr_chg_date,
x_s_local_addr_chg_date,
x_s_default_status,
x_s_signature_code,
x_mode,
x_pnote_batch_id,
x_pnote_ack_date,
x_pnote_mpn_ind,
x_elec_mpn_ind,
x_borr_sign_ind,
x_stud_sign_ind,
x_borr_credit_auth_code,
x_relationship_cd,
x_interest_rebate_percent_num,
x_cps_trans_num,
x_atd_entity_id_txt,
x_rep_entity_id_txt,
x_crdt_decision_status,
x_note_message,
x_book_loan_amt,
x_book_loan_amt_date,
x_pymt_servicer_amt,
x_pymt_servicer_date,
x_external_loan_id_txt ,
x_deferment_request_code ,
x_eft_authorization_code ,
x_requested_loan_amt ,
x_actual_record_type_code ,
x_reinstatement_amt ,
x_school_use_txt ,
x_lender_use_txt ,
x_guarantor_use_txt ,
x_fls_approved_amt ,
x_flu_approved_amt ,
x_flp_approved_amt ,
x_alt_approved_amt ,
x_loan_app_form_code ,
x_override_grade_level_code ,
x_b_alien_reg_num_txt ,
x_esign_src_typ_cd ,
x_acad_begin_date ,
x_acad_end_date
);
update_row (
x_rowid,
x_origination_id,
x_loan_id,
x_sch_cert_date,
x_orig_status_flag,
x_orig_batch_id,
x_orig_batch_date,
x_chg_batch_id,
x_orig_ack_date,
x_credit_override,
x_credit_decision_date,
x_req_serial_loan_code,
x_act_serial_loan_code,
x_pnote_delivery_code,
x_pnote_status,
x_pnote_status_date,
x_pnote_id,
x_pnote_print_ind,
x_pnote_accept_amt,
x_pnote_accept_date,
x_unsub_elig_for_heal,
x_disclosure_print_ind,
x_orig_fee_perct,
x_borw_confirm_ind,
x_borw_interest_ind,
x_borw_outstd_loan_code,
x_unsub_elig_for_depnt,
x_guarantee_amt,
x_guarantee_date,
x_guarnt_amt_redn_code,
x_guarnt_status_code,
x_guarnt_status_date,
x_lend_apprv_denied_code,
x_lend_apprv_denied_date,
x_lend_status_code,
x_lend_status_date,
x_guarnt_adj_ind,
x_grade_level_code,
x_enrollment_code,
x_anticip_compl_date,
x_borw_lender_id,
x_duns_borw_lender_id,
x_guarantor_id,
x_duns_guarnt_id,
x_prc_type_code,
x_cl_seq_number,
x_last_resort_lender,
x_lender_id,
x_duns_lender_id,
x_lend_non_ed_brc_id,
x_recipient_id,
x_recipient_type,
x_duns_recip_id,
x_recip_non_ed_brc_id,
x_rec_type_ind,
x_cl_loan_type,
x_cl_rec_status,
x_cl_rec_status_last_update,
x_alt_prog_type_code,
x_alt_appl_ver_code,
x_mpn_confirm_code,
x_resp_to_orig_code,
x_appl_loan_phase_code,
x_appl_loan_phase_code_chg,
x_appl_send_error_codes,
x_tot_outstd_stafford,
x_tot_outstd_plus,
x_alt_borw_tot_debt,
x_act_interest_rate,
x_service_type_code,
x_rev_notice_of_guarnt,
x_sch_refund_amt,
x_sch_refund_date,
x_uniq_layout_vend_code,
x_uniq_layout_ident_code,
x_p_person_id,
x_p_ssn_chg_date,
x_p_dob_chg_date,
x_p_permt_addr_chg_date,
x_p_default_status,
x_p_signature_code,
x_p_signature_date,
x_s_ssn_chg_date,
x_s_dob_chg_date,
x_s_permt_addr_chg_date,
x_s_local_addr_chg_date,
x_s_default_status,
x_s_signature_code,
x_mode,
x_pnote_batch_id,
x_pnote_ack_date,
x_pnote_mpn_ind,
x_elec_mpn_ind,
x_borr_sign_ind,
x_stud_sign_ind,
x_borr_credit_auth_code,
x_relationship_cd,
x_interest_rebate_percent_num,
x_cps_trans_num,
x_atd_entity_id_txt,
x_rep_entity_id_txt,
x_crdt_decision_status,
x_note_message,
x_book_loan_amt,
x_book_loan_amt_date,
x_pymt_servicer_amt,
x_pymt_servicer_date,
x_external_loan_id_txt ,
x_deferment_request_code ,
x_eft_authorization_code ,
x_requested_loan_amt ,
x_actual_record_type_code ,
x_reinstatement_amt ,
x_school_use_txt ,
x_lender_use_txt ,
x_guarantor_use_txt ,
x_fls_approved_amt ,
x_flu_approved_amt ,
x_flp_approved_amt ,
x_alt_approved_amt ,
x_loan_app_form_code ,
x_override_grade_level_code ,
x_b_alien_reg_num_txt ,
x_esign_src_typ_cd ,
x_acad_begin_date ,
x_acad_end_date
);
PROCEDURE delete_row (
x_rowid IN VARCHAR2
) AS
/*
|| Created By : venagara
|| Created On : 02-DEC-2000
|| 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 igf_sl_lor_all
WHERE rowid = x_rowid;
END delete_row;