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_DELIVERABLE_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 416: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE

412:
413: PROCEDURE GET_OKE_FLAGS
414: ( p_project_id IN pa_projects_all.project_id%TYPE
415: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
416: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
417: ,p_action_item_id IN pa_proj_elements.proj_element_id%TYPE
418: ,p_action_version_id IN pa_proj_element_versions.element_version_id%TYPE
419: ,p_calling_module IN VARCHAR2
420: ,x_ready_to_ship OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 418: ,p_action_version_id IN pa_proj_element_versions.element_version_id%TYPE

414: ( p_project_id IN pa_projects_all.project_id%TYPE
415: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
416: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
417: ,p_action_item_id IN pa_proj_elements.proj_element_id%TYPE
418: ,p_action_version_id IN pa_proj_element_versions.element_version_id%TYPE
419: ,p_calling_module IN VARCHAR2
420: ,x_ready_to_ship OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
421: ,x_ready_to_procure OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
422: ,x_planning_initiated OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 441: ,pa_proj_element_versions ver

437: SELECT 'Y'
438: FROM dual
439: WHERE EXISTS ( SELECT 'Y'
440: FROM pa_object_relationships obj
441: ,pa_proj_element_versions ver
442: WHERE obj.object_id_from2 = p_dlvr_item_id
443: AND obj.object_type_to = 'PA_ACTIONS'
444: AND obj.object_type_from = 'PA_DELIVERABLES'
445: AND obj.object_id_to2 = ver.proj_element_id

Line 542: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE

538:
539: FUNCTION IS_TASK_ASSGMNT_EXISTS
540: ( p_project_id IN pa_projects_all.project_id%TYPE
541: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
542: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
543: )
544: RETURN VARCHAR2
545: IS
546: l_task_assignment_exists VARCHAR2(1) := 'N' ;

Line 586: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE

582:
583: PROCEDURE IS_DLV_STATUS_CHANGE_ALLOWED
584: ( p_project_id IN pa_projects_all.project_id%TYPE
585: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
586: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
587: ,p_dlv_type_id IN pa_task_types.task_type_id%TYPE
588: ,p_dlvr_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE
589: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
590: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 605: ,pa_proj_element_versions ver

601: SELECT 'Y'
602: FROM dual
603: WHERE EXISTS ( SELECT 'Y'
604: FROM pa_object_relationships obj
605: ,pa_proj_element_versions ver
606: WHERE obj.object_id_from2 = p_dlvr_item_id
607: AND obj.object_type_to = 'PA_ACTIONS'
608: AND obj.object_type_from = 'PA_DELIVERABLES'
609: AND obj.object_id_to2 = ver.proj_element_id

Line 635: ,pa_proj_element_versions ver

631: SELECT 'Y'
632: FROM dual
633: WHERE EXISTS ( SELECT 'Y'
634: FROM pa_object_relationships obj
635: ,pa_proj_element_versions ver
636: WHERE
637: obj.object_id_from2 = p_dlvr_item_id
638: AND obj.object_type_to = 'PA_ACTIONS'
639: AND obj.object_type_from = 'PA_DELIVERABLES'

Line 664: ,pa_proj_element_versions ver

660: SELECT 'Y'
661: FROM dual
662: WHERE EXISTS ( SELECT 'Y'
663: FROM pa_object_relationships obj
664: ,pa_proj_element_versions ver
665: WHERE
666: obj.object_id_from2 = p_dlvr_item_id
667: AND obj.object_type_to = 'PA_ACTIONS'
668: AND obj.object_type_from = 'PA_DELIVERABLES'

Line 884: ,p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

880:
881: FUNCTION IS_DLV_DOC_DEFINED
882: (
883: p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
884: ,p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
885: ) RETURN VARCHAR2
886: IS
887:
888: l_doc_defined VARCHAR2(1) := 'N' ;

Line 967: ,x_element_version_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895

963: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
964: ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
965: ,p_structure_type IN VARCHAR2 := 'DELIVERABLE'
966: ,x_proj_element_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895
967: ,x_element_version_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
968: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
969: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
970: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
971: )

Line 1011: pa_proj_element_versions pev,

1007: ppe.proj_element_id
1008: ,pev.element_version_id
1009: From
1010: pa_proj_elements ppe,
1011: pa_proj_element_versions pev,
1012: pa_proj_structure_types pst,
1013: pa_structure_types st
1014: Where
1015: ppe.project_id = p_project_id

Line 1456: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

1452:
1453:
1454: PROCEDURE GET_DLVR_DETAIL
1455: (
1456: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1457: ,x_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
1458: ,x_number OUT NOCOPY PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE --File.Sql.39 bug 4440895
1459: )
1460: IS

Line 1468: PA_PROJ_ELEMENT_VERSIONS PEV

1464: PPE.NAME,
1465: PPE.ELEMENT_NUMBER
1466: FROM
1467: PA_PROJ_ELEMENTS PPE,
1468: PA_PROJ_ELEMENT_VERSIONS PEV
1469: WHERE
1470: PEV.ELEMENT_VERSION_ID = p_dlvr_ver_id
1471: AND PPE.PROJECT_ID = PEV.PROJECT_ID
1472: AND PPE.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID

Line 1516: p_dlvr_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

1512:
1513:
1514: PROCEDURE GET_ACTION_DETAIL
1515: (
1516: p_dlvr_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1517: ,x_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
1518: ,x_number OUT NOCOPY PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE --File.Sql.39 bug 4440895
1519: )
1520: IS

Line 1529: PA_PROJ_ELEMENT_VERSIONS PEV

1525: PPE.NAME,
1526: PPE.ELEMENT_NUMBER
1527: FROM
1528: PA_PROJ_ELEMENTS PPE,
1529: PA_PROJ_ELEMENT_VERSIONS PEV
1530: WHERE
1531: PEV.ELEMENT_VERSION_ID = p_dlvr_action_ver_id
1532: AND PPE.PROJECT_ID = PEV.PROJECT_ID
1533: AND PPE.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID

Line 1576: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

1572:
1573:
1574: FUNCTION GET_PROJ_CURRENCY_CODE
1575: (
1576: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1577: )
1578: RETURN VARCHAR2
1579: IS
1580: x_proj_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE := null;

Line 1588: PA_PROJ_ELEMENT_VERSIONS PEV

1584: SELECT
1585: PPA.PROJFUNC_CURRENCY_CODE
1586: FROM
1587: PA_PROJECTS_ALL PPA,
1588: PA_PROJ_ELEMENT_VERSIONS PEV
1589: WHERE
1590: PEV.ELEMENT_VERSION_ID = p_dlvr_ver_id
1591: AND PEV.PROJECT_ID = PPA.PROJECT_ID
1592: AND PEV.OBJECT_TYPE = 'PA_DELIVERABLES';

Line 1631: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

1627:
1628:
1629: PROCEDURE GET_DLVR_PROJECT_DETAIL
1630: (
1631: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1632: ,x_project_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJECT_ID%TYPE --File.Sql.39 bug 4440895
1633: ,x_project_name OUT NOCOPY PA_PROJECTS_ALL.NAME%TYPE --File.Sql.39 bug 4440895
1634: )
1635: IS

Line 1644: PA_PROJ_ELEMENT_VERSIONS PEV

1640: PPA.PROJECT_ID,
1641: PPA.NAME
1642: FROM
1643: PA_PROJECTS_ALL PPA,
1644: PA_PROJ_ELEMENT_VERSIONS PEV
1645: WHERE
1646: PEV.ELEMENT_VERSION_ID = p_dlvr_ver_id
1647: AND PEV.PROJECT_ID = PPA.PROJECT_ID
1648: AND PEV.OBJECT_TYPE = 'PA_DELIVERABLES';

Line 1690: p_dlvr_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

1686:
1687:
1688: PROCEDURE GET_ACTION_PROJECT_DETAIL
1689: (
1690: p_dlvr_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1691: ,x_project_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJECT_ID%TYPE --File.Sql.39 bug 4440895
1692: ,x_project_name OUT NOCOPY PA_PROJECTS_ALL.NAME%TYPE --File.Sql.39 bug 4440895
1693: )
1694: IS

Line 1703: PA_PROJ_ELEMENT_VERSIONS PEV

1699: PPA.PROJECT_ID,
1700: PPA.NAME
1701: FROM
1702: PA_PROJECTS_ALL PPA,
1703: PA_PROJ_ELEMENT_VERSIONS PEV
1704: WHERE
1705: PEV.ELEMENT_VERSION_ID = p_dlvr_action_ver_id
1706: AND PEV.PROJECT_ID = PPA.PROJECT_ID
1707: AND PEV.OBJECT_TYPE = 'PA_ACTIONS';

Line 1747: p_task_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

1743:
1744:
1745: FUNCTION GET_ACTION_TASK_DETAIL
1746: (
1747: p_task_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1748: ) RETURN VARCHAR2
1749: IS
1750:
1751: l_task_number VARCHAR2(340) ;

Line 1804: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

1800:
1801: PROCEDURE GET_DEFAULT_DLVR_OWNER
1802: (
1803: p_project_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1804: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1805: ,x_owner_id OUT NOCOPY PER_ALL_PEOPLE_F.PERSON_ID%TYPE --File.Sql.39 bug 4440895
1806: ,x_owner_name OUT NOCOPY PER_ALL_PEOPLE_F.FULL_NAME%TYPE --File.Sql.39 bug 4440895
1807: )
1808: IS

Line 1818: PA_PROJ_ELEMENT_VERSIONS PEV

1814: ,PPF.FULL_NAME
1815: FROM
1816: PA_PROJ_ELEMENTS PPE,
1817: PER_ALL_PEOPLE_F PPF,
1818: PA_PROJ_ELEMENT_VERSIONS PEV
1819: WHERE
1820: PEV.ELEMENT_VERSION_ID = p_task_ver_id
1821: AND PEV.OBJECT_TYPE = 'PA_TASKS'
1822: AND PEV.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID

Line 1879: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

1875:
1876: PROCEDURE GET_DEFAULT_DLVR_DATE
1877: (
1878: p_project_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1879: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1880: ,x_due_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
1881: )
1882: IS
1883:

Line 1908: PA_PROJ_ELEMENT_VERSIONS PEV

1904: SELECT
1905: PES.SCHEDULED_FINISH_DATE,
1906: SYSDATE
1907: FROM
1908: PA_PROJ_ELEMENT_VERSIONS PEV
1909: ,PA_PROJ_ELEM_VER_SCHEDULE PES
1910: WHERE
1911: PEV.ELEMENT_VERSION_ID = p_task_ver_id
1912: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID ;

Line 1987: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

1983: -- x_owner_name VARCHAR Owner Name
1984:
1985: PROCEDURE GET_DEFAULT_ACTION_OWNER
1986: (
1987: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1988: ,x_owner_id OUT NOCOPY PER_ALL_PEOPLE_F.PERSON_ID%TYPE --File.Sql.39 bug 4440895
1989: ,x_owner_name OUT NOCOPY PER_ALL_PEOPLE_F.FULL_NAME%TYPE --File.Sql.39 bug 4440895
1990: )
1991: IS

Line 1999: PA_PROJ_ELEMENT_VERSIONS PEV

1995: SELECT
1996: PPF.PERSON_ID
1997: ,PPF.FULL_NAME
1998: FROM
1999: PA_PROJ_ELEMENT_VERSIONS PEV
2000: ,PA_PROJ_ELEMENTS PPE
2001: ,PER_ALL_PEOPLE_F PPF
2002: WHERE
2003: PEV.ELEMENT_VERSION_ID = p_dlvr_ver_id

Line 2052: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

2048: -- x_earliest_finish_date DATE Earliest Finish Date
2049:
2050: PROCEDURE GET_DEFAULT_ACTION_DATE
2051: (
2052: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2053: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2054: ,p_project_mode IN VARCHAR2
2055: ,p_function_code IN PA_PROJ_ELEMENTS.FUNCTION_CODE%TYPE
2056: ,x_due_date OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 2053: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

2049:
2050: PROCEDURE GET_DEFAULT_ACTION_DATE
2051: (
2052: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2053: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2054: ,p_project_mode IN VARCHAR2
2055: ,p_function_code IN PA_PROJ_ELEMENTS.FUNCTION_CODE%TYPE
2056: ,x_due_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
2057: )

Line 2072: PA_PROJ_ELEMENT_VERSIONS PEV,

2068: SELECT
2069: PES.SCHEDULED_FINISH_DATE,
2070: SYSDATE
2071: FROM
2072: PA_PROJ_ELEMENT_VERSIONS PEV,
2073: PA_PROJ_ELEM_VER_SCHEDULE PES
2074: WHERE
2075: PEV.ELEMENT_VERSION_ID = p_dlvr_ver_id
2076: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID ;

Line 2090: PA_PROJ_ELEMENT_VERSIONS PEV

2086: PES.EARLY_START_DATE
2087: ,PES.EARLY_FINISH_DATE
2088: ,PES.SCHEDULED_FINISH_DATE
2089: FROM
2090: PA_PROJ_ELEMENT_VERSIONS PEV
2091: ,PA_PROJ_ELEM_VER_SCHEDULE PES
2092: WHERE
2093: PEV.ELEMENT_VERSION_ID = p_task_ver_id
2094: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID ;

Line 2178: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL

2174:
2175: FUNCTION IS_DLV_BASED_ASSCN_EXISTS
2176: (
2177: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
2178: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
2179: )
2180: RETURN VARCHAR2
2181: IS
2182: l_dummy VARCHAR2(1) := 'N' ;

Line 2236: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

2232:
2233: FUNCTION GET_READY_TO_SHIP_FLAG
2234: (
2235: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
2236: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2237: ) RETURN VARCHAR2
2238: IS
2239: CURSOR ship_flag_dlv IS
2240: SELECT 'Y'

Line 2244: ,pa_proj_element_versions ver

2240: SELECT 'Y'
2241: FROM dual
2242: WHERE EXISTS ( SELECT 'Y'
2243: FROM pa_object_relationships obj
2244: ,pa_proj_element_versions ver
2245: WHERE obj.object_id_from2 = p_dlv_element_id
2246: AND obj.object_type_to = 'PA_ACTIONS'
2247: AND obj.object_type_from = 'PA_DELIVERABLES'
2248: AND obj.object_id_to2 = ver.proj_element_id

Line 2270: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

2266:
2267: FUNCTION GET_READY_TO_PROC_FLAG
2268: (
2269: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
2270: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2271: ) RETURN VARCHAR2
2272: IS
2273: CURSOR proc_flag_dlv IS
2274: SELECT 'Y'

Line 2278: ,pa_proj_element_versions ver

2274: SELECT 'Y'
2275: FROM dual
2276: WHERE EXISTS ( SELECT 'Y'
2277: FROM pa_object_relationships obj
2278: ,pa_proj_element_versions ver
2279: WHERE obj.object_id_from2 = p_dlv_element_id
2280: AND obj.object_type_to = 'PA_ACTIONS'
2281: AND obj.object_type_from = 'PA_DELIVERABLES'
2282: AND obj.object_id_to2 = ver.proj_element_id

Line 2442: p_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

2438: END GET_PROJECT_DETAILS;
2439:
2440: FUNCTION GET_DLV_DESCRIPTION
2441: (
2442: p_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2443: ) RETURN VARCHAR2
2444: IS
2445: CURSOR c_dlv_desc IS
2446: SELECT ppe.description

Line 2449: ,pa_proj_element_versions pev

2445: CURSOR c_dlv_desc IS
2446: SELECT ppe.description
2447: FROM pa_proj_elements ppe
2448: ,pa_object_relationships obj
2449: ,pa_proj_element_versions pev
2450: WHERE pev.element_version_id = p_action_ver_id
2451: AND pev.object_type = 'PA_ACTIONS' /*Included this clause for Performance fix Bug # 3614361 */
2452: AND pev.proj_element_id = obj.object_id_to2
2453: AND obj.relationship_type = 'A'

Line 2474: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

2470: -- and return deliverable description
2471:
2472: FUNCTION GET_DELIVERABLE_DESCRIPTION
2473: (
2474: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2475: ) RETURN VARCHAR2
2476: IS
2477: CURSOR c_dlv_desc IS
2478: SELECT

Line 2482: ,pa_proj_element_versions pev

2478: SELECT
2479: ppe.description
2480: FROM
2481: pa_proj_elements ppe
2482: ,pa_proj_element_versions pev
2483: WHERE
2484: pev.element_version_id = p_deliverable_id
2485: AND ppe.object_type = 'PA_DELIVERABLES'
2486: AND pev.object_type = 'PA_DELIVERABLES'

Line 2504: p_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

2500: -- 3470061
2501:
2502: FUNCTION IS_DLV_ITEM_BASED
2503: (
2504: p_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2505: ) RETURN VARCHAR2
2506: IS
2507: CURSOR c_is_dlv_item_based IS
2508: SELECT 'Y'

Line 2513: ,pa_proj_element_versions pev

2509: FROM dual
2510: WHERE EXISTS (SELECT 'Y'
2511: FROM pa_proj_elements ppe
2512: ,pa_object_relationships obj
2513: ,pa_proj_element_versions pev
2514: ,pa_task_types ptt
2515: WHERE pev.element_version_id = p_action_ver_id
2516: AND pev.proj_element_id = obj.object_id_to2
2517: AND obj.relationship_type = 'A'

Line 2551: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

2547: -- x_earliest_finish_date DATE Earliest Finish Date
2548:
2549: PROCEDURE GET_DEFAULT_ACTN_DATE
2550: (
2551: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2552: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2553: ,p_project_mode IN VARCHAR2
2554: ,x_due_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
2555: ,x_earliest_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 2552: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

2548:
2549: PROCEDURE GET_DEFAULT_ACTN_DATE
2550: (
2551: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2552: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2553: ,p_project_mode IN VARCHAR2
2554: ,x_due_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
2555: ,x_earliest_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
2556: ,x_earliest_finish_date OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 2570: PA_PROJ_ELEMENT_VERSIONS PEV,

2566: SELECT
2567: PES.SCHEDULED_FINISH_DATE,
2568: SYSDATE
2569: FROM
2570: PA_PROJ_ELEMENT_VERSIONS PEV,
2571: PA_PROJ_ELEM_VER_SCHEDULE PES
2572: WHERE
2573: PEV.ELEMENT_VERSION_ID = p_dlvr_ver_id
2574: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID

Line 2585: PA_PROJ_ELEMENT_VERSIONS PEV

2581: PES.EARLY_START_DATE
2582: ,PES.EARLY_FINISH_DATE
2583: ,PES.SCHEDULED_FINISH_DATE
2584: FROM
2585: PA_PROJ_ELEMENT_VERSIONS PEV
2586: ,PA_PROJ_ELEM_VER_SCHEDULE PES
2587: WHERE
2588: PEV.ELEMENT_VERSION_ID = p_task_ver_id
2589: AND PEV.ELEMENT_VERSION_ID = PES.ELEMENT_VERSION_ID

Line 2678: pa_proj_element_versions ppev

2674: SELECT 1 FROM dual
2675: WHERE EXISTS(
2676: SELECT ppe.proj_element_id DlvrElemId, ppev.element_version_id DlvrElemVerId
2677: FROM pa_proj_elements ppe,
2678: pa_proj_element_versions ppev
2679: WHERE ppe.proj_element_id = ppev.proj_element_id
2680: AND ppe.project_id = p_project_id
2681: AND ppev.project_id = p_project_id
2682: AND ppe.object_type = ppev.object_type

Line 2703: pa_proj_element_versions ppev

2699: SELECT 1 FROM dual
2700: WHERE EXISTS(
2701: SELECT ppe.proj_element_id DlvrElemId, ppev.element_version_id DlvrElemVerId
2702: FROM pa_proj_elements ppe,
2703: pa_proj_element_versions ppev
2704: WHERE ppe.project_id = p_project_id
2705: AND ppe.object_type = 'PA_DELIVERABLES'
2706: AND 'Y' = PA_DELIVERABLE_UTILS.IS_DELIVERABLE_HAS_PROGRESS(p_project_id,ppe.proj_element_id)
2707: );

Line 2715: pa_proj_element_versions ppev

2711: SELECT 1 FROM dual
2712: WHERE EXISTS(
2713: SELECT ppe.proj_element_id DlvrElemId, ppev.element_version_id DlvrElemVerId
2714: FROM pa_proj_elements ppe,
2715: pa_proj_element_versions ppev
2716: WHERE ppe.proj_element_id = ppev.proj_element_id
2717: AND ppe.project_id = p_project_id
2718: AND ppev.project_id = p_project_id
2719: AND ppe.object_type = ppev.object_type

Line 2877: pa_proj_element_versions ppv,

2873: SELECT 1 FROM dual
2874: WHERE EXISTS(
2875: SELECT 1
2876: FROM pa_proj_elements ppe,
2877: pa_proj_element_versions ppv,
2878: pa_object_relationships obj1,
2879: pa_object_relationships obj2
2880: WHERE ppe.proj_element_id=p_task_id
2881: AND ppe.object_type='PA_TASKS'

Line 2999: ,p_wp_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

2995:
2996: PROCEDURE CHECK_CHANGE_MAPPING_OK( p_api_version IN NUMBER := 1.0
2997: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2998: ,p_debug_mode IN VARCHAR2 := 'N'
2999: ,p_wp_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
3000: ,p_fp_task_verison_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
3001: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3002: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3003: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3000: ,p_fp_task_verison_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

2996: PROCEDURE CHECK_CHANGE_MAPPING_OK( p_api_version IN NUMBER := 1.0
2997: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2998: ,p_debug_mode IN VARCHAR2 := 'N'
2999: ,p_wp_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
3000: ,p_fp_task_verison_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
3001: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3002: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3003: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3004: )

Line 3011: pa_proj_element_versions ppv,

3007: SELECT 1 FROM dual
3008: WHERE EXISTS(
3009: SELECT 1
3010: FROM pa_proj_elements ppe,
3011: pa_proj_element_versions ppv,
3012: pa_object_relationships obj1,
3013: pa_object_relationships obj2
3014: WHERE ppe.proj_element_id=p_wp_task_version_id
3015: AND ppe.object_type='PA_TASKS'

Line 3134: pa_proj_element_versions ppev

3130: WHERE EXISTS(
3131: SELECT 1
3132: FROM pa_proj_elements ppe,
3133: pa_object_relationships obj,
3134: pa_proj_element_versions ppev
3135: WHERE ppe.proj_element_id=p_task_id
3136: AND ppe.object_type='PA_TASKS'
3137: AND obj.relationship_type='A'
3138: AND obj.relationship_subtype='TASK_TO_DELIVERABLE'

Line 3237: pa_proj_element_versions ppev,

3233: WHERE EXISTS(
3234: SELECT 1
3235: FROM pa_proj_elements ppe,
3236: pa_proj_elements ppe2,
3237: pa_proj_element_versions ppev,
3238: pa_object_relationships obj1,
3239: pa_object_relationships obj2
3240: WHERE ppe.project_id = p_project_id
3241: AND ppe.object_type = 'PA_ACTIONS'

Line 3582: p_action_version_id IN pa_proj_element_versions.element_version_id%TYPE

3578: END IS_ITEM_BASED_DLV_EXISTS ;
3579:
3580: FUNCTION IS_BILLING_FUNCTION
3581: (
3582: p_action_version_id IN pa_proj_element_versions.element_version_id%TYPE
3583: )
3584: RETURN VARCHAR2
3585: IS
3586: CURSOR C IS

Line 3591: pa_proj_element_versions pev

3587: SELECT 'Y'
3588: FROM DUAL
3589: WHERE EXISTS (Select 'Y'
3590: from pa_proj_elements ppe,
3591: pa_proj_element_versions pev
3592: where pev.element_version_id = p_action_version_id
3593: and ppe.proj_element_id = pev.proj_element_id
3594: and ppe.function_code = 'BILLING'
3595: ) ;

Line 3649: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

3645:
3646: -- p_deliverable_id IN VARCHAR2 N Deliverable Version Id
3647: FUNCTION IS_DLVR_ITEM_BASED
3648: (
3649: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
3650: ) RETURN VARCHAR2
3651: IS
3652: CURSOR c_is_dlvr_item_based IS
3653: SELECT 'Y'

Line 3657: PA_PROJ_ELEMENT_VERSIONS PEV

3653: SELECT 'Y'
3654: FROM PA_TASK_TYPES
3655: WHERE TASK_TYPE_ID=(SELECT TYPE_ID
3656: FROM PA_PROJ_ELEMENTS PPE,
3657: PA_PROJ_ELEMENT_VERSIONS PEV
3658: WHERE PPE.PROJ_ELEMENT_ID= PEV.PROJ_ELEMENT_ID
3659: AND PEV.ELEMENT_VERSION_ID = p_deliverable_id
3660: AND PEV.OBJECT_TYPE='PA_DELIVERABLES'
3661: AND PPE.OBJECT_TYPE='PA_DELIVERABLES')

Line 3685: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

3681: -- p_deliverable_id IN VARCHAR2 N Deliverable Version Id
3682:
3683: FUNCTION GET_DLVR_NAME_NUMBER
3684: (
3685: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
3686: ) RETURN VARCHAR2
3687: IS
3688: CURSOR c_dlv_name_number IS
3689: SELECT

Line 3693: ,pa_proj_element_versions pev

3689: SELECT
3690: ppe.name || '(' || ppe.element_number || ')'
3691: FROM
3692: pa_proj_elements ppe
3693: ,pa_proj_element_versions pev
3694: WHERE
3695: pev.element_version_id = p_deliverable_id
3696: AND ppe.object_type = 'PA_DELIVERABLES'
3697: AND pev.object_type = 'PA_DELIVERABLES'

Line 3722: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

3718: -- p_deliverable_id IN VARCHAR2 N Deliverable Version Id
3719:
3720: FUNCTION GET_DLVR_NUMBER
3721: (
3722: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
3723: ) RETURN VARCHAR2
3724: IS
3725: CURSOR c_dlv_name_number IS
3726: SELECT

Line 3730: ,pa_proj_element_versions pev

3726: SELECT
3727: ppe.ELEMENT_NUMBER
3728: FROM
3729: pa_proj_elements ppe
3730: ,pa_proj_element_versions pev
3731: WHERE
3732: pev.element_version_id = p_deliverable_id
3733: AND ppe.object_type = 'PA_DELIVERABLES'
3734: AND pev.object_type = 'PA_DELIVERABLES'

Line 3763: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

3759:
3760:
3761: FUNCTION IS_DLVR_OWNER
3762: (
3763: p_deliverable_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
3764: ,p_user_id IN NUMBER
3765: ) RETURN VARCHAR2
3766: IS
3767: CURSOR c_dlvr_owner IS

Line 3772: pa_proj_element_versions pev

3768: select
3769: ppe.manager_person_id
3770: from
3771: pa_proj_elements ppe,
3772: pa_proj_element_versions pev
3773: where
3774: pev.element_version_id = p_deliverable_id
3775: and pev.object_type = 'PA_DELIVERABLES'
3776: and ppe.object_type = 'PA_DELIVERABLES'

Line 4195: l_dummy pa_proj_element_versions.element_version_id%TYPE;

4191: p_project_id IN NUMBER
4192: ) RETURN NUMBER
4193: IS
4194:
4195: l_dummy pa_proj_element_versions.element_version_id%TYPE;
4196:
4197: CURSOR c_dlvr_version IS
4198: SELECT
4199: pev.element_version_id

Line 4202: ,pa_proj_element_versions pev

4198: SELECT
4199: pev.element_version_id
4200: FROM
4201: pa_proj_elements ppe
4202: ,pa_proj_element_versions pev
4203: WHERE
4204: pev.proj_element_id = p_deliverable_id
4205: AND ppe.object_type = 'PA_DELIVERABLES'
4206: AND pev.object_type = 'PA_DELIVERABLES'

Line 4584: l_dummy pa_proj_element_versions.element_version_id%TYPE;

4580: p_project_id IN NUMBER
4581: ) RETURN NUMBER
4582: IS
4583:
4584: l_dummy pa_proj_element_versions.element_version_id%TYPE;
4585:
4586: CURSOR c_action_version IS
4587: SELECT
4588: pev.element_version_id

Line 4591: ,pa_proj_element_versions pev

4587: SELECT
4588: pev.element_version_id
4589: FROM
4590: pa_proj_elements ppe
4591: ,pa_proj_element_versions pev
4592: WHERE
4593: pev.proj_element_id = p_action_id
4594: AND ppe.object_type = 'PA_ACTIONS'
4595: AND pev.object_type = 'PA_ACTIONS'

Line 5048: l_structure_version_id Pa_Proj_Element_Versions.Element_Version_Id%TYPE;

5044: WHERE Project_id = p_Project_Id;
5045:
5046: l_name Pa_Proj_Elements.Name%TYPE;
5047: l_structure_id Pa_Proj_Elements.Proj_Element_Id%TYPE;
5048: l_structure_version_id Pa_Proj_Element_Versions.Element_Version_Id%TYPE;
5049: l_pev_structure_id Pa_Proj_Element_Versions.Element_Version_Id%TYPE;
5050:
5051: l_api_name CONSTANT VARCHAR2(30) := 'ENABLE_DELIVERABLES';
5052: l_msg_index_out NUMBER;

Line 5049: l_pev_structure_id Pa_Proj_Element_Versions.Element_Version_Id%TYPE;

5045:
5046: l_name Pa_Proj_Elements.Name%TYPE;
5047: l_structure_id Pa_Proj_Elements.Proj_Element_Id%TYPE;
5048: l_structure_version_id Pa_Proj_Element_Versions.Element_Version_Id%TYPE;
5049: l_pev_structure_id Pa_Proj_Element_Versions.Element_Version_Id%TYPE;
5050:
5051: l_api_name CONSTANT VARCHAR2(30) := 'ENABLE_DELIVERABLES';
5052: l_msg_index_out NUMBER;
5053: -- added for Bug:4537865

Line 5351: -- as PA_PROJ_ELEMENT_VERSIONS had join with object relationship table

5347: IS
5348:
5349:
5350: -- 3578694 removed the cursor
5351: -- as PA_PROJ_ELEMENT_VERSIONS had join with object relationship table
5352: -- and one of the where condition was checking the structure_to_task relationship subtype
5353: -- so for child tasks, above condition is failing
5354:
5355: --cursor c_task_exists(l_struct_ver_id IN NUMBER) IS

Line 5360: -- ,PA_PROJ_ELEMENT_VERSIONS PEV

5356: -- SELECT
5357: -- PEV.ELEMENT_VERSION_ID
5358: -- FROM
5359: -- PA_OBJECT_RELATIONSHIPS POR
5360: -- ,PA_PROJ_ELEMENT_VERSIONS PEV
5361: -- WHERE
5362: -- POR.OBJECT_ID_FROM1 = l_struct_ver_id
5363: -- AND PEV.PROJ_ELEMENT_ID = p_task_id
5364: -- AND POR.OBJECT_ID_TO1 = PEV.ELEMENT_VERSION_ID

Line 5375: PA_PROJ_ELEMENT_VERSIONS PEV

5371: cursor c_task_exists(l_struct_ver_id IN NUMBER) IS
5372: SELECT
5373: PEV.ELEMENT_VERSION_ID
5374: FROM
5375: PA_PROJ_ELEMENT_VERSIONS PEV
5376: WHERE
5377: PEV.PARENT_STRUCTURE_VERSION_ID = l_struct_ver_id
5378: AND PEV.PROJ_ELEMENT_ID = p_task_id
5379: AND PEV.PROJECT_ID = p_project_id;

Line 5581: ,pa_proj_element_versions pev1

5577: SELECT distinct pt.task_id
5578: ,pt.task_name
5579: ,pt.task_number
5580: FROM pa_tasks pt
5581: ,pa_proj_element_versions pev1
5582: ,pa_proj_element_versions pev2
5583: ,pa_object_relationships obj1
5584: ,pa_object_relationships obj2
5585: WHERE obj1.object_id_to2 = p_dlv_element_id

Line 5582: ,pa_proj_element_versions pev2

5578: ,pt.task_name
5579: ,pt.task_number
5580: FROM pa_tasks pt
5581: ,pa_proj_element_versions pev1
5582: ,pa_proj_element_versions pev2
5583: ,pa_object_relationships obj1
5584: ,pa_object_relationships obj2
5585: WHERE obj1.object_id_to2 = p_dlv_element_id
5586: AND obj1.relationship_type = 'A'

Line 5607: ,pa_proj_element_versions pev

5603: SELECT distinct pt.task_id
5604: ,pt.task_name
5605: ,pt.task_number
5606: FROM pa_tasks pt
5607: ,pa_proj_element_versions pev
5608: ,pa_object_relationships obj
5609: WHERE obj.object_id_to2 = p_dlv_element_id
5610: AND obj.relationship_type = 'A'
5611: AND obj.relationship_subtype = 'TASK_TO_DELIVERABLE'

Line 5630: ,pa_proj_element_versions pev1

5626: SELECT distinct pt.top_task_id
5627: ,pt1.task_name
5628: ,pt1.task_number
5629: FROM pa_tasks pt
5630: ,pa_proj_element_versions pev1
5631: ,pa_proj_element_versions pev2
5632: ,pa_object_relationships obj1
5633: ,pa_object_relationships obj2
5634: ,pa_tasks pt1

Line 5631: ,pa_proj_element_versions pev2

5627: ,pt1.task_name
5628: ,pt1.task_number
5629: FROM pa_tasks pt
5630: ,pa_proj_element_versions pev1
5631: ,pa_proj_element_versions pev2
5632: ,pa_object_relationships obj1
5633: ,pa_object_relationships obj2
5634: ,pa_tasks pt1
5635: WHERE obj1.object_id_to2 = p_dlv_element_id

Line 5658: ,pa_proj_element_versions pev

5654: SELECT distinct pt.top_task_id
5655: ,pt1.task_name
5656: ,pt1.task_number
5657: FROM pa_tasks pt
5658: ,pa_proj_element_versions pev
5659: ,pa_object_relationships obj
5660: ,pa_tasks pt1
5661: WHERE obj.object_id_to2 = p_dlv_element_id
5662: AND obj.relationship_type = 'A'

Line 5849: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

5845:
5846: FUNCTION IS_SHIPPING_INITIATED
5847: (
5848: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
5849: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
5850: ) RETURN VARCHAR2
5851: IS
5852: CURSOR ship_flag_dlv IS
5853: SELECT 'Y'

Line 5857: ,pa_proj_element_versions ver

5853: SELECT 'Y'
5854: FROM dual
5855: WHERE EXISTS ( SELECT 'Y'
5856: FROM pa_object_relationships obj
5857: ,pa_proj_element_versions ver
5858: WHERE obj.object_id_from2 = p_dlv_element_id
5859: AND obj.object_type_to = 'PA_ACTIONS'
5860: AND obj.object_type_from = 'PA_DELIVERABLES'
5861: AND obj.object_id_to2 = ver.proj_element_id

Line 5895: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

5891:
5892: FUNCTION IS_PROCUREMENT_INITIATED
5893: (
5894: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
5895: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
5896: ) RETURN VARCHAR2
5897: IS
5898: CURSOR proc_flag_dlv IS
5899: SELECT 'Y'

Line 5903: ,pa_proj_element_versions ver

5899: SELECT 'Y'
5900: FROM dual
5901: WHERE EXISTS ( SELECT 'Y'
5902: FROM pa_object_relationships obj
5903: ,pa_proj_element_versions ver
5904: WHERE obj.object_id_from2 = p_dlv_element_id
5905: AND obj.object_type_to = 'PA_ACTIONS'
5906: AND obj.object_type_from = 'PA_DELIVERABLES'
5907: AND obj.object_id_to2 = ver.proj_element_id

Line 5941: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

5937:
5938: FUNCTION IS_BILLING_EVENT_PROCESSED
5939: (
5940: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
5941: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
5942: ) RETURN VARCHAR2
5943: IS
5944: CURSOR bill_flag_dlv IS
5945: SELECT 'Y'

Line 5949: ,pa_proj_element_versions ver

5945: SELECT 'Y'
5946: FROM dual
5947: WHERE EXISTS ( SELECT 'Y'
5948: FROM pa_object_relationships obj
5949: ,pa_proj_element_versions ver
5950: WHERE obj.object_id_from2 = p_dlv_element_id
5951: AND obj.object_type_to = 'PA_ACTIONS'
5952: AND obj.object_type_from = 'PA_DELIVERABLES'
5953: AND obj.object_id_to2 = ver.proj_element_id

Line 6080: PA_PROJ_ELEMENT_VERSIONS PEV

6076: cursor c_task_exists(l_struct_ver_id IN NUMBER) IS
6077: SELECT
6078: PEV.ELEMENT_VERSION_ID
6079: FROM
6080: PA_PROJ_ELEMENT_VERSIONS PEV
6081: WHERE
6082: PEV.PARENT_STRUCTURE_VERSION_ID = l_struct_ver_id
6083: AND PEV.PROJ_ELEMENT_ID = p_task_id
6084: AND PEV.PROJECT_ID = p_project_id;

Line 6093: ,PA_PROJ_ELEMENT_VERSIONS PEV

6089: SELECT PPEVS.ELEMENT_VERSION_ID STRUCT_VER_ID
6090: ,PEV.ELEMENT_VERSION_ID TASK_VER_ID
6091: FROM
6092: PA_PROJ_ELEM_VER_STRUCTURE PPEVS
6093: ,PA_PROJ_ELEMENT_VERSIONS PEV
6094: WHERE PEV.PROJECT_ID = p_project_id
6095: AND PEV.PARENT_STRUCTURE_VERSION_ID = PPEVS.ELEMENT_VERSION_ID
6096: AND PEV.PROJ_ELEMENT_ID = p_task_id
6097: AND PEV.PROJECT_ID = PPEVS.PROJECT_ID

Line 6181: p_dlvr_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

6177: --
6178:
6179: PROCEDURE GET_SHIP_PROC_ACTN_DETAIL
6180: (
6181: p_dlvr_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
6182: ,x_ship_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
6183: ,x_ship_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
6184: ,x_ship_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
6185: ,x_proc_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895

Line 6182: ,x_ship_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895

6178:
6179: PROCEDURE GET_SHIP_PROC_ACTN_DETAIL
6180: (
6181: p_dlvr_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
6182: ,x_ship_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
6183: ,x_ship_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
6184: ,x_ship_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
6185: ,x_proc_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
6186: ,x_proc_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895

Line 6185: ,x_proc_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895

6181: p_dlvr_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
6182: ,x_ship_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
6183: ,x_ship_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
6184: ,x_ship_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
6185: ,x_proc_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
6186: ,x_proc_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
6187: ,x_proc_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
6188: )
6189: IS

Line 6201: ,pa_proj_element_versions pev

6197: from
6198: pa_object_relationships obj
6199: ,pa_proj_elements ppe
6200: ,pa_proj_elem_ver_schedule ppevs
6201: ,pa_proj_element_versions pev
6202: where
6203: pev.element_version_id = p_dlvr_id
6204: and obj.object_id_from2 = pev.proj_element_id
6205: and pev.object_type = 'PA_DELIVERABLES'

Line 6225: ,pa_proj_element_versions pev

6221: from
6222: pa_object_relationships obj
6223: ,pa_proj_elements ppe
6224: ,pa_proj_elem_ver_schedule ppevs
6225: ,pa_proj_element_versions pev
6226: where
6227: pev.element_version_id = p_dlvr_id
6228: and obj.object_id_from2 = pev.proj_element_id
6229: and pev.object_type = 'PA_DELIVERABLES'