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

Line 121: FROM igf_aw_awd_disb_all

117: ------------------------------------------------------------------
118: CURSOR c_chk_repkg(cp_award_id IN igf_aw_award_all.award_id%TYPE)
119: IS
120: SELECT 'X'
121: FROM igf_aw_awd_disb_all
122: WHERE award_id = cp_award_id;
123: l_repkg_rec c_chk_repkg%ROWTYPE;
124:
125: BEGIN

Line 140: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE

136: END isRepackaging;
137:
138: PROCEDURE cancel_extra_disb (
139: p_award_id IN igf_aw_award.award_id%TYPE,
140: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE
141: )
142: IS
143: /*
144: || Created By : museshad

Line 158: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE

154:
155: -- Get all disbursements more than cp_disb_num in the award
156: CURSOR c_disb_cancel(
157: cp_award_id igf_aw_award_all.award_id%TYPE,
158: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
159: )
160: IS
161: SELECT *
162: FROM igf_aw_awd_disb

Line 162: FROM igf_aw_awd_disb

158: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
159: )
160: IS
161: SELECT *
162: FROM igf_aw_awd_disb
163: WHERE award_id = cp_award_id AND
164: trans_type <> 'C' AND
165: disb_num > cp_disb_num;
166:

Line 181: igf_aw_awd_disb_pkg.update_row(

177: 'Cancelling disb num ' ||disb_cancel_rec.disb_num|| ' in award_id:' ||p_award_id);
178: END IF;
179:
180: -- cancel the disbursement
181: igf_aw_awd_disb_pkg.update_row(
182: x_rowid => disb_cancel_rec.row_id,
183: x_award_id => disb_cancel_rec.award_id,
184: x_disb_num => disb_cancel_rec.disb_num,
185: x_tp_cal_type => disb_cancel_rec.tp_cal_type,

Line 269: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE

265: l_get_fed_fund_code cur_get_fed_fund_code%ROWTYPE;
266:
267: CURSOR c_disb(
268: cp_award_id igf_aw_award_all.award_id%TYPE,
269: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
270: ) IS
271: SELECT rowid row_id,
272: disb.*
273: FROM igf_aw_awd_disb_all disb

Line 273: FROM igf_aw_awd_disb_all disb

269: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
270: ) IS
271: SELECT rowid row_id,
272: disb.*
273: FROM igf_aw_awd_disb_all disb
274: WHERE award_id = cp_award_id
275: AND disb_num = cp_disb_num;
276: l_disb c_disb%ROWTYPE;
277:

Line 307: igf_aw_awd_disb_pkg.update_row (

303:
304: IF isRepackaging(p_award_id => p_award_id) AND (c_disb%FOUND) THEN
305: l_hold_ind := NVL(l_disb.hold_rel_ind, 'FALSE');
306:
307: igf_aw_awd_disb_pkg.update_row (
308: x_mode => 'R',
309: x_rowid => l_disb.row_id,
310: x_award_id => p_award_id,
311: x_disb_num => i,

Line 356: igf_aw_awd_disb_pkg.insert_row (

352: x_fund_return_mthd_code => l_disb.fund_return_mthd_code,
353: x_direct_to_borr_flag => l_disb.direct_to_borr_flag
354: );
355: ELSE
356: igf_aw_awd_disb_pkg.insert_row (
357: x_mode => 'R',
358: x_rowid => lv_row_id,
359: x_award_id => p_award_id,
360: x_disb_num => i,

Line 736: FROM igf_aw_awd_disb disb

732: -- The ORDER BY clause ensures that the disbursements are returned in the order of their creation
733: CURSOR cur_get_all_disb (p_award_id igf_aw_award_all.award_id%TYPE)
734: IS
735: SELECT disb.rowid, disb.*
736: FROM igf_aw_awd_disb disb
737: WHERE
738: award_id = p_award_id AND
739: trans_type <> 'C'
740: ORDER BY disb_num ;

Line 948: igf_aw_awd_disb_pkg.update_row(

944: ' Old Disbursement amount: ' ||l_disb_rec.disb_gross_amt||
945: ' New disbursement amount after applying rounding logic: ' ||NVL(l_disb_structure_rec(l_disb_no).disb_amt, 0));
946: END IF;
947:
948: igf_aw_awd_disb_pkg.update_row(
949: x_rowid => l_disb_rec.rowid ,
950: x_award_id => l_disb_rec.award_id ,
951: x_disb_num => l_disb_rec.disb_num ,
952: x_tp_cal_type => l_disb_rec.tp_cal_type,

Line 1514: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE

1510:
1511: -- Get a specific disbursment for an award
1512: CURSOR c_disb(
1513: cp_award_id igf_aw_award_all.award_id%TYPE,
1514: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
1515: ) IS
1516: SELECT rowid row_id,
1517: disb.*
1518: FROM igf_aw_awd_disb_all disb

Line 1518: FROM igf_aw_awd_disb_all disb

1514: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
1515: ) IS
1516: SELECT rowid row_id,
1517: disb.*
1518: FROM igf_aw_awd_disb_all disb
1519: WHERE award_id = cp_award_id
1520: AND disb_num = cp_disb_num;
1521:
1522: l_disb c_disb%ROWTYPE;

Line 1569: ld_verf_enfr_dt igf_aw_awd_disb_all.verf_enfr_dt%TYPE;

1565: ln_int_rebate_amt NUMBER(12,2) := 0;
1566: ln_dummy_net_amt NUMBER(12,2) := 0;
1567: ln_dummy_fee_1 NUMBER(12,2) := 0;
1568: lv_base_att_type VARCHAR2(1);
1569: ld_verf_enfr_dt igf_aw_awd_disb_all.verf_enfr_dt%TYPE;
1570: ld_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
1571: ld_disb_date1 igf_aw_awd_disb_all.disb_date%TYPE;
1572: ld_disb_exp_dt igf_aw_awd_disb_all.disb_exp_dt%TYPE;
1573: l_hold_ind igf_sl_cl_setup_all.hold_rel_ind%TYPE;

Line 1570: ld_disb_date igf_aw_awd_disb_all.disb_date%TYPE;

1566: ln_dummy_net_amt NUMBER(12,2) := 0;
1567: ln_dummy_fee_1 NUMBER(12,2) := 0;
1568: lv_base_att_type VARCHAR2(1);
1569: ld_verf_enfr_dt igf_aw_awd_disb_all.verf_enfr_dt%TYPE;
1570: ld_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
1571: ld_disb_date1 igf_aw_awd_disb_all.disb_date%TYPE;
1572: ld_disb_exp_dt igf_aw_awd_disb_all.disb_exp_dt%TYPE;
1573: l_hold_ind igf_sl_cl_setup_all.hold_rel_ind%TYPE;
1574: l_auto_ind igf_sl_cl_setup_all.auto_late_disb_ind%TYPE;

Line 1571: ld_disb_date1 igf_aw_awd_disb_all.disb_date%TYPE;

1567: ln_dummy_fee_1 NUMBER(12,2) := 0;
1568: lv_base_att_type VARCHAR2(1);
1569: ld_verf_enfr_dt igf_aw_awd_disb_all.verf_enfr_dt%TYPE;
1570: ld_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
1571: ld_disb_date1 igf_aw_awd_disb_all.disb_date%TYPE;
1572: ld_disb_exp_dt igf_aw_awd_disb_all.disb_exp_dt%TYPE;
1573: l_hold_ind igf_sl_cl_setup_all.hold_rel_ind%TYPE;
1574: l_auto_ind igf_sl_cl_setup_all.auto_late_disb_ind%TYPE;
1575: l_adplans_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;

Line 1572: ld_disb_exp_dt igf_aw_awd_disb_all.disb_exp_dt%TYPE;

1568: lv_base_att_type VARCHAR2(1);
1569: ld_verf_enfr_dt igf_aw_awd_disb_all.verf_enfr_dt%TYPE;
1570: ld_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
1571: ld_disb_date1 igf_aw_awd_disb_all.disb_date%TYPE;
1572: ld_disb_exp_dt igf_aw_awd_disb_all.disb_exp_dt%TYPE;
1573: l_hold_ind igf_sl_cl_setup_all.hold_rel_ind%TYPE;
1574: l_auto_ind igf_sl_cl_setup_all.auto_late_disb_ind%TYPE;
1575: l_adplans_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
1576:

Line 2074: igf_aw_awd_disb_pkg.update_row (

2070: END IF;
2071:
2072: l_hold_ind := NVL(l_disb.hold_rel_ind, 'FALSE');
2073:
2074: igf_aw_awd_disb_pkg.update_row (
2075: x_mode => 'R',
2076: x_rowid => l_disb.row_id,
2077: x_award_id => p_award_id,
2078: x_disb_num => ln_count,

Line 2137: igf_aw_awd_disb_pkg.insert_row (

2133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','ln_disb_net_amt:'||ln_disb_net_amt);
2134: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','p_award_status: ' || p_award_status);
2135: END IF;
2136:
2137: igf_aw_awd_disb_pkg.insert_row (
2138: x_mode => 'R',
2139: x_rowid => lv_row_id,
2140: x_award_id => p_award_id,
2141: x_disb_num => ln_count,

Line 2302: igf_aw_awd_disb_pkg.update_row(

2298: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2299: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Flag set - updating disb num 1 with NSLDS disb offset date: ' ||ld_disb_date1);
2300: END IF;
2301:
2302: igf_aw_awd_disb_pkg.update_row(
2303: x_mode => 'R',
2304: x_rowid => l_disb.row_id,
2305: x_award_id => l_disb.award_id,
2306: x_disb_num => l_disb.disb_num,

Line 2545: p_disb_num igf_aw_awd_disb.disb_num%TYPE)

2541:
2542: END remove_awd_rules_override;
2543:
2544: FUNCTION place_ovawd_holds (p_award_id igf_aw_award.award_id%TYPE,
2545: p_disb_num igf_aw_awd_disb.disb_num%TYPE)
2546:
2547: RETURN BOOLEAN
2548: IS
2549:

Line 2556: p_disb_num igf_aw_awd_disb.disb_num%TYPE) IS

2552: -- If this function returns TRUE, it means new overaward hold
2553: -- can be placed
2554: --
2555: CURSOR cur_chk_holds( p_award_id igf_aw_award.award_id%TYPE,
2556: p_disb_num igf_aw_awd_disb.disb_num%TYPE) IS
2557: SELECT dh.release_flag
2558: FROM igf_db_disb_holds dh
2559: WHERE dh.award_id = p_award_id
2560: AND dh.disb_num = p_disb_num

Line 2617: FROM igf_aw_awd_disb disb

2613: CURSOR c_get_planned_awd_disb(
2614: p_award_id igf_aw_award.award_id%TYPE
2615: ) IS
2616: SELECT disb.award_id, disb.disb_num
2617: FROM igf_aw_awd_disb disb
2618: WHERE disb.award_id = p_award_id
2619: AND disb.trans_type = 'P';
2620:
2621: lc_row_id VARCHAR2(30);

Line 2702: FROM igf_aw_awd_disb_all disb

2698:
2699:
2700: CURSOR c_accept_null IS
2701: SELECT disb.*,disb.rowid row_id
2702: FROM igf_aw_awd_disb_all disb
2703: WHERE disb.award_id = p_award_id
2704: AND disb.trans_type <> 'C'
2705: AND NVL(disb.disb_accepted_amt,0) = 0
2706: FOR UPDATE OF disb.disb_gross_amt NOWAIT;

Line 2727: igf_aw_awd_disb_pkg.update_row (

2723: NVL(c_null_rec.fee_paid_1,0) +
2724: NVL(c_null_rec.fee_paid_2,0) +
2725: NVL(c_null_rec.int_rebate_amt,0);
2726:
2727: igf_aw_awd_disb_pkg.update_row (
2728: x_mode => 'R',
2729: x_rowid => c_null_rec.row_id,
2730: x_award_id => c_null_rec.award_id,
2731: x_disb_num => c_null_rec.disb_num,

Line 2804: -- igf_aw_awd_disb table

2800: --This procedure ensures that whenever the Award Status is changed to Accepted OR Offered
2801: -- from Cancelled or Declined the Transaction type , eligibility status , elig date should get updated
2802: -- who when what
2803: --smadathi 24-NOV-2004 Enh. Bug 3416936. Modified the update_row call to
2804: -- igf_aw_awd_disb table
2805: --adhawan 24-May-2002 Added this procedure
2806: --Bug ID : 2375571
2807: -----------------------------------------------------------------------------*/
2808:

