APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_AW_AWD_DISB

Line 35: -- Impacts of obsoleting columns from igf_aw_awd_disb_all

31: Modified the reference of payment_isir_id
32: */
33: ----------------------------------------------------------------------------------
34: -- veramach July 2004 FA 151 HR Integration (bug#3709292)
35: -- Impacts of obsoleting columns from igf_aw_awd_disb_all
36: ---------------------------------------------------------------------------------
37: -- veramach 04-May-2004 bug 3603289
38: -- Modified cursor cur_student_licence to select
39: -- dependency_status from ISIR. other details are

Line 49: -- bkkumar 04-DEC-2003 Bug 3252382 FA 131 . TBH impact for the igf_aw_awd_disb_all

45: ----------------------------------------------------------------------------------
46: -- veramach 11-Dec-2003 Bug # 3184891 Removed calls to igf_ap_gen.write_log
47: -- and added common logging
48: ----------------------------------------------------------------------------------
49: -- bkkumar 04-DEC-2003 Bug 3252382 FA 131 . TBH impact for the igf_aw_awd_disb_all
50: -- Added two columns ATTENDANCE_TYPE_CODE,BASE_ATTENDANCE_TYPE_CODE
51: ----------------------------------------------------------------------------------
52: -- ugummall 04-NOV-2003 Bug 3102439. FA 126 - Multiple FA Offices.
53: -- Renamed cursor c_ope_id to c_source_or_branch_id with one extra

Line 2950: FROM igf_aw_awd_disb_all

2946: CURSOR c_gross_amt(cp_award_id NUMBER,
2947: cp_disb_num NUMBER)
2948: IS
2949: SELECT disb_accepted_amt disb_gross_amt
2950: FROM igf_aw_awd_disb_all
2951: WHERE award_id = cp_award_id
2952: AND disb_num = cp_disb_num;
2953:
2954: l_gross_amt c_gross_amt%ROWTYPE;

Line 3687: igf_aw_awd_disb_all adisb

3683: SELECT
3684: ROWID,
3685: adisb.*
3686: FROM
3687: igf_aw_awd_disb_all adisb
3688: WHERE
3689: adisb.award_id = p_award_id AND
3690: adisb.disb_num = cp_disb_num;
3691:

Line 4693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before Update IGF_AW_AWD_DISB');

4689: FETCH c_disb_det INTO l_disb_det;
4690: CLOSE c_disb_det;
4691:
4692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before Update IGF_AW_AWD_DISB');
4694: END IF;
4695:
4696: igf_aw_awd_disb_pkg.update_row (
4697: x_mode => 'R',

Line 4696: igf_aw_awd_disb_pkg.update_row (

4692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before Update IGF_AW_AWD_DISB');
4694: END IF;
4695:
4696: igf_aw_awd_disb_pkg.update_row (
4697: x_mode => 'R',
4698: x_rowid => l_disb_det.rowid,
4699: x_award_id => l_disb_det.award_id,
4700: x_disb_num => l_disb_det.disb_num,

Line 4918: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before Update IGF_AW_AWD_DISB');

4914: FETCH c_disb_det INTO l_disb_det;
4915: CLOSE c_disb_det;
4916:
4917: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4918: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before Update IGF_AW_AWD_DISB');
4919: END IF;
4920:
4921: igf_aw_awd_disb_pkg.update_row (
4922: x_mode => 'R',

Line 4921: igf_aw_awd_disb_pkg.update_row (

4917: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4918: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before Update IGF_AW_AWD_DISB');
4919: END IF;
4920:
4921: igf_aw_awd_disb_pkg.update_row (
4922: x_mode => 'R',
4923: x_rowid => l_disb_det.rowid,
4924: x_award_id => l_disb_det.award_id,
4925: x_disb_num => l_disb_det.disb_num,

Line 4991: FROM igf_aw_awd_disb

4987: WHERE award_id = p_award_id;
4988:
4989: CURSOR c_awd_cur IS
4990: SELECT *
4991: FROM igf_aw_awd_disb
4992: WHERE award_id = p_award_id;
4993:
4994: BEGIN
4995:

Line 5170: FROM igf_aw_awd_disb_all adisb

5166: CURSOR c_disb_det(cp_award_id NUMBER,
5167: cp_disb_num NUMBER)
5168: IS
5169: SELECT 1
5170: FROM igf_aw_awd_disb_all adisb
5171: WHERE adisb.award_id = cp_award_id
5172: AND adisb.disb_num = cp_disb_num;
5173:
5174: l_disb_det c_disb_det%ROWTYPE;