APPS.IGF_SL_DL_ORIG dependencies on IGF_SL_AWD_DISB_LOC

Line 99: -- amount in the igf_sl_awd_disb_loc table with

95: -- igf_sl_loans_pkg
96: -----------------------------------------------------------------------------------
97: -- sjadhav 26-Mar-2003 Bug 2863960
98: -- Modified routine to populate disb gross
99: -- amount in the igf_sl_awd_disb_loc table with
100: -- disb accepted amount
101: -----------------------------------------------------------------------------------
102: -- masehgal # 2593215 removed begin/end dates fetching functions
103: -- used procedure get_acad_cal_dtls instead

Line 446: -- Delete this loan record in IGF_SL_AWD_DISB_LOC.

442: igf_sl_lor_loc_pkg.delete_row (tbh_rec.row_id);
443: END LOOP;
444: END;
445:
446: -- Delete this loan record in IGF_SL_AWD_DISB_LOC.
447: DECLARE
448: lv_row_id VARCHAR2(25);
449: CURSOR c_tbh_cur IS
450: SELECT row_id row_id FROM igf_sl_awd_disb_loc

Line 450: SELECT row_id row_id FROM igf_sl_awd_disb_loc

446: -- Delete this loan record in IGF_SL_AWD_DISB_LOC.
447: DECLARE
448: lv_row_id VARCHAR2(25);
449: CURSOR c_tbh_cur IS
450: SELECT row_id row_id FROM igf_sl_awd_disb_loc
451: WHERE award_id = lv_orig_award_id FOR UPDATE OF igf_sl_awd_disb_loc.disb_date NOWAIT;
452: BEGIN
453: FOR tbh_rec in c_tbh_cur LOOP
454: igf_sl_awd_disb_loc_pkg.delete_row (tbh_rec.row_id);

Line 451: WHERE award_id = lv_orig_award_id FOR UPDATE OF igf_sl_awd_disb_loc.disb_date NOWAIT;

447: DECLARE
448: lv_row_id VARCHAR2(25);
449: CURSOR c_tbh_cur IS
450: SELECT row_id row_id FROM igf_sl_awd_disb_loc
451: WHERE award_id = lv_orig_award_id FOR UPDATE OF igf_sl_awd_disb_loc.disb_date NOWAIT;
452: BEGIN
453: FOR tbh_rec in c_tbh_cur LOOP
454: igf_sl_awd_disb_loc_pkg.delete_row (tbh_rec.row_id);
455: END LOOP;

Line 454: igf_sl_awd_disb_loc_pkg.delete_row (tbh_rec.row_id);

450: SELECT row_id row_id FROM igf_sl_awd_disb_loc
451: WHERE award_id = lv_orig_award_id FOR UPDATE OF igf_sl_awd_disb_loc.disb_date NOWAIT;
452: BEGIN
453: FOR tbh_rec in c_tbh_cur LOOP
454: igf_sl_awd_disb_loc_pkg.delete_row (tbh_rec.row_id);
455: END LOOP;
456: END;
457:
458:

Line 882: igf_sl_awd_disb_loc_pkg.insert_row (

878: SELECT * FROM igf_aw_awd_disb
879: WHERE award_id = lv_orig_award_id;
880: BEGIN
881: FOR tbh_rec in c_tbh_cur LOOP
882: igf_sl_awd_disb_loc_pkg.insert_row (
883: X_Mode => 'R',
884: x_rowid => lv_row_id,
885: x_award_id => tbh_rec.award_id,
886: x_disb_num => tbh_rec.disb_num,