APPS.PA_FP_WEBADI_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 54: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

50: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
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

Line 60: ,x_parent_assignment_id OUT NOCOPY pa_resource_assignments.parent_assignment_id%TYPE --File.Sql.39 bug 4440895

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
60: ,x_parent_assignment_id OUT NOCOPY pa_resource_assignments.parent_assignment_id%TYPE --File.Sql.39 bug 4440895
61: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE --File.Sql.39 bug 4440895
62: ,x_resource_id OUT NOCOPY pa_resource_list_members.resource_id%TYPE --File.Sql.39 bug 4440895
63: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
64: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 196: p_uom pa_resource_assignments.unit_of_measure%TYPE,

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,
198: p_amount VARCHAR2)
199: RETURN NUMBER;
200:

Line 213: p_uom pa_resource_assignments.unit_of_measure%TYPE,

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,
215: p_amount VARCHAR2)
216: RETURN NUMBER;
217:

Line 229: p_uom pa_resource_assignments.unit_of_measure%TYPE,

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,
231: p_amount VARCHAR2)
232: RETURN NUMBER;
233: