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 1380: PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(elv.project_id))

1376: and a.object_id_from2 <> c_parent_proj_id -- Fix for Bug # 4297715.
1377: and exists (select 1 from PA_PROJ_ELEMENT_VERSIONS elv /* Added the exists for Bug 6148092 */
1378: where elv.element_version_id = a.object_id_from1
1379: and ((elv.PARENT_STRUCTURE_VERSION_ID =
1380: PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(elv.project_id))
1381: or (elv.PARENT_STRUCTURE_VERSION_ID =
1382: PA_PROJECT_STRUCTURE_UTILS.get_latest_wp_version(elv.project_id))
1383: )
1384: );

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

1378: where elv.element_version_id = a.object_id_from1
1379: and ((elv.PARENT_STRUCTURE_VERSION_ID =
1380: PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(elv.project_id))
1381: or (elv.PARENT_STRUCTURE_VERSION_ID =
1382: PA_PROJECT_STRUCTURE_UTILS.get_latest_wp_version(elv.project_id))
1383: )
1384: );
1385:
1386: l_linked_parent_proj_id NUMBER;

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

2059:
2060: -- The calling API in this case is: pa_task_utils.check_create_subtask_ok() which is only
2061: -- called for 'FINANCIAL' tasks.
2062:
2063: l_cur_working_str_ver_id := pa_project_structure_utils.get_fin_struc_ver_id(p_project_id);
2064:
2065: open cur_task_version_id(p_project_id, p_task_id, l_cur_working_str_ver_id);
2066: fetch cur_task_version_id into l_task_version_id;
2067: close cur_task_version_id;

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

2152: begin
2153:
2154: l_return_value := 'N';
2155:
2156: if (pa_project_structure_utils.check_program_flag_enable(p_project_id) = 'Y') then -- Bug # 4742904.
2157:
2158: -- Bug # 4757224.
2159:
2160: open cur_structure_version_ids(p_structure_version_id, p_relationship_type);