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_AWARD

Line 4: PROCEDURE create_auto_disb( p_fund_id IN igf_aw_award.fund_id%TYPE,

1: PACKAGE igf_aw_gen_003 AS
2: /* $Header: IGFAW12S.pls 120.1 2005/07/01 06:55:41 appldev ship $ */
3:
4: PROCEDURE create_auto_disb( p_fund_id IN igf_aw_award.fund_id%TYPE,
5: p_award_id IN igf_aw_award.award_id%TYPE,
6: p_offered_amt IN igf_aw_award.offered_amt%TYPE,
7: p_award_status IN igf_aw_award.award_status%TYPE,
8: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,

Line 5: p_award_id IN igf_aw_award.award_id%TYPE,

1: PACKAGE igf_aw_gen_003 AS
2: /* $Header: IGFAW12S.pls 120.1 2005/07/01 06:55:41 appldev ship $ */
3:
4: PROCEDURE create_auto_disb( p_fund_id IN igf_aw_award.fund_id%TYPE,
5: p_award_id IN igf_aw_award.award_id%TYPE,
6: p_offered_amt IN igf_aw_award.offered_amt%TYPE,
7: p_award_status IN igf_aw_award.award_status%TYPE,
8: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
9: p_method_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,

Line 6: p_offered_amt IN igf_aw_award.offered_amt%TYPE,

2: /* $Header: IGFAW12S.pls 120.1 2005/07/01 06:55:41 appldev ship $ */
3:
4: PROCEDURE create_auto_disb( p_fund_id IN igf_aw_award.fund_id%TYPE,
5: p_award_id IN igf_aw_award.award_id%TYPE,
6: p_offered_amt IN igf_aw_award.offered_amt%TYPE,
7: p_award_status IN igf_aw_award.award_status%TYPE,
8: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
9: p_method_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
10: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE

Line 7: p_award_status IN igf_aw_award.award_status%TYPE,

3:
4: PROCEDURE create_auto_disb( p_fund_id IN igf_aw_award.fund_id%TYPE,
5: p_award_id IN igf_aw_award.award_id%TYPE,
6: p_offered_amt IN igf_aw_award.offered_amt%TYPE,
7: p_award_status IN igf_aw_award.award_status%TYPE,
8: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
9: p_method_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
10: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
11: );

Line 14: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,

10: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE
11: );
12:
13: PROCEDURE round_off_disbursements(
14: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
15: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
16: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
17: p_award_status IN igf_aw_award_all.award_status%TYPE,
18: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,

Line 15: p_award_id IN igf_aw_award_t_all.award_id%TYPE,

11: );
12:
13: PROCEDURE round_off_disbursements(
14: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
15: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
16: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
17: p_award_status IN igf_aw_award_all.award_status%TYPE,
18: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
19: p_disb_count IN NUMBER

Line 16: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,

12:
13: PROCEDURE round_off_disbursements(
14: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
15: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
16: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
17: p_award_status IN igf_aw_award_all.award_status%TYPE,
18: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
19: p_disb_count IN NUMBER
20: );

Line 17: p_award_status IN igf_aw_award_all.award_status%TYPE,

13: PROCEDURE round_off_disbursements(
14: p_fund_id IN igf_aw_award_t_all.fund_id%TYPE,
15: p_award_id IN igf_aw_award_t_all.award_id%TYPE,
16: p_offered_amt IN igf_aw_award_t_all.offered_amt%TYPE,
17: p_award_status IN igf_aw_award_all.award_status%TYPE,
18: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
19: p_disb_count IN NUMBER
20: );
21:

Line 23: p_award_id IN igf_aw_award.award_id%TYPE

19: p_disb_count IN NUMBER
20: );
21:
22: PROCEDURE update_accept_amount (
23: p_award_id IN igf_aw_award.award_id%TYPE
24: );
25: -- adhawan, May 12th 2002
26: --This procedure ensures that whenever the Award Status is changed to Accepted from Offered
27: --and the Accepted amount is null or Zero then updation of the accepted amounts should take

Line 31: PROCEDURE update_awd_cancell_to_offer(p_award_id IN igf_aw_award.award_id%TYPE,

27: --and the Accepted amount is null or Zero then updation of the accepted amounts should take
28: -- place with the offered amounts to the Disbursement table.
29: --Bug ID : 2332588
30:
31: PROCEDURE update_awd_cancell_to_offer(p_award_id IN igf_aw_award.award_id%TYPE,
32: p_award_stat IN VARCHAR2,
33: p_fed_fund_code IN VARCHAR2,
34: p_base_id IN NUMBER,
35: p_message OUT NOCOPY VARCHAR2

Line 46: p_award_id IN igf_aw_award.award_id%TYPE

42: --Bug ID : 2375571
43:
44:
45: PROCEDURE remove_awd_rules_override(
46: p_award_id IN igf_aw_award.award_id%TYPE
47: );
48:
49: PROCEDURE create_over_awd_holds(
50: p_award_id IN igf_aw_award.award_id%TYPE

Line 50: p_award_id IN igf_aw_award.award_id%TYPE

46: p_award_id IN igf_aw_award.award_id%TYPE
47: );
48:
49: PROCEDURE create_over_awd_holds(
50: p_award_id IN igf_aw_award.award_id%TYPE
51: );
52: --To update the Financial Aid base Record with The cost of Attendance
53: --Fixed Coa , Pell Coa , Coa for Federal , Coa for Institutional
54: PROCEDURE updating_coa_in_fa_base

Line 69: p_person_number IN igf_aw_award_v.person_number%TYPE,

65: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
66: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
67: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
68: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
69: p_person_number IN igf_aw_award_v.person_number%TYPE,
70: p_award_id IN igf_aw_award_all.award_id%TYPE,
71: p_act_isir IN VARCHAR2,
72: p_ld_seq_number IN NUMBER,
73: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,

Line 70: p_award_id IN igf_aw_award_all.award_id%TYPE,

66: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
67: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
68: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
69: p_person_number IN igf_aw_award_v.person_number%TYPE,
70: p_award_id IN igf_aw_award_all.award_id%TYPE,
71: p_act_isir IN VARCHAR2,
72: p_ld_seq_number IN NUMBER,
73: p_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
74: p_chk_holds OUT NOCOPY VARCHAR2)

Line 83: FUNCTION check_disbdts ( p_award_id IN igf_aw_award_all.award_id%TYPE,

79: -- This function returns validation failure message if any
80: -- The out NOCOPY parameter is indicator if the award is an overAward or not
81: --
82:
83: FUNCTION check_disbdts ( p_award_id IN igf_aw_award_all.award_id%TYPE,
84: p_ld_seq_number IN NUMBER)
85: RETURN VARCHAR2;
86:
87: --

Line 90: PROCEDURE update_bill_flag ( p_fund_id IN igf_aw_award_all.fund_id%TYPE,

86:
87: --
88: -- Procedure to update show_on_bill flag based on the fund manager value
89: --
90: PROCEDURE update_bill_flag ( p_fund_id IN igf_aw_award_all.fund_id%TYPE,
91: p_new_val IN igf_aw_fund_mast_all.show_on_bill%TYPE);
92:
93: FUNCTION delete_awd_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,
94: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE DEFAULT NULL,

Line 93: FUNCTION delete_awd_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,

89: --
90: PROCEDURE update_bill_flag ( p_fund_id IN igf_aw_award_all.fund_id%TYPE,
91: p_new_val IN igf_aw_fund_mast_all.show_on_bill%TYPE);
92:
93: FUNCTION delete_awd_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,
94: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE DEFAULT NULL,
95: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE DEFAULT NULL)
96: RETURN VARCHAR2;
97:

Line 99: FUNCTION get_total_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,

95: p_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE DEFAULT NULL)
96: RETURN VARCHAR2;
97:
98:
99: FUNCTION get_total_disb ( p_award_id IN igf_aw_award_all.award_id%TYPE,
100: p_ld_seq_num IN igf_aw_awd_disb_all.ld_sequence_number%TYPE DEFAULT NULL)
101: RETURN NUMBER;
102:
103: PROCEDURE awd_group_freeze(p_award_grp IN VARCHAR2,