[Home] [Help]
PACKAGE: APPS.IGW_BUDGETS_PVT
Source
1 PACKAGE IGW_BUDGETS_PVT AUTHID CURRENT_USER as
2 --$Header: igwvbvss.pls 115.8 2002/11/14 18:38:41 vmedikon ship $
3 G_package_name VARCHAR2(30) := 'IGW_BUDGETS_PVT';
4
5 procedure manage_budget_deletion
6 (p_delete_level VARCHAR2
7 ,p_proposal_id NUMBER
8 ,p_version_id NUMBER
9 ,p_budget_period_id NUMBER := null
10 ,p_line_item_id NUMBER := null
11 ,p_budget_personnel_detail_id NUMBER := null
12 ,x_return_status OUT NOCOPY VARCHAR2);
13
14 ---------------------------------------------------------------------------------------
15 PROCEDURE copy_final_to_award_budget(
16 p_proposal_id IN NUMBER
17 ,p_proposal_installment_id IN NUMBER
18 ,x_return_status OUT NOCOPY VARCHAR2
19 ,x_msg_data OUT NOCOPY VARCHAR2
20 ,x_msg_count OUT NOCOPY NUMBER);
21
22 -------------------------------------------------------------------------------------
23
24 procedure create_budget_version
25 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
26 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
27 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
28 ,p_proposal_id NUMBER
29 ,p_version_id NUMBER
30 ,p_start_date DATE := null
31 ,p_end_date DATE := null
32 ,p_total_cost NUMBER := 0
33 ,p_total_direct_cost NUMBER := 0
34 ,p_total_indirect_cost NUMBER := 0
35 ,p_cost_sharing_amount NUMBER := 0
36 ,p_underrecovery_amount NUMBER := 0
37 ,p_residual_funds NUMBER := 0
38 ,p_total_cost_limit NUMBER
39 ,p_oh_rate_class_id NUMBER
40 ,p_oh_rate_class_name VARCHAR2
41 ,p_proposal_form_number VARCHAR2
42 ,p_comments VARCHAR2
43 ,p_final_version_flag VARCHAR2 := 'N'
44 ,p_budget_type_code VARCHAR2 := 'PROPOSAL_BUDGET'
45 ,p_enter_budget_at_period_level VARCHAR2
46 ,p_apply_inflation_setup_rates VARCHAR2
47 ,p_apply_eb_setup_rates VARCHAR2
48 ,p_apply_oh_setup_rates VARCHAR2
49 ,p_attribute_category VARCHAR2 := null
50 ,p_attribute1 VARCHAR2 := null
51 ,p_attribute2 VARCHAR2 := null
52 ,p_attribute3 VARCHAR2 := null
53 ,p_attribute4 VARCHAR2 := null
54 ,p_attribute5 VARCHAR2 := null
55 ,p_attribute6 VARCHAR2 := null
56 ,p_attribute7 VARCHAR2 := null
57 ,p_attribute8 VARCHAR2 := null
58 ,p_attribute9 VARCHAR2 := null
59 ,p_attribute10 VARCHAR2 := null
60 ,p_attribute11 VARCHAR2 := null
61 ,p_attribute12 VARCHAR2 := null
62 ,p_attribute13 VARCHAR2 := null
63 ,p_attribute14 VARCHAR2 := null
64 ,p_attribute15 VARCHAR2 := null
65 ,x_rowid OUT NOCOPY ROWID
66 ,x_return_status OUT NOCOPY VARCHAR2
67 ,x_msg_count OUT NOCOPY NUMBER
68 ,x_msg_data OUT NOCOPY VARCHAR2);
69
70
71 ----------------------------------------------------------------------
72 procedure update_budget_version
73 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
74 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
75 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
76 ,p_proposal_id NUMBER
77 ,p_version_id NUMBER
78 ,p_start_date DATE
79 ,p_end_date DATE
80 ,p_total_cost NUMBER
81 ,p_total_direct_cost NUMBER
82 ,p_total_indirect_cost NUMBER
83 ,p_cost_sharing_amount NUMBER
84 ,p_underrecovery_amount NUMBER
85 ,p_residual_funds NUMBER
86 ,p_total_cost_limit NUMBER
87 ,p_oh_rate_class_id NUMBER
88 ,p_oh_rate_class_name VARCHAR2
89 ,p_proposal_form_number VARCHAR2
90 ,p_comments VARCHAR2
91 ,p_final_version_flag VARCHAR2
92 ,p_budget_type_code VARCHAR2 := 'PROPOSAL_BUDGET'
93 ,p_enter_budget_at_period_level VARCHAR2
94 ,p_apply_inflation_setup_rates VARCHAR2
95 ,p_apply_eb_setup_rates VARCHAR2
96 ,p_apply_oh_setup_rates VARCHAR2
97 ,p_attribute_category VARCHAR2 := null
98 ,p_attribute1 VARCHAR2 := null
99 ,p_attribute2 VARCHAR2 := null
100 ,p_attribute3 VARCHAR2 := null
101 ,p_attribute4 VARCHAR2 := null
102 ,p_attribute5 VARCHAR2 := null
103 ,p_attribute6 VARCHAR2 := null
104 ,p_attribute7 VARCHAR2 := null
105 ,p_attribute8 VARCHAR2 := null
106 ,p_attribute9 VARCHAR2 := null
107 ,p_attribute10 VARCHAR2 := null
108 ,p_attribute11 VARCHAR2 := null
109 ,p_attribute12 VARCHAR2 := null
110 ,p_attribute13 VARCHAR2 := null
111 ,p_attribute14 VARCHAR2 := null
112 ,p_attribute15 VARCHAR2 := null
113 ,p_record_version_number IN NUMBER
114 ,p_rowid IN ROWID
115 ,x_return_status OUT NOCOPY VARCHAR2
116 ,x_msg_count OUT NOCOPY NUMBER
117 ,x_msg_data OUT NOCOPY VARCHAR2);
118
119 -----------------------------------------------------------------------
120
121 procedure delete_budget_version
122 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
123 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
124 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
125 ,p_proposal_id IN NUMBER
126 ,p_version_id IN NUMBER
127 ,p_record_version_number IN NUMBER
128 ,p_rowid IN ROWID
129 ,x_return_status OUT NOCOPY VARCHAR2
130 ,x_msg_count OUT NOCOPY NUMBER
131 ,x_msg_data OUT NOCOPY VARCHAR2);
132
133
134 END IGW_BUDGETS_PVT;