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_PACKAGING dependencies on IGF_AW_AWD_DIST_PLANS

Line 345: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

341: g_awarded_aid std_aid_tab := std_aid_tab();
342:
343: FUNCTION check_disb(
344: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
345: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
346: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
347: ) RETURN BOOLEAN AS
348: ------------------------------------------------------------------
349: --Created by : veramach, Oracle India

Line 361: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

357: --Change History:
358: --Who When What
359: -------------------------------------------------------------------
360: CURSOR c_term_wcoa(
361: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
362: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
363: ) IS
364: SELECT COUNT(tp.adteach_id) tp,
365: COUNT(DISTINCT terms.adterms_id) terms

Line 368: igf_aw_awd_dist_plans dp,

364: SELECT COUNT(tp.adteach_id) tp,
365: COUNT(DISTINCT terms.adterms_id) terms
366: FROM igf_aw_dp_teach_prds tp,
367: igf_aw_dp_terms terms,
368: igf_aw_awd_dist_plans dp,
369: igf_aw_awd_prd_term aprd
370: WHERE terms.adterms_id = tp.adterms_id
371: AND terms.adplans_id = cp_adplans_id
372: AND terms.adplans_id = dp.adplans_id

Line 381: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

377: AND aprd.award_prd_cd = cp_award_prd_code;
378:
379: CURSOR c_term(
380: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
381: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
382: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
383: ) IS
384: SELECT COUNT(tp.adteach_id) tp,
385: COUNT(DISTINCT terms.adterms_id) terms

Line 395: igf_aw_awd_dist_plans dp

391: FROM igf_aw_coa_itm_terms
392: WHERE base_id = cp_base_id
393: GROUP BY base_id, ld_cal_type, ld_sequence_number) coaterms,
394: igf_aw_awd_prd_term aprd,
395: igf_aw_awd_dist_plans dp
396: WHERE terms.adterms_id = tp.adterms_id
397: AND terms.adplans_id = cp_adplans_id
398: AND coaterms.ld_cal_type = terms.ld_cal_type
399: AND coaterms.ld_sequence_number = terms.ld_sequence_number

Line 663: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,

659: RETURN l_term_start_date;
660: END get_term_start_date;
661:
662: PROCEDURE get_plan_desc(
663: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
664: p_method_name OUT NOCOPY igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE,
665: p_method_desc OUT NOCOPY igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE
666: ) AS
667: ------------------------------------------------------------------

Line 664: p_method_name OUT NOCOPY igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE,

660: END get_term_start_date;
661:
662: PROCEDURE get_plan_desc(
663: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
664: p_method_name OUT NOCOPY igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE,
665: p_method_desc OUT NOCOPY igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE
666: ) AS
667: ------------------------------------------------------------------
668: --Created by : veramach, Oracle India

Line 665: p_method_desc OUT NOCOPY igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE

661:
662: PROCEDURE get_plan_desc(
663: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
664: p_method_name OUT NOCOPY igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE,
665: p_method_desc OUT NOCOPY igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE
666: ) AS
667: ------------------------------------------------------------------
668: --Created by : veramach, Oracle India
669: --Date created:

Line 681: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

677: --Who When What
678: -------------------------------------------------------------------
679: -- Get get plan desc
680: CURSOR c_plan(
681: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
682: ) IS
683: SELECT awd_dist_plan_cd_desc,
684: dist_plan_method_code_desc
685: FROM igf_aw_awd_dist_plans_v

Line 685: FROM igf_aw_awd_dist_plans_v

681: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
682: ) IS
683: SELECT awd_dist_plan_cd_desc,
684: dist_plan_method_code_desc
685: FROM igf_aw_awd_dist_plans_v
686: WHERE adplans_id = cp_adplans_id;
687: l_plan c_plan%ROWTYPE;
688:
689: BEGIN

Line 927: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,

923:
924: END calc_students_needs;
925:
926: PROCEDURE check_plan(
927: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
928: p_result OUT NOCOPY VARCHAR2,
929: p_method_code OUT NOCOPY igf_aw_awd_dist_plans.dist_plan_method_code%TYPE
930: ) AS
931: ------------------------------------------------------------------

Line 929: p_method_code OUT NOCOPY igf_aw_awd_dist_plans.dist_plan_method_code%TYPE

925:
926: PROCEDURE check_plan(
927: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
928: p_result OUT NOCOPY VARCHAR2,
929: p_method_code OUT NOCOPY igf_aw_awd_dist_plans.dist_plan_method_code%TYPE
930: ) AS
931: ------------------------------------------------------------------
932: --Created by : veramach, Oracle India
933: --Date created: 20-NOV-2003

Line 946: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

942: -------------------------------------------------------------------
943:
944: --cursor to get distribution plan code
945: CURSOR cur_get_plan_cd(
946: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
947: ) IS
948: SELECT awd_dist_plan_cd,
949: awd_dist_plan_cd_desc,
950: dist_plan_method_code

Line 951: FROM igf_aw_awd_dist_plans

947: ) IS
948: SELECT awd_dist_plan_cd,
949: awd_dist_plan_cd_desc,
950: dist_plan_method_code
951: FROM igf_aw_awd_dist_plans
952: WHERE adplans_id = cp_adplans_id;
953: l_get_plan_cd cur_get_plan_cd%ROWTYPE;
954:
955: BEGIN

Line 1710: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,

