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_PROJECTS_MAINT_UTILS dependencies on PA_ORGANIZATIONS_PROJECT_V

Line 1527: -- p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE Required

1523: -- API name : check_agreement_org_name_or_id
1524: -- Type : Public
1525: -- Pre-reqs : None.
1526: -- Parameters :
1527: -- p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE Required
1528: -- p_agreement_org_name IN pa_organizations_project_v.name%TYPE Required
1529: -- p_check_id_flag IN VARCHAR2 Required
1530: -- x_agreement_org_id OUT NUMBER Required
1531: -- x_return_status OUT VARCHAR2 Required

Line 1528: -- p_agreement_org_name IN pa_organizations_project_v.name%TYPE Required

1524: -- Type : Public
1525: -- Pre-reqs : None.
1526: -- Parameters :
1527: -- p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE Required
1528: -- p_agreement_org_name IN pa_organizations_project_v.name%TYPE Required
1529: -- p_check_id_flag IN VARCHAR2 Required
1530: -- x_agreement_org_id OUT NUMBER Required
1531: -- x_return_status OUT VARCHAR2 Required
1532: -- x_error_msg_code OUT VARCHAR2 Required

Line 1541: ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE

1537: -- 12-OCT-2001 -- anlee created
1538: --
1539: --
1540: procedure Check_agreement_org_name_or_id
1541: ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE
1542: ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE
1543: ,p_check_id_flag IN VARCHAR2
1544: ,x_agreement_org_id OUT NOCOPY pa_organizations_project_v.organization_id%TYPE --File.Sql.39 bug 4440895
1545: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1542: ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE

1538: --
1539: --
1540: procedure Check_agreement_org_name_or_id
1541: ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE
1542: ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE
1543: ,p_check_id_flag IN VARCHAR2
1544: ,x_agreement_org_id OUT NOCOPY pa_organizations_project_v.organization_id%TYPE --File.Sql.39 bug 4440895
1545: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1546: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 1544: ,x_agreement_org_id OUT NOCOPY pa_organizations_project_v.organization_id%TYPE --File.Sql.39 bug 4440895

1540: procedure Check_agreement_org_name_or_id
1541: ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE
1542: ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE
1543: ,p_check_id_flag IN VARCHAR2
1544: ,x_agreement_org_id OUT NOCOPY pa_organizations_project_v.organization_id%TYPE --File.Sql.39 bug 4440895
1545: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1546: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1547: IS
1548: BEGIN

Line 1553: FROM pa_organizations_project_v

1549: IF (p_agreement_org_id IS NOT NULL) THEN
1550: IF (p_check_id_flag = 'Y') THEN
1551: SELECT organization_id
1552: INTO x_agreement_org_id
1553: FROM pa_organizations_project_v
1554: WHERE organization_id = p_agreement_org_id;
1555: ELSE
1556: x_agreement_org_id := p_agreement_org_id;
1557: END IF;

Line 1561: FROM pa_organizations_project_v

1557: END IF;
1558: ELSE
1559: SELECT organization_id
1560: INTO x_agreement_org_id
1561: FROM pa_organizations_project_v
1562: WHERE name = p_agreement_org_name;
1563: END IF;
1564: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1565: EXCEPTION