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 2820: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE

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

Line 3841: FROM pa_fin_plan_types_vl

3837: END IF;
3838:
3839: SELECT name
3840: INTO l_fin_plan_type_name
3841: FROM pa_fin_plan_types_vl
3842: WHERE fin_plan_type_id = l_fin_plan_type_id;
3843:
3844: PA_UTILS.ADD_MESSAGE
3845: (p_app_short_name => 'PA',

Line 5988: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE

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

Line 6685: FROM pa_fin_plan_types_vl

6681:
6682: --Get the plan type name
6683: SELECT name
6684: INTO l_fin_plan_type_name
6685: FROM pa_fin_plan_types_vl
6686: WHERE fin_plan_type_id = l_fin_plan_type_id;
6687:
6688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6689: THEN

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

Line 7094: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE;

7090: l_project_id NUMBER;
7091: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
7092: l_budget_version_id NUMBER;
7093: l_fin_plan_type_id NUMBER;
7094: l_fin_plan_type_name pa_fin_plan_types_vl.name%TYPE;
7095: l_version_type pa_budget_versions.version_type%TYPE;
7096: l_version_number NUMBER;
7097: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
7098:

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

8997: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8998: ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
8999: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
9000: ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9001: ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9002: ,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
9003: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9004: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9005: ,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 9254: FROM pa_fin_plan_types_vl

9250:
9251: CURSOR l_finplan_type_name_csr(p_finplan_type_id NUMBER)
9252: IS
9253: SELECT name
9254: FROM pa_fin_plan_types_vl
9255: WHERE fin_plan_type_id=p_finplan_type_id;
9256:
9257:
9258:

Line 14297: pa_fin_plan_types_vl pt

14293: ,bv.etc_start_date
14294: ,nvl(bv.wp_version_flag,'N') wp_version_flag
14295: ,bv.plan_processing_code
14296: FROM pa_budget_versions bv,
14297: pa_fin_plan_types_vl pt
14298: WHERE bv.budget_version_id = c_budget_version_id
14299: AND pt.fin_plan_type_id(+) = bv.fin_plan_type_id
14300: AND bv.ci_id IS NULL; -- -- Added an extra clause bv.ci_id IS NULL--Bug # 3507156
14301:

Line 14954: FROM pa_fin_plan_types_vl

14950: , use_for_workplan_flag
14951: INTO l_fin_plan_type_code
14952: ,l_fin_plan_type_name
14953: ,l_workplan_flag
14954: FROM pa_fin_plan_types_vl
14955: WHERE fin_plan_type_id = l_fin_plan_type_id;
14956:
14957: IF l_fin_plan_type_code = 'ORG_FORECAST' THEN
14958:

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

17108: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17109: ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17110: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17111: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17112: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17113: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17114: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17115: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
17116: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

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

18857: ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18858: ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18859: ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18860: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
18861: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18862: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18863: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18864: ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18865: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM