APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_SL_AWD_DISB_LOC

Line 3354: FROM igf_sl_awd_disb_loc_all

3350:
3351: CURSOR c_disb_loc(cp_award_id NUMBER)
3352: IS
3353: SELECT rowid
3354: FROM igf_sl_awd_disb_loc_all
3355: WHERE award_id = cp_award_id;
3356:
3357: l_disb_loc c_disb_loc%ROWTYPE;
3358:

Line 3462: igf_sl_awd_disb_loc_pkg.delete_row(x_ROWID => l_disb_loc.rowid);

3458: FOR l_disb_loc IN c_disb_loc(l_award_id) LOOP
3459: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.delete_records.debug','l_disb_loc ROWID ' || l_disb_loc.rowid);
3461: END IF;
3462: igf_sl_awd_disb_loc_pkg.delete_row(x_ROWID => l_disb_loc.rowid);
3463: END LOOP;
3464:
3465: IF (p_loan_number IS NOT NULL) THEN
3466: OPEN c_resp_r1(p_loan_number);

Line 4977: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_AWD_DISB_LOC');

4973: END LOOP;
4974: END IF;
4975:
4976: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4977: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_AWD_DISB_LOC');
4978: END IF;
4979:
4980: DECLARE
4981:

Line 4986: FROM igf_sl_awd_disb_loc

4982: lv_row_id VARCHAR2(25);
4983:
4984: CURSOR c_loc_cur IS
4985: SELECT *
4986: FROM igf_sl_awd_disb_loc
4987: WHERE award_id = p_award_id;
4988:
4989: CURSOR c_awd_cur IS
4990: SELECT *

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

4993:
4994: BEGIN
4995:
4996: FOR tbh_rec IN c_loc_cur LOOP
4997: igf_sl_awd_disb_loc_pkg.delete_row (tbh_rec.row_id);
4998: END LOOP;
4999:
5000: FOR tbh_rec IN c_awd_cur LOOP
5001:

Line 5004: igf_sl_awd_disb_loc_pkg.insert_row (

5000: FOR tbh_rec IN c_awd_cur LOOP
5001:
5002: lv_row_id := NULL;
5003:
5004: igf_sl_awd_disb_loc_pkg.insert_row (
5005: x_mode => 'R',
5006: x_rowid => lv_row_id,
5007: x_award_id => tbh_rec.award_id,
5008: x_disb_num => tbh_rec.disb_num,

Line 5019: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug',' After insert into IGF_SL_AWD_DISB_LOC');

5015: x_fee_paid_1 => tbh_rec.fee_paid_1,
5016: x_fee_paid_2 => tbh_rec.fee_paid_2);
5017:
5018: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5019: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug',' After insert into IGF_SL_AWD_DISB_LOC');
5020: END IF;
5021:
5022: END LOOP;
5023: