1 PACKAGE PSB_BUDGET_PERIOD_PVT AS
2 /* $Header: PSBVPRDS.pls 120.2 2005/07/13 11:29:07 shtripat ship $ */
3
4 PROCEDURE INSERT_ROW (
5 p_api_version in number,
6 p_init_msg_list in varchar2 := fnd_api.g_false,
7 p_commit in varchar2 := fnd_api.g_false,
8 p_validation_level in number := fnd_api.g_valid_level_full,
9 p_return_status OUT NOCOPY varchar2,
10 p_msg_count OUT NOCOPY number,
11 p_msg_data OUT NOCOPY varchar2,
12 p_rowid in OUT NOCOPY varchar2,
13 p_budget_period_id in number,
14 p_budget_calendar_id in number,
15 p_description in varchar2,
16 p_start_date in date,
17 p_end_date in date,
18 p_name in varchar2,
19 p_budget_year_type_id in number,
20 p_parent_budget_period_id in number,
21 p_budget_period_type in varchar2,
22 p_period_distribution_type in varchar2,
23 p_calculation_period_type in varchar2,
24 p_attribute1 in varchar2,
25 p_attribute2 in varchar2,
26 p_attribute3 in varchar2,
27 p_attribute4 in varchar2,
28 p_attribute5 in varchar2,
29 p_attribute6 in varchar2,
30 p_attribute7 in varchar2,
31 p_attribute8 in varchar2,
32 p_attribute9 in varchar2,
33 p_attribute10 in varchar2,
34 p_context in varchar2,
35 p_mode in varchar2 default 'R',
36 p_requery OUT NOCOPY varchar2
37 );
38 --
39 --
40 --
41 PROCEDURE LOCK_ROW (
42 p_api_version in number,
43 p_init_msg_list in varchar2 := fnd_api.g_false,
44 p_commit in varchar2 := fnd_api.g_false,
45 p_validation_level in number := fnd_api.g_valid_level_full,
46 p_return_status OUT NOCOPY varchar2,
47 p_msg_count OUT NOCOPY number,
48 p_msg_data OUT NOCOPY varchar2,
49 p_row_locked OUT NOCOPY varchar2,
50 p_budget_period_id in number,
51 p_budget_calendar_id in number,
52 p_description in varchar2,
53 p_start_date in date,
54 p_end_date in date,
55 p_name in varchar2,
56 p_budget_year_type_id in number,
57 p_parent_budget_period_id in number,
58 p_budget_period_type in varchar2,
59 p_period_distribution_type in varchar2,
60 p_calculation_period_type in varchar2,
61 p_attribute1 in varchar2,
62 p_attribute2 in varchar2,
63 p_attribute3 in varchar2,
64 p_attribute4 in varchar2,
65 p_attribute5 in varchar2,
66 p_attribute6 in varchar2,
67 p_attribute7 in varchar2,
68 p_attribute8 in varchar2,
69 p_attribute9 in varchar2,
70 p_attribute10 in varchar2,
71 p_context in varchar2
72 );
73 --
74 --
75 --
76 PROCEDURE UPDATE_ROW (
77 p_api_version in number,
78 p_init_msg_list in varchar2 := fnd_api.g_false,
79 p_commit in varchar2 := fnd_api.g_false,
80 p_validation_level in number := fnd_api.g_valid_level_full,
81 p_return_status OUT NOCOPY varchar2,
82 p_msg_count OUT NOCOPY number,
83 p_msg_data OUT NOCOPY varchar2,
84 p_budget_period_id in number,
85 p_budget_calendar_id in number,
86 p_description in varchar2,
87 p_start_date in date,
88 p_end_date in date,
89 p_name in varchar2,
90 p_budget_year_type_id in number,
91 p_parent_budget_period_id in number,
92 p_budget_period_type in varchar2,
93 p_period_distribution_type in varchar2,
94 p_calculation_period_type in varchar2,
95 p_attribute1 in varchar2,
96 p_attribute2 in varchar2,
97 p_attribute3 in varchar2,
98 p_attribute4 in varchar2,
99 p_attribute5 in varchar2,
100 p_attribute6 in varchar2,
101 p_attribute7 in varchar2,
102 p_attribute8 in varchar2,
103 p_attribute9 in varchar2,
104 p_attribute10 in varchar2,
105 p_context in varchar2,
106 p_mode in varchar2 default 'R',
107 p_requery OUT NOCOPY varchar2
108 );
109 --
110 --
111 --
112 PROCEDURE ADD_ROW (
113 p_api_version in number,
114 p_init_msg_list in varchar2 := fnd_api.g_false,
115 p_commit in varchar2 := fnd_api.g_false,
116 p_validation_level in number := fnd_api.g_valid_level_full,
117 p_return_status OUT NOCOPY varchar2,
118 p_msg_count OUT NOCOPY number,
119 p_msg_data OUT NOCOPY varchar2,
120 p_rowid in OUT NOCOPY varchar2,
121 p_budget_period_id in number,
122 p_budget_calendar_id in number,
123 p_description in varchar2,
124 p_start_date in date,
125 p_end_date in date,
126 p_name in varchar2,
127 p_budget_year_type_id in number,
128 p_parent_budget_period_id in number,
129 p_budget_period_type in varchar2,
130 p_period_distribution_type in varchar2,
131 p_calculation_period_type in varchar2,
132 p_attribute1 in varchar2,
133 p_attribute2 in varchar2,
134 p_attribute3 in varchar2,
135 p_attribute4 in varchar2,
136 p_attribute5 in varchar2,
137 p_attribute6 in varchar2,
138 p_attribute7 in varchar2,
139 p_attribute8 in varchar2,
140 p_attribute9 in varchar2,
141 p_attribute10 in varchar2,
142 p_context in varchar2,
143 p_mode in varchar2 default 'R',
144 p_requery OUT NOCOPY varchar2
145 );
146 --
147 --
148 --
149 PROCEDURE DELETE_ROW (
150 p_api_version in number,
151 p_init_msg_list in varchar2 := fnd_api.g_false,
152 p_commit in varchar2 := fnd_api.g_false,
153 p_validation_level in number := fnd_api.g_valid_level_full,
154 p_return_status OUT NOCOPY varchar2,
155 p_msg_count OUT NOCOPY number,
156 p_msg_data OUT NOCOPY varchar2,
157 p_budget_period_id in number
158 );
159 --
160 --
161 --
162 --
163 PROCEDURE Copy_Years_In_Calendar(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166 p_commit IN VARCHAR2 := FND_API.G_FALSE,
167 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
168 p_return_status OUT NOCOPY VARCHAR2,
169 p_msg_count OUT NOCOPY NUMBER,
170 p_msg_data OUT NOCOPY VARCHAR2,
171 p_source_cal_id IN NUMBER,
172 p_target_cal_id IN NUMBER,
173 p_shift_flag IN VARCHAR2);
174 --
175 --
176 PROCEDURE Check_Consecutive_Year_Types(
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179 p_commit IN VARCHAR2 := FND_API.G_FALSE,
180 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181 p_return_status OUT NOCOPY VARCHAR2,
182 p_msg_count OUT NOCOPY NUMBER,
183 p_msg_data OUT NOCOPY VARCHAR2,
184 p_calendar_id IN NUMBER,
185 p_curr_year_type IN NUMBER,
186 p_curr_start_date IN DATE,
187 p_curr_end_date IN DATE,
188 p_mode_type IN VARCHAR2
189 );
190 --
191 --
192 FUNCTION get_debug RETURN VARCHAR2;
193 --
194 END PSB_BUDGET_PERIOD_PVT ;