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_PROJECT_PUB dependencies on PA_PROJ_ELEMENTS_UTILS

Line 5130: l_d_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID( l_project_id, 'WORKPLAN');

5126: IF NVL(PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED,'N') = 'Y'
5127: THEN
5128: l_d_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
5129: ELSE
5130: l_d_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID( l_project_id, 'WORKPLAN');
5131: END IF;
5132:
5133: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_d_structure_version_id
5134: ,p_task_id => l_d_task_id);

Line 5133: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_d_structure_version_id

5129: ELSE
5130: l_d_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID( l_project_id, 'WORKPLAN');
5131: END IF;
5132:
5133: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_d_structure_version_id
5134: ,p_task_id => l_d_task_id);
5135:
5136: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string
5137: ,p_delimeter => l_task_in_rec.pred_delimiter

Line 7152: l_d_struct_ver_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(p_pa_project_id, 'WORKPLAN');

7148: THEN
7149: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_pa_project_id) = 'Y') THEN
7150: l_d_struct_ver_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_pa_project_id);
7151: ELSE
7152: l_d_struct_ver_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(p_pa_project_id, 'WORKPLAN');
7153: END IF;
7154: ELSE
7155: l_d_struct_ver_id := p_structure_version_id;
7156: END IF;

Line 7158: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_d_struct_ver_id

7154: ELSE
7155: l_d_struct_ver_id := p_structure_version_id;
7156: END IF;
7157:
7158: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_d_struct_ver_id
7159: ,p_task_id => l_d_task_id);
7160:
7161: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string
7162: ,p_delimeter => l_task_in_rec.pred_delimiter

Line 7352: --l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id, l_task_id);

7348: END IF;
7349: END IF;
7350: IF (G_PROJECT_SHARING_TYPE = 'SHARE_PARTIAL' and l_structure_type /*p_structure_type 3746912*/= 'FINANCIAL') THEN
7351: --Get the task Version Id
7352: --l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id, l_task_id);
7353: OPEN c_get_pa_record_version_number ( l_task_version_id , l_project_id);
7354: FETCH c_get_pa_record_version_number INTO l_patask_record_version_number;
7355: CLOSE c_get_pa_record_version_number;
7356: IF

Line 21832: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_update_structure_version_id

21828: END IF;
21829: END IF;
21830: --maansari5/18
21831:
21832: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_update_structure_version_id
21833: ,p_task_id => l_d_task_id);
21834:
21835: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string
21836: ,p_delimeter => l_task_in_rec.pred_delimiter

Line 24158: PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_pa_task_id) = 'Y'

24154: --l_structure_version_id := p_structure_version_id;
24155: --Added by rtarway for BUG 4106154
24156: if (l_update_pa_tasks = 'Y' AND
24157: --Added by rtarway for bug 4321313
24158: PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_pa_task_id) = 'Y'
24159: ) then
24160:
24161: --In case of Shared Structures, we do not need to update dff attributes in pa_tasks, instead
24162: --dff fields of pa_proj_elem_ver_schedule are updated

Line 24436: l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(l_structure_version_id, l_pa_task_id);

