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_PROJ_ELEMENTS_UTILS

Line 262: IF PA_PROJ_ELEMENTS_UTILS.Check_element_number_Unique

258: END IF;
259:
260: --Bug 2168170
261:
262: IF PA_PROJ_ELEMENTS_UTILS.Check_element_number_Unique
263: (
264: p_element_number => rtrim(p_task_number)
265: ,p_element_id => null
266: ,p_project_id => p_project_id

Line 2340: PA_PROJ_ELEMENTS_UTILS.Check_Del_all_task_Ver_Ok(p_project_id => l_task_info_rec.project_id

2336: */
2337: --6023347: No need to check tasks if complete version is to be deleted from Workplan Version Disabling
2338: IF p_calling_from <> 'DEL_WP_STRUC_DISABLE_VERSION' THEN -- 6023347
2339: --Check if it is okay to delete task version. Also checks financial task
2340: PA_PROJ_ELEMENTS_UTILS.Check_Del_all_task_Ver_Ok(p_project_id => l_task_info_rec.project_id
2341: ,p_task_version_id => p_task_version_id
2342: ,p_parent_structure_ver_id => l_structure_version_id -- 4068685
2343: ,x_return_status => l_return_status
2344: ,x_error_message_code => l_error_msg_code);

Line 4058: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(

4054: (p_src_project_name IS NOT NULL)) OR
4055: ((p_src_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
4056: (p_src_project_id IS NOT NULL)) THEN
4057: --Call Check API.
4058: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(
4059: p_project_name => p_src_project_name,
4060: p_project_id => p_src_project_id,
4061: x_project_id => l_src_project_id,
4062: x_return_status => l_return_status,

Line 4125: PA_PROJ_ELEMENTS_UTILS.task_Ver_Name_Or_Id

4121: --Call Check API.
4122:
4123: --dbms_output.put_line( 'Before Id to name conv. task_Ver_Name_Or_Id' );
4124:
4125: PA_PROJ_ELEMENTS_UTILS.task_Ver_Name_Or_Id
4126: (
4127: p_task_name => p_src_task_name
4128: ,p_task_version_id => p_src_task_version_id
4129: ,p_structure_version_id => l_src_structure_version_id

Line 4338: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

4334: IF (l_peer_or_sub = 'PEER') THEN
4335: OPEN get_parent_version_id(l_ref_task_version_id);
4336: FETCH get_parent_version_id into l_parent_ver_id;
4337: CLOSE get_parent_version_id;
4338: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
4339: p_parent_task_ver_id => l_parent_ver_id
4340: ,x_return_status => l_return_status
4341: ,x_error_message_code => l_error_msg_code);
4342:

Line 4349: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

4345: p_msg_name => l_error_msg_code);
4346: raise FND_API.G_EXC_ERROR;
4347: END IF;
4348: ELSE
4349: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
4350: p_parent_task_ver_id => l_ref_task_version_id
4351: ,x_return_status => l_return_status
4352: ,x_error_message_code => l_error_msg_code
4353: );

Line 4388: l_lowest_task_flag1 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_dest_task_version_id );

4384:
4385: --check the task is a lowest task bug 3301192
4386: IF p_dest_structure_version_id <> p_dest_task_version_id /* reference should not be str ver */
4387: THEN
4388: l_lowest_task_flag1 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_dest_task_version_id );
4389: END IF;
4390:
4391: --dbms_output.put_line( 'l_element_version_id '||l_element_version_id );
4392:

Line 5385: l_lowest_task_flag2 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_dest_task_version_id );

5381: -- END OF BLOCK MOVED FOR P1 BUG 4210796
5382:
5383: IF l_wp_type = 'Y' AND p_dest_structure_version_id <> p_dest_task_version_id
5384: THEN
5385: l_lowest_task_flag2 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_dest_task_version_id );
5386:
5387: IF l_lowest_task_flag1 = 'Y' AND
5388: l_lowest_task_flag2 = 'N' /* reference task is no more a lowest task therefore call delete planning api */
5389: THEN

Line 6020: IF ('Y' = pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(

6016: INTO l_proj_element_id
6017: FROM PA_PROJ_ELEMENT_VERSIONS
6018: WHERE element_version_id = p_task_version_id;
6019:
6020: IF ('Y' = pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(
6021: l_proj_element_id)) THEN
6022: --Indenting a task with phase. Error
6023: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_NO_MOVE_PHASE_TASK');
6024: END IF;

Line 6089: PA_PROJ_ELEMENTS_UTILS.check_move_task_ok(

6085: end if;
6086:
6087: --hsiu added for task status
6088: --check if ok to move this task
6089: PA_PROJ_ELEMENTS_UTILS.check_move_task_ok(
6090: p_task_ver_id => p_task_version_id
6091: ,x_return_status => l_return_status
6092: ,x_error_message_code => l_error_msg_code
6093: );

Line 6132: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

6128: END IF;
6129: END IF;
6130: --end bug 3069306
6131:
6132: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
6133: p_parent_task_ver_id => l_parent_ver_id
6134: ,x_return_status => l_return_status
6135: ,x_error_message_code => l_error_msg_code
6136: );

Line 6171: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

6167: END IF;
6168: END IF;
6169: --end bug 3069306
6170:
6171: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
6172: p_parent_task_ver_id => p_ref_task_version_id
6173: ,x_return_status => l_return_status
6174: ,x_error_message_code => l_error_msg_code
6175: );

Line 6200: l_lowest_task_flag1 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_ref_task_version_id );

6196: --check the task is a lowest task bug 3301192
6197:
6198: IF l_ref_parent_struct_ver_id <> p_ref_task_version_id
6199: THEN
6200: l_lowest_task_flag1 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_ref_task_version_id );
6201: END IF;
6202: --
6203: --Bug No 3475920
6204: IF p_peer_or_sub = 'PEER' THEN

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

6201: END IF;
6202: --
6203: --Bug No 3475920
6204: IF p_peer_or_sub = 'PEER' THEN
6205: l_ref_parent_task_ver_id:=PA_PROJ_ELEMENTS_UTILS.GET_PARENT_TASK_VERSION_ID(p_ref_task_version_id);
6206: ELSE
6207: l_ref_parent_task_ver_id:=p_ref_task_version_id;
6208: END IF;
6209: --

Line 6210: IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,l_ref_parent_task_ver_id) = 'Y' THEN

6206: ELSE
6207: l_ref_parent_task_ver_id:=p_ref_task_version_id;
6208: END IF;
6209: --
6210: IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,l_ref_parent_task_ver_id) = 'Y' THEN
6211: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
6212: p_msg_name => 'PA_PS_CHK_DELIV_UPDATE');
6213: RAISE FND_API.G_EXC_ERROR;
6214: END IF;

Line 6300: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(l_proj_element_id); --bug 3301192 move in pa_tasks also if it exists there.

6296:
6297: IF l_fin_type = 'Y' -- 4269830 this is equivalent to cur_struc_type%FOUND
6298: THEN
6299:
6300: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(l_proj_element_id); --bug 3301192 move in pa_tasks also if it exists there.
6301:
6302: IF (NVL( l_published_version, 'N' ) = 'N' AND l_fin_task_flag = 'Y') OR
6303: (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y' AND l_fin_task_flag = 'Y' )
6304: OR ((l_published_version = 'Y') AND (l_shared = 'N') AND (l_fin_task_flag = 'Y')) -- Bug # 5064340. -- To accomodate split financial tasks.

Line 6701: l_lowest_task_flag2 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_ref_task_version_id );

6697: */
6698: IF l_wp_type = 'Y'
6699: AND l_ref_parent_struct_ver_id <> p_ref_task_version_id /* make sure that the reference is not a str ver */
6700: THEN
6701: l_lowest_task_flag2 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_ref_task_version_id );
6702: IF l_lowest_task_flag1 = 'Y' AND
6703: l_lowest_task_flag2 = 'N'
6704: THEN
6705: l_task_ver_ids2.extend(1); /* Venky */

Line 6984: IF ('Y' = pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(

6980: INTO l_proj_element_id, l_wbs_level, l_display_sequence, l_parent_structure_version_id
6981: FROM PA_PROJ_ELEMENT_VERSIONS
6982: WHERE element_version_id = p_task_version_id;
6983:
6984: IF ('Y' = pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(
6985: l_proj_element_id)) THEN
6986: --Indenting a task with phase. Error
6987: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_NO_INDENT_PHASE_TASK');
6988: END IF;

Line 7091: PA_PROJ_ELEMENTS_UTILS.Check_move_task_ok(

7087:
7088:
7089: --hsiu added for task status
7090: --Check if ok to indent this task
7091: PA_PROJ_ELEMENTS_UTILS.Check_move_task_ok(
7092: p_task_ver_id => p_task_version_id
7093: ,x_return_status => l_return_status
7094: ,x_error_message_code => l_error_msg_code
7095: );

Line 7108: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

7104: IF (l_peer_or_sub = 'PEER') THEN
7105: OPEN get_parent_version_id(l_ref_task_version_id);
7106: FETCH get_parent_version_id into l_parent_ver_id;
7107: CLOSE get_parent_version_id;
7108: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
7109: p_parent_task_ver_id => l_parent_ver_id
7110: ,x_return_status => l_return_status
7111: ,x_error_message_code => l_error_msg_code
7112: );

Line 7120: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

7116: p_msg_name => l_error_msg_code);
7117: raise FND_API.G_EXC_ERROR;
7118: END IF;
7119: ELSE
7120: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
7121: p_parent_task_ver_id => l_ref_task_version_id
7122: ,x_return_status => l_return_status
7123: ,x_error_message_code => l_error_msg_code
7124: );

Line 7178: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS

7174:
7175: --dbms_output.put_line( 'Indent Task Stage 12 ' );
7176:
7177:
7178: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
7179: ( p_commit => p_commit
7180: ,p_debug_mode => p_debug_mode
7181: ,p_parent_structure_ver_id => l_parent_structure_version_id
7182: ,p_task_id => p_task_version_id

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

7507: --added on 08-JAN-2002
7508: --check if task are linked task
7509: IF (p_structure_version_id IS NOT NULL) AND
7510: (p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
7511: IF ('N' = pa_proj_elements_utils.check_task_in_structure(
7512: p_structure_version_id,
7513: p_task_version_id)) THEN
7514: --deleting linked task. Error
7515: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NO_OUTD_LINKED_TASK');

Line 7593: PA_PROJ_ELEMENTS_UTILS.Check_move_task_ok(

7589: AND display_sequence < l_display_sequence);
7590:
7591: --hsiu added for task status
7592: --Check if ok to outdent this task
7593: PA_PROJ_ELEMENTS_UTILS.Check_move_task_ok(
7594: p_task_ver_id => p_task_version_id
7595: ,x_return_status => l_return_status
7596: ,x_error_message_code => l_error_msg_code
7597: );

Line 7608: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

7604:
7605: OPEN get_parent_version_id(l_ref_task_version_id);
7606: FETCH get_parent_version_id into l_parent_ver_id;
7607: CLOSE get_parent_version_id;
7608: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
7609: p_parent_task_ver_id => l_parent_ver_id
7610: ,x_return_status => l_return_status
7611: ,x_error_message_code => l_error_msg_code
7612: );

Line 7657: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS

7653: INTO l_parent_structure_version_id
7654: FROM PA_PROJ_ELEMENT_VERSIONS
7655: WHERE element_version_id = p_task_version_id;
7656:
7657: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
7658: ( p_commit => p_commit
7659: ,p_debug_mode => p_debug_mode
7660: ,p_parent_structure_ver_id => l_parent_structure_version_id
7661: ,p_task_id => p_task_version_id

Line 8231: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

8227: IF (l_peer_or_sub = 'PEER') THEN
8228: OPEN get_parent_version_id(l_ref_task_ver_id);
8229: FETCH get_parent_version_id into l_parent_ver_id;
8230: CLOSE get_parent_version_id;
8231: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
8232: p_parent_task_ver_id => l_parent_ver_id
8233: ,x_return_status => l_return_status
8234: ,x_error_message_code => l_error_msg_code
8235: );

Line 8243: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

8239: p_msg_name => l_error_msg_code);
8240: raise API_ERROR;
8241: END IF;
8242: ELSE
8243: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
8244: p_parent_task_ver_id => l_ref_task_ver_id
8245: ,x_return_status => l_return_status
8246: ,x_error_message_code => l_error_msg_code
8247: );

