[Home] [Help]
PACKAGE: APPS.PN_VAR_RENT_PUB
Source
1 PACKAGE pn_var_rent_pub AUTHID CURRENT_USER AS
2 /* $Header: PNVARPUS.pls 120.4.12020000.2 2012/07/18 10:00:37 admarath ship $ */
3 /*#
4 * This package contains the public APIs for lease and terms information.
5 * @rep:scope public
6 * @rep:product PN
7 * @rep:lifecycle active
8 * @rep:displayname Variable Rent Definition
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PN_VARIABLE_RENTS
11 */
12 /*********************************************/
13 -- Procedure to create variable rent
14 /*********************************************/
15 /*#
16 * This API creates a new variable rent in the Oracle Projects.
17 * @param p_api_version API standard version number
18 * @rep:paraminfo {@rep:required}
19 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
20 * @rep:paraminfo {@rep:required}
21 * @param p_commit API standard (default = F): indicates if transaction will be committed
22 * @rep:paraminfo {@rep:required}
23 * @param p_validate_flag Indicates whether the system performs scheduling validations. Default is Y
24 * @rep:paraminfo {@rep:precision 1}
25 * @param p_var_rent_rec Input Output identifier for variable rent record details
26 * @rep:paraminfo {@rep:required}
27 * @param p_variable_rent_lines_tbl Input Output identifier for variable rent lines table
28 * @rep:paraminfo {@rep:required}
29 * @param p_breakpoint_header_tbl Input Output identifier for breakpoint header table
30 * @rep:paraminfo {@rep:required}
31 * @param p_breakpoint_details_tbl Input Output identifier for breakpoint details table
32 * @rep:paraminfo {@rep:required}
33 * @param p_constraints_tbl Input Output identifier for constraints table
34 * @rep:paraminfo {@rep:required}
35 * @param p_allow_abat_tbl Input Output identifier for allowances and abatement table
36 * @rep:paraminfo {@rep:required}
37 * @param p_generate_periods Input identifier for generate periods. Default is N
38 * @rep:paraminfo {@rep:precision 1}
39 * @param p_generate_breakpoints Input identifier for generate breakpoint. Default is N
40 * @rep:paraminfo {@rep:precision 1}
41 * @param p_generate_constraints Input identifier for generate constraints. Default is N
42 * @rep:paraminfo {@rep:precision 1}
43 * @param x_return_status API standard: return of the API (success/failure/unexpected error)
44 * @param x_msg_count API standard: number of error messages
45 * @rep:paraminfo {@rep:required}
46 * @param x_msg_data API standard: error message
47 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
48 * @param x_var_rent_id Output identifier for variable rent id
49 * @param x_var_rent_num Output identifier for variable rent number
50 * @rep:scope public
51 * @rep:lifecycle active
52 * @rep:displayname Create Variable Rent
53 * @rep:category BUSINESS_ENTITY PN_VARIABLE_RENTS
54 * @rep:compatibility S
55 */
56
57 PROCEDURE create_var_rent (
58 p_api_version IN NUMBER
59 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
60 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
61 , p_validate_flag IN VARCHAR2 DEFAULT 'N'
62 , p_var_rent_rec IN OUT NOCOPY pn_varen_pvt.var_rent_rec_type
63 , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
64 , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
65 , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
66 , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
67 , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
68 , p_generate_periods IN VARCHAR2 DEFAULT 'N'
69 , p_generate_breakpoints IN VARCHAR2 DEFAULT 'N'
70 , p_generate_constraints IN VARCHAR2 DEFAULT 'N'
71 , x_return_status OUT NOCOPY VARCHAR2
72 , x_msg_count OUT NOCOPY NUMBER
73 , x_msg_data OUT NOCOPY VARCHAR2
74 , x_var_rent_id OUT NOCOPY NUMBER
75 , x_var_rent_num OUT NOCOPY VARCHAR2
76 );
77
78 /*********************************************/
79 -- Procedure to generate periods
80 /*********************************************/
81 /*#
82 * This API generates periods for variable rents in the Oracle Projects.
83 * @param p_api_version API standard version number
84 * @rep:paraminfo {@rep:required}
85 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
86 * @rep:paraminfo {@rep:required}
87 * @param p_commit API standard (default = F): indicates if transaction will be committed
88 * @rep:paraminfo {@rep:required}
89 * @param p_var_rent_id Input identifier for variable rent id
90 * @param p_generate_periods Input identifier for generate periods. Default is N
91 * @param x_return_status API standard: return of the API (success/failure/unexpected error)
92 * @param x_msg_count API standard: number of error messages
93 * @rep:paraminfo {@rep:required}
94 * @param x_msg_data API standard: error message
95 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
96 * @rep:scope public
97 * @rep:lifecycle active
98 * @rep:displayname Generate Period
99 * @rep:category BUSINESS_ENTITY PN_VARIABLE_RENTS
100 * @rep:compatibility S
101 */
102
103 PROCEDURE generate_periods (
104 p_api_version IN NUMBER
105 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
106 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
107 , p_var_rent_id IN NUMBER
108 , p_generate_periods IN VARCHAR2 DEFAULT 'N'
109 , x_return_status OUT NOCOPY VARCHAR2
110 , x_msg_count OUT NOCOPY NUMBER
111 , x_msg_data OUT NOCOPY VARCHAR2
112 );
113
114 /*************************************************************************/
115 -- Procedure to create breakpoint, constraints, allowances and abatement
116 /*************************************************************************/
117 /*#
118 * This API creates breakpoints, constraints, allowances and abatements in the Oracle Projects.
119 * @param p_api_version API standard version number
120 * @rep:paraminfo {@rep:required}
121 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
122 * @rep:paraminfo {@rep:required}
123 * @param p_commit API standard (default = F): indicates if transaction will be committed
124 * @rep:paraminfo {@rep:required}
125 * @param p_validate_flag Indicates whether the system performs scheduling validations. Default is Y
126 * @rep:paraminfo {@rep:precision 1}
127 * @param p_variable_rent_lines_tbl Input Output identifier for variable rent lines table type
128 * @rep:paraminfo {@rep:required}
129 * @param p_breakpoint_header_tbl Input Output identifier for breakpoint header table type
130 * @rep:paraminfo {@rep:required}
131 * @param p_breakpoint_details_tbl Input Output identifier for breakpoint details table type
132 * @rep:paraminfo {@rep:required}
133 * @param p_constraints_tbl Input Output identifier for constraints table type
134 * @rep:paraminfo {@rep:required}
135 * @param p_allow_abat_tbl Input Output identifier for allowances and abatement table type
136 * @rep:paraminfo {@rep:required}
137 * @param x_return_status API standard: return of the API (success/failure/unexpected error)
138 * @param x_msg_count API standard: number of error messages
139 * @rep:paraminfo {@rep:required}
140 * @param x_msg_data API standard: error message
141 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
142 * @rep:scope public
143 * @rep:lifecycle active
144 * @rep:displayname Create Breakpoint, constraint, Allowance and Abatement
145 * @rep:category BUSINESS_ENTITY PN_VARIABLE_RENTS
146 * @rep:compatibility S
147 */
148 PROCEDURE create_bkpt_const_allow_abat (
149 p_api_version IN NUMBER
150 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
151 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
152 , p_validate_flag IN VARCHAR2 DEFAULT 'N'
153 , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
154 , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
155 , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
156 , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
157 , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
158 , x_return_status OUT NOCOPY VARCHAR2
159 , x_msg_count OUT NOCOPY NUMBER
160 , x_msg_data OUT NOCOPY VARCHAR2
161 );
162
163 /*********************************************/
164 -- Procedure to update variable rent
165 /*********************************************/
166
167 /*#
168 * This API updates variable rent in the Oracle Projects.
169 * @param p_api_version API standard version number
170 * @rep:paraminfo {@rep:required}
171 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
172 * @rep:paraminfo {@rep:required}
173 * @param p_commit API standard (default = F): indicates if transaction will be committed
174 * @rep:paraminfo {@rep:required}
175 * @param p_validate_flag Indicates whether the system performs scheduling validations. Default is Y
176 * @rep:paraminfo {@rep:precision 1}
177 * @param p_upd_var_rent_rec Input Output identifier for update variable rent record details
178 * @rep:paraminfo {@rep:required}
179 * @param p_var_rent_lines_tbl Input Output identifier for variable rent lines table type
180 * @rep:paraminfo {@rep:required}
181 * @param p_breakpoint_header_tbl Input Output identifier for breakpoint header table type
182 * @rep:paraminfo {@rep:required}
183 * @param p_breakpoint_details_tbl Input Output identifier for breakpoint details table type
184 * @rep:paraminfo {@rep:required}
185 * @param p_constraints_tbl Input Output identifier for constraints table type
186 * @rep:paraminfo {@rep:required}
187 * @param p_allow_abat_tbl Input Output identifier for allowances and abatement table type
188 * @rep:paraminfo {@rep:required}
189 * @param p_undo_periods Input identifier for undoing periods. Default is N
190 * @param p_undo_breakpoints Input identifier for undoing breakpoint. Default is N
191 * @param p_undo_constraints Input identifier for undoing constraints. Default is N
192 * @param x_return_status API standard: return of the API (success/failure/unexpected error)
193 * @param x_msg_count API standard: number of error messages
194 * @rep:paraminfo {@rep:required}
195 * @param x_msg_data API standard: error message
196 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
197 * @rep:scope public
198 * @rep:lifecycle active
199 * @rep:displayname Update Variable Rent
200 * @rep:category BUSINESS_ENTITY PN_VARIABLE_RENTS
201 * @rep:compatibility S
202 */
203 PROCEDURE update_var_rent (
204 p_api_version IN NUMBER
205 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
206 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
207 , p_validate_flag IN VARCHAR2 DEFAULT 'Y'
208 , p_upd_var_rent_rec IN OUT NOCOPY pn_varen_pvt.upd_var_rent_rec_type
209 , p_var_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
210 , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
211 , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type
212 , p_constraints_tbl IN OUT NOCOPY pn_varen_pvt.constraints_tbl_type
213 , p_allow_abat_tbl IN OUT NOCOPY pn_varen_pvt.allow_abat_tbl_type
214 , p_undo_periods IN VARCHAR2 DEFAULT 'N'
215 , p_undo_breakpoints IN VARCHAR2 DEFAULT 'N'
216 , p_undo_constraints IN VARCHAR2 DEFAULT 'N'
217 , x_return_status OUT NOCOPY VARCHAR2
218 , x_msg_count OUT NOCOPY NUMBER
219 , x_msg_data OUT NOCOPY VARCHAR2
220 );
221 END pn_var_rent_pub;