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
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
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
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}
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
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
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
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
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)
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}
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
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
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
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
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
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}
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
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
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
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
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
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}
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
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