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 1514: -- p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE Required

1510: -- API name : check_agreement_org_name_or_id
1511: -- Type : Public
1512: -- Pre-reqs : None.
1513: -- Parameters :
1514: -- p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE Required
1515: -- p_agreement_org_name IN pa_organizations_project_v.name%TYPE Required
1516: -- p_check_id_flag IN VARCHAR2 Required
1517: -- x_agreement_org_id OUT NUMBER Required
1518: -- x_return_status OUT VARCHAR2 Required

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

1511: -- Type : Public
1512: -- Pre-reqs : None.
1513: -- Parameters :
1514: -- p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE Required
1515: -- p_agreement_org_name IN pa_organizations_project_v.name%TYPE Required
1516: -- p_check_id_flag IN VARCHAR2 Required
1517: -- x_agreement_org_id OUT NUMBER Required
1518: -- x_return_status OUT VARCHAR2 Required
1519: -- x_error_msg_code OUT VARCHAR2 Required

Line 1528: ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE

1524: -- 12-OCT-2001 -- anlee created
1525: --
1526: --
1527: procedure Check_agreement_org_name_or_id
1528: ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE
1529: ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE
1530: ,p_check_id_flag IN VARCHAR2
1531: ,x_agreement_org_id OUT NOCOPY pa_organizations_project_v.organization_id%TYPE --File.Sql.39 bug 4440895
1532: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1529: ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE

1525: --
1526: --
1527: procedure Check_agreement_org_name_or_id
1528: ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE
1529: ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE
1530: ,p_check_id_flag IN VARCHAR2
1531: ,x_agreement_org_id OUT NOCOPY pa_organizations_project_v.organization_id%TYPE --File.Sql.39 bug 4440895
1532: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1533: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

1527: procedure Check_agreement_org_name_or_id
1528: ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE
1529: ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE
1530: ,p_check_id_flag IN VARCHAR2
1531: ,x_agreement_org_id OUT NOCOPY pa_organizations_project_v.organization_id%TYPE --File.Sql.39 bug 4440895
1532: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1533: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1534: IS
1535: BEGIN

Line 1540: FROM pa_organizations_project_v

1536: IF (p_agreement_org_id IS NOT NULL) THEN
1537: IF (p_check_id_flag = 'Y') THEN
1538: SELECT organization_id
1539: INTO x_agreement_org_id
1540: FROM pa_organizations_project_v
1541: WHERE organization_id = p_agreement_org_id;
1542: ELSE
1543: x_agreement_org_id := p_agreement_org_id;
1544: END IF;

Line 1548: FROM pa_organizations_project_v

1544: END IF;
1545: ELSE
1546: SELECT organization_id
1547: INTO x_agreement_org_id
1548: FROM pa_organizations_project_v
1549: WHERE name = p_agreement_org_name;
1550: END IF;
1551: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1552: EXCEPTION