24432: --Begin Add by rtarway FP.M chages for Set Financial Task
24433: IF (G_PROJECT_SHARING_TYPE = 'SHARE_PARTIAL' and nvl(l_is_wp_separate_from_fn,'N') = 'N') THEN --l_structure_type
24434: --Get the task Version Id
24435: --BUG 3919800,p_structure_version_id and p_pa_task_id are replaced
24436: l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(l_structure_version_id, l_pa_task_id);
24437: OPEN c_get_pa_record_version_number ( l_task_version_id , l_project_id ); --Bug#3747312
24438: FETCH c_get_pa_record_version_number INTO l_patask_record_version_number;
24439: CLOSE c_get_pa_record_version_number;
24440: IF ( p_financial_task_flag IS NOT NULL AND p_financial_task_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 24483: l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(l_structure_version_id, l_pa_task_id);

24479: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'Y'
24480: THEN
24481: IF l_task_version_id IS NULL
24482: THEN
24483: l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(l_structure_version_id, l_pa_task_id);
24484: END IF;
24485: PA_PROJ_TASK_STRUC_PUB.rollup_dates(
24486: p_tasks_in => l_tasks_out
24487: ,p_task_version_id => l_task_version_id

Line 24597: l_d_struct_ver_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(p_pa_project_id, 'WORKPLAN');

24593: /*
24594: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_pa_project_id) = 'Y') THEN
24595: l_d_struct_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LAST_UPDATED_WORKING_VER(l_d_task_id);
24596: ELSE
24597: l_d_struct_ver_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(p_pa_project_id, 'WORKPLAN');
24598: END IF;
24599: */ --we dont need this. The structure version id is derived.
24600:
24601: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_structure_version_id

Line 24601: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_structure_version_id

24597: l_d_struct_ver_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(p_pa_project_id, 'WORKPLAN');
24598: END IF;
24599: */ --we dont need this. The structure version id is derived.
24600:
24601: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_structure_version_id
24602: ,p_task_id => l_d_task_id);
24603:
24604: pa_proj_task_struc_pub.parse_predecessor_import(p_string => p_pred_string
24605: ,p_delimeter => p_pred_delimiter

Line 30265: l_wp_task_flag := PA_PROJ_ELEMENTS_UTILS.CHECK_IS_WORKPLAN_TASK (

30261:
30262: -- 5462298 Added below code to validate passed task id
30263: -- if it is not workplan task , throw error message
30264:
30265: l_wp_task_flag := PA_PROJ_ELEMENTS_UTILS.CHECK_IS_WORKPLAN_TASK (
30266: p_project_id => l_project_id
30267: , p_proj_element_id => l_task_id );
30268:
30269: IF l_wp_task_flag <> 'Y' THEN

Line 33195: l_wp_task_flag := PA_PROJ_ELEMENTS_UTILS.CHECK_IS_WORKPLAN_TASK (

33191:
33192: -- 5462298 Added below code to validate passed task id
33193: -- if it is not workplan task , throw error message
33194:
33195: l_wp_task_flag := PA_PROJ_ELEMENTS_UTILS.CHECK_IS_WORKPLAN_TASK (
33196: p_project_id => l_project_id
33197: , p_proj_element_id => l_task_id );
33198:
33199: IF l_wp_task_flag <> 'Y' THEN

Line 34121: l_wp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');

34117: )
34118: THEN
34119:
34120: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
34121: l_wp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
34122: IF (l_wp_structure_version_id = -1 OR l_wp_structure_version_id = NULL)
34123: THEN
34124: l_wp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34125: END IF;

Line 34132: l_wp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID

34128: THEN
34129: l_wp_structure_version_id :=p_wp_structure_version_id;
34130: END IF;
34131: --1.2.1.1 get the l_wp_task_version_id
34132: l_wp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID
34133: (
34134: p_structure_version_id => l_wp_structure_version_id
34135: , p_task_id => l_wp_task_id
34136: );

Line 34476: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');

34472: -- Avoid this call if wkp task name and wkp task version ids are passed
34473: IF (l_wkp_task_id IS NOT NULL AND l_wkp_structure_version_id IS NULL ) THEN
34474:
34475: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
34476: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
34477: IF (l_wkp_structure_version_id = -1 OR l_wkp_structure_version_id = NULL)
34478: THEN
34479: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34480: END IF;

Line 34483: l_wkp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID

34479: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34480: END IF;
34481: END IF;
34482: END IF;
34483: l_wkp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID
34484: (
34485: p_structure_version_id => l_wkp_structure_version_id
34486: , p_task_id => l_wkp_task_id
34487: );

Line 34824: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');

34820: --Get the task version id from Wkp task Id
34821: -- Avoid this call if wkp task name and wkp task version ids are passed
34822: IF (l_wkp_task_id IS NOT NULL AND l_wkp_structure_version_id IS NULL ) THEN
34823: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
34824: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
34825: IF (l_wkp_structure_version_id IS NULL OR l_wkp_structure_version_id = -1) THEN
34826: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34827: END IF;
34828: END IF;

Line 34830: l_wkp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID

34826: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34827: END IF;
34828: END IF;
34829: END IF;
34830: l_wkp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID
34831: (
34832: p_structure_version_id => l_wkp_structure_version_id
34833: , p_task_id => l_wkp_task_id
34834: );

Line 35299: IF PA_PROJ_ELEMENTS_UTILS.check_pa_lookup_exists('PA_DEPENDENCY_TYPE',p_type) <> 'Y' THEN

35295: --end bug 3880403
35296: --
35297: -- Bug 3768933 Validating the relationship_subtype
35298: -- Bug 8513869 - Replaced lookup type PA_OBJECT_DEPENDENCY_TYPES with PA_DEPENDENCY_TYPE
35299: IF PA_PROJ_ELEMENTS_UTILS.check_pa_lookup_exists('PA_DEPENDENCY_TYPE',p_type) <> 'Y' THEN
35300: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35301: p_msg_name => 'PA_PS_INV_REL_SUBTYPE_VAL');
35302: RAISE FND_API.G_EXC_ERROR;
35303: END IF;

Line 37294: if (pa_proj_elements_utils.is_summary_task_or_structure(l_task_version_id) = 'Y') then

37290: end if;
37291:
37292: -- Check if the task version id corresponds to a summary task.
37293: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration
37294: if (pa_proj_elements_utils.is_summary_task_or_structure(l_task_version_id) = 'Y') then
37295: -- The task is a summary task.
37296: open l_cur_prog_name(l_task_version_id);
37297: fetch l_cur_prog_name into l_program_name;
37298: close l_cur_prog_name;

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

40357: -- Lifecycle Phase validation Changes. Check if task has phase associated with it
40358: IF (p_task_version_id IS NOT NULL) AND
40359: (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
40360:
40361: IF ('Y' = pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(
40362: src_proj_element_id)) THEN
40363: --Indenting a task with phase. Error
40364: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_NO_INDENT_PHASE_TASK');
40365: raise FND_API.G_EXC_ERROR;

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

40423: CLOSE cur_get_ref_tsk_ver_id;
40424:
40425: END IF;
40426:
40427: IF PA_PROJ_ELEMENTS_UTILS.check_deliv_in_hierarchy(p_task_version_id, l_ref_tsk_version_id) = 'Y' THEN
40428: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
40429: p_msg_name => 'PA_PS_CHK_DELIV_UPDATE');
40430: raise FND_API.G_EXC_ERROR;
40431: END IF;

Line 40434: PA_PROJ_ELEMENTS_UTILS.Check_move_task_ok(

40430: raise FND_API.G_EXC_ERROR;
40431: END IF;
40432:
40433: --Check if ok to indent this task
40434: PA_PROJ_ELEMENTS_UTILS.Check_move_task_ok(
40435: p_task_ver_id => p_task_version_id
40436: ,x_return_status => l_return_status
40437: ,x_error_message_code => l_error_msg_code
40438: );

Line 40471: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

40467: END IF;
40468: END IF;
40469: --end bug 3069306
40470:
40471: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
40472: p_parent_task_ver_id => l_parent_ver_id
40473: ,x_return_status => l_return_status
40474: ,x_error_message_code => l_error_msg_code
40475: );

Line 40511: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

40507: END IF;
40508: --end bug 3069306
40509:
40510:
40511: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
40512: p_parent_task_ver_id => ref_elem_ver_id
40513: ,x_return_status => l_return_status
40514: ,x_error_message_code => l_error_msg_code
40515: );

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

40548: End If;
40549: End If;
40550:
40551: --check the task is a lowest task bug 3301192
40552: l_lowest_task_flag1 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id );
40553:
40554: /*** The following part should do the same task as done by PA_TASK_PUB1.Update_Task_Version and Update_wbs_numbers ***/
40555:
40556: -- Logic Added for plsql table

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

40970: l_project_id);
40971: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
40972: l_project_id);
40973:
40974: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --indent in corresponding task in pa_tasks
40975:
40976: IF (NVL( l_published_version, 'N' ) = 'N' AND l_fin_task_flag = 'Y' ) OR
40977: (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y' AND l_fin_task_flag = 'Y' )
40978: OR ((l_published_version = 'Y') AND (l_shared = 'N') AND (l_fin_task_flag = 'Y')) -- Bug # 5064340. -- To accomodate split financial tasks.

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

41214: END IF;
41215: END IF;
41216:
41217: --check the task is a lowest task again and check whehter its no more a lowest task.
41218: l_lowest_task_flag2 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id );
41219:
41220: IF l_lowest_task_flag1 = 'Y' AND
41221: l_lowest_task_flag2 = 'N'
41222: THEN

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

41770: END IF;
41771:
41772: IF (p_structure_version_id IS NOT NULL) AND
41773: (p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
41774: IF ('N' = pa_proj_elements_utils.check_task_in_structure(
41775: p_structure_version_id,
41776: p_task_version_id)) THEN
41777: --deleting linked task. Error
41778: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NO_OUTD_LINKED_TASK');

Line 41875: PA_PROJ_ELEMENTS_UTILS.Check_move_task_ok(

41871:
41872: end if;
41873:
41874: --Check if ok to OUTDENT this task
41875: PA_PROJ_ELEMENTS_UTILS.Check_move_task_ok(
41876: p_task_ver_id => p_task_version_id
41877: ,x_return_status => l_return_status
41878: ,x_error_message_code => l_error_msg_code
41879: );

Line 41909: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

41905: raise FND_API.G_EXC_ERROR;
41906: END IF;
41907: END IF;
41908:
41909: PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
41910: p_parent_task_ver_id => l_parent_ver_id
41911: ,x_return_status => l_return_status
41912: ,x_error_message_code => l_error_msg_code
41913: );

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

41939: End If;
41940: End If;
41941:
41942: --check the task is a lowest task bug 3301192
41943: l_lowest_task_flag1 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id );
41944:
41945: -- End of FP_M changes
41946:
41947: /*** The following part should do the same task as done by PA_TASK_PUB1.Update_Task_Version and Update_wbs_numbers ***/

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

42487: l_project_id);
42488: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
42489: l_project_id);
42490:
42491: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --outdent in corresponding task in pa_tasks
42492:
42493: IF (NVL( l_published_version, 'N' ) = 'N' AND l_fin_task_flag = 'Y' ) OR
42494: (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y' AND l_fin_task_flag = 'Y' )
42495: OR ((l_published_version = 'Y') AND (l_shared = 'N') AND (l_fin_task_flag = 'Y')) -- Bug # 5064340. -- To accomodate split financial tasks.

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

42730: end if;
42731: END IF;
42732: END IF;
42733: --check the task is a lowest task again and check whehter its no more a lowest task.
42734: l_lowest_task_flag2 := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id );
42735:
42736: IF l_lowest_task_flag1 = 'Y' AND
42737: l_lowest_task_flag2 = 'N'
42738: THEN