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.

[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 1277: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL

1273: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
1274: ,p_one_to_one_mapping_flag IN VARCHAR2 DEFAULT 'N'
1275: ,p_calling_module IN VARCHAR2 DEFAULT NULL
1276: ,p_project_id IN Pa_projects_all.project_id%TYPE
1277: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
1278: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1279: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1280: ,p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type
1281: DEFAULT SYSTEM.PA_NUM_TBL_TYPE() --bug#16200605

Line 1371: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;

1367: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1368: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1369: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1370: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1371: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;
1372: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
1373:
1374: -- Added for Bug 3719918 -- USED FOR INSERT WHEN p-one-t-one-mapping-flag is Y
1375: l_task_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1596: CURSOR c_proj_element_id(c_elem_version_id pa_proj_element_versions.element_version_id%TYPE) IS

1592: -- This cursor is to be used to retrieve the proj_element_id based on the
1593: -- element_version_id.
1594: -- This might be removed.
1595: --------------------------------------------------------------------------
1596: CURSOR c_proj_element_id(c_elem_version_id pa_proj_element_versions.element_version_id%TYPE) IS
1597: SELECT proj_element_id
1598: FROM pa_proj_element_versions
1599: WHERE element_version_id = c_elem_version_id;
1600:

Line 1598: FROM pa_proj_element_versions

1594: -- This might be removed.
1595: --------------------------------------------------------------------------
1596: CURSOR c_proj_element_id(c_elem_version_id pa_proj_element_versions.element_version_id%TYPE) IS
1597: SELECT proj_element_id
1598: FROM pa_proj_element_versions
1599: WHERE element_version_id = c_elem_version_id;
1600:
1601: -- gboomina added for bug 8586393 - start
1602: --Mcloseout

Line 5958: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE

5954: PROCEDURE update_planning_transactions
5955: (
5956: p_context IN VARCHAR2
5957: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
5958: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
5959: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
5960: ,p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5961: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5962: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE

Line 11133: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE

11129: ********************************************************************************************************/
11130: PROCEDURE check_and_create_task_rec_info
11131: (
11132: p_project_id IN Pa_projects_all.project_id%TYPE
11133: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
11134: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
11135: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
11136: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
11137: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 12226: from pa_tasks a, pa_proj_element_versions b

12222: and p_calling_context = 'SELECT_TASKS');
12223:
12224: CURSOR top_tasks_cur (c_project_id number, c_parent_structure_version_id number) is
12225: select b.element_version_id
12226: from pa_tasks a, pa_proj_element_versions b
12227: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.
12228: * Note that financial_task_flag of pa_proj_element_versions cannot be used
12229: * since it is set to Y even for tasks that are part of fin struct ver but not
12230: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This

Line 12228: * Note that financial_task_flag of pa_proj_element_versions cannot be used

12224: CURSOR top_tasks_cur (c_project_id number, c_parent_structure_version_id number) is
12225: select b.element_version_id
12226: from pa_tasks a, pa_proj_element_versions b
12227: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.
12228: * Note that financial_task_flag of pa_proj_element_versions cannot be used
12229: * since it is set to Y even for tasks that are part of fin struct ver but not
12230: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This
12231: * required a join with pa_tasks to identify true fin tasks which can be
12232: * budgeted for */