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_AWD_DISB

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 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 36: -- Changed signature of igf_aw_awd_disb_pkg.update_row(Added attendance_type_code to the tbh call)

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()
40: --vvutukur 18-Jul-2003 Enh#3038511.FICR106 Build. Modified procedure transfer_disb_dtls_to_sf.

Line 71: --SYkrishn 08-MAY-2002 Procedure main_disbursement - The column DISB_PAID_AMT in the table igf_aw_awd_disb is updated

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.
71: --SYkrishn 08-MAY-2002 Procedure main_disbursement - The column DISB_PAID_AMT in the table igf_aw_awd_disb is updated
72: -- with the Cumulation of existing Disb Paid amount with the newly disbursed amount (each iteration)
73: -- instead of overriding with the new value - Bug 2356801.
74: --sarakshi 18-Mar-2002 Bug:2144600, added logic for refunding the excess credit amount in
75: -- main_disbursement program unit

Line 76: --vchappid 11-Feb-2002 Enh#2191470,modified cursor cur_disb, to include igf_aw_awd_disb table and

72: -- with the Cumulation of existing Disb Paid amount with the newly disbursed amount (each iteration)
73: -- instead of overriding with the new value - Bug 2356801.
74: --sarakshi 18-Mar-2002 Bug:2144600, added logic for refunding the excess credit amount in
75: -- main_disbursement program unit
76: --vchappid 11-Feb-2002 Enh#2191470,modified cursor cur_disb, to include igf_aw_awd_disb table and
77: -- disb_dlt.ld_cal_type, disb_dlt.ld_sequence_number are included in the
78: -- cursor selected columns, removed reference to igf_aw_fund_tp_all and the where
79: -- clause is changed from tp_cal_type, tp_sequence_number to
80: -- disb_dlt.ld_cal_type, disb_dlt.ld_sequence_number

Line 102: igf_aw_awd_disb disb,

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,
106: igf_ap_fa_base_rec fab

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 834: Changed signature of igf_aw_awd_disb_pkg.update_row(Added attendance_type_code to the tbh call)

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
838: vvutukur 10-Apr-2003 Enh#2831554.Internal Credits API Build. Added validations for Fee,Load,Award Calendar Instances,credit type,

Line 852: SYkrishn 08-MAY-2002 The column DISB_PAID_AMT in the table igf_aw_awd_disb is updated with the Cumulation of existing Disb Paid amount

848: due to Non-Meargability and higher value of shared memory beyong the acceptable limit
849: vvutukur 20-Nov-2002 Enh#2584986.Added new parameter p_d_gl_date.Also modified the calls to call_charges_api
850: and call_credits_api to pass this p_d_gl_date parameter.Also added this p_d_gl_date
851: parameter to the call to igs_fi_prc_refunds.process_plus.
852: SYkrishn 08-MAY-2002 The column DISB_PAID_AMT in the table igf_aw_awd_disb is updated with the Cumulation of existing Disb Paid amount
853: with the newly disbursed amount (each iteration) instead of overriding with the new value - Bug 2356801.
854: sarakshi 18-Mar-2002 Bug:2144600, added logic for refunding the excess credit amount
855: vchappid 11-Feb-2002 Enh#2191470, Un-Commented reference to Fee Cal parameters in the Charges API invoking
856: Fee Cal Parameters Derived for the Load Cal are passed for charges Creation

Line 877: CURSOR cur_awd_disb(cp_award_id igf_aw_awd_disb.award_id%TYPE,

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,
878: cp_disb_num igf_aw_awd_disb.disb_num%TYPE) IS
879: SELECT a.rowid,a.*
880: FROM igf_aw_awd_disb a
881: WHERE award_id=cp_award_id

Line 878: cp_disb_num igf_aw_awd_disb.disb_num%TYPE) IS

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,
878: cp_disb_num igf_aw_awd_disb.disb_num%TYPE) IS
879: SELECT a.rowid,a.*
880: FROM igf_aw_awd_disb a
881: WHERE award_id=cp_award_id
882: AND disb_num=cp_disb_num;

Line 880: FROM igf_aw_awd_disb a

876:
877: CURSOR cur_awd_disb(cp_award_id igf_aw_awd_disb.award_id%TYPE,
878: cp_disb_num igf_aw_awd_disb.disb_num%TYPE) IS
879: SELECT a.rowid,a.*
880: FROM igf_aw_awd_disb a
881: WHERE award_id=cp_award_id
882: AND disb_num=cp_disb_num;
883: l_rec_awd_disb cur_awd_disb%ROWTYPE;
884:

Line 885: CURSOR cur_borrower(cp_award_id igf_aw_awd_disb.award_id%TYPE) IS

881: WHERE award_id=cp_award_id
882: AND disb_num=cp_disb_num;
883: l_rec_awd_disb cur_awd_disb%ROWTYPE;
884:
885: CURSOR cur_borrower(cp_award_id igf_aw_awd_disb.award_id%TYPE) IS
886: SELECT lor.p_person_id
887: FROM igf_sl_loans lon ,igf_sl_lor lor
888: WHERE lon.award_id=cp_award_id
889: AND lon.loan_id=lor.loan_id;

Line 908: l_disb_paid_amt igf_aw_awd_disb.disb_paid_amt%TYPE;

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;
912: l_flag2 BOOLEAN :=TRUE;

Line 1192: The column DISB_PAID_AMT in the table igf_aw_awd_disb is updated with the Cumulation of existing Disb Paid amount

1188: OPEN cur_awd_disb(p_rec_disb.award_id,p_rec_disb.disb_num);
1189: FETCH cur_awd_disb INTO l_rec_awd_disb;
1190: CLOSE cur_awd_disb;
1191: /*
1192: The column DISB_PAID_AMT in the table igf_aw_awd_disb is updated with the Cumulation of existing Disb Paid amount
1193: with the newly disbursed amount (each iteration) instead of overriding with the new value - Bug 2356801.
1194: */
1195: l_disb_paid_amt := NVL(l_rec_awd_disb.disb_paid_amt,0) + p_rec_disb.amount;
1196:

Line 1204: igf_aw_awd_disb_pkg.update_row( X_ROWID => l_rec_awd_disb.rowid,

1200: */
1201:
1202: BEGIN
1203: -- Bug 5217319 Added call to format amount by rounding off to currency precision for l_disb_paid_amt
1204: igf_aw_awd_disb_pkg.update_row( X_ROWID => l_rec_awd_disb.rowid,
1205: X_AWARD_ID => l_rec_awd_disb.award_id,
1206: X_DISB_NUM => l_rec_awd_disb.disb_num,
1207: X_TP_CAL_TYPE => l_rec_awd_disb.tp_cal_type,
1208: X_TP_SEQUENCE_NUMBER => l_rec_awd_disb.tp_sequence_number,