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_AW_AWARD

Line 17: -- in the igf_aw_awd_disb_pkg.update_row (l_disb_paid_amt), igf_aw_award_pkg.update_row

13: --Change History:
14: --Who When What
15: --museshad 10-Aug-2006 Bug 5337555. Build FA 163. TBH Impact.
16: --svuppala 12-May-2006 Bug 5217319 Added call to format amount by rounding off to currency precision
17: -- in the igf_aw_awd_disb_pkg.update_row (l_disb_paid_amt), igf_aw_award_pkg.update_row
18: -- (l_paid_amt) calls in main_disbursement procedure
19: --pmarada 26-JUL-2005 Enh 3392095, modifed as per tution waiver build, passing p_api_version
20: -- parameter value as 2.1 to the igs_fi_credit_pvt.create_credit call
21: --svuppala 18-JUL-2005 Enh 4213629 - Impact of automatic generation of the Receipt Number

Line 35: -- Changed signature of igf_aw_award_pkg.update_row(Added adplans_id to the tbh call)

31: -- procedure main_disbursement
32: --pathipat 22-Apr-2004 Enh 3558549 - Commercial Receivables Enhancements build
33: -- Modified call_credits_api() and main_disbursement()
34: --veramach 3-NOV-2003 FA 125 Multiple Distr Methods
35: -- Changed signature of igf_aw_award_pkg.update_row(Added adplans_id to the tbh call)
36: -- Changed signature of igf_aw_awd_disb_pkg.update_row(Added attendance_type_code to the tbh call)
37: --pathipat 21-Aug-2003 Enh 3076768 - Auto Release of Holds build
38: -- Modified call_credits_api() - added check when return_status = 'S'
39: -- Modified main_disbursement()

Line 44: --bkkumar 04-jun-2003 #2858504 Added legacy_record_flag and award_number_txt in the table handler calls for igf_aw_award_pkg.update_row

40: --vvutukur 18-Jul-2003 Enh#3038511.FICR106 Build. Modified procedure transfer_disb_dtls_to_sf.
41: --SMADATHI 26-jun-2003 Bug 2852816. Modified procedures call_credits_api,call_charges_api,main_disbursement
42: -- Modified cursor cur_disb select to include fund_code column
43: --vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Modified the procedure call_credits_api.
44: --bkkumar 04-jun-2003 #2858504 Added legacy_record_flag and award_number_txt in the table handler calls for igf_aw_award_pkg.update_row
45: --shtatiko 02-MAY-2003 Enh# 2831569, Modified transfer_disb_dtls_to_sf and added check for Manage Accounts
46: -- System Option to cur_disb cursor.
47: --vvutukur 08-Apr-2003 Enh#2831554.Internal Credits API Build. Modified function lookup_desc and procedures
48: -- call_credits_api,call_charges_api,main_disbursement,transfer_disb_dtls_to_sf.

Line 66: -- adhawan 25-oct-2002 Bug #2613546 Added ALT_PELL_SCHEDULE in igf_aw_award_pkg.update_row

62: --smadathi 31-dec-2002 Bug 2620343. Modified function validate_persid_grp
63: --vvutukur 13-Dec-2002 Enh#2584741.Modified procedure call_credits_api.
64: --vvutukur 20-Nov-2002 Enh#2584986.Modifications done in transfer_disb_dtls_to_sf,main_disbursement,
65: -- call_charges_api,call_credits_api.
66: -- adhawan 25-oct-2002 Bug #2613546 Added ALT_PELL_SCHEDULE in igf_aw_award_pkg.update_row
67: --jbegum 21-Sep-2002 Bug#2564643 Modified call_credits_api and call_charges_api.
68: --smadathi 10-JUL-2002 Bug 2450332. call_credits_api modified.
69: --smadathi 03-Jun-2002 Bug 2349394. Added new private function get_bill_desc. Also modified call_credits_api,
70: -- call_charges_api. Modified cur_disb to select fund_id column also.

Line 90: cp_person_id igf_aw_award_v.person_id%TYPE,

