eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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 601: FROM pa_budget_entry_methods

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

Line 5183: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;

5179: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
5180: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
5181: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
5182: l_budget_version_id NUMBER;
5183: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
5184: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5185: l_budget_amount_code pa_budget_types.budget_amount_code%type;
5186: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5187: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 5189: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;

5185: l_budget_amount_code pa_budget_types.budget_amount_code%type;
5186: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
5187: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
5188: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
5189: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
5190: l_record_version_number pa_budget_versions.record_version_number%TYPE;
5191:
5192: l_resource_name VARCHAR2(80); --bug 3711693
5193:

Line 8209: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;

8205: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
8206: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
8207: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
8208: l_budget_version_id NUMBER;
8209: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
8210: l_resource_list_id NUMBER;
8211: l_budget_amount_code pa_budget_types.budget_amount_code%type;
8212: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
8213: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 8215: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;

8211: l_budget_amount_code pa_budget_types.budget_amount_code%type;
8212: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
8213: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
8214: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8215: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
8216: l_record_version_number NUMBER;
8217: l_task_id NUMBER;
8218: l_resource_list_member_id NUMBER;
8219: l_currency_code VARCHAR2(15);

Line 9257: FROM pa_budget_entry_methods

9253: IS
9254: SELECT time_phased_type_code
9255: , entry_level_code
9256: , categorization_code
9257: FROM pa_budget_entry_methods
9258: WHERE budget_entry_method_code = p_budget_entry_method_code;
9259:
9260: --needed to get the resource assignment for this budget_version / task / member combination
9261:

Line 13262: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;

13258: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
13259: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
13260: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
13261: l_budget_version_id NUMBER;
13262: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
13263: l_resource_list_id NUMBER;
13264: l_budget_amount_code pa_budget_types.budget_amount_code%type;
13265: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
13266: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 13268: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;

13264: l_budget_amount_code pa_budget_types.budget_amount_code%type;
13265: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
13266: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13267: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
13268: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
13269: l_record_version_number pa_budget_versions.record_version_number%TYPE;
13270:
13271: l_budget_lines_in budget_line_in_tbl_type;
13272: l_budget_lines_out_tbl budget_line_out_tbl_type;

Line 14433: ,pa_budget_entry_methods m

14429: CURSOR l_get_entry_level_csr (c_budget_version_id IN NUMBER)
14430: IS
14431: SELECT m.entry_level_code
14432: FROM pa_budget_versions v
14433: ,pa_budget_entry_methods m
14434: WHERE v.budget_version_id = c_budget_version_id
14435: AND v.budget_entry_method_code = m.budget_entry_method_code
14436: AND v.ci_id IS NULL; -- -- Added an extra clause v.ci_id IS NULL--Bug # 3507156
14437:

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

14458: l_function_allowed VARCHAR2(1);
14459: l_resp_id NUMBER := 0;
14460: l_user_id NUMBER := 0;
14461: l_module_name VARCHAR2(80);
14462: l_entry_level pa_budget_entry_methods.entry_level_code%type; /* 2207723 */
14463:
14464: p_multiple_task_msg VARCHAR2(1) := 'T';
14465:
14466: l_budget_line_id pa_budget_lines.budget_line_id%TYPE; /* FPB2 */

Line 19407: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;

19403: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
19404: l_fin_plan_class_code varchar2(30);
19405: l_version_type pa_budget_versions.version_type%TYPE;
19406: l_budget_version_id NUMBER;
19407: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
19408: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
19409: l_budget_amount_code pa_budget_types.budget_amount_code%type;
19410: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19411: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 19413: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;

19409: l_budget_amount_code pa_budget_types.budget_amount_code%type;
19410: l_entry_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
19411: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
19412: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
19413: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
19414: l_project_number pa_projects_all.segment1%type;
19415:
19416: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type;
19417: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type;