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_PROJECTS_ALL

Line 414: ( p_project_id IN pa_projects_all.project_id%TYPE

410: -- x_msg_count OUT VARCHAR2 Y
411: -- x_msg_data OUT
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

Line 540: ( p_project_id IN pa_projects_all.project_id%TYPE

536: -- p_dlvr_item_id IN NUMBER Y element id of the deliverable
537: -- p_dlvr_version_id IN NUMBER Y version id of the deliverable
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

Line 584: ( p_project_id IN pa_projects_all.project_id%TYPE

580: -- x_msg_data OUT VARCHAR2
581:
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

Line 1118: PA_PROJECTS_ALL p

1114: IF (p_task_id IS NULL) THEN
1115: SELECT
1116: p.carrying_out_organization_id INTO x_organization_id
1117: FROM
1118: PA_PROJECTS_ALL p
1119: WHERE p.project_id = p_project_id;
1120: -- else retrive carrying_out_organization_id from pa_proj_elements
1121: ELSE
1122: SELECT

Line 1565: -- Note : Retrieve projfunc_currency_code from pa_projects_all

1561:
1562: -- Procedure : GET_PROJ_CURRENCY_CODE
1563: -- Type : UTILITY
1564: -- Purpose : To retrieve Project Currency Code
1565: -- Note : Retrieve projfunc_currency_code from pa_projects_all
1566: -- :
1567: -- Assumptions : None
1568:
1569: -- Parameters Type Required Description and Purpose

Line 1580: x_proj_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE := null;

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;
1581:
1582: CURSOR l_proj_currency_code_csr
1583: IS
1584: SELECT

Line 1587: PA_PROJECTS_ALL PPA,

1583: IS
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

Line 1618: -- Note : Retrieve Project Id and Name from pa_projects_all

1614:
1615: -- Procedure : GET_DLVR_PROJECT_DETAIL
1616: -- Type : UTILITY
1617: -- Purpose : To retrieve Project Id and name
1618: -- Note : Retrieve Project Id and Name from pa_projects_all
1619: -- :
1620: -- Assumptions : None
1621:
1622: -- Parameters Type Required Description and Purpose

Line 1633: ,x_project_name OUT NOCOPY PA_PROJECTS_ALL.NAME%TYPE --File.Sql.39 bug 4440895

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
1636:
1637: CURSOR l_project_info_csr

Line 1643: PA_PROJECTS_ALL PPA,

1639: SELECT
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

Line 1677: -- Note : Retrieve Project Id and Name from pa_projects_all

1673:
1674: -- Procedure : GET_ACTION_PROJECT_DETAIL
1675: -- Type : UTILITY
1676: -- Purpose : To retrieve Project Id and name
1677: -- Note : Retrieve Project Id and Name from pa_projects_all
1678: -- :
1679: -- Assumptions : None
1680:
1681: -- Parameters Type Required Description and Purpose

Line 1692: ,x_project_name OUT NOCOPY PA_PROJECTS_ALL.NAME%TYPE --File.Sql.39 bug 4440895

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
1695:
1696: CURSOR l_project_info_csr

Line 1702: PA_PROJECTS_ALL PPA,

1698: SELECT
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

Line 1897: PA_PROJECTS_ALL

1893: TARGET_FINISH_DATE,
1894: COMPLETION_DATE,
1895: SYSDATE
1896: FROM
1897: PA_PROJECTS_ALL
1898: WHERE
1899: PROJECT_ID = p_project_id;
1900:
1901:

Line 2387: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE

2383: -- x_org_id VARCHAR Organization Id
2384:
2385: PROCEDURE GET_PROJECT_DETAILS
2386: (
2387: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
2388: ,x_projfunc_currency_code OUT NOCOPY PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE --File.Sql.39 bug 4440895
2389: ,x_org_id OUT NOCOPY PA_PLAN_RES_DEFAULTS.item_master_id%TYPE -- 3462360 changed type --File.Sql.39 bug 4440895
2390: )
2391: IS

Line 2388: ,x_projfunc_currency_code OUT NOCOPY PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE --File.Sql.39 bug 4440895

2384:
2385: PROCEDURE GET_PROJECT_DETAILS
2386: (
2387: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
2388: ,x_projfunc_currency_code OUT NOCOPY PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE --File.Sql.39 bug 4440895
2389: ,x_org_id OUT NOCOPY PA_PLAN_RES_DEFAULTS.item_master_id%TYPE -- 3462360 changed type --File.Sql.39 bug 4440895
2390: )
2391: IS
2392:

Line 2403: PA_PROJECTS_ALL P

2399: SELECT
2400: P.PROJFUNC_CURRENCY_CODE
2401: -- ,P.ORG_ID -- 3462360 removed org_id column
2402: FROM
2403: PA_PROJECTS_ALL P
2404: WHERE
2405: P.PROJECT_ID = p_project_id;
2406:
2407: BEGIN

Line 3501: p_project_id IN pa_projects_all.project_id%TYPE

3497: =================================================================================================*/
3498:
3499: FUNCTION GET_ADJUSTED_DATES
3500: (
3501: p_project_id IN pa_projects_all.project_id%TYPE
3502: ,p_dlv_due_date IN DATE
3503: ,p_delta IN NUMBER
3504: ) RETURN DATE
3505: IS

Line 3509: FROM pa_projects_all pa

3505: IS
3506: CURSOR c_proj_dates IS
3507: SELECT start_date
3508: ,completion_date
3509: FROM pa_projects_all pa
3510: WHERE pa.project_id = p_project_id ;
3511: l_start_date DATE ;
3512: l_end_date DATE ;
3513: l_dlv_due_date DATE ;

Line 3621: FROM pa_projects_all ppa, pa_project_types ppt

3617:
3618: CURSOR cur_projects_all
3619: IS
3620: SELECT ppt.project_type_class_code
3621: FROM pa_projects_all ppa, pa_project_types ppt
3622: WHERE ppa.project_id = p_project_id
3623: AND ppa.project_type = ppt.project_type
3624: AND ppa.org_id = ppt.org_id; -- 4363092 MOAC Changes
3625:

Line 3846: l_project_number Pa_Projects_All.Segment1%TYPE;

3842: l_dlvr_action_enabled VARCHAR2(1) := NULL;
3843: l_status_code PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL;
3844: l_status_code_valid VARCHAR2(1) := NULL;
3845:
3846: l_project_number Pa_Projects_All.Segment1%TYPE;
3847: l_task_number Pa_Proj_Elements.Name%TYPE;
3848:
3849: BEGIN
3850:

Line 3881: FROM Pa_Projects_All

3877: l_task_number := null;
3878: END IF;
3879:
3880: SELECT segment1 INTO l_project_number
3881: FROM Pa_Projects_All
3882: WHERE project_id = p_project_id;
3883:
3884: IF l_debug_mode = 'Y' THEN
3885: Pa_Debug.WRITE(g_module_name, 'token values proj ['||l_Project_Number||'] task ['||l_task_Number||']',l_debug_level3);

Line 4326: FROM pa_proj_elements elem, pa_projects_all proj

4322:
4323: CURSOR l_dlvr_ref_csr
4324: IS
4325: SELECT elem.proj_element_id, proj.segment1
4326: FROM pa_proj_elements elem, pa_projects_all proj
4327: where pm_source_reference = p_deliverable_reference
4328: and elem.project_id = p_project_id
4329: and elem.project_id = proj.project_id
4330: and object_type = 'PA_DELIVERABLES';

Line 4337: l_project_number Pa_Projects_All.Segment1%TYPE;

4333: l_deliverable_id NUMBER ;
4334: l_dummy VARCHAR2(1);
4335:
4336: l_err_message Fnd_New_Messages.Message_text%TYPE; -- for AMG message
4337: l_project_number Pa_Projects_All.Segment1%TYPE;
4338:
4339:
4340: BEGIN
4341:

Line 4457: FROM pa_projects_all

4453:
4454: CURSOR proj_num
4455: IS
4456: SELECT segment1
4457: FROM pa_projects_all
4458: WHERE project_id = p_project_id;
4459:
4460: l_api_name CONSTANT VARCHAR2(30) := 'Convert_pm_dlvrref_to_id';
4461: l_deliverable_id NUMBER ;

Line 4463: l_project_number Pa_Projects_All.Segment1%TYPE;

4459:
4460: l_api_name CONSTANT VARCHAR2(30) := 'Convert_pm_dlvrref_to_id';
4461: l_deliverable_id NUMBER ;
4462: l_dummy VARCHAR2(1);
4463: l_project_number Pa_Projects_All.Segment1%TYPE;
4464:
4465: BEGIN
4466:
4467: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4645: FROM pa_projects_all proj

4641:
4642: CURSOR proj_num IS
4643: SELECT proj.segment1
4644: , elem.name
4645: FROM pa_projects_all proj
4646: , pa_proj_elements elem
4647: WHERE proj.project_id = p_project_id
4648: AND elem.project_id = proj.project_id
4649: AND elem.object_type = 'PA_DELIVERABLES'

Line 4655: l_project_number Pa_Projects_All.Segment1%TYPE;

4651:
4652: l_api_name CONSTANT VARCHAR2(30) := 'is_action_reference_unique';
4653: l_action_id NUMBER ;
4654: l_dummy VARCHAR2(1);
4655: l_project_number Pa_Projects_All.Segment1%TYPE;
4656: l_deliverable_name Pa_proj_elements.name%TYPE;
4657:
4658: BEGIN
4659:

Line 4815: FROM pa_projects_all proj

4811:
4812: CURSOR proj_num IS
4813: SELECT proj.segment1
4814: , elem.name
4815: FROM pa_projects_all proj
4816: , pa_proj_elements elem
4817: WHERE proj.project_id = p_project_id
4818: AND elem.project_id = proj.project_id
4819: AND elem.object_type = 'PA_DELIVERABLES'

Line 4826: l_project_number Pa_Projects_All.Segment1%TYPE;

4822:
4823: l_api_name CONSTANT VARCHAR2(30) := 'Convert_pm_dlvrref_to_id';
4824: l_action_id NUMBER ;
4825: l_dummy VARCHAR2(1);
4826: l_project_number Pa_Projects_All.Segment1%TYPE;
4827: l_deliverable_name Pa_proj_elements.name%TYPE;
4828:
4829: BEGIN
4830:

Line 5036: , p_project_id IN Pa_Projects_All.project_id%TYPE

5032: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5033: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5034: , p_debug_mode IN VARCHAR2 := 'N'
5035: , p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5036: , p_project_id IN Pa_Projects_All.project_id%TYPE
5037: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5038: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5039: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5040: )IS

Line 5043: FROM pa_Projects_All

5039: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5040: )IS
5041: Cursor C_name IS
5042: SELECT segment1||':Deliverable'
5043: FROM pa_Projects_All
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;