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_FIN_PLAN_TYPES_B

Line 109: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

105: ,p_budget_lines_in IN budget_line_in_tbl_type
106: ,p_budget_lines_out OUT NOCOPY budget_line_out_tbl_type
107:
108: /*Parameters due fin plan model */
109: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
110: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
111: ,p_version_type IN pa_budget_versions.version_type%TYPE
112: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
113: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

Line 208: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;

204: l_budget_version_name VARCHAR2(60);
205: l_budget_rlmid NUMBER;
206: l_budget_alias VARCHAR2(80); --bug 3711693
207:
208: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
209: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
210: l_version_type pa_budget_versions.version_type%TYPE ;
211: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
212: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;

Line 2883: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

2879: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2880: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2881:
2882: --Added the following parameters for changes in AMG due to finplan model
2883: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
2884: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
2885: ,p_version_type IN pa_budget_versions.version_type%TYPE
2886: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2887: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

Line 3297: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

3293: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3294: ,p_mark_as_original IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3295:
3296: --Parameters due to Fin Plan Model
3297: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3298: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3299: ,p_version_type IN pa_budget_versions.version_type%TYPE)
3300:
3301: IS

Line 3467: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

3463: l_encum_type_id NUMBER := NULL;
3464: l_balance_type VARCHAR2(1) := NULL;
3465:
3466: -- --------------------------------------------------------
3467: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3468: l_debug_mode VARCHAR2(1);
3469: l_debug_level2 CONSTANT NUMBER := 2;
3470: l_debug_level3 CONSTANT NUMBER := 3;
3471: l_debug_level4 CONSTANT NUMBER := 4;

Line 3487: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

3483: l_msg_index_out NUMBER;
3484: l_dummy VARCHAR2(1);
3485: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3486: l_result VARCHAR2(1);
3487: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3488: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3489: l_fc_version_created_flag VARCHAR2(1);
3490: l_final_plan_prc_code VARCHAR2(10);
3491: l_targ_request_id pa_budget_versions.request_id%TYPE;

Line 6141: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

6137: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6138:
6139: -- Parameters required for Fin Plan Model
6140: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
6141: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
6142: ,p_version_number IN pa_budget_versions.version_number%TYPE
6143: ,p_version_type IN pa_budget_versions.version_type%TYPE
6144: )
6145:

Line 6172: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)

6168: --FP M Changes for delete_draft_budget
6169: --This cursor is used to check if a fin_plan_type_id is
6170: --used to store workplan data
6171: CURSOR l_use_for_wp_csr
6172: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
6173: IS
6174: SELECT 1
6175: FROM pa_fin_plan_types_b
6176: WHERE fin_plan_type_id = p_fin_plan_type_id

Line 6175: FROM pa_fin_plan_types_b

6171: CURSOR l_use_for_wp_csr
6172: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
6173: IS
6174: SELECT 1
6175: FROM pa_fin_plan_types_b
6176: WHERE fin_plan_type_id = p_fin_plan_type_id
6177: AND use_for_workplan_flag = 'Y';
6178:
6179:

Line 7139: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7135: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7136: ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7137: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7138: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7139: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7140: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7141: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7142: ,p_version_number IN pa_budget_versions.version_number%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7143: )

Line 7199: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)

7195:
7196: --This cursor is used to check if a fin_plan_type_id is
7197: --used to store workplan data
7198: CURSOR l_use_for_wp_csr
7199: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
7200: IS
7201: SELECT 1
7202: FROM pa_fin_plan_types_b
7203: WHERE fin_plan_type_id = p_fin_plan_type_id

Line 7202: FROM pa_fin_plan_types_b

7198: CURSOR l_use_for_wp_csr
7199: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
7200: IS
7201: SELECT 1
7202: FROM pa_fin_plan_types_b
7203: WHERE fin_plan_type_id = p_fin_plan_type_id
7204: AND use_for_workplan_flag = 'Y';
7205:
7206: --needed to get the field values associated to a AMG message

Line 8146: ( c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE

8142: FOR UPDATE NOWAIT;
8143:
8144: --This cursor is used to get the approved rev plan type flag of the plan type
8145: CURSOR l_approved_revenue_flag_csr
8146: ( c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE
8147: ,c_project_id pa_projects_all.project_id%TYPE)
8148: IS
8149: SELECT approved_rev_plan_type_flag
8150: FROM pa_proj_fp_options

Line 8184: pa_fin_plan_types_b pt

8180: IS
8181: SELECT pt.plan_class_code
8182: ,bv.etc_start_date
8183: FROM pa_budget_versions bv,
8184: pa_fin_plan_types_b pt
8185: WHERE bv.budget_version_id = c_budget_version_id
8186: AND pt.fin_plan_type_id = bv.fin_plan_type_id;
8187:
8188: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

Line 8188: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

8184: pa_fin_plan_types_b pt
8185: WHERE bv.budget_version_id = c_budget_version_id
8186: AND pt.fin_plan_type_id = bv.fin_plan_type_id;
8187:
8188: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
8189: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
8190:
8191: i NUMBER := 0;
8192: l_dummy NUMBER;

Line 9522: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;

9518:
9519: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;
9520: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9521: lx_version_type pa_budget_versions.version_type%TYPE := null;
9522: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9523: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9524: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9525: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9526: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;

Line 14327: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

14323: ,p_update_db_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14324: ,p_calc_budget_lines_out OUT NOCOPY calc_budget_line_out_tbl_type
14325: -- Bug 2863564 Parameters added for new Fin Plan Model
14326: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
14327: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
14328: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
14329: ,p_version_type IN pa_budget_versions.version_type%TYPE
14330: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
14331: ) IS

Line 14478: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

14474: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14475: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14476: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14477:
14478: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14479: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
14480: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14481:
14482: l_version_type pa_budget_versions.version_type%TYPE;

Line 14479: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

14475: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14476: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14477:
14478: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14479: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
14480: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14481:
14482: l_version_type pa_budget_versions.version_type%TYPE;
14483: l_record_version_number pa_budget_versions.record_version_number%TYPE;

Line 14496: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

14492: l_security_ret_code VARCHAR2(30);
14493: l_result VARCHAR2(30);
14494:
14495:
14496: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14497: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14498: ll_version_type pa_budget_versions.version_type%TYPE;
14499: ll_version_number pa_budget_versions.version_number%TYPE;
14500: --needed to get the field values associated to a AMG message

Line 16977: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

16973: ,p_calc_revenue_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16974: ,p_update_db_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16975: -- Bug 2863564 Parameters required for new Fin Plan Model
16976: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
16977: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
16978: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
16979: ,p_version_type IN pa_budget_versions.version_type%TYPE
16980: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
16981: ) IS

Line 17466: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;

17462: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17463: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17464: l_change_reason_code pa_budget_versions.change_reason_code%type;
17465: l_budget_version_name pa_budget_versions.version_name%type;
17466: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17467: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
17468: l_version_type pa_budget_versions.version_type%TYPE ;
17469: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
17470: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;

Line 18683: From pa_fin_plan_types_b

18679: Select decode(plan_class_code,
18680: 'BUDGET',PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET,
18681: 'FORECAST',PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FORECAST)
18682: Into l_plan_tran_context
18683: From pa_fin_plan_types_b
18684: Where fin_plan_type_id = l_fin_plan_type_id;
18685:
18686: /* Calling Add Planning Transaction API */
18687:

Line 19386: FROM pa_fin_plan_types_b

19382: IS
19383:
19384: CURSOR c_get_plan_class_code(c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE) is
19385: SELECT plan_class_code
19386: FROM pa_fin_plan_types_b
19387: WHERE fin_plan_type_id=c_fin_plan_type_id;
19388:
19389: l_msg_count NUMBER := 0;
19390: l_data VARCHAR2(2000);