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 3646: -- l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

3642: l_element_version_id NUMBER;
3643:
3644: --Hsiu added for date rollup
3645: --bug 3991067
3646: -- l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
3647: l_tasks_ver_ids PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
3648: l_task_cnt NUMBER := 0;
3649: --end bug 3991067
3650:

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

5446: c_get_peer_tasks get_peer_tasks%ROWTYPE;
5447:
5448: --Hsiu added, for dates rollup
5449: /* Bug 5768425 Start*/
5450: --l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
5451: l_tasks_ver_ids PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
5452: l_task_cnt NUMBER := 0;
5453: /* Bug 5768425 End */
5454:

Line 6616: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

6612: AND project_id = c_project_id
6613: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
6614:
6615: --Hsiu added for date rollup
6616: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
6617:
6618: --hsiu added for task status
6619: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
6620: select object_id_from1

Line 7177: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

7173: and b.object_id_to1 <> p_task_version_id;
7174: c_get_peer_tasks get_peer_tasks%ROWTYPE;
7175:
7176: --Hsiu added, for dates rollup
7177: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
7178: --hsiu added, for task status
7179: l_rollup_task_id NUMBER;
7180:
7181: --hsiu added for task status

Line 7565: -- p_outline_level IN PA_NUM_1000_NUM

7561: -- p_project_id IN NUMBER
7562: -- p_ref_task_version_id IN NUMBER
7563: -- p_structure_id IN NUMBER
7564: -- p_structure_version_id IN NUMBER
7565: -- p_outline_level IN PA_NUM_1000_NUM
7566: -- p_task_number IN PA_VC_1000_150
7567: -- p_task_name IN PA_VC_1000_2000
7568: -- p_scheduled_start_date IN PA_DATE_1000_DATE
7569: -- p_scheduled_finish_date IN PA_DATE_1000_DATE

Line 7570: -- p_task_manager_id IN PA_NUM_1000_NUM

7566: -- p_task_number IN PA_VC_1000_150
7567: -- p_task_name IN PA_VC_1000_2000
7568: -- p_scheduled_start_date IN PA_DATE_1000_DATE
7569: -- p_scheduled_finish_date IN PA_DATE_1000_DATE
7570: -- p_task_manager_id IN PA_NUM_1000_NUM
7571: -- p_task_manager_name IN PA_VC_1000_150
7572: --FP M Development Changes
7573: -- p_planned_effort IN PA_NUM_1000_NUM
7574: -- p_dependencies IN PA_VC_1000_4000

Line 7573: -- p_planned_effort IN PA_NUM_1000_NUM

7569: -- p_scheduled_finish_date IN PA_DATE_1000_DATE
7570: -- p_task_manager_id IN PA_NUM_1000_NUM
7571: -- p_task_manager_name IN PA_VC_1000_150
7572: --FP M Development Changes
7573: -- p_planned_effort IN PA_NUM_1000_NUM
7574: -- p_dependencies IN PA_VC_1000_4000
7575: -- p_dependency_ids IN PA_NUM_1000_NUM
7576: -- p_structure_type IN VARCHAR2 :='WORKPLAN'
7577: -- p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 7575: -- p_dependency_ids IN PA_NUM_1000_NUM

7571: -- p_task_manager_name IN PA_VC_1000_150
7572: --FP M Development Changes
7573: -- p_planned_effort IN PA_NUM_1000_NUM
7574: -- p_dependencies IN PA_VC_1000_4000
7575: -- p_dependency_ids IN PA_NUM_1000_NUM
7576: -- p_structure_type IN VARCHAR2 :='WORKPLAN'
7577: -- p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7578: -- p_resources IN PA_VC_1000_4000
7579: -- p_resource_ids IN PA_NUM_1000_NUM

Line 7579: -- p_resource_ids IN PA_NUM_1000_NUM

7575: -- p_dependency_ids IN PA_NUM_1000_NUM
7576: -- p_structure_type IN VARCHAR2 :='WORKPLAN'
7577: -- p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7578: -- p_resources IN PA_VC_1000_4000
7579: -- p_resource_ids IN PA_NUM_1000_NUM
7580: -- p_mapped_task IN PA_VC_1000_4000
7581: -- p_mapped_task_id IN PA_NUM_1000_NUM
7582: --End FP M Development Changes
7583: -- x_msg_count OUT NUMBER

Line 7581: -- p_mapped_task_id IN PA_NUM_1000_NUM

