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_TASK_PUB1 dependencies on PA_NUM_1000_NUM

Line 3715: -- l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

3711: l_element_version_id NUMBER;
3712:
3713: --Hsiu added for date rollup
3714: --bug 3991067
3715: -- l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
3716: l_tasks_ver_ids PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
3717: l_task_cnt NUMBER := 0;
3718: --end bug 3991067
3719:

Line 5725: --l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

5721: c_get_peer_tasks get_peer_tasks%ROWTYPE;
5722:
5723: --Hsiu added, for dates rollup
5724: /* Bug 5768425 Start*/
5725: --l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
5726: l_tasks_ver_ids PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
5727: l_task_cnt NUMBER := 0;
5728: /* Bug 5768425 End */
5729:

Line 6899: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

6895: AND project_id = c_project_id
6896: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
6897:
6898: --Hsiu added for date rollup
6899: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
6900:
6901: --hsiu added for task status
6902: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
6903: select object_id_from1

Line 7474: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

7470: and b.object_id_to1 <> p_task_version_id;
7471: c_get_peer_tasks get_peer_tasks%ROWTYPE;
7472:
7473: --Hsiu added, for dates rollup
7474: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
7475: --hsiu added, for task status
7476: l_rollup_task_id NUMBER;
7477:
7478: --hsiu added for task status

Line 7862: -- p_outline_level IN PA_NUM_1000_NUM

7858: -- p_project_id IN NUMBER
7859: -- p_ref_task_version_id IN NUMBER
7860: -- p_structure_id IN NUMBER
7861: -- p_structure_version_id IN NUMBER
7862: -- p_outline_level IN PA_NUM_1000_NUM
7863: -- p_task_number IN PA_VC_1000_150
7864: -- p_task_name IN PA_VC_1000_2000
7865: -- p_scheduled_start_date IN PA_DATE_1000_DATE
7866: -- p_scheduled_finish_date IN PA_DATE_1000_DATE

Line 7867: -- p_task_manager_id IN PA_NUM_1000_NUM

7863: -- p_task_number IN PA_VC_1000_150
7864: -- p_task_name IN PA_VC_1000_2000
7865: -- p_scheduled_start_date IN PA_DATE_1000_DATE
7866: -- p_scheduled_finish_date IN PA_DATE_1000_DATE
7867: -- p_task_manager_id IN PA_NUM_1000_NUM
7868: -- p_task_manager_name IN PA_VC_1000_150
7869: --FP M Development Changes
7870: -- p_planned_effort IN PA_NUM_1000_NUM
7871: -- p_dependencies IN PA_VC_1000_4000

Line 7870: -- p_planned_effort IN PA_NUM_1000_NUM

7866: -- p_scheduled_finish_date IN PA_DATE_1000_DATE
7867: -- p_task_manager_id IN PA_NUM_1000_NUM
7868: -- p_task_manager_name IN PA_VC_1000_150
7869: --FP M Development Changes
7870: -- p_planned_effort IN PA_NUM_1000_NUM
7871: -- p_dependencies IN PA_VC_1000_4000
7872: -- p_dependency_ids IN PA_NUM_1000_NUM
7873: -- p_structure_type IN VARCHAR2 :='WORKPLAN'
7874: -- p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 7872: -- p_dependency_ids IN PA_NUM_1000_NUM

7868: -- p_task_manager_name IN PA_VC_1000_150
7869: --FP M Development Changes
7870: -- p_planned_effort IN PA_NUM_1000_NUM
7871: -- p_dependencies IN PA_VC_1000_4000
7872: -- p_dependency_ids IN PA_NUM_1000_NUM
7873: -- p_structure_type IN VARCHAR2 :='WORKPLAN'
7874: -- p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7875: -- p_resources IN PA_VC_1000_4000
7876: -- p_resource_ids IN PA_NUM_1000_NUM

Line 7876: -- p_resource_ids IN PA_NUM_1000_NUM

7872: -- p_dependency_ids IN PA_NUM_1000_NUM
7873: -- p_structure_type IN VARCHAR2 :='WORKPLAN'
7874: -- p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7875: -- p_resources IN PA_VC_1000_4000
7876: -- p_resource_ids IN PA_NUM_1000_NUM
7877: -- p_mapped_task IN PA_VC_1000_4000
7878: -- p_mapped_task_id IN PA_NUM_1000_NUM
7879: --End FP M Development Changes
7880: -- x_msg_count OUT NUMBER

Line 7878: -- p_mapped_task_id IN PA_NUM_1000_NUM

7874: -- p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7875: -- p_resources IN PA_VC_1000_4000
7876: -- p_resource_ids IN PA_NUM_1000_NUM
7877: -- p_mapped_task IN PA_VC_1000_4000
7878: -- p_mapped_task_id IN PA_NUM_1000_NUM
7879: --End FP M Development Changes
7880: -- x_msg_count OUT NUMBER
7881: -- x_msg_data OUT VARCHAR2
7882: -- x_return_status OUT VARCHAR2

Line 7898: ,p_outline_level IN PA_NUM_1000_NUM

7894: ( p_project_id IN NUMBER
7895: ,p_ref_task_version_id IN NUMBER
7896: ,p_structure_id IN NUMBER
7897: ,p_structure_version_id IN NUMBER
7898: ,p_outline_level IN PA_NUM_1000_NUM
7899: ,p_task_number IN PA_VC_1000_150
7900: ,p_task_name IN PA_VC_1000_2000
7901: ,p_scheduled_start_date IN PA_DATE_1000_DATE
7902: ,p_scheduled_finish_date IN PA_DATE_1000_DATE

Line 7903: ,p_task_manager_id IN PA_NUM_1000_NUM

7899: ,p_task_number IN PA_VC_1000_150
7900: ,p_task_name IN PA_VC_1000_2000
7901: ,p_scheduled_start_date IN PA_DATE_1000_DATE
7902: ,p_scheduled_finish_date IN PA_DATE_1000_DATE
7903: ,p_task_manager_id IN PA_NUM_1000_NUM
7904: ,p_task_manager_name IN PA_VC_1000_150
7905: ,p_TYPE_ID IN PA_NUM_1000_NUM
7906: --FP M Development Changes bug 330119
7907: ,p_planned_effort IN PA_NUM_1000_NUM

Line 7905: ,p_TYPE_ID IN PA_NUM_1000_NUM

7901: ,p_scheduled_start_date IN PA_DATE_1000_DATE
7902: ,p_scheduled_finish_date IN PA_DATE_1000_DATE
7903: ,p_task_manager_id IN PA_NUM_1000_NUM
7904: ,p_task_manager_name IN PA_VC_1000_150
7905: ,p_TYPE_ID IN PA_NUM_1000_NUM
7906: --FP M Development Changes bug 330119
7907: ,p_planned_effort IN PA_NUM_1000_NUM
7908: ,p_planned_equip_effort IN PA_NUM_1000_NUM
7909: ,p_dependencies IN PA_VC_1000_4000

Line 7907: ,p_planned_effort IN PA_NUM_1000_NUM

7903: ,p_task_manager_id IN PA_NUM_1000_NUM
7904: ,p_task_manager_name IN PA_VC_1000_150
7905: ,p_TYPE_ID IN PA_NUM_1000_NUM
7906: --FP M Development Changes bug 330119
7907: ,p_planned_effort IN PA_NUM_1000_NUM
7908: ,p_planned_equip_effort IN PA_NUM_1000_NUM
7909: ,p_dependencies IN PA_VC_1000_4000
7910: ,p_dependency_ids IN PA_NUM_1000_NUM
7911: ,p_structure_type IN VARCHAR2 :='WORKPLAN'

Line 7908: ,p_planned_equip_effort IN PA_NUM_1000_NUM

7904: ,p_task_manager_name IN PA_VC_1000_150
7905: ,p_TYPE_ID IN PA_NUM_1000_NUM
7906: --FP M Development Changes bug 330119
7907: ,p_planned_effort IN PA_NUM_1000_NUM
7908: ,p_planned_equip_effort IN PA_NUM_1000_NUM
7909: ,p_dependencies IN PA_VC_1000_4000
7910: ,p_dependency_ids IN PA_NUM_1000_NUM
7911: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
7912: ,p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 7910: ,p_dependency_ids IN PA_NUM_1000_NUM

7906: --FP M Development Changes bug 330119
7907: ,p_planned_effort IN PA_NUM_1000_NUM
7908: ,p_planned_equip_effort IN PA_NUM_1000_NUM
7909: ,p_dependencies IN PA_VC_1000_4000
7910: ,p_dependency_ids IN PA_NUM_1000_NUM
7911: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
7912: ,p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7913: ,p_use_in_fin_plan IN PA_VC_1000_10
7914: ,p_resources IN PA_VC_1000_4000

Line 7915: ,p_resource_ids IN PA_NUM_1000_NUM

7911: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
7912: ,p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7913: ,p_use_in_fin_plan IN PA_VC_1000_10
7914: ,p_resources IN PA_VC_1000_4000
7915: ,p_resource_ids IN PA_NUM_1000_NUM
7916: ,p_mapped_task IN PA_VC_1000_4000
7917: ,p_mapped_task_id IN PA_NUM_1000_NUM
7918: --End FP M Development Changes bug 330119
7919: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 7917: ,p_mapped_task_id IN PA_NUM_1000_NUM

7913: ,p_use_in_fin_plan IN PA_VC_1000_10
7914: ,p_resources IN PA_VC_1000_4000
7915: ,p_resource_ids IN PA_NUM_1000_NUM
7916: ,p_mapped_task IN PA_VC_1000_4000
7917: ,p_mapped_task_id IN PA_NUM_1000_NUM
7918: --End FP M Development Changes bug 330119
7919: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7920: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7921: ,x_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 7956: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

7952: WHERE element_version_id = p_ref_task_ver_id
7953: AND object_type = 'PA_TASKS';
7954:
7955: --Hsiu added for date rollup
7956: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
7957:
7958: -- anlee task weighting
7959: l_top_sub_count NUMBER;
7960: -- anlee End of changes

Line 8786: -- p_element_versions IN PA_NUM_1000_NUM

8782: -- Pre-reqs : None
8783: -- Return Value : N/A
8784: -- Prameters
8785: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
8786: -- p_element_versions IN PA_NUM_1000_NUM
8787: -- p_outline_level IN PA_NUM_1000_NUM
8788: -- p_top_peer_count IN NUMBER
8789: -- p_top_sub_count IN NUMBER
8790: -- x_msg_count OUT NUMBER

Line 8787: -- p_outline_level IN PA_NUM_1000_NUM

8783: -- Return Value : N/A
8784: -- Prameters
8785: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
8786: -- p_element_versions IN PA_NUM_1000_NUM
8787: -- p_outline_level IN PA_NUM_1000_NUM
8788: -- p_top_peer_count IN NUMBER
8789: -- p_top_sub_count IN NUMBER
8790: -- x_msg_count OUT NUMBER
8791: -- x_msg_data OUT VARCHAR2

Line 8801: ( p_element_versions IN PA_NUM_1000_NUM

8797: --
8798: --
8799:
8800: PROCEDURE CALC_TASK_WEIGHTS
8801: ( p_element_versions IN PA_NUM_1000_NUM
8802: ,p_outline_level IN PA_NUM_1000_NUM
8803: ,p_top_sub_count IN NUMBER
8804: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8805: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 8802: ,p_outline_level IN PA_NUM_1000_NUM

8798: --
8799:
8800: PROCEDURE CALC_TASK_WEIGHTS
8801: ( p_element_versions IN PA_NUM_1000_NUM
8802: ,p_outline_level IN PA_NUM_1000_NUM
8803: ,p_top_sub_count IN NUMBER
8804: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8805: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8806: ,x_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 9552: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

9548: l_version_from NUMBER;
9549: l_versioned VARCHAR2(1) := 'N';
9550: l_shared VARCHAR2(1) := 'N';
9551:
9552: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
9553: l_parent_ver_id NUMBER;
9554: l_error_msg_code VARCHAR2(30);
9555:
9556: src_elem_ver_id NUMBER;

Line 11064: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

11060: l_versioned VARCHAR2(1) := 'N';
11061: l_shared VARCHAR2(1) := 'N';
11062: l_rollup_task_id NUMBER;
11063:
11064: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
11065: l_parent_ver_id NUMBER;
11066: l_error_msg_code VARCHAR2(30);
11067:
11068: src_elem_ver_id NUMBER;

Line 13604: p_tasks_ver_ids IN PA_NUM_1000_NUM,

13600: --FPM bug 3301192
13601: --Planning and budget changes.
13602: --This apis is called from CREATE_TASKS api and AMG create_project, update_prohject and add_task apis
13603: PROCEDURE call_add_planning_txns(
13604: p_tasks_ver_ids IN PA_NUM_1000_NUM,
13605: p_planned_effort IN PA_NUM_1000_NUM,
13606: p_project_id IN NUMBER,
13607: p_structure_version_id IN NUMBER,
13608: p_start_date IN PA_DATE_1000_DATE,

Line 13605: p_planned_effort IN PA_NUM_1000_NUM,

13601: --Planning and budget changes.
13602: --This apis is called from CREATE_TASKS api and AMG create_project, update_prohject and add_task apis
13603: PROCEDURE call_add_planning_txns(
13604: p_tasks_ver_ids IN PA_NUM_1000_NUM,
13605: p_planned_effort IN PA_NUM_1000_NUM,
13606: p_project_id IN NUMBER,
13607: p_structure_version_id IN NUMBER,
13608: p_start_date IN PA_DATE_1000_DATE,
13609: p_end_date IN PA_DATE_1000_DATE,