DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_BUDGET_LINES

Line 144: g_bl_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;

140: g_baselined_planned_qty pa_resource_assignments.total_plan_quantity%TYPE;
141: g_bl_planned_bur_cost_txn_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
142: g_bl_bur_cost_proj_cur pa_resource_assignments.total_project_burdened_cost%TYPE;
143: g_bl_bur_cost_projfunc_cur pa_resource_assignments.total_plan_burdened_cost%TYPE;
144: g_bl_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
145: g_bl_raw_cost_proj_cur pa_resource_assignments.total_project_raw_cost%TYPE;
146: g_bl_raw_cost_projfunc_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
147:
148: g_pl_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;

Line 150: g_planned_quantity pa_budget_lines.quantity%TYPE;

146: g_bl_raw_cost_projfunc_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
147:
148: g_pl_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
149:
150: g_planned_quantity pa_budget_lines.quantity%TYPE;
151: g_planned_bur_cost_txn_cur pa_budget_lines.txn_burdened_cost%TYPE;
152: g_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
153: g_actual_quantity pa_budget_lines.init_quantity%TYPE;
154: g_act_bur_cost_txn_cur pa_budget_lines.init_burdened_cost%TYPE;

Line 151: g_planned_bur_cost_txn_cur pa_budget_lines.txn_burdened_cost%TYPE;

147:
148: g_pl_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
149:
150: g_planned_quantity pa_budget_lines.quantity%TYPE;
151: g_planned_bur_cost_txn_cur pa_budget_lines.txn_burdened_cost%TYPE;
152: g_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
153: g_actual_quantity pa_budget_lines.init_quantity%TYPE;
154: g_act_bur_cost_txn_cur pa_budget_lines.init_burdened_cost%TYPE;
155: g_act_raw_cost_txn_cur pa_budget_lines.init_raw_cost%TYPE;

Line 152: g_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;

148: g_pl_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
149:
150: g_planned_quantity pa_budget_lines.quantity%TYPE;
151: g_planned_bur_cost_txn_cur pa_budget_lines.txn_burdened_cost%TYPE;
152: g_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
153: g_actual_quantity pa_budget_lines.init_quantity%TYPE;
154: g_act_bur_cost_txn_cur pa_budget_lines.init_burdened_cost%TYPE;
155: g_act_raw_cost_txn_cur pa_budget_lines.init_raw_cost%TYPE;
156: g_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 153: g_actual_quantity pa_budget_lines.init_quantity%TYPE;

149:
150: g_planned_quantity pa_budget_lines.quantity%TYPE;
151: g_planned_bur_cost_txn_cur pa_budget_lines.txn_burdened_cost%TYPE;
152: g_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
153: g_actual_quantity pa_budget_lines.init_quantity%TYPE;
154: g_act_bur_cost_txn_cur pa_budget_lines.init_burdened_cost%TYPE;
155: g_act_raw_cost_txn_cur pa_budget_lines.init_raw_cost%TYPE;
156: g_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
157: g_avg_bur_cost_rate pa_budget_lines.burden_cost_rate%TYPE;

Line 154: g_act_bur_cost_txn_cur pa_budget_lines.init_burdened_cost%TYPE;

150: g_planned_quantity pa_budget_lines.quantity%TYPE;
151: g_planned_bur_cost_txn_cur pa_budget_lines.txn_burdened_cost%TYPE;
152: g_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
153: g_actual_quantity pa_budget_lines.init_quantity%TYPE;
154: g_act_bur_cost_txn_cur pa_budget_lines.init_burdened_cost%TYPE;
155: g_act_raw_cost_txn_cur pa_budget_lines.init_raw_cost%TYPE;
156: g_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
157: g_avg_bur_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
158:

Line 155: g_act_raw_cost_txn_cur pa_budget_lines.init_raw_cost%TYPE;

151: g_planned_bur_cost_txn_cur pa_budget_lines.txn_burdened_cost%TYPE;
152: g_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
153: g_actual_quantity pa_budget_lines.init_quantity%TYPE;
154: g_act_bur_cost_txn_cur pa_budget_lines.init_burdened_cost%TYPE;
155: g_act_raw_cost_txn_cur pa_budget_lines.init_raw_cost%TYPE;
156: g_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
157: g_avg_bur_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
158:
159: g_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;

Line 156: g_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

152: g_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
153: g_actual_quantity pa_budget_lines.init_quantity%TYPE;
154: g_act_bur_cost_txn_cur pa_budget_lines.init_burdened_cost%TYPE;
155: g_act_raw_cost_txn_cur pa_budget_lines.init_raw_cost%TYPE;
156: g_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
157: g_avg_bur_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
158:
159: g_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
160:

Line 157: g_avg_bur_cost_rate pa_budget_lines.burden_cost_rate%TYPE;

153: g_actual_quantity pa_budget_lines.init_quantity%TYPE;
154: g_act_bur_cost_txn_cur pa_budget_lines.init_burdened_cost%TYPE;
155: g_act_raw_cost_txn_cur pa_budget_lines.init_raw_cost%TYPE;
156: g_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
157: g_avg_bur_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
158:
159: g_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
160:
161: g_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

Line 161: g_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

157: g_avg_bur_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
158:
159: g_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
160:
161: g_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
162:
163: g_ta_display_flag VARCHAR2(1) := 'N';
164: g_apply_progress_flag VARCHAR2(1) := 'N'; -- Bug 4286558
165:

Line 340: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

336: FUNCTION get_baselined_asgmt_dates(
337: p_project_id IN pa_projects_all.project_id%TYPE,
338: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
339: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
340: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
341: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
342: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
343: p_code IN VARCHAR2) RETURN DATE;
344:

Line 349: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

345: FUNCTION get_baselined_asgmt_amounts(
346: p_project_id IN pa_projects_all.project_id%TYPE,
347: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
348: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
349: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
350: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
351: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
352: p_code IN VARCHAR2) RETURN NUMBER;
353: