APPS.PA_RELATIONSHIP_UTILS dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 286: If (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(

282: --Check if it has costing/billing structure type.
283: --changed to financial
284: --dbms_output.put_line('l_element_id = '||l_element_id);
285:
286: If (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
287: l_from_struc_ver_id, 'FINANCIAL') = 'Y') THEN
288: --Check for transaction for this task
289:
290:

Line 327: l_financial_from := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(

323: -- Get From Structure Version Id
324: OPEN get_struc_ver_id(p_element_version_id_from);
325: FETCH get_struc_ver_id into l_struc_ver_id_from, l_project_id_from;
326: CLOSE get_struc_ver_id;
327: l_financial_from := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
328: l_struc_ver_id_from,
329: 'FINANCIAL');
330: l_workplan_from := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
331: l_struc_ver_id_from,

Line 330: l_workplan_from := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(

326: CLOSE get_struc_ver_id;
327: l_financial_from := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
328: l_struc_ver_id_from,
329: 'FINANCIAL');
330: l_workplan_from := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
331: l_struc_ver_id_from,
332: 'WORKPLAN');
333:
334: -- Get To Structure Version Id

Line 338: l_financial_to := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(

334: -- Get To Structure Version Id
335: OPEN get_struc_ver_id(p_element_version_id_to);
336: FETCH get_struc_ver_id into l_struc_ver_id_to, l_project_id_to;
337: CLOSE get_struc_ver_id;
338: l_financial_to := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
339: l_struc_ver_id_to,
340: 'FINANCIAL');
341: l_workplan_to := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
342: l_struc_ver_id_to,

Line 341: l_workplan_to := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(

337: CLOSE get_struc_ver_id;
338: l_financial_to := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
339: l_struc_ver_id_to,
340: 'FINANCIAL');
341: l_workplan_to := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(
342: l_struc_ver_id_to,
343: 'WORKPLAN');
344: --Compare structure types
345: If (l_workplan_from = 'Y') and

Line 1365: PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(elv.project_id))

1361: and a.object_id_from2 <> c_parent_proj_id -- Fix for Bug # 4297715.
1362: and exists (select 1 from PA_PROJ_ELEMENT_VERSIONS elv /* Added the exists for Bug 6148092 */
1363: where elv.element_version_id = a.object_id_from1
1364: and ((elv.PARENT_STRUCTURE_VERSION_ID =
1365: PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(elv.project_id))
1366: or (elv.PARENT_STRUCTURE_VERSION_ID =
1367: PA_PROJECT_STRUCTURE_UTILS.get_latest_wp_version(elv.project_id))
1368: )
1369: );

Line 1367: PA_PROJECT_STRUCTURE_UTILS.get_latest_wp_version(elv.project_id))

1363: where elv.element_version_id = a.object_id_from1
1364: and ((elv.PARENT_STRUCTURE_VERSION_ID =
1365: PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(elv.project_id))
1366: or (elv.PARENT_STRUCTURE_VERSION_ID =
1367: PA_PROJECT_STRUCTURE_UTILS.get_latest_wp_version(elv.project_id))
1368: )
1369: );
1370:
1371: l_linked_parent_proj_id NUMBER;

Line 2048: l_cur_working_str_ver_id := pa_project_structure_utils.get_fin_struc_ver_id(p_project_id);

2044:
2045: -- The calling API in this case is: pa_task_utils.check_create_subtask_ok() which is only
2046: -- called for 'FINANCIAL' tasks.
2047:
2048: l_cur_working_str_ver_id := pa_project_structure_utils.get_fin_struc_ver_id(p_project_id);
2049:
2050: open cur_task_version_id(p_project_id, p_task_id, l_cur_working_str_ver_id);
2051: fetch cur_task_version_id into l_task_version_id;
2052: close cur_task_version_id;

Line 2141: if (pa_project_structure_utils.check_program_flag_enable(p_project_id) = 'Y') then -- Bug # 4742904.

2137: begin
2138:
2139: l_return_value := 'N';
2140:
2141: if (pa_project_structure_utils.check_program_flag_enable(p_project_id) = 'Y') then -- Bug # 4742904.
2142:
2143: -- Bug # 4757224.
2144:
2145: open cur_structure_version_ids(p_structure_version_id, p_relationship_type);