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_VL

Line 110: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%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
114: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE

Line 209: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE ;

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 ;
213: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 2884: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE

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
2888: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE

Line 3913: FROM pa_fin_plan_types_vl

3909: END IF;
3910:
3911: SELECT name
3912: INTO l_fin_plan_type_name
3913: FROM pa_fin_plan_types_vl
3914: WHERE fin_plan_type_id = l_fin_plan_type_id;
3915:
3916: PA_UTILS.ADD_MESSAGE
3917: (p_app_short_name => 'PA',

Line 6140: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE

6136: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
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: )

Line 6837: FROM pa_fin_plan_types_vl

6833:
6834: --Get the plan type name
6835: SELECT name
6836: INTO l_fin_plan_type_name
6837: FROM pa_fin_plan_types_vl
6838: WHERE fin_plan_type_id = l_fin_plan_type_id;
6839:
6840: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6841: THEN

Line 7140: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%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: )
7144:

Line 7246: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE;

7242: l_project_id NUMBER;
7243: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
7244: l_budget_version_id NUMBER;
7245: l_fin_plan_type_id NUMBER;
7246: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE;
7247: l_version_type pa_budget_versions.version_type%TYPE;
7248: l_version_number NUMBER;
7249: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
7250:

Line 9180: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

9176: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9177: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9178: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9179: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9180: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9181: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9182: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9183: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9184: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 9437: FROM pa_fin_plan_types_vl

9433:
9434: CURSOR l_finplan_type_name_csr(p_finplan_type_id NUMBER)
9435: IS
9436: SELECT name
9437: FROM pa_fin_plan_types_vl
9438: WHERE fin_plan_type_id=p_finplan_type_id;
9439:
9440:
9441:

Line 14543: pa_fin_plan_types_vl pt

14539: ,bv.etc_start_date
14540: ,nvl(bv.wp_version_flag,'N') wp_version_flag
14541: ,bv.plan_processing_code
14542: FROM pa_budget_versions bv,
14543: pa_fin_plan_types_vl pt
14544: WHERE bv.budget_version_id = c_budget_version_id
14545: AND pt.fin_plan_type_id(+) = bv.fin_plan_type_id
14546: AND bv.ci_id IS NULL; -- -- Added an extra clause bv.ci_id IS NULL--Bug # 3507156
14547:

Line 15200: FROM pa_fin_plan_types_vl

15196: , use_for_workplan_flag
15197: INTO l_fin_plan_type_code
15198: ,l_fin_plan_type_name
15199: ,l_workplan_flag
15200: FROM pa_fin_plan_types_vl
15201: WHERE fin_plan_type_id = l_fin_plan_type_id;
15202:
15203: IF l_fin_plan_type_code = 'ORG_FORECAST' THEN
15204:

Line 17371: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

17367: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17368: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17369: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17370: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17371: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17372: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17373: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17374: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17375: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 17467: l_fin_plan_type_name pa_fin_plan_types_vl.name%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 ;
17471:

Line 19146: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19142: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19143: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19144: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19145: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19146: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19147: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19148: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19149: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19150: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 19518: FROM pa_fin_plan_types_vl

19514:
19515: IF p_fin_plan_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM then
19516: SELECT fin_plan_type_id
19517: INTO l_fin_plan_type_id
19518: FROM pa_fin_plan_types_vl
19519: WHERE name = p_fin_plan_type_name;
19520: ELSE
19521: l_fin_plan_type_id := p_fin_plan_type_id;
19522: END IF;

Line 19527: FROM pa_fin_plan_types_vl

19523:
19524: IF p_fin_plan_type_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR then
19525: SELECT name
19526: INTO l_fin_plan_type_name
19527: FROM pa_fin_plan_types_vl
19528: WHERE fin_plan_type_id = p_fin_plan_type_id;
19529: ELSE
19530: l_fin_plan_type_name := p_fin_plan_type_name;
19531: END IF;