DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_PROJ_ELEMENTS_UTILS

Line 457: IF PA_PROJ_ELEMENTS_UTILS.Check_element_number_Unique

453:
454: --Bug 2168170
455: --dbms_output.put_line('Inside private API');
456: --dbms_output.put_line( 'Check if the task name is unique within the project.'||l_task_number);
457: IF PA_PROJ_ELEMENTS_UTILS.Check_element_number_Unique
458: (
459: p_element_number => l_task_number --Bug 3705333 Changed from p_task_number to l_task_number
460: ,p_element_id => null
461: ,p_project_id => p_project_id

Line 489: If (PA_PROJ_ELEMENTS_UTILS.check_element_number_unique(l_task_number, --Bug 3705333 Changed from p_task_number to l_task_number

485: --end bug 2669388
486: --dbms_output.put_line( 'After Check if the task name is unique within the project.' );
487:
488: --Check if the task name is unique within the project
489: If (PA_PROJ_ELEMENTS_UTILS.check_element_number_unique(l_task_number, --Bug 3705333 Changed from p_task_number to l_task_number
490: NULL,
491: p_project_id,
492: p_structure_id) <> 'Y') THEN
493: --Name is not unique

Line 597: l_TYPE_ID := PA_PROJ_ELEMENTS_UTILS.GET_DEFAULT_TASK_TYPE_ID;

593: IF ( p_TYPE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_TYPE_ID IS NULL )
594: THEN
595: --IF (p_TYPE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_object_type = 'PA_TASKS') THEN
596: IF (p_object_type = 'PA_TASKS') THEN
597: l_TYPE_ID := PA_PROJ_ELEMENTS_UTILS.GET_DEFAULT_TASK_TYPE_ID;
598: ELSE
599: l_TYPE_ID := NULL;
600: END IF;
601: ELSE

Line 964: pa_proj_elements_utils.Check_create_subtask_ok

960: end if;
961: -- 12700283: added if-else condition to check workplan versioning is enabled or not.. end.
962: -- 13102269: bypassing all validations of Check_create_subtask_ok API for peer task.
963: IF p_peer_or_sub = 'SUB' then
964: pa_proj_elements_utils.Check_create_subtask_ok
965: ( l_ref_parent_task_ver_id
966: ,l_return_status
967: ,l_error_message_code );
968:

Line 1976: If (PA_PROJ_ELEMENTS_UTILS.check_element_number_unique(l_task_number, --Bug 3705333 changed from p_task_number to l_task_number

1972: case below:
1973: Task 1.0 to be re-named to Taslk 1.1 and Task 1.1 to be renamed to Task 1.0 **/
1974: --Check if the task name is unique within the project
1975: /* Code below is uncommented for bug 4218947 **/
1976: If (PA_PROJ_ELEMENTS_UTILS.check_element_number_unique(l_task_number, --Bug 3705333 changed from p_task_number to l_task_number
1977: p_task_id,
1978: v_cur_proj_elems_rec.project_id,
1979: v_cur_proj_elems_rec.PARENT_STRUCTURE_ID) <> 'Y') THEN
1980: --Name is not unique

Line 2015: IF ('N' = pa_proj_elements_utils.IS_TOP_TASK_ACROSS_ALL_VER(

2011: IF ( p_phase_version_id IS NOT NULL) AND
2012: (p_phase_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
2013:
2014: -- check if it is top task
2015: IF ('N' = pa_proj_elements_utils.IS_TOP_TASK_ACROSS_ALL_VER(
2016: p_task_id)) THEN
2017: --Is not a top task across all versions. Error
2018: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_NOT_ALL_TOP_TASKS');
2019: -- start of bug 3459905

Line 2033: IF ('Y' = pa_proj_elements_utils.CHECK_PHASE_IN_USE(

2029: -- end of bug 3459905
2030: END IF;
2031:
2032: -- check if the current phase is already used.
2033: IF ('Y' = pa_proj_elements_utils.CHECK_PHASE_IN_USE(
2034: p_task_id,
2035: p_phase_version_id)) THEN
2036: -- Phase already in use in the structure. Error
2037: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_PHASE_IN_USE');

Line 2400: l_del_cnt:=PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hie_upd(l_task_version_id);

2396: OPEN get_task_versions_id(p_task_id,l_project_id);
2397: LOOP
2398: FETCH get_task_versions_id INTO l_task_version_id;
2399: EXIT WHEN get_task_versions_id%NOTFOUND;
2400: l_del_cnt:=PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hie_upd(l_task_version_id);
2401: -- IF l_del_cnt >=1 AND p_Base_Perc_Comp_Deriv_Code LIKE 'DELIVERABLE' THEN --Jun 28th
2402: IF l_del_cnt >=1 AND (p_Base_Perc_Comp_Deriv_Code LIKE 'DELIVERABLE'
2403: OR l_tt_base_perc_comp_der_cd LIKE 'DELIVERABLE' ) THEN --Jun 28th
2404: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 2415: l_del_cnt:=PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hie_upd(l_task_version_id);

2411: OPEN get_task_versions_id2(p_task_id,l_project_id);
2412: LOOP
2413: FETCH get_task_versions_id2 INTO l_task_version_id;
2414: EXIT WHEN get_task_versions_id2%NOTFOUND;
2415: l_del_cnt:=PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hie_upd(l_task_version_id);
2416: -- IF l_del_cnt >=1 AND p_Base_Perc_Comp_Deriv_Code LIKE 'DELIVERABLE' THEN --Jun 28th
2417: IF l_del_cnt >=1 AND (p_Base_Perc_Comp_Deriv_Code LIKE 'DELIVERABLE'
2418: OR l_tt_base_perc_comp_der_cd LIKE 'DELIVERABLE' ) THEN --Jun 28th
2419: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 2919: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(P_Task_ID);

2915:
2916: -- Modified for FP_M changes
2917: -- Tracking Bug 3305199
2918:
2919: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(P_Task_ID);
2920:
2921: IF (NVL( l_published_version, 'N' ) = 'N' and l_fin_task_flag = 'Y') OR
2922: (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y' and l_fin_task_flag = 'Y') -- Bug 3305199
2923: THEN

Line 3006: IF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(p_task_id) = 'Y') THEN

3002: -- end xxlu changes
3003: ELSE --Added for transaction dates update
3004: --there is a publish version; update task that have financial attribute
3005: -- This code will excecute for fully shared and versioning enabled case
3006: IF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(p_task_id) = 'Y') THEN
3007: -- xxlu add task DFF attributes
3008: --bug 3690807
3009:
3010: -- Changed SUBSTR to SUBSTRB for 3935874

Line 3119: PA_PROJ_ELEMENTS_UTILS.Check_chg_stat_cancel_ok (

3115:
3116: --maansari
3117: IF PA_PROGRESS_UTILS.get_system_task_status( l_STATUS_CODE ) = 'CANCELLED'
3118: THEN
3119: PA_PROJ_ELEMENTS_UTILS.Check_chg_stat_cancel_ok (
3120: p_task_id => p_task_id
3121: ,p_task_version_id => l_latest_task_ver_rec.element_version_id
3122: ,p_new_task_status => l_STATUS_CODE
3123: ,x_return_status => l_return_status

Line 3521: l_ref_parent_task_ver_id:=PA_PROJ_ELEMENTS_UTILS.GET_PARENT_TASK_VERSION_ID(p_ref_task_version_id);

3517: --
3518: --Bug No 3450684 Smukka 04/Mar/04 Checking for deliverable
3519: --Bug No 3475920
3520: IF p_peer_or_sub = 'PEER' THEN
3521: l_ref_parent_task_ver_id:=PA_PROJ_ELEMENTS_UTILS.GET_PARENT_TASK_VERSION_ID(p_ref_task_version_id);
3522: ELSE
3523: l_ref_parent_task_ver_id:=p_ref_task_version_id;
3524: END IF;
3525: --Bug No 3475920

Line 3530: IF PA_PROJ_ELEMENTS_UTILS.check_task_parents_deliv(l_ref_parent_task_ver_id) = 'Y' THEN

3526: OPEN get_task_detail(p_task_id);
3527: FETCH get_task_detail INTO l_base_deriv_code;
3528: CLOSE get_task_detail;
3529: IF l_base_deriv_code LIKE 'DELIVERABLE' THEN
3530: IF PA_PROJ_ELEMENTS_UTILS.check_task_parents_deliv(l_ref_parent_task_ver_id) = 'Y' THEN
3531: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3532: p_msg_name => 'PA_TASK_AND_PARENTTASK_DEL');
3533: raise FND_API.G_EXC_ERROR;
3534: END IF;

Line 3621: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

3617:
3618: --hsiu: bug 2695631
3619: --copy structure version should not validate when creating tasks
3620: IF (p_validation_level <> 0) THEN
3621: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
3622: p_parent_task_ver_id => l_parent_id
3623: ,x_return_status => l_return_status
3624: ,x_error_message_code => l_error_message_code
3625: );

Line 3653: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

3649: End if; /** Changes end for performance BUg 4046026 */
3650: --hsiu: bug 2695631
3651: --copy structure version should not validate when creating tasks
3652: IF (p_validation_level <> 0) THEN
3653: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
3654: p_parent_task_ver_id => p_ref_task_version_id
3655: ,x_return_status => l_return_status
3656: ,x_error_message_code => l_error_message_code
3657: );

Line 3690: l_link_task_flag := PA_PROJ_ELEMENTS_UTILS.link_flag ( p_task_id );

3686: END IF;
3687: END IF;
3688:
3689: --Display sequence is null if the task is a linking task.
3690: l_link_task_flag := PA_PROJ_ELEMENTS_UTILS.link_flag ( p_task_id );
3691: IF l_link_task_flag = 'Y'
3692: THEN
3693: l_DISPLAY_SEQUENCE := null;
3694: END IF;

Line 3785: -- AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N' commenitng out for bug 4180390

3781: WHERE display_sequence > l_ref_seq_no
3782: AND element_version_id <> x_task_version_id
3783: AND parent_structure_version_id = v_cur_proj_elems_rec.parent_structure_version_id
3784: AND object_type = 'PA_TASKS'
3785: -- AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N' commenitng out for bug 4180390
3786: ;
3787: ELSE
3788: IF p_peer_or_sub = 'PEER' --Bug 4046026
3789: THEN

Line 3796: --AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N' commenitng out for bug 4180390

3792: WHERE display_sequence > l_ref_seq_no
3793: AND element_version_id <> x_task_version_id
3794: AND parent_structure_version_id = v_cur_proj_elems_rec.parent_structure_version_id
3795: AND object_type = 'PA_TASKS'
3796: --AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N' commenitng out for bug 4180390
3797: ;
3798: END IF;
3799: END IF; --Added for Bug 4046026 Commented for 4057190 /** Uncommented it again for BUg 4046026 **/
3800: END IF; --End changes for bug 13923366

Line 3860: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS (

3856: IF l_link_task_flag = 'N'
3857: THEN
3858: --my_error_msg( 'In create_task_version pvt API Stage 6' );
3859:
3860: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS (
3861: p_commit => p_commit
3862: ,p_debug_mode => p_debug_mode
3863: ,p_parent_structure_ver_id => l_parent_struc_ver_id
3864: ,p_task_id => x_task_version_id

Line 4275: -- IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,p_task_version_id) = 'Y' THEN

4271: end;
4272: --Bug 13895419 end
4273: --Bug No 3450684 Smukka 04/Mar/04 Checking for deliverable
4274: --Bug No 3475920 SMukka Commented out following logic to check for deliverable.
4275: -- IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,p_task_version_id) = 'Y' THEN
4276: -- IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,p_ref_task_version_id) = 'Y' THEN
4277: -- PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4278: -- p_msg_name => 'PA_PS_CHK_DELIV_UPDATE');
4279: -- raise FND_API.G_EXC_ERROR;

Line 4276: -- IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,p_ref_task_version_id) = 'Y' THEN

4272: --Bug 13895419 end
4273: --Bug No 3450684 Smukka 04/Mar/04 Checking for deliverable
4274: --Bug No 3475920 SMukka Commented out following logic to check for deliverable.
4275: -- IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,p_task_version_id) = 'Y' THEN
4276: -- IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,p_ref_task_version_id) = 'Y' THEN
4277: -- PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4278: -- p_msg_name => 'PA_PS_CHK_DELIV_UPDATE');
4279: -- raise FND_API.G_EXC_ERROR;
4280: -- END IF;

Line 4756: -- if p_peer_or_sub is Sub or parent task is not same for source and destination task, then call PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS.

4752: END LOOP;
4753:
4754: --updating wbs number only once after making display seq null
4755: --Bug 13895419 start
4756: -- if p_peer_or_sub is Sub or parent task is not same for source and destination task, then call PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS.
4757: IF p_peer_or_sub = 'SUB' or (p_peer_or_sub = 'PEER' and l_parent_task_id <> l_ref_parent_task_id)
4758: then
4759: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
4760: ( p_commit => p_commit

Line 4759: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS

4755: --Bug 13895419 start
4756: -- if p_peer_or_sub is Sub or parent task is not same for source and destination task, then call PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS.
4757: IF p_peer_or_sub = 'SUB' or (p_peer_or_sub = 'PEER' and l_parent_task_id <> l_ref_parent_task_id)
4758: then
4759: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
4760: ( p_commit => p_commit
4761: ,p_debug_mode => p_debug_mode
4762: ,p_parent_structure_ver_id => l_parent_struc_ver_id
4763: ,p_task_id => NULL

Line 5119: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS

5115:
5116: --update wbs number for affected tasks
5117: -- Insert
5118: --update WBS NUMBER properly now for the affected rows.
5119: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
5120: ( p_commit => p_commit
5121: ,p_debug_mode => p_debug_mode
5122: ,p_parent_structure_ver_id => cur_affected_tasks_rec.parent_structure_version_id
5123: ,p_task_id => cur_affected_tasks_rec.element_version_id

Line 5178: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS

5174:
5175: --update wbs number for actual tasks
5176: -- Insert
5177: --update WBS NUMBER properly now
5178: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
5179: ( p_commit => p_commit
5180: ,p_debug_mode => p_debug_mode
5181: ,p_parent_structure_ver_id => cur_actual_tasks_rec.parent_structure_version_id
5182: ,p_task_id => cur_actual_tasks_rec.element_version_id

Line 5225: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS

5221: -- dbms_output.put_line( 'cur_affected_tasks_rec.display_sequence '|| cur_affected_tasks_rec.display_sequence );
5222: --update wbs number for affected tasks
5223: -- Insert
5224: --update WBS NUMBER properly now for the affected rows.
5225: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
5226: ( p_commit => p_commit
5227: ,p_debug_mode => p_debug_mode
5228: ,p_parent_structure_ver_id => cur_affected_tasks_rec.parent_structure_version_id
5229: ,p_task_id => cur_affected_tasks_rec.element_version_id

Line 5248: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS

5244: l_start_display_seq := nvl(l_ref_task_last_child_seq_num, l_ref_task_seq_num);
5245: l_end_display_seq := nvl(l_task_last_child_seq_num, l_task_seq_num);
5246: END IF;
5247: FOR cur_affected_tasks_rec IN c1(l_start_display_seq, l_end_display_seq) LOOP
5248: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
5249: ( p_commit => p_commit
5250: ,p_debug_mode => p_debug_mode
5251: ,p_parent_structure_ver_id => cur_affected_tasks_rec.parent_structure_version_id
5252: ,p_task_id => cur_affected_tasks_rec.element_version_id

Line 5693: IF ('N' = pa_proj_elements_utils.check_task_in_structure(

5689: --added on 08-JAN-2002
5690: --check if task is linked task
5691: IF (p_structure_version_id IS NOT NULL) AND
5692: (p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
5693: IF ('N' = pa_proj_elements_utils.check_task_in_structure(
5694: p_structure_version_id,
5695: p_task_version_id)) THEN
5696: --deleting linked task. Error
5697: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5804: IF l_delete_flag = 'Y' AND PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id )= 'Y'

5800: END IF;
5801: END IF ; -- Bug#3834117
5802: END IF;
5803:
5804: IF l_delete_flag = 'Y' AND PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id )= 'Y'
5805: -- Added for FP_M changes Bug 3305199 Bhumesh
5806: THEN
5807:
5808: -- Added for FP_M changes

Line 5909: --The following code is reqd. to pass calling mode to check api bcoz PA_PROJ_ELEMENTS_UTILS.check_delete_task_ver_ok again calls

5905: --check_delete_task ok
5906:
5907: --dbms_output.put_line( 'before chk_delete ' );
5908:
5909: --The following code is reqd. to pass calling mode to check api bcoz PA_PROJ_ELEMENTS_UTILS.check_delete_task_ver_ok again calls
5910: --PA_TASK_UTILS.check_delete_task_ok api
5911: --bug 2947492
5912: --commenting out the 'R'estricted mode logic for bug 3010538
5913: -- IF p_calling_module = 'AMG'

Line 5924: PA_PROJ_ELEMENTS_UTILS.check_delete_task_ver_ok(

5920:
5921: /* bug 4006401--removed since it is called in PUB.
5922: IF p_called_from_api <> 'MOVE_TASK_VERSION'
5923: THEN
5924: PA_PROJ_ELEMENTS_UTILS.check_delete_task_ver_ok(
5925: p_project_id => x_project_id
5926: ,p_task_version_id => cur_child_tasks_rec.object_id_to1
5927: ,p_parent_structure_ver_id => x_parent_struc_ver_id
5928: --bug 3010538 ,p_validation_mode => l_validation_mode --bug 2947492

Line 5947: IF PA_PROJ_ELEMENTS_UTILS.structure_type(

5943:
5944: --deleting schedule version if its a workplan
5945: --IF workplan_structure THEN
5946: IF p_called_from_api <> 'MOVE_TASK_VERSION' THEN
5947: IF PA_PROJ_ELEMENTS_UTILS.structure_type(
5948: p_structure_version_id => null
5949: ,p_task_version_id => cur_child_tasks_rec.object_id_to1
5950: ,p_structure_type => 'WORKPLAN' ) = 'Y' THEN
5951:

Line 6097: IF l_delete_flag = 'Y' AND PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id )= 'Y'

6093: */
6094: -- 4201927 end
6095:
6096: /*
6097: IF l_delete_flag = 'Y' AND PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id )= 'Y'
6098: -- Added for FP_M changes Bug 3305199 Bhumesh
6099: THEN
6100:
6101: -- Added for FP_M changes

Line 6329: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS (

6325: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N') = 'N' THEN
6326:
6327: --Ansari
6328: --Call update wbs number
6329: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS (
6330: p_commit => p_commit
6331: ,p_debug_mode => p_debug_mode
6332: ,p_parent_structure_ver_id => x_parent_struc_ver_id
6333: ,p_task_id => null

Line 6619: AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N';

6615: SET display_sequence = PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, 0, l_task_cnt, 'DELETE', 'DOWN')
6616: -- record_version_number = record_version_number + 1
6617: WHERE parent_structure_version_id = x_parent_struc_ver_id
6618: AND (display_sequence > l_selected_seq_num)
6619: AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N';
6620: EXCEPTION
6621: WHEN OTHERS THEN
6622: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
6623: raise FND_API.G_EXC_ERROR;

Line 7336: PA_PROJ_ELEMENTS_UTILS.Check_Date_range(

7332: END IF;
7333: -- end xxlu changes.
7334:
7335:
7336: PA_PROJ_ELEMENTS_UTILS.Check_Date_range(
7337: p_scheduled_start_date => l_scheduled_start_date
7338: ,p_scheduled_end_date => l_scheduled_end_date
7339: ,p_obligation_start_date => l_obligation_start_date
7340: ,p_obligation_end_date => l_obligation_end_date

Line 8479: PA_PROJ_ELEMENTS_UTILS.Check_Date_range(

8475: l_level_assignments_flag := p_level_assignments_flag;
8476: END IF;
8477: --end bug 3305199
8478:
8479: PA_PROJ_ELEMENTS_UTILS.Check_Date_range(
8480: p_scheduled_start_date => l_scheduled_start_date
8481: ,p_scheduled_end_date => l_scheduled_end_date
8482: ,p_obligation_start_date => l_obligation_start_date
8483: ,p_obligation_end_date => l_obligation_end_date

Line 9006: IF PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => cur_proj_elem_ver_sch_rec.ELEMENT_VERSION_ID ) = 'Y'

9002:
9003: END IF;
9004:
9005: --bug 3301192 fp changes
9006: IF PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => cur_proj_elem_ver_sch_rec.ELEMENT_VERSION_ID ) = 'Y'
9007: THEN
9008:
9009: open get_parent_struc_ver_id(cur_proj_elem_ver_sch_rec.ELEMENT_VERSION_ID);
9010: fetch get_parent_struc_ver_id INTO l_parent_struc_ver_id;

Line 9823: IF PA_PROJ_ELEMENTS_UTILS.structure_type(

9819:
9820: --deleting schedule version if its a workplan
9821: --IF workplan_structure THEN
9822: --IF p_called_from_api <> 'MOVE_TASK_VERSION' THEN
9823: IF PA_PROJ_ELEMENTS_UTILS.structure_type(
9824: p_structure_version_id => null
9825: ,p_task_version_id => cur_child_tasks_rec.object_id_to1
9826: ,p_structure_type => 'WORKPLAN' ) = 'Y' THEN
9827:

Line 10108: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS (

10104: --Ansari
10105: --Call update wbs number
10106: --hsiu: bug 2800553: performance changes: not called when deleting structure
10107: IF (p_calling_module <> 'DEL_STRUCT') THEN
10108: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS (
10109: p_commit => p_commit
10110: ,p_debug_mode => p_debug_mode
10111: ,p_parent_structure_ver_id => x_parent_struc_ver_id
10112: ,p_task_id => null

Line 10274: AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N';

10270: SET display_sequence = PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, 0, l_task_cnt, 'DELETE', 'DOWN')
10271: -- record_version_number = record_version_number + 1
10272: WHERE parent_structure_version_id = x_parent_struc_ver_id
10273: AND (display_sequence > l_selected_seq_num)
10274: AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N';
10275: EXCEPTION
10276: WHEN OTHERS THEN
10277: PA_UTILS.ADD_MESSAGE('PA', 'PA_TASK_SEQ_NUM_ERR');
10278: raise FND_API.G_EXC_ERROR;

Line 10605: l_parent_struc_ver_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id( p_project_id, 'WORKPLAN' );

10601: BEGIN
10602: IF PA_PROGRESS_UTILS.get_system_task_status( p_task_status ) = 'CANCELLED'
10603: THEN
10604: l_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( p_project_id );
10605: l_parent_struc_ver_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id( p_project_id, 'WORKPLAN' );
10606:
10607: --Store the whole branch of published version under p_task_id in pl/sql table.
10608: FOR cur_task_hier_rec IN cur_task_hier(l_parent_struc_ver_id) LOOP
10609: i := i + 1;