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 590: FROM pa_budget_types

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

Line 3243: FROM pa_budget_types

3239: CURSOR l_budget_types_csr
3240: (p_budget_type_code VARCHAR2 )
3241: IS
3242: SELECT 1
3243: FROM pa_budget_types
3244: WHERE budget_type_code = p_budget_type_code;
3245:
3246: -- Changed the cursor so that it can be used in both old budget model
3247: -- and finplan model

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

5064: l_err_stage VARCHAR2(120);
5065: l_err_stack VARCHAR2(630);
5066:
5067: l_project_id NUMBER := p_pa_project_id;
5068: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
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;

Line 5075: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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

Line 6012: FROM pa_budget_types

6008: CURSOR l_budget_type_csr
6009: ( p_budget_type_code VARCHAR2 )
6010: IS
6011: SELECT 1
6012: FROM pa_budget_types
6013: WHERE budget_type_code = p_budget_type_code;
6014:
6015: --Bug 4224464: Following cursor has been added as part of
6016: --FP M Changes for delete_draft_budget

Line 7041: FROM pa_budget_types

7037: CURSOR l_budget_type_csr
7038: ( p_budget_type_code VARCHAR2 )
7039: IS
7040: SELECT 1
7041: FROM pa_budget_types
7042: WHERE budget_type_code = p_budget_type_code;
7043:
7044: --This cursor is used to check if a fin_plan_type_id is
7045: --used to store workplan data

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

8040: l_err_stage VARCHAR2(120);
8041: l_err_stack VARCHAR2(630);
8042:
8043: l_project_id NUMBER := p_pa_project_id;
8044: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
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;

Line 8051: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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

Line 9040: FROM pa_budget_types

9036: CURSOR l_budget_type_csr
9037: (p_budget_type_code VARCHAR2 )
9038: IS
9039: SELECT budget_amount_code
9040: FROM pa_budget_types
9041: WHERE budget_type_code = p_budget_type_code;
9042:
9043: --needed to check whether budget line already exists
9044:

Line 9389: l_budget_type_code pa_budget_types.budget_type_code%TYPE;

9385: l_using_resource_lists_flag VARCHAR2(1);
9386: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9387: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
9388: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
9389: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
9390: l_amg_project_number pa_projects_all.segment1%TYPE;
9391: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
9392: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
9393: l_CW_record_version_number pa_budget_versions.record_Version_number%TYPE;

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

13030: l_err_stage VARCHAR2(120);
13031: l_err_stack VARCHAR2(630);
13032:
13033: l_project_id NUMBER := p_pa_project_id;
13034: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
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;

Line 13041: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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

Line 14091: FROM pa_budget_types

14087: CURSOR l_budget_type_csr
14088: (p_budget_type_code VARCHAR2 )
14089: IS
14090: SELECT 'X'
14091: FROM pa_budget_types
14092: WHERE budget_type_code = p_budget_type_code;
14093:
14094: CURSOR l_task_csr (p_task_id IN NUMBER ) IS
14095: SELECT pm_task_reference,

Line 17329: l_budget_amount_code pa_budget_types.budget_amount_code%type;

17325: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
17326: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
17327:
17328: --Added for bug 4224464
17329: l_budget_amount_code pa_budget_types.budget_amount_code%type;
17330:
17331: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
17332:
17333: --Bug 5475184. In the below set, pt stands for "plan type".

Line 19107: l_budget_type_code pa_budget_types.budget_type_code%TYPE;

19103: l_module_name VARCHAR2(100) :='update_plannning_element_attr';
19104: l_api_name CONSTANT VARCHAR2(100) := 'update_plannning_element_attr';
19105:
19106: l_project_id NUMBER;
19107: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
19108: l_fin_plan_type_id NUMBER;
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;

Line 19115: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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