DBA Data[Home] [Help]

APPS.PA_BUDGET_PUB dependencies on PA_BUDGET_ENTRY_METHODS

Line 181: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;

177: l_err_stage VARCHAR2(120);
178: l_err_stack VARCHAR2(630);
179: i NUMBER;
180: l_budget_line_in_rec pa_budget_pub.budget_line_in_rec_type;
181: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;
182: l_budget_amount_code pa_budget_types.budget_amount_code%type;
183: l_description VARCHAR2(255);
184: l_resource_name pa_resource_lists_tl.Name%type;
185: l_dummy VARCHAR2(1);

Line 247: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;

243: l_allow_qty_flag VARCHAR2(1);
244: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
245: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
246: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
247: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
248: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
249: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
250: l_amg_segment1 pa_projects_all.segment1%TYPE;
251: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;

Line 248: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;

244: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
245: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
246: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
247: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
248: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
249: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
250: l_amg_segment1 pa_projects_all.segment1%TYPE;
251: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
252: l_unit_of_measure pa_resources.unit_of_measure%TYPE;

Line 249: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;

245: l_uncategorized_rlmid pa_resource_list_members.resource_list_member_id%TYPE;
246: l_uncategorized_resid pa_resource_list_members.resource_id%TYPE;
247: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
248: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
249: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
250: l_amg_segment1 pa_projects_all.segment1%TYPE;
251: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
252: l_unit_of_measure pa_resources.unit_of_measure%TYPE;
253: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

Line 599: FROM pa_budget_entry_methods

595: ,entry_level_code
596: INTO l_time_phased_type_code
597: ,l_categorization_code
598: ,l_entry_level_code
599: FROM pa_budget_entry_methods
600: WHERE budget_entry_method_code = p_entry_method_code
601: AND trunc(sysdate) BETWEEN trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));
602:
603: END IF;

Line 5073: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;

5069: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
5070: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
5071: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
5072: l_budget_version_id NUMBER;
5073: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
5074: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5075: l_budget_amount_code pa_budget_types.budget_amount_code%type;
5076: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5077: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 5079: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;

5075: l_budget_amount_code pa_budget_types.budget_amount_code%type;
5076: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5077: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
5078: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
5079: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
5080: l_record_version_number pa_budget_versions.record_version_number%TYPE;
5081:
5082: l_resource_name VARCHAR2(80); --bug 3711693
5083:

Line 8049: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;

8045: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
8046: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
8047: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
8048: l_budget_version_id NUMBER;
8049: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
8050: l_resource_list_id NUMBER;
8051: l_budget_amount_code pa_budget_types.budget_amount_code%type;
8052: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
8053: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 8055: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;

8051: l_budget_amount_code pa_budget_types.budget_amount_code%type;
8052: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
8053: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
8054: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8055: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
8056: l_record_version_number NUMBER;
8057: l_task_id NUMBER;
8058: l_resource_list_member_id NUMBER;
8059: l_currency_code VARCHAR2(15);

Line 9078: FROM pa_budget_entry_methods

9074: IS
9075: SELECT time_phased_type_code
9076: , entry_level_code
9077: , categorization_code
9078: FROM pa_budget_entry_methods
9079: WHERE budget_entry_method_code = p_budget_entry_method_code;
9080:
9081: --needed to get the resource assignment for this budget_version / task / member combination
9082:

Line 13039: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;

13035: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
13036: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
13037: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
13038: l_budget_version_id NUMBER;
13039: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
13040: l_resource_list_id NUMBER;
13041: l_budget_amount_code pa_budget_types.budget_amount_code%type;
13042: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
13043: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 13045: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;

13041: l_budget_amount_code pa_budget_types.budget_amount_code%type;
13042: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
13043: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13044: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
13045: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
13046: l_record_version_number pa_budget_versions.record_version_number%TYPE;
13047:
13048: l_budget_lines_in budget_line_in_tbl_type;
13049: l_budget_lines_out_tbl budget_line_out_tbl_type;

Line 14187: ,pa_budget_entry_methods m

14183: CURSOR l_get_entry_level_csr (c_budget_version_id IN NUMBER)
14184: IS
14185: SELECT m.entry_level_code
14186: FROM pa_budget_versions v
14187: ,pa_budget_entry_methods m
14188: WHERE v.budget_version_id = c_budget_version_id
14189: AND v.budget_entry_method_code = m.budget_entry_method_code
14190: AND v.ci_id IS NULL; -- -- Added an extra clause v.ci_id IS NULL--Bug # 3507156
14191:

Line 14216: l_entry_level pa_budget_entry_methods.entry_level_code%type; /* 2207723 */

14212: l_function_allowed VARCHAR2(1);
14213: l_resp_id NUMBER := 0;
14214: l_user_id NUMBER := 0;
14215: l_module_name VARCHAR2(80);
14216: l_entry_level pa_budget_entry_methods.entry_level_code%type; /* 2207723 */
14217:
14218: p_multiple_task_msg VARCHAR2(1) := 'T';
14219:
14220: l_budget_line_id pa_budget_lines.budget_line_id%TYPE; /* FPB2 */

Line 19113: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;

19109: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
19110: l_fin_plan_class_code varchar2(30);
19111: l_version_type pa_budget_versions.version_type%TYPE;
19112: l_budget_version_id NUMBER;
19113: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
19114: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
19115: l_budget_amount_code pa_budget_types.budget_amount_code%type;
19116: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19117: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 19119: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;

19115: l_budget_amount_code pa_budget_types.budget_amount_code%type;
19116: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19117: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
19118: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
19119: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
19120: l_project_number pa_projects_all.segment1%type;
19121:
19122: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type;
19123: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type;