eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_DB_SF_INTEGRATION dependencies on IGF_DB_AWD_DISB_DTL

Line 27: -- Changed the TBH calls of the packages: IGF_AW_AWD_DISB_PKG and IGF_DB_AWD_DISB_DTL_PKG

23: --ridas 08-Nov-2004 Bug 3021287 If the profile_value = 'TRANSFER'
24: -- then updating COA at the student level
25:
26: --ayedubat 14-OCT-04 FA 149 COD-XML Standards build bug # 3416863
27: -- Changed the TBH calls of the packages: IGF_AW_AWD_DISB_PKG and IGF_DB_AWD_DISB_DTL_PKG
28: --smadathi 01-JUL-2004 Bug 3735396. GSCC Warning File.Sql.35 was also fixed as part of this bug.
29: -- The variable g_chgadj global to this package body is modified as CONSTANT
30: -- variable. Modified procedure transfer_disb_dtls_to_sf,function validate_persid_grp,
31: -- procedure main_disbursement

Line 101: FROM igf_db_awd_disb_dtl disb_dlt,

97: fcat.sys_fund_type sys_fund_type,fnd.ci_cal_type,fnd.ci_sequence_number,fnd.credit_type_id,
98: DECODE(disb_dlt.disb_seq_num,1,disb_dlt.disb_net_amt,disb_dlt.disb_adj_amt) amount,
99: NVL(disb_dlt.ld_cal_type,disb.ld_cal_type) ld_cal_type, NVL(disb_dlt.ld_sequence_number,disb.ld_sequence_number) ld_sequence_number,
100: fnd.fund_id, fnd.fund_code fund_code
101: FROM igf_db_awd_disb_dtl disb_dlt,
102: igf_aw_awd_disb disb,
103: igf_aw_award awd,
104: igf_aw_fund_mast fnd,
105: igf_aw_fund_cat fcat,

Line 361: p_status OUT NOCOPY igf_db_awd_disb_dtl.sf_status%TYPE,

357: PROCEDURE call_credits_api(p_cur_disb IN cur_disb%ROWTYPE,
358: p_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
359: p_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
360: p_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
361: p_status OUT NOCOPY igf_db_awd_disb_dtl.sf_status%TYPE,
362: p_error_desc OUT NOCOPY igf_db_awd_disb_dtl.error_desc%TYPE,
363: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
364: p_n_source_invoice_id IN igs_fi_credits_all.source_invoice_id%TYPE
365: )AS

Line 362: p_error_desc OUT NOCOPY igf_db_awd_disb_dtl.error_desc%TYPE,

