DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 55: ,p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

51: );
52:
53: PROCEDURE GET_RES_ASSIGNMENT_INFO
54: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
55: ,p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
56: ,x_task_number OUT NOCOPY pa_tasks.task_number%TYPE --File.Sql.39 bug 4440895
57: ,x_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
58: ,x_resource_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
59: ,x_resource_group_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895

Line 78: ,p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

74: */
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

Line 152: (p_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE

148:
149:
150:
151: PROCEDURE GET_LAYOUT_DETAILS
152: (p_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
153: ,p_integrator_code IN bne_integrators_b.integrator_code%TYPE
154: ,x_layout_name OUT NOCOPY bne_layouts_tl.user_name%TYPE --File.Sql.39 bug 4440895
155: ,x_layout_type_code OUT NOCOPY pa_lookups.lookup_code%TYPE --File.Sql.39 bug 4440895
156: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 193: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,

189: FUNCTION get_current_amount(
190: p_fin_plan_type_id NUMBER,
191: p_plan_class_code VARCHAR2,
192: p_project_id NUMBER,
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,

Line 210: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,

206: FUNCTION get_original_amount(
207: p_fin_plan_type_id NUMBER,
208: p_plan_class_code VARCHAR2,
209: p_project_id NUMBER,
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,

Line 226: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,

222: FUNCTION get_prior_forecast_amount(
223: p_fin_plan_type_id NUMBER,
224: p_plan_class_code VARCHAR2,
225: p_project_id NUMBER,
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,