APPS.PJI_FM_PLAN_MAINT dependencies on PA_BUDGET_VERSIONS

Line 12: -- TYPE plan_version_id_rec IS RECORD (plan_version_id pa_budget_versions.budget_version_id%TYPE);

8: g_event_rec PA_PJI_PROJ_EVENTS_LOG%ROWTYPE;
9: g_process_update_wbs_flag VARCHAR2(1) := 'N' ;
10:
11:
12: -- TYPE plan_version_id_rec IS RECORD (plan_version_id pa_budget_versions.budget_version_id%TYPE);
13:
14: -- TYPE c_plnverid_cur IS REF CURSOR RETURN plan_version_id_rec;
15:
16: -- FUNCTION get_plan_version_ids_cursor ( p_context VARCHAR2 ) RETURN c_plnverid_cur;

Line 600: c_fp_src_version_id pa_budget_versions.budget_version_id%TYPE

596: , p_Copy_mode IN VARCHAR2 :=NULL
597: ) IS
598:
599: CURSOR c_src_struct_version_id (
600: c_fp_src_version_id pa_budget_versions.budget_version_id%TYPE
601: ) IS
602: (
603: SELECT DECODE ( src.wp_version_flag
604: , 'Y'

Line 608: FROM pa_budget_versions src

604: , 'Y'
605: , src.project_structure_version_id
606: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(src.project_id)
607: ) src_struct_version_id
608: FROM pa_budget_versions src
609: WHERE src.budget_version_id = c_fp_src_version_id
610: );
611:
612: CURSOR c_dest_struct_version_id (

Line 613: c_fp_tar_version_id pa_budget_versions.budget_version_id%TYPE

609: WHERE src.budget_version_id = c_fp_src_version_id
610: );
611:
612: CURSOR c_dest_struct_version_id (
613: c_fp_tar_version_id pa_budget_versions.budget_version_id%TYPE
614: ) IS
615: (
616: SELECT DECODE ( tar.wp_version_flag
617: , 'Y'

Line 621: FROM pa_budget_versions tar

617: , 'Y'
618: , tar.project_structure_version_id
619: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(tar.project_id)
620: ) tar_struct_version_id
621: FROM pa_budget_versions tar
622: WHERE tar.budget_version_id = c_fp_tar_version_id
623: );
624:
625: l_wbs_src_struct_version_id pa_budget_versions.project_structure_version_id%TYPE;

Line 625: l_wbs_src_struct_version_id pa_budget_versions.project_structure_version_id%TYPE;

621: FROM pa_budget_versions tar
622: WHERE tar.budget_version_id = c_fp_tar_version_id
623: );
624:
625: l_wbs_src_struct_version_id pa_budget_versions.project_structure_version_id%TYPE;
626: l_wbs_tar_struct_version_id pa_budget_versions.project_structure_version_id%TYPE;
627: l_return_status VARCHAR2(1) ;
628:
629: -- Avoid re-populating pa/pji denorm tables if denorm definition already exists.

Line 626: l_wbs_tar_struct_version_id pa_budget_versions.project_structure_version_id%TYPE;

622: WHERE tar.budget_version_id = c_fp_tar_version_id
623: );
624:
625: l_wbs_src_struct_version_id pa_budget_versions.project_structure_version_id%TYPE;
626: l_wbs_tar_struct_version_id pa_budget_versions.project_structure_version_id%TYPE;
627: l_return_status VARCHAR2(1) ;
628:
629: -- Avoid re-populating pa/pji denorm tables if denorm definition already exists.
630: l_tar_denorm_exists_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();