86: -- is not allowed if Manage Accounts Option has value OTHER.
87: CURSOR cur_disb(cp_cal_type igf_aw_fund_mast_v.ci_cal_type%TYPE,
88: cp_sequence_number igf_aw_fund_mast_v.ci_sequence_number%TYPE,
89: cp_fund_id igf_aw_fund_mast_v.fund_id%TYPE,
90: cp_person_id igf_aw_award_v.person_id%TYPE,
91: cp_tp_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,
92: cp_tp_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE,
93: cp_manage_accounts igs_fi_control_all.manage_accounts%TYPE
94: ) IS

Line 103: igf_aw_award awd,

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,
106: igf_ap_fa_base_rec fab
107: WHERE disb_dlt.award_id = disb.award_id

Line 826: in igf_aw_awd_disb_pkg.update_row , igf_aw_award_pkg.update_row calls

822: Known limitations,enhancements,remarks:
823: Change History
824: Who When What
825: svuppala 12-May-2006 Bug 5217319 Added call to format amount by rounding off to currency precision
826: in igf_aw_awd_disb_pkg.update_row , igf_aw_award_pkg.update_row calls
827: smadathi 01-JUL-2004 Bug 3735396. GSCC Warning File.Sql.35 was fixed as part of this bug. The initialization
828: of local variable l_status in the procedure declaration was removed and the same
829: was initialized at the starting of this procedure.
830: pathipat 22-Apr-2004 Enh 3558549 - Commercial Receivables Enhancements

Line 833: Changed signature of igf_aw_award_pkg.update_row(Added adplans_id to the tbh call)

829: was initialized at the starting of this procedure.
830: pathipat 22-Apr-2004 Enh 3558549 - Commercial Receivables Enhancements
831: Modified calls to call_credits_api() - added new parameter p_n_source_invoice_id
832: veramach 3-NOV-2003 FA 125 Multiple Distr Methods
833: Changed signature of igf_aw_award_pkg.update_row(Added adplans_id to the tbh call)
834: Changed signature of igf_aw_awd_disb_pkg.update_row(Added attendance_type_code to the tbh call)
835: pathipat 23-Aug-2003 Enh 3076768 - Automatic Release of Holds build
836: Added code to log message is holds release failed in call to Credits API
837: SMADATHI 26-jun-2003 Bug 2852816. Removed parameter p_student_sponsor from the calls to call_credits_api,call_charges_api

Line 871: CURSOR cur_awd(cp_award_id igf_aw_award.award_id%TYPE) IS

867: WHERE credit_type_id = cp_credit_type_id;
868:
869: l_v_cr_type_name igs_fi_cr_types_all.credit_type_name%TYPE;
870:
871: CURSOR cur_awd(cp_award_id igf_aw_award.award_id%TYPE) IS
872: SELECT a.rowid,a.*
873: FROM igf_aw_award a
874: WHERE award_id=cp_award_id;
875: l_rec_awd cur_awd%ROWTYPE;

Line 873: FROM igf_aw_award a

869: l_v_cr_type_name igs_fi_cr_types_all.credit_type_name%TYPE;
870:
871: CURSOR cur_awd(cp_award_id igf_aw_award.award_id%TYPE) IS
872: SELECT a.rowid,a.*
873: FROM igf_aw_award a
874: WHERE award_id=cp_award_id;
875: l_rec_awd cur_awd%ROWTYPE;
876:
877: CURSOR cur_awd_disb(cp_award_id igf_aw_awd_disb.award_id%TYPE,

Line 907: l_paid_amt igf_aw_award.paid_amt%TYPE;

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;
911: l_flag1 BOOLEAN :=TRUE;

Line 1134: igf_aw_award_pkg.update_row( X_ROWID => l_rec_awd.rowid,

1130: l_paid_amt := NVL(l_rec_awd.paid_amt,0) + p_rec_disb.amount;
1131:
1132: BEGIN
1133: -- Bug 5217319 Added call to format amount by rounding off to currency precision for l_paid_amt
1134: igf_aw_award_pkg.update_row( X_ROWID => l_rec_awd.rowid,
1135: X_AWARD_ID => l_rec_awd.award_id,
1136: X_FUND_ID => l_rec_awd.fund_id,
1137: X_BASE_ID => l_rec_awd.base_id,
1138: X_OFFERED_AMT => l_rec_awd.offered_amt,