Line 2829: FROM igf_aw_awd_disb_all disb,

2825: SELECT disb.ld_cal_type,
2826: disb.ld_sequence_number,
2827: disb.base_attendance_type_code,
2828: SUM(disb.disb_gross_amt) term_total
2829: FROM igf_aw_awd_disb_all disb,
2830: igf_aw_award_all awd
2831: WHERE awd.award_id = disb.award_id
2832: AND awd.award_id = p_award_id
2833: GROUP BY disb.ld_cal_type,disb.ld_sequence_number,disb.base_attendance_type_code;

Line 2839: FROM igf_aw_awd_disb_all disb

2835: term_amounts_rec cur_term_amounts%ROWTYPE;
2836:
2837: CURSOR c_change_trans IS
2838: SELECT disb.*,disb.rowid row_id
2839: FROM igf_aw_awd_disb_all disb
2840: WHERE disb.award_id = p_award_id
2841: AND disb.trans_type = 'C'
2842: FOR UPDATE OF disb.disb_gross_amt NOWAIT;
2843:

Line 2905: -- x_called_from passed to igf_aw_awd_disb_pkg.update_row is hard coded

2901: NVL(c_change_trans_rec.fee_2,0) +
2902: NVL(c_change_trans_rec.fee_paid_1,0) +
2903: NVL(c_change_trans_rec.fee_paid_2,0) +
2904: NVL(c_change_trans_rec.int_rebate_amt,0);
2905: -- x_called_from passed to igf_aw_awd_disb_pkg.update_row is hard coded
2906: -- as IGFAW016 as this procedural update_awd_cancell_to_offer call out
2907: -- happens only through IGFAW016 - Student Awards form
2908:
2909: igf_aw_awd_disb_pkg.update_row (

Line 2909: igf_aw_awd_disb_pkg.update_row (

2905: -- x_called_from passed to igf_aw_awd_disb_pkg.update_row is hard coded
2906: -- as IGFAW016 as this procedural update_awd_cancell_to_offer call out
2907: -- happens only through IGFAW016 - Student Awards form
2908:
2909: igf_aw_awd_disb_pkg.update_row (
2910: x_mode => 'R',
2911: x_rowid => c_change_trans_rec.row_id,
2912: x_award_id => c_change_trans_rec.award_id,
2913: x_disb_num => c_change_trans_rec.disb_num,

Line 2961: igf_aw_awd_disb_pkg.update_row (

2957: );
2958: END LOOP;
2959: ELSIF p_award_stat ='CDO' THEN
2960: FOR c_change_trans_rec IN c_change_trans LOOP
2961: igf_aw_awd_disb_pkg.update_row (
2962: x_mode => 'R',
2963: x_rowid => c_change_trans_rec.row_id,
2964: x_award_id => c_change_trans_rec.award_id,
2965: x_disb_num => c_change_trans_rec.disb_num,

Line 3048: igf_aw_awd_disb_all

3044:
3045: CURSOR cur_disb_num ( p_award_id igf_aw_award_all.award_id%TYPE) IS
3046: SELECT disb_num,disb_date,trans_type
3047: FROM
3048: igf_aw_awd_disb_all
3049: WHERE
3050: award_id = p_award_id
3051: AND
3052: trans_type IN ('P','A')

Line 3061: igf_aw_awd_disb

3057:
3058: CURSOR cur_disb_dat ( p_award_id igf_aw_award_all.award_id%TYPE) IS
3059: SELECT disb_num,disb_date
3060: FROM
3061: igf_aw_awd_disb
3062: WHERE
3063: award_id = p_award_id
3064: AND
3065: trans_type IN ('P','A')

Line 3072: ( disb_num igf_aw_awd_disb.disb_num%TYPE,

3068:
3069: disb_dat_rec cur_disb_dat%ROWTYPE;
3070:
3071: TYPE disb_record IS RECORD
3072: ( disb_num igf_aw_awd_disb.disb_num%TYPE,
3073: disb_date igf_aw_awd_disb.disb_date%TYPE
3074: );
3075:
3076: TYPE disb_num_list IS TABLE OF disb_record INDEX BY BINARY_INTEGER;

Line 3073: disb_date igf_aw_awd_disb.disb_date%TYPE

3069: disb_dat_rec cur_disb_dat%ROWTYPE;
3070:
3071: TYPE disb_record IS RECORD
3072: ( disb_num igf_aw_awd_disb.disb_num%TYPE,
3073: disb_date igf_aw_awd_disb.disb_date%TYPE
3074: );
3075:
3076: TYPE disb_num_list IS TABLE OF disb_record INDEX BY BINARY_INTEGER;
3077: disb_num_ele disb_num_list;

Line 3205: igf_aw_awd_disb_all disb,

3201: SELECT
3202: NVL(SUM(NVL(disb.disb_gross_amt,0)),0) lf_total,
3203: COUNT(DISTINCT awd.award_id) lf_count
3204: FROM
3205: igf_aw_awd_disb_all disb,
3206: igf_aw_award_all awd,
3207: igf_aw_fund_mast_all fmast,
3208: igf_ap_fa_base_rec_all fabase
3209: WHERE fmast.fund_code = cp_fund_code

Line 3251: igf_aw_awd_disb disb

3247: IS
3248: SELECT SUM(disb.disb_gross_amt) total_fund_amt
3249: FROM
3250: igf_aw_award awd,
3251: igf_aw_awd_disb disb
3252: WHERE awd.base_id = p_base_id
3253: AND awd.fund_id = p_fund_id
3254: AND awd.award_id = disb.award_id
3255: AND awd.award_status IN ('OFFERED', 'ACCEPTED')

Line 3267: igf_aw_awd_disb disb

3263: IS
3264: SELECT
3265: SUM(disb.disb_gross_amt) total_award_amt
3266: FROM
3267: igf_aw_awd_disb disb
3268: WHERE
3269: disb.award_id = p_award_id AND
3270: disb.trans_type <> 'C';
3271:

Line 3325: FROM igf_aw_awd_disb

3321: CURSOR cur_get_count ( p_award_id igf_aw_award_all.award_id%TYPE)
3322: IS
3323: SELECT
3324: COUNT(ld_cal_type) disb_count
3325: FROM igf_aw_awd_disb
3326: WHERE
3327: award_id = p_award_id;
3328:
3329:

Line 3333: igf_aw_awd_disb_all

3329:
3330: CURSOR cur_disb_num ( p_award_id igf_aw_award_all.award_id%TYPE) IS
3331: SELECT disb_num,disb_date,trans_type,disb_accepted_amt accepted_amt
3332: FROM
3333: igf_aw_awd_disb_all
3334: WHERE
3335: award_id = p_award_id;
3336:
3337: disb_num_rec cur_disb_num%ROWTYPE;

Line 3361: FROM igf_aw_awd_disb_all disb,

3357: SELECT disb.ld_cal_type,
3358: disb.ld_sequence_number,
3359: disb.base_attendance_type_code,
3360: SUM(disb.disb_gross_amt) term_total
3361: FROM igf_aw_awd_disb_all disb,
3362: igf_aw_award_all awd
3363: WHERE disb.trans_type <> 'C'
3364: AND awd.award_id = disb.award_id
3365: AND awd.award_id = p_award_id

Line 3901: igf_aw_awd_disb

3897: p_new_val IN igf_aw_fund_mast_all.show_on_bill%TYPE)
3898: IS
3899: SELECT *
3900: FROM
3901: igf_aw_awd_disb
3902: WHERE
3903: award_id = p_award_id AND
3904: trans_type = 'P' AND
3905: NVL(show_on_bill,'*') <> p_new_val

Line 3919: igf_aw_awd_disb_pkg.update_row( x_rowid => get_adisb_rec.row_id,

3915: LOOP
3916: FOR get_adisb_rec IN cur_get_adisb( get_awd_rec.award_id,p_new_val)
3917: LOOP
3918:
3919: igf_aw_awd_disb_pkg.update_row( x_rowid => get_adisb_rec.row_id,
3920: x_award_id => get_adisb_rec.award_id,
3921: x_disb_num => get_adisb_rec.disb_num,
3922: x_tp_cal_type => get_adisb_rec.tp_cal_type,
3923: x_tp_sequence_number => get_adisb_rec.tp_sequence_number,

Line 3988: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE ,

3984: END update_bill_flag;
3985:
3986:
3987: FUNCTION delete_awd_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE ,
3988: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE ,
3989: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE )
3990: RETURN VARCHAR2
3991: IS
3992:

Line 3989: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE )

3985:
3986:
3987: FUNCTION delete_awd_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE ,
3988: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE ,
3989: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE )
3990: RETURN VARCHAR2
3991: IS
3992:
3993: --

Line 4049: p_ld_seq_num igf_aw_awd_disb_all.ld_sequence_number%TYPE,

4045: -- Cursor to get disbursements
4046: --
4047:
4048: CURSOR cur_get_adisb ( p_award_id igf_aw_award_all.award_id%TYPE,
4049: p_ld_seq_num igf_aw_awd_disb_all.ld_sequence_number%TYPE,
4050: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
4051: IS
4052: SELECT
4053: row_id,

Line 4050: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)

4046: --
4047:
4048: CURSOR cur_get_adisb ( p_award_id igf_aw_award_all.award_id%TYPE,
4049: p_ld_seq_num igf_aw_awd_disb_all.ld_sequence_number%TYPE,
4050: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
4051: IS
4052: SELECT
4053: row_id,
4054: disb_num

Line 4056: igf_aw_awd_disb

4052: SELECT
4053: row_id,
4054: disb_num
4055: FROM
4056: igf_aw_awd_disb
4057: WHERE
4058: award_id = p_award_id AND
4059: disb_num = NVL(p_disb_num,disb_num) AND
4060: ld_sequence_number = NVL(p_ld_seq_num,ld_sequence_number);

Line 4070: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)

4066: -- Cursor to get Holds
4067: --
4068:
4069: CURSOR cur_get_holds ( p_award_id igf_aw_award_all.award_id%TYPE,
4070: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
4071: IS
4072: SELECT
4073: row_id
4074: FROM

Line 4113: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE

4109:
4110:
4111: CURSOR cur_chg_dtls(
4112: cp_award_id igf_aw_award_all.award_id%TYPE,
4113: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
4114: ) IS
4115: SELECT ROWID row_id,
4116: disb_status
4117: FROM igf_aw_db_chg_dtls

Line 4193: igf_aw_awd_disb_pkg.delete_row(get_adisb_rec.row_id);

4189: RETURN lv_message;
4190: END IF;
4191: END LOOP;
4192: END IF;
4193: igf_aw_awd_disb_pkg.delete_row(get_adisb_rec.row_id);
4194:
4195: END LOOP;
4196: END IF;
4197:

Line 4229: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE )

4225: END delete_awd_disb;
4226:
4227:
4228: FUNCTION get_total_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,
4229: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE )
4230: RETURN NUMBER
4231: IS
4232: --
4233: -- sjadhav

Line 4239: p_ld_seq_num igf_aw_awd_disb_all.ld_sequence_number%TYPE)

4235: -- Function to return number of disbursements
4236: --
4237:
4238: CURSOR cur_disb_nums ( p_award_id igf_aw_award_all.award_id%TYPE,
4239: p_ld_seq_num igf_aw_awd_disb_all.ld_sequence_number%TYPE)
4240: IS
4241: SELECT COUNT(disb_num) tot_num
4242: FROM
4243: igf_aw_awd_disb

Line 4243: igf_aw_awd_disb

4239: p_ld_seq_num igf_aw_awd_disb_all.ld_sequence_number%TYPE)
4240: IS
4241: SELECT COUNT(disb_num) tot_num
4242: FROM
4243: igf_aw_awd_disb
4244: WHERE
4245: award_id = p_award_id AND
4246: ld_sequence_number = NVL(p_ld_seq_num,ld_sequence_number);
4247: