DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_TASK_PUB1

Line 433: PA_TASK_PUB1.Create_Schedule_Version(

429:
430:
431: IF NVL( p_struc_type, 'WORKPLAN' ) = 'WORKPLAN'
432: THEN
433: PA_TASK_PUB1.Create_Schedule_Version(
434: p_element_version_id => x_struc_version_id
435: ,p_scheduled_start_date => SYSDATE
436: ,p_scheduled_end_date => SYSDATE
437: ,x_pev_schedule_id => x_pev_schedule_id

Line 762: PA_TASK_PUB1.Create_Schedule_Version(

758: OPEN cur_ver_sch_attr_rec(x_task_version_id);
759: FETCH cur_ver_sch_attr_rec INTO l_ver_sch_attr_rec;
760: CLOSE cur_ver_sch_attr_rec;
761:
762: PA_TASK_PUB1.Create_Schedule_Version(
763: p_element_version_id => x_task_version_id
764: ,p_scheduled_start_date => SYSDATE
765: ,p_scheduled_end_date => SYSDATE
766: ,p_attribute_category => l_ver_sch_attr_rec.attribute_category

Line 1509: PA_TASK_PUB1.create_task(

1505: IF p_create_task_version_only = 'N'
1506: THEN
1507:
1508: --For each project create 1 task
1509: PA_TASK_PUB1.create_task(
1510: p_calling_module => p_calling_module
1511: ,p_init_msg_list => l_init_msg_list
1512: ,p_object_type => 'PA_TASKS'
1513: ,p_project_id => p_project_id

Line 2155: PA_TASK_PUB1.Create_Schedule_Version(

2151: END IF;
2152: --Bug 6153503 end
2153: --End add rtarway, 3908013
2154:
2155: PA_TASK_PUB1.Create_Schedule_Version(
2156: p_element_version_id => l_task_version_id
2157: ,p_init_msg_list => l_init_msg_list
2158: ,p_scheduled_start_date => l_scheduled_start_date
2159: ,p_scheduled_end_date => l_scheduled_finish_date

Line 2289: -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.

2285: l_del_task_ver_ids(l_del_task_ver_ids.count):= x_task_version_id;
2286: end if;
2287: end if;
2288:
2289: -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.
2290:
2291: begin
2292: pa_task_pub1.call_add_planning_txns(
2293: p_tasks_ver_ids => l_add_task_ver_ids,

Line 2292: pa_task_pub1.call_add_planning_txns(

2288:
2289: -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.
2290:
2291: begin
2292: pa_task_pub1.call_add_planning_txns(
2293: p_tasks_ver_ids => l_add_task_ver_ids,
2294: p_planned_effort => l_add_planned_effort,
2295: p_project_id => p_project_id,
2296: p_structure_version_id => l_structure_version_id, --replace p_structure_version_id, bug 3838186

Line 2308: p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));

2304: exception
2305: when others then
2306: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
2307: p_procedure_name => 'CREATE_PROJECT',
2308: p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
2309: raise fnd_api.g_exc_error;
2310: end;
2311:
2312: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.

Line 2370: -- 18-MAY-2004 Rakesh Raghavan Modified call to API: pa_task_pub1.update_task_det_sch_info().

2366: -- History
2367: --
2368: -- 25-APR-02 MAansari -Created
2369: -- 05-APR-2004 Rakesh Raghavan Progress Management Changes. Bug # 3420093.
2370: -- 18-MAY-2004 Rakesh Raghavan Modified call to API: pa_task_pub1.update_task_det_sch_info().
2371:
2372: PROCEDURE update_task_structure
2373: (
2374: p_calling_module IN VARCHAR2 := 'FORMS'

Line 2665: --pa_task_pub1.call_add_planning_txns

2661:
2662: --Bug 5256359. Changed the type of these pl-sql tbls to SYSTEM.pa_xxx_tbl_type from PA_xxx_1000_xxx.
2663:
2664: --New tbls (suffixed with _prm), created below will be used as parameters in the call to
2665: --pa_task_pub1.call_add_planning_txns
2666:
2667: l_add_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2668: l_add_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2669: l_add_start_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 2837: PA_TASK_PUB1.Update_Task(

2833: END IF;
2834: --End add by rtarway for BUG 3666023
2835:
2836:
2837: PA_TASK_PUB1.Update_Task(
2838: p_calling_module => p_calling_module
2839: ,p_init_msg_list => l_init_msg_list
2840: --rtarway for BUG 3666023
2841: --,p_task_id => p_task_id

Line 2868: --dbms_output.put_line('Before calling PA_TASK_PUB1.Update_Task l_return_status'||l_return_status);

2864: ,x_msg_count => l_msg_count
2865: ,x_msg_data => l_msg_data
2866: ,P_PM_SOURCE_CODE => P_PM_SOURCE_CODE -- Huawei 15876400 source code
2867: );
2868: --dbms_output.put_line('Before calling PA_TASK_PUB1.Update_Task l_return_status'||l_return_status);
2869:
2870: IF l_return_status <> 'S'
2871: THEN
2872: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 3153: PA_TASK_PUB1.move_task_version(

3149: END IF ;
3150:
3151: -- PA L Changes 3010538
3152:
3153: PA_TASK_PUB1.move_task_version(
3154: p_calling_module => p_calling_module
3155: ,p_init_msg_list => l_init_msg_list
3156: ,p_structure_version_id => l_structure_version_id
3157: ,p_task_version_id => l_task_version_id

Line 3421: PA_TASK_PUB1.Update_Schedule_Version(

3417: --End add rtarway, 3908013
3418:
3419:
3420:
3421: PA_TASK_PUB1.Update_Schedule_Version(
3422: p_calling_module => p_calling_module
3423: ,p_init_msg_list => l_init_msg_list
3424: ,p_pev_schedule_id => l_pev_schedule_id
3425: ,p_calendar_id => p_calendar_id

Line 3550: -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.

3546: end if;
3547: end loop;
3548: end if;
3549:
3550: -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.
3551: --Bug 5256359. Introduced the loop to call pa_task_pub1.call_add_planning_txns
3552: --for set of 1000 records.
3553: rec_count:=0;
3554: for i in 1..l_add_task_ver_ids.count loop

Line 3551: --Bug 5256359. Introduced the loop to call pa_task_pub1.call_add_planning_txns

3547: end loop;
3548: end if;
3549:
3550: -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.
3551: --Bug 5256359. Introduced the loop to call pa_task_pub1.call_add_planning_txns
3552: --for set of 1000 records.
3553: rec_count:=0;
3554: for i in 1..l_add_task_ver_ids.count loop
3555:

Line 3570: pa_task_pub1.call_add_planning_txns(

3566:
3567: if rec_count=1000 OR
3568: i=l_add_task_ver_ids.count then
3569: begin
3570: pa_task_pub1.call_add_planning_txns(
3571: p_tasks_ver_ids => l_add_task_ver_ids_prm,
3572: p_planned_effort => l_add_planned_effort_prm,
3573: p_project_id => p_project_id,
3574: p_structure_version_id => l_structure_version_id, --replace p_structure_version_id, bug 3838186

Line 3586: p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));

3582: exception
3583: when others then
3584: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
3585: p_procedure_name => 'CREATE_PROJECT',
3586: p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
3587: raise fnd_api.g_exc_error;
3588: end;
3589:
3590: l_add_task_ver_ids_prm := PA_NUM_1000_NUM();

Line 3657: as PA_TASK_PUB1.update_task_det_sch_info() should be called for both versioning enabled

3653:
3654: -- Progress Management Changes. Bug # 3420093.
3655:
3656: /* Commenting out the condition to check if workplan versioning is enabled for the project
3657: as PA_TASK_PUB1.update_task_det_sch_info() should be called for both versioning enabled
3658: and versioning disabled projects. */
3659:
3660: /* if (PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(p_project_id) = 'Y') then */
3661:

Line 3662: /* Calling API: pa_task_pub1.update_task_det_sch_info() only if calling module is not 'FORMS'. */

3658: and versioning disabled projects. */
3659:
3660: /* if (PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(p_project_id) = 'Y') then */
3661:
3662: /* Calling API: pa_task_pub1.update_task_det_sch_info() only if calling module is not 'FORMS'. */
3663:
3664: if p_calling_module <> 'FORMS' then
3665:
3666: pa_task_pub1.update_task_det_sch_info(

Line 3666: pa_task_pub1.update_task_det_sch_info(

3662: /* Calling API: pa_task_pub1.update_task_det_sch_info() only if calling module is not 'FORMS'. */
3663:
3664: if p_calling_module <> 'FORMS' then
3665:
3666: pa_task_pub1.update_task_det_sch_info(
3667: p_calling_module => p_calling_module
3668: ,p_task_ver_id => l_task_version_id
3669: ,p_project_id => p_project_id
3670: ,p_planned_effort => p_planned_effort

Line 3812: PA_TASK_PUB1.Delete_Task_Version(

3808: END IF;
3809:
3810: IF l_task_version_id > 0
3811: THEN
3812: PA_TASK_PUB1.Delete_Task_Version(
3813: p_calling_module => p_calling_module
3814: ,p_structure_type => p_structure_type --bug 3301192
3815: ,p_task_version_id => l_task_version_id
3816: ,p_record_version_number => l_record_version_number

Line 4403: PA_TASK_PUB1.Create_Schedule_Version(

4399: END LOOP;
4400: --Now create the schedule versions for the workplan structure version and task versions.
4401: FOR cur_pa_proj_elem_vers_rec2 IN cur_pa_proj_elem_vers2 LOOP
4402: x_pev_schedule_id := null;
4403: PA_TASK_PUB1.Create_Schedule_Version(
4404: p_element_version_id => cur_pa_proj_elem_vers_rec2.element_version_id
4405: ,p_scheduled_start_date => SYSDATE
4406: ,p_scheduled_end_date => SYSDATE
4407: ,x_pev_schedule_id => x_pev_schedule_id

Line 4421: PA_TASK_PUB1.Create_Schedule_Version(

4417: raise api_error;
4418: END IF;
4419: FOR cur_pa_proj_elem_vers_rec3 IN cur_pa_proj_elem_vers3(cur_pa_proj_elem_vers_rec2.element_version_id) LOOP
4420: x_pev_schedule_id := null;
4421: PA_TASK_PUB1.Create_Schedule_Version(
4422: p_element_version_id => cur_pa_proj_elem_vers_rec3.element_version_id
4423: ,p_scheduled_start_date => SYSDATE
4424: ,p_scheduled_end_date => SYSDATE
4425: ,x_pev_schedule_id => x_pev_schedule_id

Line 5132: PA_TASK_PUB1.Create_Schedule_Version(

5128: , X_SOURCE_OBJECT_ID => p_project_id
5129: , X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
5130: );
5131:
5132: PA_TASK_PUB1.Create_Schedule_Version(
5133: p_element_version_id => x_structure_version_id
5134: ,p_scheduled_start_date => SYSDATE
5135: ,p_scheduled_end_date => SYSDATE
5136: ,x_pev_schedule_id => x_pev_schedule_id

Line 5392: PA_TASK_PUB1.Create_Schedule_Version(

5388: , X_SOURCE_OBJECT_ID => p_project_id
5389: , X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
5390: );
5391:
5392: PA_TASK_PUB1.Create_Schedule_Version(
5393: p_element_version_id => x_structure_version_id
5394: ,p_scheduled_start_date => SYSDATE
5395: ,p_scheduled_end_date => SYSDATE
5396: ,x_pev_schedule_id => x_pev_schedule_id

Line 5536: PA_TASK_PUB1.Create_Schedule_Version(

5532: , X_SOURCE_OBJECT_ID => p_project_id
5533: , X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
5534: );
5535:
5536: PA_TASK_PUB1.Create_Schedule_Version(
5537: p_element_version_id => x_structure_version_id
5538: ,p_scheduled_start_date => SYSDATE
5539: ,p_scheduled_end_date => SYSDATE
5540: ,x_pev_schedule_id => x_pev_schedule_id

Line 6299: --The following API is added to re-calculate task weights to call PA_TASK_PUB1.CALC_TASK_WEIGHTS

6295:
6296: END create_tasks_versions_only;
6297:
6298:
6299: --The following API is added to re-calculate task weights to call PA_TASK_PUB1.CALC_TASK_WEIGHTS
6300: --The API is called from PA_PROJECT_PUB.create_project and PA_PROJECT_PUB.update_project
6301:
6302: PROCEDURE recalc_task_weightings(
6303: p_tasks_in IN pa_project_pub.task_out_tbl_type

Line 6363: --To avoid no_data_found when this array is read in PA_TASK_PUB1.Cal_Task_weights

6359: END IF;
6360: j := j + 1;
6361: IF NVL( l_recalculate_flag, 'N' ) = 'Y' AND j >= 1000
6362: THEN
6363: --To avoid no_data_found when this array is read in PA_TASK_PUB1.Cal_Task_weights
6364: l_outline_level.extend;
6365: l_outline_level(l_outline_level.count) := null;
6366:
6367: /*--bug 2856033

Line 6392: PA_TASK_PUB1.Calc_Task_Weights(

6388: end if;
6389: --bug 2856033
6390: */
6391:
6392: PA_TASK_PUB1.Calc_Task_Weights(
6393: p_element_versions => l_tasks_ver_ids
6394: ,p_outline_level => l_outline_level
6395: ,p_top_sub_count => l_total_top_tasks
6396: ,x_return_status => l_return_status

Line 6447: --To avoid no_data_found when this array is read in PA_TASK_PUB1.Cal_Task_weights

6443:
6444: IF NVL( l_recalculate_flag, 'N' ) = 'Y'
6445: THEN
6446:
6447: --To avoid no_data_found when this array is read in PA_TASK_PUB1.Cal_Task_weights
6448: l_outline_level.extend;
6449: l_outline_level(l_outline_level.count) := null;
6450:
6451: /*--bug 2856033

Line 6477: PA_TASK_PUB1.Calc_Task_Weights(

6473: --bug 2856033
6474: */
6475:
6476:
6477: PA_TASK_PUB1.Calc_Task_Weights(
6478: p_element_versions => l_tasks_ver_ids
6479: ,p_outline_level => l_outline_level
6480: ,p_top_sub_count => l_total_top_tasks
6481: ,x_return_status => l_return_status

Line 10185: PA_TASK_PUB1.Create_Schedule_Version(

10181: ,'PA_PROJECTS'
10182: );
10183:
10184: --bug 3912603, insert records into pa_proj_elem_ver_Schedule, Satish, start
10185: PA_TASK_PUB1.Create_Schedule_Version(
10186: p_element_version_id => l_new_wp_ver_id
10187: ,p_scheduled_start_date => SYSDATE
10188: ,p_scheduled_end_date => SYSDATE
10189: ,x_pev_schedule_id => x_pev_schedule_id

Line 13549: --To avoid no_data_found when this array is read in PA_TASK_PUB1.Cal_Task_weights

13545: i := p_tasks_in.next(i);
13546: j := j + 1;
13547: END LOOP;
13548: END IF;
13549: --To avoid no_data_found when this array is read in PA_TASK_PUB1.Cal_Task_weights
13550: --l_tasks_ver_ids.extend;
13551: --l_tasks_ver_ids(l_tasks_ver_ids.count) := null;
13552: ELSE
13553: l_tasks_ver_ids(1) := p_task_version_id;

Line 14896: -- before calling api PA_TASK_PUB1.update_task

14892: -- carrying_out_organization_id, pm_task_reference, address_id, task_manager_person_id
14893: -- 2. l_parent_task_id
14894: -- 3. l_task_id -- the task that is being processed.
14895: -- l_proj_elem_rvn of record of pa_proj_elements to be updated
14896: -- before calling api PA_TASK_PUB1.update_task
14897:
14898: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
14899: l_task_in_rec.pa_task_id IS NULL -- new tasks to be crated
14900: THEN

Line 15275: pa_debug.g_err_stage := 'Calling API PA_TASK_PUB1.create_task';

15271: THEN
15272: IF p_create_task_version_only = 'N' THEN
15273:
15274: IF l_debug_mode = 'Y' THEN
15275: pa_debug.g_err_stage := 'Calling API PA_TASK_PUB1.create_task';
15276: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
15277: END IF;
15278: PA_TASK_PUB1.create_task(
15279: p_api_version => p_api_version_number

Line 15278: PA_TASK_PUB1.create_task(

15274: IF l_debug_mode = 'Y' THEN
15275: pa_debug.g_err_stage := 'Calling API PA_TASK_PUB1.create_task';
15276: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
15277: END IF;
15278: PA_TASK_PUB1.create_task(
15279: p_api_version => p_api_version_number
15280: ,p_commit => p_commit
15281: ,p_validate_only => FND_API.G_FALSE
15282: ,p_calling_module => p_calling_module

Line 15361: PA_TASK_PUB1.Update_Task(

15357: l_status_code := l_task_in_rec.STATUS_CODE;
15358: end if;
15359: -- Bug 6717386
15360:
15361: PA_TASK_PUB1.Update_Task(
15362: p_calling_module => 'AMG'
15363: ,p_init_msg_list => FND_API.G_FALSE
15364: ,p_task_id => l_task_in_rec.pa_task_id
15365: ,p_task_number => l_task_in_rec.pa_task_number

Line 16726: END IF; /* Before calling PA_TASK_PUB1 Create_Schedule_Version or Update_Schedule_Version*/

16722: END IF;
16723: --end bug 3035902 maansari
16724:
16725:
16726: END IF; /* Before calling PA_TASK_PUB1 Create_Schedule_Version or Update_Schedule_Version*/
16727:
16728: -- set the following after calling Create_Schedule_Version or Update_Schedule_Version
16729: -- px_tasks_out_tbl(i).return_status
16730:

Line 16734: -- set the following after calling api PA_TASK_PUB1.Create_Schedule_Version

16730:
16731: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
16732: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
16733: THEN
16734: -- set the following after calling api PA_TASK_PUB1.Create_Schedule_Version
16735: -- px_tasks_out_tbl(i).return_status
16736:
16737: -- Create a schedule version for the task version only if the workplan
16738: -- structure is involved.

Line 16745: PA_TASK_PUB1.Create_Schedule_Version(

16741: pa_debug.g_err_stage := 'Calling API create schedule version';
16742: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level4);
16743: END IF;
16744:
16745: PA_TASK_PUB1.Create_Schedule_Version(
16746: p_element_version_id => l_task_version_id
16747: ,p_init_msg_list => FND_API.G_FALSE
16748: ,p_scheduled_start_date => l_scheduled_start_date
16749: ,p_scheduled_end_date => l_scheduled_finish_date

Line 16877: -- set the following after calling api PA_TASK_PUB1.Update_Schedule_Version

16873: --rtarway, 4099429 end
16874:
16875:
16876: ELSE -- in update task case
16877: -- set the following after calling api PA_TASK_PUB1.Update_Schedule_Version
16878: -- px_tasks_out_tbl(i).return_status
16879:
16880:
16881: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --bug 4145893 do not call PJI.plan_update api

Line 16881: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --bug 4145893 do not call PJI.plan_update api

16877: -- set the following after calling api PA_TASK_PUB1.Update_Schedule_Version
16878: -- px_tasks_out_tbl(i).return_status
16879:
16880:
16881: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --bug 4145893 do not call PJI.plan_update api
16882: --if tasks are updated in bulk.
16883: --This should set for every single task.
16884: PA_TASK_PUB1.Update_Schedule_Version(
16885: p_calling_module => p_calling_module

Line 16884: PA_TASK_PUB1.Update_Schedule_Version(

16880:
16881: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --bug 4145893 do not call PJI.plan_update api
16882: --if tasks are updated in bulk.
16883: --This should set for every single task.
16884: PA_TASK_PUB1.Update_Schedule_Version(
16885: p_calling_module => p_calling_module
16886: ,p_init_msg_list => FND_API.G_FALSE
16887: ,p_pev_schedule_id => l_ver_sch_attr_rec.pev_schedule_id
16888: ,p_calendar_id => l_task_in_rec.calendar_id

Line 16946: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := NULL;

16942:
16943: );
16944:
16945: --bug 4149392
16946: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := NULL;
16947: --end bug 4149392
16948:
16949: px_tasks_out_tbl(i).return_status := x_return_status;
16950:

Line 17029: pa_task_pub1.update_task_det_sch_info(

17025: -- End addition for bug 6458891
17026:
17027: --Added by rtarway for BUG 39198900
17028: IF p_calling_module <> 'FORMS' and l_update_task_det_flag = 'Y' THEN /* Added flag check for Bug 6458891 */
17029: pa_task_pub1.update_task_det_sch_info(
17030: p_calling_module => p_calling_module
17031: ,p_task_ver_id => l_task_version_id
17032: ,p_project_id => p_project_id
17033: ,p_planned_effort => l_task_in_rec.planned_effort

Line 17718: -- -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.

17714: -- end loop;
17715: -- end if;--Bug3802469, rtarway
17716: -- end if;
17717: --
17718: -- -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.
17719: --
17720: --
17721: -- begin
17722: -- --BUG 3802469, rtarway , if the tasks table is empty, l_add_task_ver_ids will not be populated.

Line 17726: -- pa_task_pub1.call_add_planning_txns(

17722: -- --BUG 3802469, rtarway , if the tasks table is empty, l_add_task_ver_ids will not be populated.
17723: -- --Check needed before calling call_add_planning_txns, to see if l_add_task_ver_ids is empty
17724: -- if ( l_add_task_ver_ids IS NOT NULL AND l_add_task_ver_ids.count > 0)
17725: -- then
17726: -- pa_task_pub1.call_add_planning_txns(
17727: -- p_tasks_ver_ids => l_add_task_ver_ids,
17728: -- p_planned_effort => l_add_planned_effort,
17729: -- p_project_id => p_project_id,
17730: -- p_structure_version_id => l_structure_version_id, --replace p_structure_version_id, bug 3838186

Line 17745: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));

17741: -- exception
17742: -- when others then
17743: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17744: -- p_procedure_name => 'CREATE_PROJECT',
17745: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
17746: -- raise fnd_api.g_exc_error;
17747: -- end;
17748: --
17749: -- -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.

Line 17808: -- -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.

17804: -- end if;
17805: -- end loop;
17806: -- end if;
17807: --
17808: -- -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.
17809: --
17810: -- begin
17811: -- --BUG3802469, rtarway, see comments above
17812: -- if ( l_add_task_ver_ids IS NOT NULL and l_add_task_ver_ids.count > 0)

Line 17814: -- pa_task_pub1.call_add_planning_txns(

17810: -- begin
17811: -- --BUG3802469, rtarway, see comments above
17812: -- if ( l_add_task_ver_ids IS NOT NULL and l_add_task_ver_ids.count > 0)
17813: -- then
17814: -- pa_task_pub1.call_add_planning_txns(
17815: -- p_tasks_ver_ids => l_add_task_ver_ids,
17816: -- p_planned_effort => l_add_planned_effort,
17817: -- p_project_id => p_project_id,
17818: -- p_structure_version_id => l_structure_version_id, --replace p_structure_version_id, bug 3838186

Line 17833: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));

17829: -- exception
17830: -- when others then
17831: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17832: -- p_procedure_name => 'CREATE_PROJECT',
17833: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
17834: -- raise fnd_api.g_exc_error;
17835: -- end;
17836: --
17837: -- -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.

Line 19783: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --4149392 fixed during fixing 4186512

19779: -- Bug 3762882 : This code should be commented as FP is also
19780: -- pushing actuals for resource assignments so we should not push it for tasks here.
19781: -- BEGIN Bug 4284444 : Commented
19782:
19783: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --4149392 fixed during fixing 4186512
19784:
19785: --bug 4019845
19786: IF (l_publish_flag = 'Y') THEN
19787: --*******************************************

Line 19828: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null; --set the flag so that PJI rolls up data on the working version.

19824:
19825: IF l_debug_mode = 'Y' THEN
19826: pa_debug.write(G_PKG_NAME, 'Calling PLAN_UPDATE in PUBLISH mode for working version', 3);
19827: END IF;
19828: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null; --set the flag so that PJI rolls up data on the working version.
19829:
19830: PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE (x_msg_code => l_msg_code,
19831: p_plan_version_id => l_plan_version_id, --bug 4587145
19832: x_return_status => x_return_status);

Line 19838: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --Set the flag back to 'N' to bypass any PJI rollup api call untill explicit plan_update gets called.

19834: IF l_debug_mode = 'Y' THEN
19835: pa_debug.write(G_PKG_NAME,'After PLAN_UPDATE in PUBLISH mode for working verison x_return_status='||
19836: x_return_status,l_debug_level3);
19837: END IF;
19838: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --Set the flag back to 'N' to bypass any PJI rollup api call untill explicit plan_update gets called.
19839: EXCEPTION
19840: WHEN OTHERS THEN
19841: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TASK_STRUC_PUB',
19842: p_procedure_name => 'PROCESS_WBS_UPDATES',

Line 20452: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := NULL;

20448: END IF;
20449:
20450: --bug 4149392
20451:
20452: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := NULL;
20453: BEGIN
20454:
20455: --bug 4587145
20456: BEGIN

Line 20708: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;

20704:
20705: --bug 4186512
20706: --set the PJI global flag to NULL before calling pji wbsmant for
20707: --indent/outdent/copy/move
20708: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
20709:
20710: BEGIN -- Bug 4284444
20711: --both working version
20712: IF l_debug_mode = 'Y' THEN

Line 20988: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;

20984:
20985: -- Begin Bug # 4611373.
20986: --set the PJI global flag to NULL before calling pji wbsmant for
20987: --indent/outdent/copy/move
20988: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
20989:
20990: BEGIN
20991: --both working version
20992: IF l_debug_mode = 'Y' THEN