Line 9858: IF ('Y' = pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(

9854: -- Lifecycle Phase validation Changes. Check if task has phase associated with it
9855: IF (p_task_version_id IS NOT NULL) AND
9856: (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
9857:
9858: IF ('Y' = pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(
9859: src_proj_element_id)) THEN
9860: --Indenting a task with phase. Error
9861: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_NO_INDENT_PHASE_TASK');
9862: raise FND_API.G_EXC_ERROR;

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

9952: */
9953:
9954: --Bug No 3475920 Smukka 25/May/04 Checking for deliverable
9955: --bug 4214825, pass the correct ref_task_version
9956: --IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,ref_elem_ver_id) = 'Y' THEN
9957: IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id, l_ref_tsk_version_id) = 'Y' THEN
9958: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9959: p_msg_name => 'PA_PS_CHK_DELIV_UPDATE');
9960: raise FND_API.G_EXC_ERROR;

Line 9957: IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id, l_ref_tsk_version_id) = 'Y' THEN

9953:
9954: --Bug No 3475920 Smukka 25/May/04 Checking for deliverable
9955: --bug 4214825, pass the correct ref_task_version
9956: --IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id,ref_elem_ver_id) = 'Y' THEN
9957: IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id, l_ref_tsk_version_id) = 'Y' THEN
9958: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9959: p_msg_name => 'PA_PS_CHK_DELIV_UPDATE');
9960: raise FND_API.G_EXC_ERROR;
9961: END IF;

Line 9964: PA_PROJ_ELEMENTS_UTILS.Check_move_task_ok(

9960: raise FND_API.G_EXC_ERROR;
9961: END IF;
9962:
9963: --Check if ok to indent this task
9964: PA_PROJ_ELEMENTS_UTILS.Check_move_task_ok(
9965: p_task_ver_id => p_task_version_id
9966: ,x_return_status => l_return_status
9967: ,x_error_message_code => l_error_msg_code
9968: );

Line 10001: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

9997: END IF;
9998: END IF;
9999: --end bug 3069306
10000:
10001: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
10002: p_parent_task_ver_id => l_parent_ver_id
10003: ,x_return_status => l_return_status
10004: ,x_error_message_code => l_error_msg_code
10005: );

Line 10041: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

10037: END IF;
10038: --end bug 3069306
10039:
10040:
10041: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
10042: p_parent_task_ver_id => ref_elem_ver_id
10043: ,x_return_status => l_return_status
10044: ,x_error_message_code => l_error_msg_code
10045: );

Line 10084: l_lowest_task_flag1 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id );