358: p_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
359: p_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
360: p_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
361: p_status OUT NOCOPY igf_db_awd_disb_dtl.sf_status%TYPE,
362: p_error_desc OUT NOCOPY igf_db_awd_disb_dtl.error_desc%TYPE,
363: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE,
364: p_n_source_invoice_id IN igs_fi_credits_all.source_invoice_id%TYPE
365: )AS
366: /***********************************************************************************************

Line 438: l_msg_data igf_db_awd_disb_dtl.error_desc%TYPE;

434: l_cur_api cur_api%ROWTYPE;
435:
436: l_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE;
437: l_msg_count NUMBER(2);
438: l_msg_data igf_db_awd_disb_dtl.error_desc%TYPE;
439: l_attribute_rec igs_fi_credits_api_pub.attribute_rec_type;
440: l_credit_num NUMBER;
441: l_person_id igs_pe_person_v.person_id%TYPE;
442: l_desc igs_fi_credits_all.description%TYPE;

Line 443: l_amount igf_db_awd_disb_dtl.disb_net_amt%TYPE;

439: l_attribute_rec igs_fi_credits_api_pub.attribute_rec_type;
440: l_credit_num NUMBER;
441: l_person_id igs_pe_person_v.person_id%TYPE;
442: l_desc igs_fi_credits_all.description%TYPE;
443: l_amount igf_db_awd_disb_dtl.disb_net_amt%TYPE;
444:
445: l_v_message_name fnd_new_messages.message_name%TYPE;
446: l_credit_rec igs_fi_credit_pvt.credit_rec_type;
447: l_v_credit_number igs_fi_credits.credit_number%TYPE;

Line 588: p_status OUT NOCOPY igf_db_awd_disb_dtl.sf_status%TYPE,

584: PROCEDURE call_charges_api(p_cur_disb IN cur_disb%ROWTYPE,
585: p_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
586: p_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
587: p_invoice_id OUT NOCOPY igs_fi_inv_int_all.invoice_id%TYPE,
588: p_status OUT NOCOPY igf_db_awd_disb_dtl.sf_status%TYPE,
589: p_error_desc OUT NOCOPY igf_db_awd_disb_dtl.error_desc%TYPE,
590: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE
591: )AS
592: /***********************************************************************************************

Line 589: p_error_desc OUT NOCOPY igf_db_awd_disb_dtl.error_desc%TYPE,

585: p_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
586: p_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
587: p_invoice_id OUT NOCOPY igs_fi_inv_int_all.invoice_id%TYPE,
588: p_status OUT NOCOPY igf_db_awd_disb_dtl.sf_status%TYPE,
589: p_error_desc OUT NOCOPY igf_db_awd_disb_dtl.error_desc%TYPE,
590: p_d_gl_date IN igs_fi_credits_all.gl_date%TYPE
591: )AS
592: /***********************************************************************************************
593:

Line 655: l_msg_data igf_db_awd_disb_dtl.error_desc%TYPE;

651: l_chg_line_tbl igs_fi_charges_api_pvt.line_tbl_type;
652: l_line_tbl igs_fi_charges_api_pvt.line_id_tbl_type;
653: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
654: l_msg_count NUMBER(5);
655: l_msg_data igf_db_awd_disb_dtl.error_desc%TYPE;
656: l_var NUMBER(5) := 0;
657: l_count NUMBER(5);
658: l_msg igf_db_awd_disb_dtl.error_desc%TYPE;
659: l_person_id igs_pe_person_v.person_id%TYPE;

Line 658: l_msg igf_db_awd_disb_dtl.error_desc%TYPE;

654: l_msg_count NUMBER(5);
655: l_msg_data igf_db_awd_disb_dtl.error_desc%TYPE;
656: l_var NUMBER(5) := 0;
657: l_count NUMBER(5);
658: l_msg igf_db_awd_disb_dtl.error_desc%TYPE;
659: l_person_id igs_pe_person_v.person_id%TYPE;
660: l_fee_type igf_aw_fund_mast.fee_type%TYPE;
661: l_invoice_desc igs_fi_inv_int.invoice_desc%TYPE;
662: l_amount igf_db_awd_disb_dtl.disb_net_amt%TYPE;

Line 662: l_amount igf_db_awd_disb_dtl.disb_net_amt%TYPE;

658: l_msg igf_db_awd_disb_dtl.error_desc%TYPE;
659: l_person_id igs_pe_person_v.person_id%TYPE;
660: l_fee_type igf_aw_fund_mast.fee_type%TYPE;
661: l_invoice_desc igs_fi_inv_int.invoice_desc%TYPE;
662: l_amount igf_db_awd_disb_dtl.disb_net_amt%TYPE;
663: l_transaction_type igs_lookups_view.lookup_code%TYPE;
664:
665: l_v_currency igs_fi_control_all.currency_cd%TYPE;
666: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 844: vvutukur 26-Feb-2003 Enh#2758823.FA117 Build. Modified the call to igf_db_awd_disb_dtl_pkg.update_row to pass TRUNC(SYSDATE)

840: appropriate values.
841: error description fields
842: shtatiko 26-MAR-2003 Bug# 2782124, Changed the logging of results from tabular format to
843: form layout.
844: vvutukur 26-Feb-2003 Enh#2758823.FA117 Build. Modified the call to igf_db_awd_disb_dtl_pkg.update_row to pass TRUNC(SYSDATE)
845: instead of SYSDATE for the parameter x_sf_status_date.
846: smadathi 31-dec-2002 Bug 2620359. Modified the cursor cur_person to fetch the person number
847: from igs_pe_person_base_v instead of the igs_pe_person. This is done
848: due to Non-Meargability and higher value of shared memory beyong the acceptable limit

Line 892: CURSOR cur_disb_dtl (cp_award_id igf_db_awd_disb_dtl.award_id%TYPE,

888: WHERE lon.award_id=cp_award_id
889: AND lon.loan_id=lor.loan_id;
890: l_borrower igf_sl_lor.p_person_id%TYPE;
891:
892: CURSOR cur_disb_dtl (cp_award_id igf_db_awd_disb_dtl.award_id%TYPE,
893: cp_disb_num igf_db_awd_disb_dtl.disb_num%TYPE,
894: cp_disb_seq_num igf_db_awd_disb_dtl.disb_seq_num%TYPE) IS
895: SELECT a.rowid,a.*
896: FROM igf_db_awd_disb_dtl a

Line 893: cp_disb_num igf_db_awd_disb_dtl.disb_num%TYPE,

889: AND lon.loan_id=lor.loan_id;
890: l_borrower igf_sl_lor.p_person_id%TYPE;
891:
892: CURSOR cur_disb_dtl (cp_award_id igf_db_awd_disb_dtl.award_id%TYPE,
893: cp_disb_num igf_db_awd_disb_dtl.disb_num%TYPE,
894: cp_disb_seq_num igf_db_awd_disb_dtl.disb_seq_num%TYPE) IS
895: SELECT a.rowid,a.*
896: FROM igf_db_awd_disb_dtl a
897: WHERE award_id=cp_award_id

Line 894: cp_disb_seq_num igf_db_awd_disb_dtl.disb_seq_num%TYPE) IS

890: l_borrower igf_sl_lor.p_person_id%TYPE;
891:
892: CURSOR cur_disb_dtl (cp_award_id igf_db_awd_disb_dtl.award_id%TYPE,
893: cp_disb_num igf_db_awd_disb_dtl.disb_num%TYPE,
894: cp_disb_seq_num igf_db_awd_disb_dtl.disb_seq_num%TYPE) IS
895: SELECT a.rowid,a.*
896: FROM igf_db_awd_disb_dtl a
897: WHERE award_id=cp_award_id
898: AND disb_num=cp_disb_num

Line 896: FROM igf_db_awd_disb_dtl a

892: CURSOR cur_disb_dtl (cp_award_id igf_db_awd_disb_dtl.award_id%TYPE,
893: cp_disb_num igf_db_awd_disb_dtl.disb_num%TYPE,
894: cp_disb_seq_num igf_db_awd_disb_dtl.disb_seq_num%TYPE) IS
895: SELECT a.rowid,a.*
896: FROM igf_db_awd_disb_dtl a
897: WHERE award_id=cp_award_id
898: AND disb_num=cp_disb_num
899: AND disb_seq_num=cp_disb_seq_num;
900: l_rec_disb_dtl cur_disb_dtl%ROWTYPE;

Line 901: l_status igf_db_awd_disb_dtl.sf_status%TYPE;

897: WHERE award_id=cp_award_id
898: AND disb_num=cp_disb_num
899: AND disb_seq_num=cp_disb_seq_num;
900: l_rec_disb_dtl cur_disb_dtl%ROWTYPE;
901: l_status igf_db_awd_disb_dtl.sf_status%TYPE;
902: l_error_desc igf_db_awd_disb_dtl.error_desc%TYPE :=NULL;
903: l_sf_credit_id igf_db_awd_disb_dtl.sf_credit_id%TYPE := NULL;
904: l_sf_invoice_num igf_db_awd_disb_dtl.sf_invoice_num%TYPE := NULL;
905: l_spnsr_credit_id igf_db_awd_disb_dtl.spnsr_credit_id%TYPE := NULL;

Line 902: l_error_desc igf_db_awd_disb_dtl.error_desc%TYPE :=NULL;

898: AND disb_num=cp_disb_num
899: AND disb_seq_num=cp_disb_seq_num;
900: l_rec_disb_dtl cur_disb_dtl%ROWTYPE;
901: l_status igf_db_awd_disb_dtl.sf_status%TYPE;
902: l_error_desc igf_db_awd_disb_dtl.error_desc%TYPE :=NULL;
903: l_sf_credit_id igf_db_awd_disb_dtl.sf_credit_id%TYPE := NULL;
904: l_sf_invoice_num igf_db_awd_disb_dtl.sf_invoice_num%TYPE := NULL;
905: l_spnsr_credit_id igf_db_awd_disb_dtl.spnsr_credit_id%TYPE := NULL;
906: l_spnsr_charge_id igf_db_awd_disb_dtl.spnsr_charge_id%TYPE := NULL;

Line 903: l_sf_credit_id igf_db_awd_disb_dtl.sf_credit_id%TYPE := NULL;

899: AND disb_seq_num=cp_disb_seq_num;
900: l_rec_disb_dtl cur_disb_dtl%ROWTYPE;
901: l_status igf_db_awd_disb_dtl.sf_status%TYPE;
902: l_error_desc igf_db_awd_disb_dtl.error_desc%TYPE :=NULL;
903: l_sf_credit_id igf_db_awd_disb_dtl.sf_credit_id%TYPE := NULL;
904: l_sf_invoice_num igf_db_awd_disb_dtl.sf_invoice_num%TYPE := NULL;
905: l_spnsr_credit_id igf_db_awd_disb_dtl.spnsr_credit_id%TYPE := NULL;
906: l_spnsr_charge_id igf_db_awd_disb_dtl.spnsr_charge_id%TYPE := NULL;
907: l_paid_amt igf_aw_award.paid_amt%TYPE;

Line 904: l_sf_invoice_num igf_db_awd_disb_dtl.sf_invoice_num%TYPE := NULL;

900: l_rec_disb_dtl cur_disb_dtl%ROWTYPE;
901: l_status igf_db_awd_disb_dtl.sf_status%TYPE;
902: l_error_desc igf_db_awd_disb_dtl.error_desc%TYPE :=NULL;
903: l_sf_credit_id igf_db_awd_disb_dtl.sf_credit_id%TYPE := NULL;
904: l_sf_invoice_num igf_db_awd_disb_dtl.sf_invoice_num%TYPE := NULL;
905: l_spnsr_credit_id igf_db_awd_disb_dtl.spnsr_credit_id%TYPE := NULL;
906: l_spnsr_charge_id igf_db_awd_disb_dtl.spnsr_charge_id%TYPE := NULL;
907: l_paid_amt igf_aw_award.paid_amt%TYPE;
908: l_disb_paid_amt igf_aw_awd_disb.disb_paid_amt%TYPE;

Line 905: l_spnsr_credit_id igf_db_awd_disb_dtl.spnsr_credit_id%TYPE := NULL;

901: l_status igf_db_awd_disb_dtl.sf_status%TYPE;
902: l_error_desc igf_db_awd_disb_dtl.error_desc%TYPE :=NULL;
903: l_sf_credit_id igf_db_awd_disb_dtl.sf_credit_id%TYPE := NULL;
904: l_sf_invoice_num igf_db_awd_disb_dtl.sf_invoice_num%TYPE := NULL;
905: l_spnsr_credit_id igf_db_awd_disb_dtl.spnsr_credit_id%TYPE := NULL;
906: l_spnsr_charge_id igf_db_awd_disb_dtl.spnsr_charge_id%TYPE := NULL;
907: l_paid_amt igf_aw_award.paid_amt%TYPE;
908: l_disb_paid_amt igf_aw_awd_disb.disb_paid_amt%TYPE;
909: l_status_code igf_db_awd_disb_dtl.sf_status%TYPE;

Line 906: l_spnsr_charge_id igf_db_awd_disb_dtl.spnsr_charge_id%TYPE := NULL;

902: l_error_desc igf_db_awd_disb_dtl.error_desc%TYPE :=NULL;
903: l_sf_credit_id igf_db_awd_disb_dtl.sf_credit_id%TYPE := NULL;
904: l_sf_invoice_num igf_db_awd_disb_dtl.sf_invoice_num%TYPE := NULL;
905: l_spnsr_credit_id igf_db_awd_disb_dtl.spnsr_credit_id%TYPE := NULL;
906: l_spnsr_charge_id igf_db_awd_disb_dtl.spnsr_charge_id%TYPE := NULL;
907: l_paid_amt igf_aw_award.paid_amt%TYPE;
908: l_disb_paid_amt igf_aw_awd_disb.disb_paid_amt%TYPE;
909: l_status_code igf_db_awd_disb_dtl.sf_status%TYPE;
910: l_log_status igf_lookups_view.meaning%TYPE;

Line 909: l_status_code igf_db_awd_disb_dtl.sf_status%TYPE;

905: l_spnsr_credit_id igf_db_awd_disb_dtl.spnsr_credit_id%TYPE := NULL;
906: l_spnsr_charge_id igf_db_awd_disb_dtl.spnsr_charge_id%TYPE := NULL;
907: l_paid_amt igf_aw_award.paid_amt%TYPE;
908: l_disb_paid_amt igf_aw_awd_disb.disb_paid_amt%TYPE;
909: l_status_code igf_db_awd_disb_dtl.sf_status%TYPE;
910: l_log_status igf_lookups_view.meaning%TYPE;
911: l_flag1 BOOLEAN :=TRUE;
912: l_flag2 BOOLEAN :=TRUE;
913: l_flag3 BOOLEAN :=TRUE;

Line 1286: igf_db_awd_disb_dtl_pkg.update_row( X_ROWID => l_rec_disb_dtl.rowid,

1282: OPEN cur_disb_dtl(p_rec_disb.award_id,p_rec_disb.disb_num,p_rec_disb.disb_seq_num);
1283: FETCH cur_disb_dtl INTO l_rec_disb_dtl;
1284: CLOSE cur_disb_dtl;
1285: BEGIN
1286: igf_db_awd_disb_dtl_pkg.update_row( X_ROWID => l_rec_disb_dtl.rowid,
1287: X_AWARD_ID => l_rec_disb_dtl.award_id,
1288: X_DISB_NUM => l_rec_disb_dtl.disb_num,
1289: X_DISB_SEQ_NUM => l_rec_disb_dtl.disb_seq_num,
1290: X_DISB_GROSS_AMT => l_rec_disb_dtl.disb_gross_amt,