[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rowid ,document_id_txt,outbound_doc
FROM igf_sl_cod_doc_dtls
WHERE document_id_txt = p_document_id_txt
AND doc_status = 'R'
FOR UPDATE OF outbound_doc;
PROCEDURE update_status(p_document_id_txt VARCHAR2)
IS
CURSOR cur_cod_loans (p_document_id_txt VARCHAR2)
IS
SELECT loc.loan_id FROM igf_sl_lor_loc_all loc
WHERE loc.document_id_txt = p_document_id_txt;
SELECT disb.award_id, disb.disb_num, disb.disb_seq_num
FROM igf_aw_db_cod_dtls disb
WHERE disb.document_id_txt = p_document_id_txt;
SELECT loan.* FROM igf_sl_loans loan
WHERE loan.loan_id = p_loan_id;
SELECT disb.rowid row_id,disb.* FROM igf_aw_db_chg_dtls disb
WHERE disb.award_id = p_award_id AND
disb.disb_num = p_disb_num AND
disb.disb_seq_num = p_disb_seq;
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.update_status.debug','First doc id ' || p_document_id_txt);
igf_sl_loans_pkg.update_row(x_rowid => sys_rec.row_id,
x_loan_id => sys_rec.loan_id,
x_award_id => sys_rec.award_id,
x_seq_num => sys_rec.seq_num,
x_loan_number => sys_rec.loan_number,
x_loan_per_begin_date => sys_rec.loan_per_begin_date,
x_loan_per_end_date => sys_rec.loan_per_end_date,
x_loan_status => sys_rec.loan_status,
x_loan_status_date => sys_rec.loan_status_date,
x_loan_chg_status => sys_rec.loan_chg_status,
x_loan_chg_status_date => sys_rec.loan_chg_status_date,
x_active => sys_rec.active,
x_active_date => sys_rec.active_date,
x_borw_detrm_code => sys_rec.borw_detrm_code,
x_mode => 'R',
x_legacy_record_flag => sys_rec.legacy_record_flag,
x_external_loan_id_txt => sys_rec.external_loan_id_txt,
x_called_from => NULL);
igf_aw_db_chg_dtls_pkg.update_row(x_rowid => sys_rec.row_id,
x_award_id => sys_rec.award_id,
x_disb_num => sys_rec.disb_num,
x_disb_seq_num => sys_rec.disb_seq_num,
x_disb_accepted_amt => sys_rec.disb_accepted_amt,
x_orig_fee_amt => sys_rec.orig_fee_amt,
x_disb_net_amt => sys_rec.disb_net_amt,
x_disb_date => sys_rec.disb_date,
x_disb_activity => sys_rec.disb_activity,
x_disb_status => sys_rec.disb_status,
x_disb_status_date => sys_rec.disb_status_date,
x_disb_rel_flag => sys_rec.disb_rel_flag,
x_first_disb_flag => sys_rec.first_disb_flag,
x_interest_rebate_amt => sys_rec.interest_rebate_amt,
x_disb_conf_flag => sys_rec.disb_conf_flag,
x_pymnt_prd_start_date => sys_rec.pymnt_prd_start_date,
x_note_message => sys_rec.note_message,
x_batch_id_txt => sys_rec.batch_id_txt,
x_ack_date => sys_rec.ack_date,
x_booking_id_txt => sys_rec.booking_id_txt,
x_booking_date => sys_rec.booking_date,
x_mode => 'R'
);
fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_gen_xml.update_status.exception','Exception:'||SQLERRM);
fnd_message.set_token('NAME','IGF_SL_DL_GEN_XML.UPDATE_STATUS');
END update_status;
PROCEDURE insert_lor_loc(p_loan_rec cur_pick_loans%ROWTYPE,
p_source_id VARCHAR2,
student_dtl_rec igf_sl_gen.person_dtl_rec,
parent_dtl_rec igf_sl_gen.person_dtl_rec,
p_isir_ssn VARCHAR2, p_isir_dob DATE,
p_isir_lname VARCHAR2, p_isir_dep VARCHAR2,
p_isir_tnum NUMBER, p_acad_begin DATE,
p_acad_end DATE, p_s_phone VARCHAR2, p_p_phone VARCHAR2)
IS
CURSOR cur_setup (p_cal_type VARCHAR2, p_seq_number NUMBER) IS
SELECT response_option_code, int_rebate
FROM igf_sl_dl_setup_all
WHERE ci_cal_type = p_cal_type
AND ci_sequence_number = p_seq_number;
SELECT loc.*
FROM igf_sl_lor_loc_all loc
WHERE loc.loan_id = p_loan_id;
SELECT chg.*
FROM igf_aw_db_chg_dtls chg
WHERE award_id = p_award_id
--AND disb_status = 'G'; -- Ready to Send (commented bcz of the bug 4105689)
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',setup_rec.response_option_code);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','start of modified values for Loan ID> ' || loan_oldinfo_rec.loan_id);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_birth_date);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_last_name);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.b_chg_ssn);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.loan_number);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_date_of_birth);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_last_name);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.p_ssn);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_birth_date);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_last_name);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_chg_ssn);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_date_of_birth);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','** last name > ' || loan_oldinfo_rec.s_last_name);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',loan_oldinfo_rec.s_ssn);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_date_of_birth);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_last_name);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',parent_dtl_rec.p_ssn);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_date_of_birth);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_last_name);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug',student_dtl_rec.p_ssn);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','end of modified values');
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine');
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_new_base_id ' || gn_new_base_id );
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_old_base_id ' || gn_old_base_id );
loan_key_rec.DELETE;
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine');
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_new_base_id ' || gn_new_base_id );
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','gn_old_base_id ' || gn_old_base_id );
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key determine ln_count ' || ln_count);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key gn_new_base_id = gn_old_base_id ');
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key ' || ln_loan_key);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','loan key = ' || ln_loan_key);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc ');
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc p_p_phone ' || p_p_phone);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting lor loc p_s_phone ' || p_s_phone);
x_cl_rec_status_last_update => NULL, -- FFELP
x_alt_prog_type_code => NULL, -- FFELP
x_alt_appl_ver_code => NULL, -- FFELP
x_borw_outstd_loan_code => NULL, -- FFELP
x_mpn_confirm_code => NULL, -- FFELP
x_resp_to_orig_code => NULL, -- FFELP
x_appl_loan_phase_code => NULL, -- FFELP
x_appl_loan_phase_code_chg => NULL, -- FFELP
x_tot_outstd_stafford => NULL, -- FFELP
x_tot_outstd_plus => NULL, -- FFELP
x_alt_borw_tot_debt => NULL, -- FFELP
x_act_interest_rate => NULL, -- FFELP
x_service_type_code => NULL, -- FFELP
x_rev_notice_of_guarnt => NULL, -- FFELP
x_sch_refund_amt => NULL, -- FFELP
x_sch_refund_date => NULL, -- FFELP
x_uniq_layout_vend_code => NULL, -- FFELP
x_uniq_layout_ident_code => NULL, -- FFELP
x_p_person_id => p_loan_rec.p_person_id,
x_p_ssn => NVL(loan_oldinfo_rec.p_ssn,parent_dtl_rec.p_ssn), -- attribute
x_p_ssn_chg_date => NULL, -- FFELP
x_p_last_name => UPPER(NVL(loan_oldinfo_rec.p_last_name,parent_dtl_rec.p_last_name)),-- attribute
x_p_first_name => UPPER(parent_dtl_rec.p_first_name),
x_p_middle_name => UPPER(parent_dtl_rec.p_middle_name),
x_p_permt_addr1 => UPPER(parent_dtl_rec.p_permt_addr1),
x_p_permt_addr2 => UPPER(parent_dtl_rec.p_permt_addr2),
x_p_permt_city => UPPER(parent_dtl_rec.p_permt_city),
x_p_permt_state => UPPER(parent_dtl_rec.p_permt_state),
x_p_permt_zip => UPPER(parent_dtl_rec.p_permt_zip),
x_p_permt_addr_chg_date => NULL, -- FFELP
x_p_permt_phone => p_p_phone,
x_p_email_addr => UPPER(parent_dtl_rec.p_email_addr),
x_p_date_of_birth => NVL(loan_oldinfo_rec.p_date_of_birth,parent_dtl_rec.p_date_of_birth), -- attribute
x_p_dob_chg_date => NULL, -- FFELP
x_p_license_num => parent_dtl_rec.p_license_num,
x_p_license_state => UPPER(parent_dtl_rec.p_license_state),
x_p_citizenship_status => parent_dtl_rec.p_citizenship_status,
x_p_alien_reg_num => NULL, -- FFELP
x_p_default_status => p_loan_rec.p_default_status,
x_p_foreign_postal_code => NULL, -- FFELP
x_p_state_of_legal_res => NULL, -- FFELP
x_p_legal_res_date => NULL, -- FFELP
x_s_ssn => NVL(loan_oldinfo_rec.s_ssn,student_dtl_rec.p_ssn), -- attribute
x_s_ssn_chg_date => NULL, -- FFELP
x_s_last_name => UPPER(NVL(loan_oldinfo_rec.s_last_name,student_dtl_rec.p_last_name)), -- attribute
x_s_first_name => UPPER(student_dtl_rec.p_first_name),
x_s_middle_name => UPPER(student_dtl_rec.p_middle_name),
x_s_permt_addr1 => UPPER(student_dtl_rec.p_permt_addr1),
x_s_permt_addr2 => UPPER(student_dtl_rec.p_permt_addr2),
x_s_permt_city => UPPER(student_dtl_rec.p_permt_city),
x_s_permt_state => UPPER(student_dtl_rec.p_permt_state),
x_s_permt_zip => UPPER(student_dtl_rec.p_permt_zip),
x_s_permt_addr_chg_date => NULL, -- FFELP
x_s_permt_phone => p_s_phone,
x_s_local_addr1 => NULL, -- Not Supported
x_s_local_addr2 => NULL, -- Not Supported
x_s_local_city => NULL, -- Not Supported
x_s_local_state => NULL, -- Not Supported
x_s_local_zip => NULL, -- Not Supported
x_s_local_addr_chg_date => NULL, -- Not Supported
x_s_email_addr => UPPER(student_dtl_rec.p_email_addr),
x_s_date_of_birth => NVL(loan_oldinfo_rec.s_date_of_birth,student_dtl_rec.p_date_of_birth), -- attribute
x_s_dob_chg_date => NULL, -- FFELP
x_s_license_num => UPPER(student_dtl_rec.p_license_num),
x_s_license_state => UPPER(student_dtl_rec.p_license_state),
x_s_depncy_status => p_isir_dep,
x_s_default_status => p_loan_rec.s_default_status,
x_s_citizenship_status => student_dtl_rec.p_citizenship_status,
x_s_alien_reg_num => NULL, -- FFELP
x_s_foreign_postal_code => NULL, -- FFELP
x_mode => 'R',
x_pnote_batch_id => p_loan_rec.pnote_batch_id,
x_pnote_ack_date => p_loan_rec.pnote_ack_date,
x_pnote_mpn_ind => p_loan_rec.pnote_mpn_ind,
x_award_id => p_loan_rec.award_id,
x_base_id => p_loan_rec.base_id,
x_document_id_txt => gv_document_id_txt,
x_loan_key_num => ln_loan_key,
x_interest_rebate_percent_num => setup_rec.int_rebate,
x_fin_award_year => SUBSTR(gv_dl_version,-4),
x_cps_trans_num => p_isir_tnum,
x_atd_entity_id_txt => p_loan_rec.atd_entity_id_txt,
x_rep_entity_id_txt => p_loan_rec.rep_entity_id_txt,
x_source_entity_id_txt => p_source_id,
x_pymt_servicer_amt => p_loan_rec.pymt_servicer_amt,
x_pymt_servicer_date => p_loan_rec.pymt_servicer_date,
x_book_loan_amt => p_loan_rec.book_loan_amt,
x_book_loan_amt_date => p_loan_rec.book_loan_amt_date,
x_s_chg_birth_date => loan_oldinfo_rec.s_chg_birth_date,
x_s_chg_ssn => loan_oldinfo_rec.s_chg_ssn,
x_s_chg_last_name => UPPER(loan_oldinfo_rec.s_chg_last_name),
x_b_chg_birth_date => loan_oldinfo_rec.b_chg_birth_date,
x_b_chg_ssn => loan_oldinfo_rec.b_chg_ssn,
x_b_chg_last_name => UPPER(loan_oldinfo_rec.b_chg_last_name),
x_note_message => p_loan_rec.note_message,
x_full_resp_code => NVL(setup_rec.response_option_code,'F'),
x_s_permt_county => UPPER(student_dtl_rec.p_county),
x_b_permt_county => UPPER(parent_dtl_rec.p_county),
x_s_permt_country => UPPER(student_dtl_rec.p_country),
x_b_permt_country => UPPER(parent_dtl_rec.p_country),
x_crdt_decision_status => p_loan_rec.crdt_decision_status,
x_mpn_type_flag => p_loan_rec.elec_mpn_ind,
x_alt_borrower_ind_flag => NULL,-- FFELP
x_borower_credit_authoriz_flag => NULL,-- FFELP
x_borower_electronic_sign_flag => NULL,-- FFELP
x_cost_of_attendance_amt => NULL,-- FFELP
x_deferment_request_code => NULL,-- FFELP
x_eft_authorization_code => NULL,-- FFELP
x_established_fin_aid_amount => NULL,-- FFELP
x_expect_family_contribute_amt => NULL,-- FFELP
x_external_loan_id_txt => NULL,-- FFELP
x_flp_approved_amt => NULL,-- FFELP
x_fls_approved_amt => NULL,-- FFELP
x_flu_approved_amt => NULL,-- FFELP
x_guarantor_use_txt => NULL,-- FFELP
x_lender_use_txt => NULL,-- FFELP
x_loan_app_form_code => NULL,-- FFELP
x_reinstatement_amt => NULL,-- FFELP
x_requested_loan_amt => NULL,-- FFELP
x_school_id_txt => NULL,-- FFELP
x_school_use_txt => NULL,-- FFELP
x_student_electronic_sign_flag => NULL,-- FFELP
x_actual_record_type_code => NULL,-- FFELP
x_alt_approved_amt => NULL,
x_esign_src_typ_cd => NULL
);-- FFELP
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','inserting cod db dtls');
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','after inserting cod db dtls seq num, disb num, award id' || rec.disb_seq_num || ' , ' || rec.disb_num || ' , ' || rec.award_id);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.insert_lor_loc.debug','after inserting cod db dtls');
END insert_lor_loc;
SELECT payment_isir,transaction_num,dependency_status,
date_of_birth,current_ssn,last_name
FROM igf_ap_isir_matched_all
WHERE base_id = p_base_id
AND payment_isir = 'Y'
AND system_record_type = 'ORIGINAL';
insert_lor_loc(p_loan_rec,p_source_id,student_dtl_rec,parent_dtl_rec,
p_isir_ssn,p_isir_dob,p_isir_lname,p_isir_dep,p_isir_tnum,
p_acad_begin,p_acad_end,p_s_phone, p_p_phone);
fnd_message.set_name('IGF','IGF_SL_DL_XML_INSERT_EXC');
SELECT person_number
FROM igs_pe_person_base_v
WHERE
person_id = p_person_id;
SELECT
base_id
FROM
igf_ap_fa_base_rec_all
WHERE
person_id = p_person_id AND
ci_cal_type = p_cal_type AND
ci_sequence_number = p_sequence_number;
CURSOR cur_sequence IS SELECT IGF_SL_DL_GEN_XML_S.NEXTVAL FROM DUAL;
SELECT description FROM igf_aw_fund_mast_all
WHERE fund_id = p_fund_id;
SELECT loan_number FROM igf_sl_loans_all
WHERE loan_id = p_loan_id;
SELECT group_cd
FROM igs_pe_persid_group_all
WHERE group_id = p_per_grp_id;
SELECT base_id
FROM igf_ap_fa_base_rec_all
WHERE base_id = p_base_id AND
ci_cal_type = p_cal_type AND
ci_sequence_number = p_seq_number;
SELECT meaning, lookup_code
FROM igf_lookups_view
WHERE lookup_type = 'IGF_GE_PARAMETERS'
AND lookup_code IN ('PARAMETER_PASS',
'AWARD_YEAR',
'SOURCE_ENTITY_ID', -- New
'REPORT_ENTITY_ID', -- New
'ATTEND_ENTITY_ID', -- New
'LOAN_TYPE', -- New
'PERSON_NUMBER',
'LOAN_NUMBER', -- New
'PERSON_ID_GROUP');
SELECT loan_number
FROM igf_sl_loans_all
WHERE loan_id = p_loan_id;
SELECT document_id_txt
FROM igf_sl_lor_loc_all
WHERE document_id_txt = p_document_id_txt;
SELECT award_year_status_code,dl_participant_code, sys_award_year
FROM igf_ap_batch_aw_map_all
WHERE ci_sequence_number = p_seq_number AND ci_cal_type = p_cal_type;
SELECT
rep.rep_entity_id_txt
FROM
igf_gr_report_pell rep
WHERE
rep.rep_entity_id_txt = p_source_id AND
rep.ci_cal_type = p_cal_type AND
rep.ci_sequence_number = p_seq_number;
SELECT
lor.loan_id
FROM
igf_sl_lor_all lor,
igf_sl_loans_all loan,
igf_aw_award_all awd,
igf_aw_fund_mast_all fmast
WHERE
loan.award_id = awd.award_id AND
awd.fund_id = fmast.fund_id AND
fmast.ci_sequence_number = p_seq_number AND
fmast.ci_cal_type = p_cal_type AND
lor.loan_id = loan.loan_id AND
lor.rep_entity_id_txt = p_report_id;
SELECT
lor.loan_id
FROM
igf_sl_lor_all lor,
igf_sl_loans_all loan,
igf_aw_award_all awd,
igf_aw_fund_mast_all fmast
WHERE
loan.award_id = awd.award_id AND
awd.fund_id = fmast.fund_id AND
fmast.ci_sequence_number = p_seq_number AND
fmast.ci_cal_type = p_cal_type AND
lor.loan_id = loan.loan_id AND
lor.rep_entity_id_txt = p_report_id AND
lor.atd_entity_id_txt = p_attend_id;
SELECT loan.loan_id
FROM
igf_sl_loans_all loan,
igf_aw_award_all awd
WHERE
awd.award_id = loan.award_id AND
awd.base_id = p_base_id AND
(
loan.loan_status = 'G' OR
loan.loan_chg_status = 'G'
);
SELECT group_id
FROM igs_pe_persid_group_all
WHERE
group_id = p_pgroup_id AND
closed_ind = 'N';
loan_key_rec.DELETE;
OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_pgroup_id;
OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';
SELECT COUNT(*) INTO ln_top FROM igf_sl_cod_top_v WHERE document_id_txt = gv_document_id_txt;
SELECT COUNT(*) INTO ln_sm FROM igf_sl_rep_smry_v WHERE document_id_txt = gv_document_id_txt;
SELECT COUNT(*) INTO ln_rs FROM igf_sl_rep_rs_v WHERE document_id_txt = gv_document_id_txt;
SELECT COUNT(*) INTO ln_rp FROM igf_sl_cod_rep_v WHERE document_id_txt = gv_document_id_txt;
SELECT COUNT(*) INTO ln_as FROM igf_sl_rep_as_v WHERE document_id_txt = gv_document_id_txt;
SELECT COUNT(*) INTO ln_st FROM igf_sl_rep_stdnt_v WHERE document_id_txt = gv_document_id_txt;
SELECT COUNT(*) INTO ln_db FROM igf_sl_db_cod_rep_v WHERE document_id_txt = gv_document_id_txt;
SELECT meaning, lookup_code
FROM igf_lookups_view
WHERE lookup_type = 'IGF_GE_PARAMETERS'
AND lookup_code IN ('PARAMETER_PASS',
'DOCUMENT_ID');
update_status(p_document_id_txt);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.print_xml.debug','Calling update status, doc id ' || p_document_id_txt);
igf_sl_cod_doc_dtls_pkg.update_row(x_rowid => lv_rowid,
x_document_id_txt => p_document_id_txt,
x_outbound_doc => lc_newxmldoc,
x_inbound_doc => NULL,
x_send_date => TRUNC(SYSDATE),
x_ack_date => NULL,
x_doc_status => 'S',
x_doc_type => 'DL',
x_full_resp_code => NULL,
x_mode => 'R');
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.store_xml.debug',' insert into doc dtls ');
igf_sl_cod_doc_dtls_pkg.insert_row(
x_rowid => lv_rowid,
x_document_id_txt => lv_document_id_txt,
x_outbound_doc => l_clob,
x_inbound_doc => NULL,
x_send_date => NULL,
x_ack_date => NULL,
x_doc_status => 'R',
x_doc_type => 'DL',
x_full_resp_code => NULL,
x_mode => 'R');