10080: End If;
10081: End If;
10082:
10083: --check the task is a lowest task bug 3301192
10084: l_lowest_task_flag1 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id );
10085:
10086: -- End of FP_M changes
10087: /*
10088:

Line 10101: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS

10097: x_return_status => l_return_status,
10098: x_msg_count => l_msg_count,
10099: x_msg_data => l_msg_data );
10100:
10101: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
10102: ( p_commit => p_commit
10103: ,p_debug_mode => p_debug_mode
10104: ,p_parent_structure_ver_id => l_parent_structure_version_id
10105: ,p_task_id => p_task_version_id

Line 10489: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --indent in corresponding task in pa_tasks

10485: l_project_id);
10486: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
10487: l_project_id);
10488:
10489: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --indent in corresponding task in pa_tasks
10490:
10491: IF (NVL( l_published_version, 'N' ) = 'N' AND l_fin_task_flag = 'Y' ) OR
10492: (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y' AND l_fin_task_flag = 'Y' )
10493: OR ((l_published_version = 'Y') AND (l_shared = 'N') AND (l_fin_task_flag = 'Y')) -- Bug # 5064340. -- To accomodate split financial tasks.

Line 10817: l_lowest_task_flag2 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id );

10813: --End bug 3010538 (Indent )
10814:
10815: --bug 3301192
10816: --check the task is a lowest task again and check whehter its no more a lowest task.
10817: l_lowest_task_flag2 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id );
10818:
10819: IF l_lowest_task_flag1 = 'Y' AND
10820: l_lowest_task_flag2 = 'N'
10821: THEN

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

11348: -- end hyau Bug 2852753
11349:
11350: IF (p_structure_version_id IS NOT NULL) AND
11351: (p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
11352: IF ('N' = pa_proj_elements_utils.check_task_in_structure(
11353: p_structure_version_id,
11354: p_task_version_id)) THEN
11355: --deleting linked task. Error
11356: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NO_OUTD_LINKED_TASK');

Line 11461: PA_PROJ_ELEMENTS_UTILS.Check_move_task_ok(

11457:
11458: end if;
11459:
11460: --Check if ok to OUTDENT this task
11461: PA_PROJ_ELEMENTS_UTILS.Check_move_task_ok(
11462: p_task_ver_id => p_task_version_id
11463: ,x_return_status => l_return_status
11464: ,x_error_message_code => l_error_msg_code
11465: );

Line 11497: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

11493: END IF;
11494: END IF;
11495: --end bug 3069306
11496:
11497: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
11498: p_parent_task_ver_id => l_parent_ver_id
11499: ,x_return_status => l_return_status
11500: ,x_error_message_code => l_error_msg_code
11501: );

Line 11511: l_fin_task_flag := PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(src_proj_element_id);

11507: END IF;
11508:
11509: --Bug 16013002
11510: -- Check if the task which is going to outdent is financial or not
11511: l_fin_task_flag := PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(src_proj_element_id);
11512: IF l_fin_task_flag='Y' THEN
11513: OPEN cur_child_tasks_exists(ref_elem_ver_id, src_seq_number);
11514: FETCH cur_child_tasks_exists INTO l_child_task_exists;
11515: -- check if there exists peer tasks (which are set to financial tasks) below to the task which is going to outdent

Line 11554: l_lowest_task_flag1 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id );

11550: End If;
11551: End If;
11552:
11553: --check the task is a lowest task bug 3301192
11554: l_lowest_task_flag1 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id );
11555:
11556: -- End of FP_M changes
11557:
11558: /*

Line 11573: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS

11569: x_return_status => l_return_status,
11570: x_msg_count => l_msg_count,
11571: x_msg_data => l_msg_data );
11572:
11573: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
11574: ( p_commit => p_commit
11575: ,p_debug_mode => p_debug_mode
11576: ,p_parent_structure_ver_id => l_parent_structure_version_id
11577: ,p_task_id => p_task_version_id

Line 11645: IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id, l_element_version_id_tab(j)) = 'Y' THEN

11641: --Need loop to check all new subtasks and see if ok (for deliverable type task)
11642: FOR j IN l_element_version_id_tab.FIRST..l_element_version_id_tab.LAST LOOP
11643: --check if moving to subtask ok
11644: IF (l_element_version_id_tab(j) <> p_task_version_id) Then
11645: IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id, l_element_version_id_tab(j)) = 'Y' THEN
11646: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
11647: p_msg_name => 'PA_PS_CHK_DELIV_UPDATE');
11648: raise FND_API.G_EXC_ERROR;
11649: END IF;

Line 12106: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --outdent in corresponding task in pa_tasks

12102: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
12103: l_project_id);
12104:
12105: --o IF (NVL( l_published_version, 'N' ) = 'N') OR (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y') THEN
12106: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --outdent in corresponding task in pa_tasks
12107:
12108: IF (NVL( l_published_version, 'N' ) = 'N' AND l_fin_task_flag = 'Y' ) OR
12109: (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y' AND l_fin_task_flag = 'Y' )
12110: OR ((l_published_version = 'Y') AND (l_shared = 'N') AND (l_fin_task_flag = 'Y')) -- Bug # 5064340. -- To accomodate split financial tasks.

Line 12490: l_lowest_task_flag2 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id );

12486: --End bug 3010538 ( outdent )
12487:
12488: --bug 3301192
12489: --check the task is a lowest task again and check whehter its no more a lowest task.
12490: l_lowest_task_flag2 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id );
12491:
12492: IF l_lowest_task_flag1 = 'Y' AND
12493: l_lowest_task_flag2 = 'N'
12494: THEN

Line 13640: IF PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_tasks_ver_ids(i) ) = 'Y'

13636: (p_planned_effort(i) IS NOT NULL AND
13637: p_planned_effort(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
13638: p_planned_effort(i) <> 0) --bug 3802240: Added conditions to skip g_miss
13639: THEN
13640: IF PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_tasks_ver_ids(i) ) = 'Y'
13641: THEN
13642: /* convert ids and planned effort to the called apis params types. */
13643: l_task_ver_ids.extend(1); /* Venky */
13644: l_task_ver_ids(l_task_ver_ids.count) := p_tasks_ver_ids(i);

