APPS.IGF_SL_DL_CHG_ORIG dependencies on IGF_SL_AWD_DISB_LOC

Line 246: FROM igf_sl_awd_disb_loc disb

242: -- ## to compare with the disbursement table to know if any change exists
243:
244: CURSOR cur_disb_loc(p_award_id igf_aw_award.award_id%TYPE) IS
245: SELECT disb.row_id row_id, disb.disb_num, disb.disb_gross_amt, disb.disb_date
246: FROM igf_sl_awd_disb_loc disb
247: WHERE award_id = p_award_id
248: ORDER BY disb.disb_num FOR UPDATE OF disb.disb_gross_amt NOWAIT;
249:
250: lcur_award cur_award%ROWTYPE;

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 708: -- ## igf_sl_awd_disb_loc table is deleted for the particular award Id and the new value from the

704:
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:

Line 929: igf_sl_awd_disb_loc_pkg.delete_row (lcur_disb_loc.row_id);

925: LOOP
926:
927: -- ## Delete the records from the LOC table.
928:
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

Line 937: igf_sl_awd_disb_loc_pkg.insert_row (

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 (
938: x_mode => 'R',
939: x_rowid => l_rowid,
940: X_award_id => lcur_award.award_id,
941: X_disb_num => lcur_award.disb_num,