1 PACKAGE IGW_AWARD_BUDGETS_PVT AUTHID CURRENT_USER as
2 --$Header: igwvabts.pls 115.7 2004/03/25 01:52:46 vmedikon ship $
3 G_package_name VARCHAR2(30) := 'IGW_AWARD_BUDGETS_PVT';
4
5 procedure create_award_budget
6 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
7 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
8 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
9 ,p_proposal_id IN NUMBER
10 ,p_proposal_installment_id IN NUMBER := NULL
11 ,p_budget_period_id IN NUMBER
12 ,p_expenditure_type_cat IN VARCHAR2
13 ,p_expenditure_category_flag IN VARCHAR2
14 ,p_budget_amount IN NUMBER := 0
15 ,p_indirect_flag IN VARCHAR2
16 ,p_project_id IN NUMBER :=NULL
17 ,p_project_number IN VARCHAR2
18 ,p_task_id IN NUMBER :=NULL
19 ,p_task_number IN VARCHAR2
20 ,p_award_id IN NUMBER :=NULL
21 ,p_award_number IN VARCHAR2
22 ,p_period_name IN VARCHAR2
23 ,p_start_date IN DATE
24 ,p_end_date IN DATE
25 ,p_transferred_flag IN VARCHAR2
26 ,x_award_budget_id OUT NOCOPY NUMBER
27 ,x_rowid OUT NOCOPY ROWID
28 ,x_return_status OUT NOCOPY VARCHAR2
29 ,x_msg_count OUT NOCOPY NUMBER
30 ,x_msg_data OUT NOCOPY VARCHAR2);
31
32
33 ----------------------------------------------------------------------
34 procedure update_award_budget
35 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
36 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
37 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
38 ,p_award_budget_id IN NUMBER
39 ,p_proposal_id IN NUMBER := NULL
40 ,p_proposal_installment_id IN NUMBER := NULL
41 ,p_budget_period_id IN NUMBER := NULL
42 ,p_expenditure_type_cat IN VARCHAR2
43 ,p_expenditure_category_flag IN VARCHAR2
44 ,p_budget_amount IN NUMBER := 0
45 ,p_indirect_flag IN VARCHAR2
46 ,p_project_id IN NUMBER
47 ,p_project_number IN VARCHAR2
48 ,p_task_id IN NUMBER
49 ,p_task_number IN VARCHAR2
50 ,p_award_id IN NUMBER
51 ,p_award_number IN VARCHAR2
52 ,p_period_name IN VARCHAR2
53 ,p_start_date IN DATE
54 ,p_end_date IN DATE
55 ,p_transferred_flag IN VARCHAR2
56 ,p_record_version_number IN NUMBER
57 ,p_rowid IN ROWID
58 ,x_return_status OUT NOCOPY VARCHAR2
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2);
61
62 -----------------------------------------------------------------------
63
64 procedure delete_award_budget
65 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
66 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
67 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
68 ,p_award_budget_id IN NUMBER
69 ,p_record_version_number IN NUMBER
70 ,p_rowid IN ROWID
71 ,x_return_status OUT NOCOPY VARCHAR2
72 ,x_msg_count OUT NOCOPY NUMBER
73 ,x_msg_data OUT NOCOPY VARCHAR2);
74 -----------------------------------------------------------------------
75 procedure apply_project_award
76 (p_award_budget_id IN NUMBER
77 ,p_proposal_installment_id IN NUMBER
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2);
81 ---------------------------------------------------------------------------
82 procedure get_time_phased_type_code
83 (p_proposal_installment_id IN NUMBER
84 ,x_time_phased_type_code OUT NOCOPY VARCHAR2
85 ,x_return_status OUT NOCOPY VARCHAR2
86 ,x_msg_count OUT NOCOPY NUMBER
87 ,x_msg_data OUT NOCOPY VARCHAR2);
88 --------------------------------------------------------------------------
89 FUNCTION get_current_budget(p_award_id IN NUMBER
90 ,p_project_id IN NUMBER
91 ,p_task_id IN NUMBER) return NUMBER;
92 pragma restrict_references(get_current_budget, wnds);
93 ----------------------------------------------------------------------------
94 FUNCTION get_additional_budget(p_proposal_installment_id IN NUMBER
95 ,p_project_id IN NUMBER
96 ,p_task_id IN NUMBER) return NUMBER;
97 -----------------------------------------------------------------------------------------
98 FUNCTION get_award_created_flag(p_proposal_award_id IN NUMBER) return VARCHAR2;
99 pragma restrict_references(get_award_created_flag, wnds);
100 -----------------------------------------------------------------------------------------
101 FUNCTION get_installment_created_flag(p_proposal_award_id IN NUMBER) return VARCHAR2 ;
102 pragma restrict_references(get_installment_created_flag, wnds);
103 ------------------------------------------------------------------------------------------------------
104 FUNCTION get_award_budget_created_flag(p_proposal_installment_id IN NUMBER) return VARCHAR2;
105 pragma restrict_references(get_award_budget_created_flag, wnds);
106 ------------------------------------------------------------------------------------------------------
107 FUNCTION get_award_budget_creation_date(p_proposal_installment_id IN NUMBER) return DATE;
108 pragma restrict_references(get_award_budget_creation_date, wnds);
109 ------------------------------------------------------------------------------------------------------
110 FUNCTION get_award_number(p_proposal_award_id IN NUMBER) return VARCHAR2;
111 pragma restrict_references(get_award_number, wnds);
112
113 procedure get_boundary_dates(p_project_id in number
114 ,p_award_id in number
115 ,x_budget_start_date out NOCOPY date
116 ,x_budget_end_date out NOCOPY date);
117
118 END;