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 335: from pa_budget_entry_methods

331: into x_entry_level_code, x_categorization_code,
332: x_time_phased_type_code, x_cost_quantity_flag,
333: x_raw_cost_flag, x_burdened_cost_flag,
334: x_rev_quantity_flag, x_revenue_flag
335: from pa_budget_entry_methods
336: where budget_entry_method_code = x_budget_entry_method_code;
337:
338: if ( (x_time_phased_type_code = 'N')
339: or (x_time_phased_type_code = 'R')) then

Line 4641: pa_budget_entry_methods pbem

4637: select pbv.resource_list_id,
4638: pbem.time_phased_type_code,
4639: pbv.budget_version_id
4640: from pa_budget_versions pbv,
4641: pa_budget_entry_methods pbem
4642: where pbem.budget_entry_method_code = pbv.budget_entry_method_code
4643: and pbv.project_id = x_project_id
4644: and pbv.budget_type_code = x_budget_type_code
4645: and pbv.budget_status_code = 'W';

Line 4655: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;

4651: where b.budget_version_id = x_version_id
4652: and b.budget_type_code = t.budget_type_code;
4653:
4654: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%type;
4655: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
4656: l_start_period_name pa_periods_all.period_name%type;
4657: l_start_period_date pa_periods_all.start_date%type;
4658: l_budget_version_id pa_budget_versions.budget_version_id%type;
4659: l_budget_amount_code pa_budget_types.budget_amount_code%type;

Line 4761: l_budget_entry_method_code pa_budget_entry_methods.time_phased_type_code%type;

4757: x_err_code number;
4758: x_err_stack varchar2(2000);
4759: x_err_stage varchar2(2000);
4760: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%type;
4761: l_budget_entry_method_code pa_budget_entry_methods.time_phased_type_code%type;
4762: l_budget_version_id pa_budget_versions.budget_version_id%type;
4763:
4764:
4765: l_start_period_date pa_periods_all.start_date%type;

Line 4767: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE; -- Bug 8682811

4763:
4764:
4765: l_start_period_date pa_periods_all.start_date%type;
4766: l_end_period_date pa_periods_all.end_date%type;
4767: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE; -- Bug 8682811
4768:
4769: l_request_id number;
4770:
4771: exc_wrong_period_set exception;

Line 4805: from pa_budget_entry_methods

4801: else
4802:
4803: select time_phased_type_code
4804: into l_time_phased_type_code
4805: from pa_budget_entry_methods
4806: where budget_entry_method_code = l_budget_entry_method_code;
4807:
4808: If l_time_phased_type_code not in ('P','G') then
4809: fnd_file.put_line(1, 'Please choose a Budget Entry Method that has periodic time phasing.');