7577: -- p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7578: -- p_resources IN PA_VC_1000_4000
7579: -- p_resource_ids IN PA_NUM_1000_NUM
7580: -- p_mapped_task IN PA_VC_1000_4000
7581: -- p_mapped_task_id IN PA_NUM_1000_NUM
7582: --End FP M Development Changes
7583: -- x_msg_count OUT NUMBER
7584: -- x_msg_data OUT VARCHAR2
7585: -- x_return_status OUT VARCHAR2

Line 7601: ,p_outline_level IN PA_NUM_1000_NUM

7597: ( p_project_id IN NUMBER
7598: ,p_ref_task_version_id IN NUMBER
7599: ,p_structure_id IN NUMBER
7600: ,p_structure_version_id IN NUMBER
7601: ,p_outline_level IN PA_NUM_1000_NUM
7602: ,p_task_number IN PA_VC_1000_150
7603: ,p_task_name IN PA_VC_1000_2000
7604: ,p_scheduled_start_date IN PA_DATE_1000_DATE
7605: ,p_scheduled_finish_date IN PA_DATE_1000_DATE

Line 7606: ,p_task_manager_id IN PA_NUM_1000_NUM

7602: ,p_task_number IN PA_VC_1000_150
7603: ,p_task_name IN PA_VC_1000_2000
7604: ,p_scheduled_start_date IN PA_DATE_1000_DATE
7605: ,p_scheduled_finish_date IN PA_DATE_1000_DATE
7606: ,p_task_manager_id IN PA_NUM_1000_NUM
7607: ,p_task_manager_name IN PA_VC_1000_150
7608: ,p_TYPE_ID IN PA_NUM_1000_NUM
7609: --FP M Development Changes bug 330119
7610: ,p_planned_effort IN PA_NUM_1000_NUM

Line 7608: ,p_TYPE_ID IN PA_NUM_1000_NUM

7604: ,p_scheduled_start_date IN PA_DATE_1000_DATE
7605: ,p_scheduled_finish_date IN PA_DATE_1000_DATE
7606: ,p_task_manager_id IN PA_NUM_1000_NUM
7607: ,p_task_manager_name IN PA_VC_1000_150
7608: ,p_TYPE_ID IN PA_NUM_1000_NUM
7609: --FP M Development Changes bug 330119
7610: ,p_planned_effort IN PA_NUM_1000_NUM
7611: ,p_planned_equip_effort IN PA_NUM_1000_NUM
7612: ,p_dependencies IN PA_VC_1000_4000

Line 7610: ,p_planned_effort IN PA_NUM_1000_NUM

7606: ,p_task_manager_id IN PA_NUM_1000_NUM
7607: ,p_task_manager_name IN PA_VC_1000_150
7608: ,p_TYPE_ID IN PA_NUM_1000_NUM
7609: --FP M Development Changes bug 330119
7610: ,p_planned_effort IN PA_NUM_1000_NUM
7611: ,p_planned_equip_effort IN PA_NUM_1000_NUM
7612: ,p_dependencies IN PA_VC_1000_4000
7613: ,p_dependency_ids IN PA_NUM_1000_NUM
7614: ,p_structure_type IN VARCHAR2 :='WORKPLAN'

Line 7611: ,p_planned_equip_effort IN PA_NUM_1000_NUM

7607: ,p_task_manager_name IN PA_VC_1000_150
7608: ,p_TYPE_ID IN PA_NUM_1000_NUM
7609: --FP M Development Changes bug 330119
7610: ,p_planned_effort IN PA_NUM_1000_NUM
7611: ,p_planned_equip_effort IN PA_NUM_1000_NUM
7612: ,p_dependencies IN PA_VC_1000_4000
7613: ,p_dependency_ids IN PA_NUM_1000_NUM
7614: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
7615: ,p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 7613: ,p_dependency_ids IN PA_NUM_1000_NUM

7609: --FP M Development Changes bug 330119
7610: ,p_planned_effort IN PA_NUM_1000_NUM
7611: ,p_planned_equip_effort IN PA_NUM_1000_NUM
7612: ,p_dependencies IN PA_VC_1000_4000
7613: ,p_dependency_ids IN PA_NUM_1000_NUM
7614: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
7615: ,p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7616: ,p_use_in_fin_plan IN PA_VC_1000_10
7617: ,p_resources IN PA_VC_1000_4000

Line 7618: ,p_resource_ids IN PA_NUM_1000_NUM

7614: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
7615: ,p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7616: ,p_use_in_fin_plan IN PA_VC_1000_10
7617: ,p_resources IN PA_VC_1000_4000
7618: ,p_resource_ids IN PA_NUM_1000_NUM
7619: ,p_mapped_task IN PA_VC_1000_4000
7620: ,p_mapped_task_id IN PA_NUM_1000_NUM
7621: --End FP M Development Changes bug 330119
7622: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 7620: ,p_mapped_task_id IN PA_NUM_1000_NUM

7616: ,p_use_in_fin_plan IN PA_VC_1000_10
7617: ,p_resources IN PA_VC_1000_4000
7618: ,p_resource_ids IN PA_NUM_1000_NUM
7619: ,p_mapped_task IN PA_VC_1000_4000
7620: ,p_mapped_task_id IN PA_NUM_1000_NUM
7621: --End FP M Development Changes bug 330119
7622: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7623: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7624: ,x_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 7659: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

7655: WHERE element_version_id = p_ref_task_ver_id
7656: AND object_type = 'PA_TASKS';
7657:
7658: --Hsiu added for date rollup
7659: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
7660:
7661: -- anlee task weighting
7662: l_top_sub_count NUMBER;
7663: -- anlee End of changes

Line 8423: -- p_element_versions IN PA_NUM_1000_NUM

8419: -- Pre-reqs : None
8420: -- Return Value : N/A
8421: -- Prameters
8422: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
8423: -- p_element_versions IN PA_NUM_1000_NUM
8424: -- p_outline_level IN PA_NUM_1000_NUM
8425: -- p_top_peer_count IN NUMBER
8426: -- p_top_sub_count IN NUMBER
8427: -- x_msg_count OUT NUMBER

Line 8424: -- p_outline_level IN PA_NUM_1000_NUM

8420: -- Return Value : N/A
8421: -- Prameters
8422: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
8423: -- p_element_versions IN PA_NUM_1000_NUM
8424: -- p_outline_level IN PA_NUM_1000_NUM
8425: -- p_top_peer_count IN NUMBER
8426: -- p_top_sub_count IN NUMBER
8427: -- x_msg_count OUT NUMBER
8428: -- x_msg_data OUT VARCHAR2

Line 8438: ( p_element_versions IN PA_NUM_1000_NUM

8434: --
8435: --
8436:
8437: PROCEDURE CALC_TASK_WEIGHTS
8438: ( p_element_versions IN PA_NUM_1000_NUM
8439: ,p_outline_level IN PA_NUM_1000_NUM
8440: ,p_top_sub_count IN NUMBER
8441: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8442: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 8439: ,p_outline_level IN PA_NUM_1000_NUM

8435: --
8436:
8437: PROCEDURE CALC_TASK_WEIGHTS
8438: ( p_element_versions IN PA_NUM_1000_NUM
8439: ,p_outline_level IN PA_NUM_1000_NUM
8440: ,p_top_sub_count IN NUMBER
8441: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8442: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8443: ,x_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 9189: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

9185: l_version_from NUMBER;
9186: l_versioned VARCHAR2(1) := 'N';
9187: l_shared VARCHAR2(1) := 'N';
9188:
9189: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
9190: l_parent_ver_id NUMBER;
9191: l_error_msg_code VARCHAR2(30);
9192:
9193: src_elem_ver_id NUMBER;

Line 10684: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

10680: l_versioned VARCHAR2(1) := 'N';
10681: l_shared VARCHAR2(1) := 'N';
10682: l_rollup_task_id NUMBER;
10683:
10684: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
10685: l_parent_ver_id NUMBER;
10686: l_error_msg_code VARCHAR2(30);
10687:
10688: src_elem_ver_id NUMBER;

Line 13080: p_tasks_ver_ids IN PA_NUM_1000_NUM,

13076: --FPM bug 3301192
13077: --Planning and budget changes.
13078: --This apis is called from CREATE_TASKS api and AMG create_project, update_prohject and add_task apis
13079: PROCEDURE call_add_planning_txns(
13080: p_tasks_ver_ids IN PA_NUM_1000_NUM,
13081: p_planned_effort IN PA_NUM_1000_NUM,
13082: p_project_id IN NUMBER,
13083: p_structure_version_id IN NUMBER,
13084: p_start_date IN PA_DATE_1000_DATE,

Line 13081: p_planned_effort IN PA_NUM_1000_NUM,

13077: --Planning and budget changes.
13078: --This apis is called from CREATE_TASKS api and AMG create_project, update_prohject and add_task apis
13079: PROCEDURE call_add_planning_txns(
13080: p_tasks_ver_ids IN PA_NUM_1000_NUM,
13081: p_planned_effort IN PA_NUM_1000_NUM,
13082: p_project_id IN NUMBER,
13083: p_structure_version_id IN NUMBER,
13084: p_start_date IN PA_DATE_1000_DATE,
13085: p_end_date IN PA_DATE_1000_DATE,