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.

APPS.PA_BUDGET_PUB dependencies on PA_BUDGET_TYPES

Line 182: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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);
186: l_attribute_category VARCHAR2(30);

Line 592: FROM pa_budget_types

588: p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
589:
590: SELECT budget_amount_code
591: INTO l_budget_amount_code
592: FROM pa_budget_types
593: WHERE budget_type_code = p_budget_type_code;
594:
595: SELECT time_phased_type_code
596: ,categorization_code

Line 3307: FROM pa_budget_types

3303: CURSOR l_budget_types_csr
3304: (p_budget_type_code VARCHAR2 )
3305: IS
3306: SELECT 1
3307: FROM pa_budget_types
3308: WHERE budget_type_code = p_budget_type_code;
3309:
3310: -- Changed the cursor so that it can be used in both old budget model
3311: -- and finplan model

Line 5178: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;

5174: l_err_stage VARCHAR2(120);
5175: l_err_stack VARCHAR2(630);
5176:
5177: l_project_id NUMBER := p_pa_project_id;
5178: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
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;

Line 5185: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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;
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;

Line 6164: FROM pa_budget_types

6160: CURSOR l_budget_type_csr
6161: ( p_budget_type_code VARCHAR2 )
6162: IS
6163: SELECT 1
6164: FROM pa_budget_types
6165: WHERE budget_type_code = p_budget_type_code;
6166:
6167: --Bug 4224464: Following cursor has been added as part of
6168: --FP M Changes for delete_draft_budget

Line 7193: FROM pa_budget_types

7189: CURSOR l_budget_type_csr
7190: ( p_budget_type_code VARCHAR2 )
7191: IS
7192: SELECT 1
7193: FROM pa_budget_types
7194: WHERE budget_type_code = p_budget_type_code;
7195:
7196: --This cursor is used to check if a fin_plan_type_id is
7197: --used to store workplan data

Line 8204: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;

8200: l_err_stage VARCHAR2(120);
8201: l_err_stack VARCHAR2(630);
8202:
8203: l_project_id NUMBER := p_pa_project_id;
8204: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
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;

Line 8211: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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;
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;

Line 9219: FROM pa_budget_types

9215: CURSOR l_budget_type_csr
9216: (p_budget_type_code VARCHAR2 )
9217: IS
9218: SELECT budget_amount_code
9219: FROM pa_budget_types
9220: WHERE budget_type_code = p_budget_type_code;
9221:
9222: --needed to check whether budget line already exists
9223:

Line 9572: l_budget_type_code pa_budget_types.budget_type_code%TYPE;

9568: l_using_resource_lists_flag VARCHAR2(1);
9569: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9570: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
9571: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9572: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
9573: l_amg_project_number pa_projects_all.segment1%TYPE;
9574: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
9575: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
9576: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;

Line 13257: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;

13253: l_err_stage VARCHAR2(120);
13254: l_err_stack VARCHAR2(630);
13255:
13256: l_project_id NUMBER := p_pa_project_id;
13257: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
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;

Line 13264: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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;
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;

Line 14337: FROM pa_budget_types

14333: CURSOR l_budget_type_csr
14334: (p_budget_type_code VARCHAR2 )
14335: IS
14336: SELECT 'X'
14337: FROM pa_budget_types
14338: WHERE budget_type_code = p_budget_type_code;
14339:
14340: CURSOR l_task_csr (p_task_id IN NUMBER ) IS
14341: SELECT pm_task_reference,

Line 17589: l_budget_amount_code pa_budget_types.budget_amount_code%type;

17585: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
17586: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17587:
17588: --Added for bug 4224464
17589: l_budget_amount_code pa_budget_types.budget_amount_code%type;
17590:
17591: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
17592:
17593: --Bug 5475184. In the below set, pt stands for "plan type".

Line 19401: l_budget_type_code pa_budget_types.budget_type_code%TYPE;

19397: l_module_name VARCHAR2(100) :='update_plannning_element_attr';
19398: l_api_name CONSTANT VARCHAR2(100) := 'update_plannning_element_attr';
19399:
19400: l_project_id NUMBER;
19401: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
19402: l_fin_plan_type_id NUMBER;
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;

Line 19409: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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;
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;