DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_FP_WEBADI_UPLOAD_INF

Line 138: error_code pa_fp_webadi_upload_inf.val_error_code%TYPE

134: (
135: task_id pa_resource_assignments.task_id%TYPE,
136: rlm_id pa_resource_assignments.resource_list_member_id%TYPE,
137: txn_currency pa_budget_lines.txn_currency_code%TYPE,
138: error_code pa_fp_webadi_upload_inf.val_error_code%TYPE
139: );
140:
141: TYPE G_FP_WEBADI_GLOBAL IS TABLE OF G_FP_WA_GLOBAL_VAR_REC;
142:

Line 164: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE

160: */
161: /*End of Changes done for Bug : 4584865*/
162:
163: PROCEDURE delete_xface
164: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE
165: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
166: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
167: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
168: ,p_calling_module IN VARCHAR2 DEFAULT NULL

Line 174: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,

170:
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,

Line 185: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE ,

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:
184: PROCEDURE process_errors
185: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE ,
186: p_context IN VARCHAR2 DEFAULT NULL,
187: p_periodic_flag IN VARCHAR2 DEFAULT NULL,
188: p_error_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
189: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

Line 254: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,

250: (x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
251: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
252: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
253: p_submit_budget_flag IN VARCHAR2 DEFAULT 'N',
254: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
255: x_success_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
256: p_submit_forecast_flag IN VARCHAR2 DEFAULT 'N',
257: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
258: p_calling_mode IN VARCHAR2 DEFAULT 'STANDARD'

Line 269: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE);

265: PROCEDURE process_MSExcel_data
266: (errbuf OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
267: retcode OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
268: p_submit_ver_flag IN VARCHAR2,
269: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE);
270:
271: --Bug 4584865.
272: --This API is called to insert records into pa_fp_webadi_xface_tmp
273: --during downloading budget line details into excel spreadsheet.