DBA Data[Home] [Help]

APPS.PA_BUDGET_CORE1 dependencies on PA_BUDGET_ENTRY_METHODS

Line 74: x_cost_quantity_flag pa_budget_entry_methods.cost_quantity_flag%TYPE;

70: x_rowid rowid;
71: old_stack varchar2(630);
72: x_budget_amount_code PA_BUDGET_TYPES.BUDGET_AMOUNT_CODE%TYPE;
73: /* Bug 2107130 Following 5 variables are added */
74: x_cost_quantity_flag pa_budget_entry_methods.cost_quantity_flag%TYPE;
75: x_raw_cost_flag pa_budget_entry_methods.raw_cost_flag%TYPE;
76: x_burdened_cost_flag pa_budget_entry_methods.burdened_cost_flag%TYPE;
77: x_rev_quantity_flag pa_budget_entry_methods.rev_quantity_flag%TYPE;
78: x_revenue_flag pa_budget_entry_methods.revenue_flag%TYPE;

Line 75: x_raw_cost_flag pa_budget_entry_methods.raw_cost_flag%TYPE;

71: old_stack varchar2(630);
72: x_budget_amount_code PA_BUDGET_TYPES.BUDGET_AMOUNT_CODE%TYPE;
73: /* Bug 2107130 Following 5 variables are added */
74: x_cost_quantity_flag pa_budget_entry_methods.cost_quantity_flag%TYPE;
75: x_raw_cost_flag pa_budget_entry_methods.raw_cost_flag%TYPE;
76: x_burdened_cost_flag pa_budget_entry_methods.burdened_cost_flag%TYPE;
77: x_rev_quantity_flag pa_budget_entry_methods.rev_quantity_flag%TYPE;
78: x_revenue_flag pa_budget_entry_methods.revenue_flag%TYPE;
79:

Line 76: x_burdened_cost_flag pa_budget_entry_methods.burdened_cost_flag%TYPE;

72: x_budget_amount_code PA_BUDGET_TYPES.BUDGET_AMOUNT_CODE%TYPE;
73: /* Bug 2107130 Following 5 variables are added */
74: x_cost_quantity_flag pa_budget_entry_methods.cost_quantity_flag%TYPE;
75: x_raw_cost_flag pa_budget_entry_methods.raw_cost_flag%TYPE;
76: x_burdened_cost_flag pa_budget_entry_methods.burdened_cost_flag%TYPE;
77: x_rev_quantity_flag pa_budget_entry_methods.rev_quantity_flag%TYPE;
78: x_revenue_flag pa_budget_entry_methods.revenue_flag%TYPE;
79:
80: -- record definition

Line 77: x_rev_quantity_flag pa_budget_entry_methods.rev_quantity_flag%TYPE;

73: /* Bug 2107130 Following 5 variables are added */
74: x_cost_quantity_flag pa_budget_entry_methods.cost_quantity_flag%TYPE;
75: x_raw_cost_flag pa_budget_entry_methods.raw_cost_flag%TYPE;
76: x_burdened_cost_flag pa_budget_entry_methods.burdened_cost_flag%TYPE;
77: x_rev_quantity_flag pa_budget_entry_methods.rev_quantity_flag%TYPE;
78: x_revenue_flag pa_budget_entry_methods.revenue_flag%TYPE;
79:
80: -- record definition
81: type period_type is

Line 78: x_revenue_flag pa_budget_entry_methods.revenue_flag%TYPE;

74: x_cost_quantity_flag pa_budget_entry_methods.cost_quantity_flag%TYPE;
75: x_raw_cost_flag pa_budget_entry_methods.raw_cost_flag%TYPE;
76: x_burdened_cost_flag pa_budget_entry_methods.burdened_cost_flag%TYPE;
77: x_rev_quantity_flag pa_budget_entry_methods.rev_quantity_flag%TYPE;
78: x_revenue_flag pa_budget_entry_methods.revenue_flag%TYPE;
79:
80: -- record definition
81: type period_type is
82: record (period_name varchar2(30),

Line 177: from pa_budget_entry_methods

173: into x_entry_level_code, x_categorization_code,
174: x_time_phased_type_code, x_cost_quantity_flag,
175: x_raw_cost_flag, x_burdened_cost_flag,
176: x_rev_quantity_flag, x_revenue_flag
177: from pa_budget_entry_methods
178: where budget_entry_method_code = x_budget_entry_method_code;
179:
180: if ( (x_time_phased_type_code = 'N')
181: or (x_time_phased_type_code = 'R')) then

Line 4223: pa_budget_entry_methods pbem

4219: select pbv.resource_list_id,
4220: pbem.time_phased_type_code,
4221: pbv.budget_version_id
4222: from pa_budget_versions pbv,
4223: pa_budget_entry_methods pbem
4224: where pbem.budget_entry_method_code = pbv.budget_entry_method_code
4225: and pbv.project_id = x_project_id
4226: and pbv.budget_type_code = x_budget_type_code
4227: and pbv.budget_status_code = 'W';

Line 4237: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;

4233: where b.budget_version_id = x_version_id
4234: and b.budget_type_code = t.budget_type_code;
4235:
4236: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%type;
4237: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
4238: l_start_period_name pa_periods_all.period_name%type;
4239: l_start_period_date pa_periods_all.start_date%type;
4240: l_budget_version_id pa_budget_versions.budget_version_id%type;
4241: l_budget_amount_code pa_budget_types.budget_amount_code%type;

Line 4342: l_budget_entry_method_code pa_budget_entry_methods.time_phased_type_code%type;

4338: x_err_code number;
4339: x_err_stack varchar2(2000);
4340: x_err_stage varchar2(2000);
4341: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%type;
4342: l_budget_entry_method_code pa_budget_entry_methods.time_phased_type_code%type;
4343: l_budget_version_id pa_budget_versions.budget_version_id%type;
4344:
4345:
4346: l_start_period_date pa_periods_all.start_date%type;