1706: p_process_id IN igf_aw_award_t_all.process_id%TYPE,
1707: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
1708: p_adplans_id IN igf_aw_award_t_all.adplans_id%TYPE,
1709: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
1710: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1711: p_disb_count IN NUMBER
1712: )
1713: IS
1714: /*

Line 2301: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;

2297: SKIP_RECORD EXCEPTION;
2298:
2299: lv_app_trans_num_txt igf_aw_award_all.app_trans_num_txt%TYPE;
2300: lv_result VARCHAR2(80);
2301: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
2302:
2303: -- Get payment ISIR transaction number
2304: CURSOR c_trans_num(
2305: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

Line 4578: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,

4574:
4575: FUNCTION chk_gplus_loan_limits (
4576: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
4577: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
4578: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
4579: p_aid IN NUMBER,
4580: p_std_loan_tab IN igf_aw_packng_subfns.std_loan_tab,
4581: p_msg_name OUT NOCOPY fnd_new_messages.message_name%TYPE
4582: )

Line 4865: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

4861: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
4862: p_lock_award_flag igf_aw_fund_mast_all.lock_award_flag%TYPE,
4863: p_re_pkg_verif_flag igf_aw_fund_mast_all.re_pkg_verif_flag%TYPE,
4864: p_donot_repkg_if_code igf_aw_fund_mast_all.donot_repkg_if_code%TYPE,
4865: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
4866: p_max_award_amt igf_aw_fund_mast_all.max_award_amt%TYPE,
4867: p_min_award_amt igf_aw_fund_mast_all.min_award_amt%TYPE,
4868: p_seq_no NUMBER
4869: ) AS

Line 5722: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;

5718: l_terms NUMBER;
5719: lv_fed_fund_code VARCHAR2(30);
5720:
5721: lv_result VARCHAR2(80);
5722: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
5723:
5724: lv_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
5725: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;
5726: --FACR116

Line 5724: lv_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;

5720:
5721: lv_result VARCHAR2(80);
5722: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
5723:
5724: lv_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
5725: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;
5726: --FACR116
5727: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
5728: ln_person_id igf_sl_cl_pref_lenders.person_id%TYPE;

Line 5725: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;

5721: lv_result VARCHAR2(80);
5722: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
5723:
5724: lv_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
5725: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;
5726: --FACR116
5727: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
5728: ln_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
5729: l_party_id igf_sl_cl_setup.party_id%TYPE;

Line 5735: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

5731:
5732: CURSOR c_dp_ap(
5733: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
5734: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
5735: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
5736: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
5737: ) IS
5738: SELECT 'x'
5739: FROM dual

Line 7725: lv_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE := NULL;

7721:
7722: lv_result VARCHAR2(80) := NULL;
7723: lv_method_code VARCHAR2(80) := NULL;
7724:
7725: lv_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE := NULL;
7726: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE := NULL;
7727:
7728: l_failed_award_id igf_aw_award_all.award_id%TYPE;
7729:

Line 7726: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE := NULL;

7722: lv_result VARCHAR2(80) := NULL;
7723: lv_method_code VARCHAR2(80) := NULL;
7724:
7725: lv_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE := NULL;
7726: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE := NULL;
7727:
7728: l_failed_award_id igf_aw_award_all.award_id%TYPE;
7729:
7730: BEGIN

Line 8672: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

8668: l_std_ln_awd_rec c_std_ln_awd%ROWTYPE;
8669:
8670: -- Get the details of term percent
8671: CURSOR c_get_term_prsnt(
8672: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
8673: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
8674: ) IS
8675: SELECT terms.ld_perct_num,
8676: terms.ld_cal_type,

Line 8697: adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

8693: offered_amt igf_aw_award_t.offered_amt%TYPE,
8694: accepted_amt igf_aw_award_t.accepted_Amt%TYPE,
8695: total NUMBER,
8696: seq_no igf_aw_awd_frml_det.seq_no%TYPE,
8697: adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
8698: award_id igf_aw_award_all.award_id%TYPE,
8699: lock_award_flag igf_aw_award_all.lock_award_flag%TYPE
8700: );
8701:

Line 8779: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;

8775:
8776: l_existing_awards NUMBER := 0;
8777:
8778: lv_result VARCHAR2(80);
8779: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
8780: lv_method_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
8781: lv_method_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;
8782:
8783: ln_com_perct NUMBER;

Line 8780: lv_method_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;

8776: l_existing_awards NUMBER := 0;
8777:
8778: lv_result VARCHAR2(80);
8779: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
8780: lv_method_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
8781: lv_method_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;
8782:
8783: ln_com_perct NUMBER;
8784:

Line 8781: lv_method_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;

8777:
8778: lv_result VARCHAR2(80);
8779: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
8780: lv_method_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
8781: lv_method_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;
8782:
8783: ln_com_perct NUMBER;
8784:
8785: l_pell_seq_id igf_gr_pell_setup_all.pell_seq_id%TYPE;

Line 11892: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

11888: */
11889:
11890: -- Get the Teching and load calendar details of the fund for creating the disbursements
11891: CURSOR c_tp_perct(
11892: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
11893: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
11894: ) IS
11895: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
11896: terms.ld_cal_type ld_cal_type,

Line 11925: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

11921:
11922: --Added this cursor for processing student without COA when COA can be exceeded
11923: CURSOR c_auto_disb_wcoa(
11924: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
11925: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
11926: ) IS
11927: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
11928: terms.ld_cal_type ld_cal_type,
11929: terms.ld_sequence_number ld_sequence_number,

Line 11945: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

11941: ORDER BY 1;
11942:
11943:
11944: CURSOR c_auto_disb_equal(
11945: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
11946: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
11947: cp_num_teach_periods NUMBER
11948: ) IS
11949: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,

Line 11977: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

11973:
11974: -- Added this cursor to process students without COA when COA can be exceeded
11975: CURSOR c_auto_disb_equal_wcoa(
11976: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
11977: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
11978: cp_num_teach_periods NUMBER
11979: ) IS
11980: SELECT NVL(igf_aw_packaging.get_date_instance (cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
11981: terms.ld_cal_type ld_cal_type,

Line 11999: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

11995:
11996: -- Get total terms
11997: CURSOR cur_terms_count(
11998: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
11999: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
12000: ) IS
12001: SELECT COUNT(*)
12002: FROM igf_aw_dp_terms terms,
12003: (SELECT base_id,

Line 12009: igf_aw_awd_dist_plans adplans,

12005: ld_sequence_number
12006: FROM igf_aw_coa_itm_terms
12007: WHERE base_id = cp_base_id
12008: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms,
12009: igf_aw_awd_dist_plans adplans,
12010: igf_aw_awd_prd_term aprd
12011: WHERE terms.adplans_id = cp_adplans_id
12012: AND coaterms.ld_cal_type = terms.ld_cal_type
12013: AND coaterms.ld_sequence_number = terms.ld_sequence_number

Line 12025: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,

12021:
12022: l_terms_count NUMBER := 0;
12023:
12024: CURSOR c_auto_disb_coa_match(
12025: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
12026: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
12027: cp_total_coa_amount NUMBER
12028: ) IS
12029: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,

Line 12057: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

12053:
12054: -- Get COA
12055: CURSOR c_coa(
12056: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
12057: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
12058: ) IS
12059: SELECT SUM(amount) coa
12060: FROM igf_aw_coa_itm_terms coa_terms,
12061: igf_aw_dp_terms terms,

Line 12062: igf_aw_awd_dist_plans adplans,

12058: ) IS
12059: SELECT SUM(amount) coa
12060: FROM igf_aw_coa_itm_terms coa_terms,
12061: igf_aw_dp_terms terms,
12062: igf_aw_awd_dist_plans adplans,
12063: igf_aw_awd_prd_term aprd
12064: WHERE terms.ld_cal_type = coa_terms.ld_cal_type
12065: AND terms.ld_sequence_number = coa_terms.ld_sequence_number
12066: AND coa_terms.base_id = cp_base_id

Line 12087: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;

12083: l_cnt NUMBER := 0;
12084: ln_fund_awd_prct NUMBER;
12085:
12086: lv_result VARCHAR2(80);
12087: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
12088:
12089: lb_use_wcoa_cur BOOLEAN := FALSE;
12090:
12091: -- Get existing pell disbursments

Line 12109: l_pell_dp igf_aw_awd_dist_plans.adplans_id%TYPE;

12105: ) IS
12106: SELECT adplans_id
12107: FROM igf_aw_award_all
12108: WHERE award_id = cp_award_id;
12109: l_pell_dp igf_aw_awd_dist_plans.adplans_id%TYPE;
12110:
12111: -- Get extra pell disbursements
12112: CURSOR c_pell_new_disb(
12113: cp_award_id igf_aw_award_all.award_id%TYPE,

Line 13097: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE

13093: l_person_number hz_parties.party_number%TYPE;
13094:
13095: -- Get DP details
13096: CURSOR c_dp(
13097: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
13098: ) IS
13099: SELECT awd_dist_plan_cd_desc
13100: FROM igf_aw_awd_dist_plans
13101: WHERE adplans_id = cp_adplans_id;

Line 13100: FROM igf_aw_awd_dist_plans

13096: CURSOR c_dp(
13097: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
13098: ) IS
13099: SELECT awd_dist_plan_cd_desc
13100: FROM igf_aw_awd_dist_plans
13101: WHERE adplans_id = cp_adplans_id;
13102: l_dp igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
13103:
13104: -- Get award group

Line 13102: l_dp igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;

13098: ) IS
13099: SELECT awd_dist_plan_cd_desc
13100: FROM igf_aw_awd_dist_plans
13101: WHERE adplans_id = cp_adplans_id;
13102: l_dp igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
13103:
13104: -- Get award group
13105: CURSOR c_awd_grp(
13106: cp_grp_code igf_aw_target_grp_all.group_cd%TYPE,

Line 13360: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;

13356: FROM igf_aw_target_grp
13357: WHERE group_cd = cp_group_cd;
13358: l_tgrp_dist c_tgrp_dist%ROWTYPE;
13359: lv_result VARCHAR2(80);
13360: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
13361:
13362: l_error_code NUMBER;
13363: BEGIN
13364: igf_aw_gen.set_org_id(NULL);