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.

[Home] [Help]

APPS.IGF_AW_GEN_003 dependencies on IGF_AW_AWD_DISB_ALL

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