Line 14216: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id );

14212: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_etc_effort='||l_etc_effort, x_Log_Level=> 3);
14213: END IF;
14214:
14215: --bug 3959087, start
14216: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id );
14217: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_ver_id, 'PA_TASKS');
14218:
14219: IF l_debug_mode = 'Y' THEN
14220: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_lowest_level_task='||l_lowest_level_task, x_Log_Level=> 3);

Line 14227: --IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id ) = 'Y' AND

14223: --bug 3959087, end
14224:
14225: -- Call: pa_fp_planning_transaction_pub.update_planning_transactions().
14226:
14227: --IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id ) = 'Y' AND
14228: IF (l_lowest_level_task = 'Y' AND --bug 3959087
14229: PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y'
14230: -- Progress Management Changes, Bug # 3420093.
14231: --AND PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,p_task_ver_id,p_object_type) = 'N' --bug 3864543

Line 15348: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(

15344: (p_src_project_name IS NOT NULL)) OR
15345: ((p_src_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
15346: (p_src_project_id IS NOT NULL)) THEN
15347: --Call Check API.
15348: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(
15349: p_project_name => p_src_project_name,
15350: p_project_id => p_src_project_id,
15351: x_project_id => l_src_project_id,
15352: x_return_status => l_return_status,

Line 16076: IF ('Y' = PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(p_task_id_tbl(i))) THEN

16072: l_tcnt := 0; -- added for --bug 8301015
16073:
16074: FOR i in p_task_id_tbl.FIRST .. p_task_id_tbl.LAST LOOP
16075: -- Changes for --bug 8301015
16076: IF ('Y' = PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(p_task_id_tbl(i))) THEN
16077:
16078: SELECT pt.project_id,
16079: pt.parent_task_id,
16080: pt.start_date,

Line 16474: PA_PROJ_ELEMENTS_UTILS.Check_chg_stat_cancel_ok

16470: IF l_debug_mode = 'Y' THEN
16471: pa_debug.write(l_module_name,'Calling Check_chg_stat_cancel_ok', 3);
16472: END IF;
16473:
16474: PA_PROJ_ELEMENTS_UTILS.Check_chg_stat_cancel_ok
16475: (
16476: p_task_id => p_task_id
16477: ,p_task_version_id => p_task_version_id
16478: ,p_new_task_status => p_cancel_status_code