DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_PROJ_ELEMENTS_UTILS

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

5011: IF NVL(PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED,'N') = 'Y'
5012: THEN
5013: l_d_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
5014: ELSE
5015: l_d_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID( l_project_id, 'WORKPLAN');
5016: END IF;
5017:
5018: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_d_structure_version_id
5019: ,p_task_id => l_d_task_id);

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

5014: ELSE
5015: l_d_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID( l_project_id, 'WORKPLAN');
5016: END IF;
5017:
5018: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_d_structure_version_id
5019: ,p_task_id => l_d_task_id);
5020:
5021: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string
5022: ,p_delimeter => l_task_in_rec.pred_delimiter

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

6905: THEN
6906: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_pa_project_id) = 'Y') THEN
6907: l_d_struct_ver_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_pa_project_id);
6908: ELSE
6909: l_d_struct_ver_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(p_pa_project_id, 'WORKPLAN');
6910: END IF;
6911: ELSE
6912: l_d_struct_ver_id := p_structure_version_id;
6913: END IF;

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

6911: ELSE
6912: l_d_struct_ver_id := p_structure_version_id;
6913: END IF;
6914:
6915: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_d_struct_ver_id
6916: ,p_task_id => l_d_task_id);
6917:
6918: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string
6919: ,p_delimeter => l_task_in_rec.pred_delimiter

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

7105: END IF;
7106: END IF;
7107: IF (G_PROJECT_SHARING_TYPE = 'SHARE_PARTIAL' and l_structure_type /*p_structure_type 3746912*/= 'FINANCIAL') THEN
7108: --Get the task Version Id
7109: --l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id, l_task_id);
7110: OPEN c_get_pa_record_version_number ( l_task_version_id , l_project_id);
7111: FETCH c_get_pa_record_version_number INTO l_patask_record_version_number;
7112: CLOSE c_get_pa_record_version_number;
7113: IF

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

21368: END IF;
21369: END IF;
21370: --maansari5/18
21371:
21372: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_update_structure_version_id
21373: ,p_task_id => l_d_task_id);
21374:
21375: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string
21376: ,p_delimeter => l_task_in_rec.pred_delimiter

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

23542: --l_structure_version_id := p_structure_version_id;
23543: --Added by rtarway for BUG 4106154
23544: if (l_update_pa_tasks = 'Y' AND
23545: --Added by rtarway for bug 4321313
23546: PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_pa_task_id) = 'Y'
23547: ) then
23548:
23549: --In case of Shared Structures, we do not need to update dff attributes in pa_tasks, instead
23550: --dff fields of pa_proj_elem_ver_schedule are updated

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

23818: --Begin Add by rtarway FP.M chages for Set Financial Task
23819: IF (G_PROJECT_SHARING_TYPE = 'SHARE_PARTIAL' and nvl(l_is_wp_separate_from_fn,'N') = 'N') THEN --l_structure_type
23820: --Get the task Version Id
23821: --BUG 3919800,p_structure_version_id and p_pa_task_id are replaced
23822: l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(l_structure_version_id, l_pa_task_id);
23823: OPEN c_get_pa_record_version_number ( l_task_version_id , l_project_id ); --Bug#3747312
23824: FETCH c_get_pa_record_version_number INTO l_patask_record_version_number;
23825: CLOSE c_get_pa_record_version_number;
23826: IF ( p_financial_task_flag IS NOT NULL AND p_financial_task_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

23865: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'Y'
23866: THEN
23867: IF l_task_version_id IS NULL
23868: THEN
23869: l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(l_structure_version_id, l_pa_task_id);
23870: END IF;
23871: PA_PROJ_TASK_STRUC_PUB.rollup_dates(
23872: p_tasks_in => l_tasks_out
23873: ,p_task_version_id => l_task_version_id

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

23978: /*
23979: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_pa_project_id) = 'Y') THEN
23980: l_d_struct_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LAST_UPDATED_WORKING_VER(l_d_task_id);
23981: ELSE
23982: l_d_struct_ver_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(p_pa_project_id, 'WORKPLAN');
23983: END IF;
23984: */ --we dont need this. The structure version id is derived.
23985:
23986: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_structure_version_id

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

23982: l_d_struct_ver_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(p_pa_project_id, 'WORKPLAN');
23983: END IF;
23984: */ --we dont need this. The structure version id is derived.
23985:
23986: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_structure_version_id
23987: ,p_task_id => l_d_task_id);
23988:
23989: pa_proj_task_struc_pub.parse_predecessor_import(p_string => p_pred_string
23990: ,p_delimeter => p_pred_delimiter

Line 29640: l_wp_task_flag := PA_PROJ_ELEMENTS_UTILS.CHECK_IS_WORKPLAN_TASK (

29636:
29637: -- 5462298 Added below code to validate passed task id
29638: -- if it is not workplan task , throw error message
29639:
29640: l_wp_task_flag := PA_PROJ_ELEMENTS_UTILS.CHECK_IS_WORKPLAN_TASK (
29641: p_project_id => l_project_id
29642: , p_proj_element_id => l_task_id );
29643:
29644: IF l_wp_task_flag <> 'Y' THEN

Line 32570: l_wp_task_flag := PA_PROJ_ELEMENTS_UTILS.CHECK_IS_WORKPLAN_TASK (

32566:
32567: -- 5462298 Added below code to validate passed task id
32568: -- if it is not workplan task , throw error message
32569:
32570: l_wp_task_flag := PA_PROJ_ELEMENTS_UTILS.CHECK_IS_WORKPLAN_TASK (
32571: p_project_id => l_project_id
32572: , p_proj_element_id => l_task_id );
32573:
32574: IF l_wp_task_flag <> 'Y' THEN

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

33492: )
33493: THEN
33494:
33495: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
33496: l_wp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
33497: IF (l_wp_structure_version_id = -1 OR l_wp_structure_version_id = NULL)
33498: THEN
33499: l_wp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
33500: END IF;

Line 33507: l_wp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID

33503: THEN
33504: l_wp_structure_version_id :=p_wp_structure_version_id;
33505: END IF;
33506: --1.2.1.1 get the l_wp_task_version_id
33507: l_wp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID
33508: (
33509: p_structure_version_id => l_wp_structure_version_id
33510: , p_task_id => l_wp_task_id
33511: );

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

33847: -- Avoid this call if wkp task name and wkp task version ids are passed
33848: IF (l_wkp_task_id IS NOT NULL AND l_wkp_structure_version_id IS NULL ) THEN
33849:
33850: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
33851: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
33852: IF (l_wkp_structure_version_id = -1 OR l_wkp_structure_version_id = NULL)
33853: THEN
33854: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
33855: END IF;

Line 33858: l_wkp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID

33854: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
33855: END IF;
33856: END IF;
33857: END IF;
33858: l_wkp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID
33859: (
33860: p_structure_version_id => l_wkp_structure_version_id
33861: , p_task_id => l_wkp_task_id
33862: );

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

34195: --Get the task version id from Wkp task Id
34196: -- Avoid this call if wkp task name and wkp task version ids are passed
34197: IF (l_wkp_task_id IS NOT NULL AND l_wkp_structure_version_id IS NULL ) THEN
34198: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
34199: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
34200: IF (l_wkp_structure_version_id IS NULL OR l_wkp_structure_version_id = -1) THEN
34201: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34202: END IF;
34203: END IF;

Line 34205: l_wkp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID

34201: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34202: END IF;
34203: END IF;
34204: END IF;
34205: l_wkp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID
34206: (
34207: p_structure_version_id => l_wkp_structure_version_id
34208: , p_task_id => l_wkp_task_id
34209: );

Line 34652: IF PA_PROJ_ELEMENTS_UTILS.check_pa_lookup_exists('PA_OBJECT_DEPENDENCY_TYPES',p_type) <> 'Y' THEN

34648: END IF;
34649: --end bug 3880403
34650: --
34651: -- Bug 3768933 Validating the relationship_subtype
34652: IF PA_PROJ_ELEMENTS_UTILS.check_pa_lookup_exists('PA_OBJECT_DEPENDENCY_TYPES',p_type) <> 'Y' THEN
34653: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34654: p_msg_name => 'PA_PS_INV_REL_SUBTYPE_VAL');
34655: RAISE FND_API.G_EXC_ERROR;
34656: END IF;

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

36636: end if;
36637:
36638: -- Check if the task version id corresponds to a summary task.
36639: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration
36640: if (pa_proj_elements_utils.is_summary_task_or_structure(l_task_version_id) = 'Y') then
36641: -- The task is a summary task.
36642: open l_cur_prog_name(l_task_version_id);
36643: fetch l_cur_prog_name into l_program_name;
36644: close l_cur_prog_name;