DBA Data[Home] [Help]

APPS.PA_FP_CALC_PLAN_PKG dependencies on PA_BUDGET_LINES

Line 67: PROCEDURE delete_budget_lines (p_budget_version_id IN pa_budget_lines.budget_version_id%type

63: ,x_msg_data OUT NOCOPY Varchar2
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

Line 69: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE

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
73: ,x_return_status OUT NOCOPY VARCHAR2

Line 70: ,p_line_start_date IN pa_budget_lines.start_date%TYPE

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
73: ,x_return_status OUT NOCOPY VARCHAR2
74: ,x_msg_count OUT NOCOPY NUMBER

Line 71: ,p_line_end_date IN pa_budget_lines.end_date%TYPE

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
73: ,x_return_status OUT NOCOPY VARCHAR2
74: ,x_msg_count OUT NOCOPY NUMBER
75: ,x_msg_data OUT NOCOPY VARCHAR2

Line 86: ,p_quantity IN pa_budget_lines.quantity%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
90: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE

Line 87: ,p_item_date IN pa_budget_lines.start_date%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
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

Line 122: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE

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
126: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE

Line 123: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE

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
126: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
127: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE

Line 389: * tbl corresponds to a record in pa_budget_lines.p_calling_context can be GLB_TBL (Global Temp Table)

385: * with non-zero actual quantity for planning resource and txn currency combination
386: *
387: * Bug 4290043.Included parameters so as to pass the amounts/actuals as pl-sql tbls input.
388: * The pl-sql tbls are assumed to be ordered by resource assignment id and each record in the pl-sql
389: * tbl corresponds to a record in pa_budget_lines.p_calling_context can be GLB_TBL (Global Temp Table)
390: * or PLS_TBL(Pl-Sql tbl)
391: */
392:
393: /* ERs: MRC Enhancements:This API builds plsql table of records required for MRC conversions