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 2819: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

2815: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2816: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2817:
2818: --Added the following parameters for changes in AMG due to finplan model
2819: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
2820: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
2821: ,p_version_type IN pa_budget_versions.version_type%TYPE
2822: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2823: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

Line 3233: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

3229: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3230: ,p_mark_as_original IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3231:
3232: --Parameters due to Fin Plan Model
3233: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3234: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3235: ,p_version_type IN pa_budget_versions.version_type%TYPE)
3236:
3237: IS

Line 3395: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

3391: l_encum_type_id NUMBER := NULL;
3392: l_balance_type VARCHAR2(1) := NULL;
3393:
3394: -- --------------------------------------------------------
3395: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3396: l_debug_mode VARCHAR2(1);
3397: l_debug_level2 CONSTANT NUMBER := 2;
3398: l_debug_level3 CONSTANT NUMBER := 3;
3399: l_debug_level4 CONSTANT NUMBER := 4;

Line 3415: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

3411: l_msg_index_out NUMBER;
3412: l_dummy VARCHAR2(1);
3413: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3414: l_result VARCHAR2(1);
3415: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3416: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3417: l_fc_version_created_flag VARCHAR2(1);
3418: l_final_plan_prc_code VARCHAR2(10);
3419: l_targ_request_id pa_budget_versions.request_id%TYPE;

Line 5989: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

5985: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5986:
5987: -- Parameters required for Fin Plan Model
5988: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE
5989: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
5990: ,p_version_number IN pa_budget_versions.version_number%TYPE
5991: ,p_version_type IN pa_budget_versions.version_type%TYPE
5992: )
5993:

Line 6020: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)

6016: --FP M Changes for delete_draft_budget
6017: --This cursor is used to check if a fin_plan_type_id is
6018: --used to store workplan data
6019: CURSOR l_use_for_wp_csr
6020: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
6021: IS
6022: SELECT 1
6023: FROM pa_fin_plan_types_b
6024: WHERE fin_plan_type_id = p_fin_plan_type_id

Line 6023: FROM pa_fin_plan_types_b

6019: CURSOR l_use_for_wp_csr
6020: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
6021: IS
6022: SELECT 1
6023: FROM pa_fin_plan_types_b
6024: WHERE fin_plan_type_id = p_fin_plan_type_id
6025: AND use_for_workplan_flag = 'Y';
6026:
6027:

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

6983: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6984: ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6985: ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6986: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6987: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6988: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6989: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6990: ,p_version_number IN pa_budget_versions.version_number%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6991: )

Line 7047: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)

7043:
7044: --This cursor is used to check if a fin_plan_type_id is
7045: --used to store workplan data
7046: CURSOR l_use_for_wp_csr
7047: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
7048: IS
7049: SELECT 1
7050: FROM pa_fin_plan_types_b
7051: WHERE fin_plan_type_id = p_fin_plan_type_id

Line 7050: FROM pa_fin_plan_types_b

7046: CURSOR l_use_for_wp_csr
7047: ( p_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE)
7048: IS
7049: SELECT 1
7050: FROM pa_fin_plan_types_b
7051: WHERE fin_plan_type_id = p_fin_plan_type_id
7052: AND use_for_workplan_flag = 'Y';
7053:
7054: --needed to get the field values associated to a AMG message

Line 7986: ( c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE

7982: FOR UPDATE NOWAIT;
7983:
7984: --This cursor is used to get the approved rev plan type flag of the plan type
7985: CURSOR l_approved_revenue_flag_csr
7986: ( c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE
7987: ,c_project_id pa_projects_all.project_id%TYPE)
7988: IS
7989: SELECT approved_rev_plan_type_flag
7990: FROM pa_proj_fp_options

Line 8024: pa_fin_plan_types_b pt

8020: IS
8021: SELECT pt.plan_class_code
8022: ,bv.etc_start_date
8023: FROM pa_budget_versions bv,
8024: pa_fin_plan_types_b pt
8025: WHERE bv.budget_version_id = c_budget_version_id
8026: AND pt.fin_plan_type_id = bv.fin_plan_type_id;
8027:
8028: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

Line 8028: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

8024: pa_fin_plan_types_b pt
8025: WHERE bv.budget_version_id = c_budget_version_id
8026: AND pt.fin_plan_type_id = bv.fin_plan_type_id;
8027:
8028: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
8029: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
8030:
8031: i NUMBER := 0;
8032: l_dummy NUMBER;

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

9335:
9336: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;
9337: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9338: lx_version_type pa_budget_versions.version_type%TYPE := null;
9339: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9340: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9341: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9342: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9343: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;

Line 14081: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

14077: ,p_update_db_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14078: ,p_calc_budget_lines_out OUT NOCOPY calc_budget_line_out_tbl_type
14079: -- Bug 2863564 Parameters added for new Fin Plan Model
14080: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
14081: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
14082: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
14083: ,p_version_type IN pa_budget_versions.version_type%TYPE
14084: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
14085: ) IS

Line 14232: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

14228: l_projfunc_cost_rate_type pa_projects_all.projfunc_cost_rate_type%TYPE;
14229: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14230: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14231:
14232: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14233: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
14234: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14235:
14236: l_version_type pa_budget_versions.version_type%TYPE;

Line 14233: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

14229: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
14230: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14231:
14232: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14233: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
14234: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14235:
14236: l_version_type pa_budget_versions.version_type%TYPE;
14237: l_record_version_number pa_budget_versions.record_version_number%TYPE;

Line 14250: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

14246: l_security_ret_code VARCHAR2(30);
14247: l_result VARCHAR2(30);
14248:
14249:
14250: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14251: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14252: ll_version_type pa_budget_versions.version_type%TYPE;
14253: ll_version_number pa_budget_versions.version_number%TYPE;
14254: --needed to get the field values associated to a AMG message

Line 16728: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

16724: ,p_calc_revenue_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16725: ,p_update_db_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16726: -- Bug 2863564 Parameters required for new Fin Plan Model
16727: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
16728: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
16729: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
16730: ,p_version_type IN pa_budget_versions.version_type%TYPE
16731: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
16732: ) IS

Line 17207: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;

17203: l_attribute15 PA_BUDGET_VERSIONS.attribute2%Type;
17204: l_pm_finplan_reference pa_budget_versions.pm_budget_reference%type;
17205: l_change_reason_code pa_budget_versions.change_reason_code%type;
17206: l_budget_version_name pa_budget_versions.version_name%type;
17207: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE ;
17208: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;
17209: l_version_type pa_budget_versions.version_type%TYPE ;
17210: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE ;
17211: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE ;

Line 18412: From pa_fin_plan_types_b

18408: Select decode(plan_class_code,
18409: 'BUDGET',PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET,
18410: 'FORECAST',PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FORECAST)
18411: Into l_plan_tran_context
18412: From pa_fin_plan_types_b
18413: Where fin_plan_type_id = l_fin_plan_type_id;
18414:
18415: /* Calling Add Planning Transaction API */
18416:

Line 19092: FROM pa_fin_plan_types_b

19088: IS
19089:
19090: CURSOR c_get_plan_class_code(c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE) is
19091: SELECT plan_class_code
19092: FROM pa_fin_plan_types_b
19093: WHERE fin_plan_type_id=c_fin_plan_type_id;
19094:
19095: l_msg_count NUMBER := 0;
19096: l_data VARCHAR2(2000);