DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_UTILS dependencies on PA_BUDGET_LINES

Line 69: (p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE

65: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66: ) ;
67: /* Bug 5350437: Commented the below API
68: PROCEDURE VALIDATE_CHANGE_REASON_CODE
69: (p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
70: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
71: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
72: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73: );

Line 79: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE

75:
76: PROCEDURE VALIDATE_TXN_CURRENCY_CODE
77: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
78: ,p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
79: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
80: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
81: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
82: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
83: );

Line 197: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,

193: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
194: p_task_id NUMBER,
195: p_resource_list_member_id NUMBER,
196: p_uom pa_resource_assignments.unit_of_measure%TYPE,
197: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,
198: p_amount VARCHAR2)
199: RETURN NUMBER;
200:
201:

Line 214: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,

210: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
211: p_task_id NUMBER,
212: p_resource_list_member_id NUMBER,
213: p_uom pa_resource_assignments.unit_of_measure%TYPE,
214: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,
215: p_amount VARCHAR2)
216: RETURN NUMBER;
217:
218: /* =================================================================================

Line 230: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,

226: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
227: p_task_id NUMBER,
228: p_resource_list_member_id NUMBER,
229: p_uom pa_resource_assignments.unit_of_measure%TYPE,
230: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,
231: p_amount VARCHAR2)
232: RETURN NUMBER;
233:
234:

Line 245: p_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE,

241: =======================================================================================*/
242: FUNCTION get_period_amounts(
243: p_budget_version_id NUMBER,
244: p_amount_code VARCHAR2,
245: p_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE,
246: p_txn_currency_code pa_budget_lines.txn_currency_code%TYPE,
247: p_prd_start_date DATE,
248: p_prd_end_date DATE,
249: preceding_date DATE,

Line 246: p_txn_currency_code pa_budget_lines.txn_currency_code%TYPE,

242: FUNCTION get_period_amounts(
243: p_budget_version_id NUMBER,
244: p_amount_code VARCHAR2,
245: p_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE,
246: p_txn_currency_code pa_budget_lines.txn_currency_code%TYPE,
247: p_prd_start_date DATE,
248: p_prd_end_date DATE,
249: preceding_date DATE,
250: succedeing_date DATE)