DBA Data[Home] [Help]

APPS.PA_FP_CALC_PLAN_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 68: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

64: ,x_return_status OUT NOCOPY Varchar2
65: );
66:
67: PROCEDURE delete_budget_lines (p_budget_version_id IN pa_budget_lines.budget_version_id%type
68: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
69: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
70: ,p_line_start_date IN pa_budget_lines.start_date%TYPE
71: ,p_line_end_date IN pa_budget_lines.end_date%TYPE
72: ,p_source_context IN varchar2

Line 81: ,p_person_id IN pa_resource_assignments.person_id%TYPE

77: );
78:
79: PROCEDURE chk_req_rate_api_inputs ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
80: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
81: ,p_person_id IN pa_resource_assignments.person_id%TYPE
82: ,p_job_id IN pa_resource_assignments.job_id%TYPE
83: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
84: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
85: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE

Line 82: ,p_job_id IN pa_resource_assignments.job_id%TYPE

78:
79: PROCEDURE chk_req_rate_api_inputs ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
80: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
81: ,p_person_id IN pa_resource_assignments.person_id%TYPE
82: ,p_job_id IN pa_resource_assignments.job_id%TYPE
83: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
84: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
85: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
86: ,p_quantity IN pa_budget_lines.quantity%TYPE

Line 83: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE

79: PROCEDURE chk_req_rate_api_inputs ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
80: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
81: ,p_person_id IN pa_resource_assignments.person_id%TYPE
82: ,p_job_id IN pa_resource_assignments.job_id%TYPE
83: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
84: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
85: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
86: ,p_quantity IN pa_budget_lines.quantity%TYPE
87: ,p_item_date IN pa_budget_lines.start_date%TYPE

Line 84: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE

80: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
81: ,p_person_id IN pa_resource_assignments.person_id%TYPE
82: ,p_job_id IN pa_resource_assignments.job_id%TYPE
83: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
84: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
85: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
86: ,p_quantity IN pa_budget_lines.quantity%TYPE
87: ,p_item_date IN pa_budget_lines.start_date%TYPE
88: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE

Line 85: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE

81: ,p_person_id IN pa_resource_assignments.person_id%TYPE
82: ,p_job_id IN pa_resource_assignments.job_id%TYPE
83: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
84: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
85: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
86: ,p_quantity IN pa_budget_lines.quantity%TYPE
87: ,p_item_date IN pa_budget_lines.start_date%TYPE
88: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
89: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE

Line 88: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE

84: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
85: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
86: ,p_quantity IN pa_budget_lines.quantity%TYPE
87: ,p_item_date IN pa_budget_lines.start_date%TYPE
88: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
89: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE
90: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
91: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
92: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE

Line 89: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE

85: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
86: ,p_quantity IN pa_budget_lines.quantity%TYPE
87: ,p_item_date IN pa_budget_lines.start_date%TYPE
88: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
89: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE
90: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
91: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
92: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE
93: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE

Line 90: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE

86: ,p_quantity IN pa_budget_lines.quantity%TYPE
87: ,p_item_date IN pa_budget_lines.start_date%TYPE
88: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
89: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE
90: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
91: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
92: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE
93: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE
94: ,p_burden_cost IN pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE

Line 121: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

117: ,x_msg_data OUT NOCOPY VARCHAR2);
118:
119: PROCEDURE convert_ra_txn_currency
120: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
121: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
122: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
123: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
124: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
125: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE