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_FP_PLANNING_TRANSACTION_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

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

1216: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
1217: ,p_one_to_one_mapping_flag IN VARCHAR2 DEFAULT 'N'
1218: ,p_calling_module IN VARCHAR2 DEFAULT NULL
1219: ,p_project_id IN Pa_projects_all.project_id%TYPE
1220: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
1221: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1222: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1223: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1224: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()

Line 1311: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;

1307: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1308: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1309: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1310: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1311: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;
1312: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
1313:
1314: -- Added for Bug 3719918 -- USED FOR INSERT WHEN p-one-t-one-mapping-flag is Y
1315: l_task_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1522: -- This cursor is to be used to retrieve the proj_element_id based on the
1523: -- element_version_id.
1524: -- This might be removed.
1525: --------------------------------------------------------------------------
1526: CURSOR c_proj_element_id(c_elem_version_id pa_proj_element_versions.element_version_id%TYPE) IS
1527: SELECT proj_element_id
1528: FROM pa_proj_element_versions
1529: WHERE element_version_id = c_elem_version_id;
1530:

Line 1528: FROM pa_proj_element_versions

1524: -- This might be removed.
1525: --------------------------------------------------------------------------
1526: CURSOR c_proj_element_id(c_elem_version_id pa_proj_element_versions.element_version_id%TYPE) IS
1527: SELECT proj_element_id
1528: FROM pa_proj_element_versions
1529: WHERE element_version_id = c_elem_version_id;
1530:
1531: BEGIN
1532: l_trace_stage := 10;

Line 5303: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE

5299: PROCEDURE update_planning_transactions
5300: (
5301: p_context IN VARCHAR2
5302: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
5303: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
5304: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
5305: ,p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5306: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5307: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE

Line 10267: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE

10263: ********************************************************************************************************/
10264: PROCEDURE check_and_create_task_rec_info
10265: (
10266: p_project_id IN Pa_projects_all.project_id%TYPE
10267: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
10268: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
10269: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
10270: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
10271: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 11352: from pa_tasks a, pa_proj_element_versions b

11348: and p_calling_context = 'SELECT_TASKS');
11349:
11350: CURSOR top_tasks_cur (c_project_id number, c_parent_structure_version_id number) is
11351: select b.element_version_id
11352: from pa_tasks a, pa_proj_element_versions b
11353: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.
11354: * Note that financial_task_flag of pa_proj_element_versions cannot be used
11355: * since it is set to Y even for tasks that are part of fin struct ver but not
11356: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This

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

11350: CURSOR top_tasks_cur (c_project_id number, c_parent_structure_version_id number) is
11351: select b.element_version_id
11352: from pa_tasks a, pa_proj_element_versions b
11353: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.
11354: * Note that financial_task_flag of pa_proj_element_versions cannot be used
11355: * since it is set to Y even for tasks that are part of fin struct ver but not
11356: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This
11357: * required a join with pa_tasks to identify true fin tasks which can be
11358: * budgeted for */