DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_BUDGET_VERSIONS

Line 175: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

171: -- Bug 3986129: FP.M Web ADI Dev changes. Added the following procedures
172: Procedure validate_header_info
173: ( p_calling_mode IN VARCHAR2 DEFAULT NULL,
174: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
175: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
176: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
177: p_pm_rec_version_number IN pa_period_masks_b.record_version_number%TYPE,
178: p_submit_flag IN VARCHAR2,
179: p_request_id IN pa_budget_versions.request_id%TYPE,

Line 176: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

172: Procedure validate_header_info
173: ( p_calling_mode IN VARCHAR2 DEFAULT NULL,
174: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
175: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
176: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
177: p_pm_rec_version_number IN pa_period_masks_b.record_version_number%TYPE,
178: p_submit_flag IN VARCHAR2,
179: p_request_id IN pa_budget_versions.request_id%TYPE,
180: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 179: p_request_id IN pa_budget_versions.request_id%TYPE,

175: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
176: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
177: p_pm_rec_version_number IN pa_period_masks_b.record_version_number%TYPE,
178: p_submit_flag IN VARCHAR2,
179: p_request_id IN pa_budget_versions.request_id%TYPE,
180: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
181: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
182: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
183:

Line 193: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,

189: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
190: p_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
191: p_txn_curr_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
192: p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
193: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
194: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
195: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
196: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
197:

Line 200: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

196: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
197:
198: PROCEDURE process_budget_lines
199: ( p_context IN VARCHAR2,
200: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
201: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
202: p_task_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
203: p_rlm_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),
204: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type(),

Line 256: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,

252: p_submit_budget_flag IN VARCHAR2 DEFAULT 'N',
253: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
254: x_success_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
255: p_submit_forecast_flag IN VARCHAR2 DEFAULT 'N',
256: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
257: p_calling_mode IN VARCHAR2 DEFAULT 'STANDARD'
258: );
259:
260: -- Bug 3986129: FP.M Web ADI Dev changes

Line 273: PROCEDURE insert_periodic_tmp_table(p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

269:
270: --Bug 4584865.
271: --This API is called to insert records into pa_fp_webadi_xface_tmp
272: --during downloading budget line details into excel spreadsheet.
273: PROCEDURE insert_periodic_tmp_table(p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2);
277: