APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_FIN_PLAN_TYPES_B

Line 1361: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

1357: --End of variables used for debugging
1358:
1359: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1360: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1361: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
1362: l_rlm_id_tbl_count NUMBER := 0;
1363: l_elem_version_id_count NUMBER := 0;
1364: l_resource_list_id pa_proj_fp_options.all_resource_list_id%TYPE;
1365: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;

Line 2353: FROM pa_fin_plan_types_b

2349: END IF;
2350:
2351: SELECT fin_plan_type_id
2352: INTO l_fin_plan_type_id
2353: FROM pa_fin_plan_types_b
2354: WHERE use_for_workplan_flag ='Y';
2355:
2356: pa_fin_plan_pub.Create_Version (
2357: p_project_id => p_project_id

Line 10886: l_appr_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag %TYPE;

10882: l_proj_wp_type_exists NUMBER :=0;
10883: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10884: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;
10885: l_proj_currency_code pa_projects_all.project_currency_code%type;
10886: l_appr_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag %TYPE;
10887:
10888: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
10889: l_src_fp_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10890: BEGIN

Line 10938: FROM pa_fin_plan_types_b

10934: BEGIN -- BLOCK to check if workplan_type is is present in the system- Starts
10935:
10936: SELECT fin_plan_type_id,approved_rev_plan_type_flag
10937: INTO l_wp_type_id,l_appr_rev_plan_type_flag
10938: FROM pa_fin_plan_types_b
10939: WHERE nvl(use_for_workplan_flag,'N') = 'Y';
10940:
10941: EXCEPTION
10942:

Line 12265: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

12261: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12262: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE :=0;
12263: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12264:
12265: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12266:
12267: BEGIN
12268: FND_MSG_PUB.initialize;
12269: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 12366: FROM pa_fin_plan_types_b

12362:
12363: BEGIN
12364: SELECT plan_class_code
12365: INTO l_plan_class_code
12366: FROM pa_fin_plan_types_b
12367: where fin_plan_type_id = version_info_rec.fin_plan_type_id;
12368:
12369: EXCEPTION
12370: WHEN OTHERS THEN

Line 12682: ,pa_fin_plan_types_b fpt

12678: ,pfo.cost_non_labor_res_rate_sch_id
12679: ,pfo.cost_res_class_rate_sch_id
12680: ,pfo.cost_burden_rate_sch_id
12681: FROM pa_proj_fp_options pfo
12682: ,pa_fin_plan_types_b fpt
12683: WHERE pfo.project_id = p_project_id
12684: AND pfo.fin_plan_type_id = fpt.fin_plan_type_id
12685: AND fpt.use_for_workplan_flag = 'Y'
12686: AND pfo.fin_plan_option_level_code = 'PLAN_TYPE';