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_SL_DL_CHG_ORIG dependencies on IGF_AW_AWD_DISB

Line 236: SELECT disb.* FROM igf_aw_awd_disb disb

232:
233: -- ## Cursor to Retrieve the disburesment records
234:
235: CURSOR cur_award(p_award_id igf_aw_award.award_id%TYPE) IS
236: SELECT disb.* FROM igf_aw_awd_disb disb
237: WHERE disb.award_id = p_award_id
238: ORDER BY disb.disb_num;
239:
240:

Line 655: -- ## the record is fetced from the igf_aw_awd_disb and origination table. The condition is made

651:
652: END IF;
653:
654: -- ## This loop is to calculate the disbursement based records. initially it is set to NULL and
655: -- ## the record is fetced from the igf_aw_awd_disb and origination table. The condition is made
656: -- ## in such a way that even if a Disbursement is Deleted, we still need to send Disb-gross-amt
657: -- ## as ZERO and disb-date as blank we need to overwrite these values at the LOC also.
658: -- ## So, 3 scenarios possible are
659: -- ## - No. of Disbursement in IGF_AW_AWD_DISB = No. of Disb in IGF_SL_AWD_DISB_LOC

Line 659: -- ## - No. of Disbursement in IGF_AW_AWD_DISB = No. of Disb in IGF_SL_AWD_DISB_LOC

655: -- ## the record is fetced from the igf_aw_awd_disb and origination table. The condition is made
656: -- ## in such a way that even if a Disbursement is Deleted, we still need to send Disb-gross-amt
657: -- ## as ZERO and disb-date as blank we need to overwrite these values at the LOC also.
658: -- ## So, 3 scenarios possible are
659: -- ## - No. of Disbursement in IGF_AW_AWD_DISB = No. of Disb in IGF_SL_AWD_DISB_LOC
660: -- ## and Disb-gross-amt and disb-date may be same or different.
661: -- ## - A New disbursment is added in IGF_AW_AWD_DISB
662: -- ## - A disbursement is deleted in IGF_AW_AWD_DISB.
663:

Line 661: -- ## - A New disbursment is added in IGF_AW_AWD_DISB

657: -- ## as ZERO and disb-date as blank we need to overwrite these values at the LOC also.
658: -- ## So, 3 scenarios possible are
659: -- ## - No. of Disbursement in IGF_AW_AWD_DISB = No. of Disb in IGF_SL_AWD_DISB_LOC
660: -- ## and Disb-gross-amt and disb-date may be same or different.
661: -- ## - A New disbursment is added in IGF_AW_AWD_DISB
662: -- ## - A disbursement is deleted in IGF_AW_AWD_DISB.
663:
664:
665: l_disb := TRUE;

Line 662: -- ## - A disbursement is deleted in IGF_AW_AWD_DISB.

658: -- ## So, 3 scenarios possible are
659: -- ## - No. of Disbursement in IGF_AW_AWD_DISB = No. of Disb in IGF_SL_AWD_DISB_LOC
660: -- ## and Disb-gross-amt and disb-date may be same or different.
661: -- ## - A New disbursment is added in IGF_AW_AWD_DISB
662: -- ## - A disbursement is deleted in IGF_AW_AWD_DISB.
663:
664:
665: l_disb := TRUE;
666: l_disb_loc := TRUE;

Line 709: -- ## igf_aw_awd_disb is inserted into this table.

705: -- ## The lc_chg_flag is the out NOCOPY parameter from the comp_lor_loc procedure, even if one changed column
706: -- ## exists then the flag is set to Y and depending on that the igf_sl_lor_loc table is updated with
707: -- ## the new value(changed value). In case of disbursement records if any changes exists then the
708: -- ## igf_sl_awd_disb_loc table is deleted for the particular award Id and the new value from the
709: -- ## igf_aw_awd_disb is inserted into this table.
710:
711: IF lc_chg_flag ='Y' THEN
712:
713: -- Update the igf_sl_lor_loc table with the New Values(Changes values)

Line 933: -- ## Insert the new record from igf_aw_awd record to igf_aw_awd_disb_loc table

929: igf_sl_awd_disb_loc_pkg.delete_row (lcur_disb_loc.row_id);
930:
931: END LOOP;
932:
933: -- ## Insert the new record from igf_aw_awd record to igf_aw_awd_disb_loc table
934:
935: FOR lcur_award IN cur_award(lc_lor.award_id)
936: LOOP
937: igf_sl_awd_disb_loc_pkg.insert_row (