DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_ORGANIZATIONS_PROJECT_V

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

480: -- API name : check_agreement_org_name_or_id
481: -- Type : Public
482: -- Pre-reqs : None.
483: -- Parameters :
484: -- p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE Required
485: -- p_agreement_org_name IN pa_organizations_project_v.name%TYPE Required
486: -- p_check_id_flag IN VARCHAR2 Required
487: -- x_agreement_org_id OUT NUMBER Required
488: -- x_return_status OUT VARCHAR2 Required

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

481: -- Type : Public
482: -- Pre-reqs : None.
483: -- Parameters :
484: -- p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE Required
485: -- p_agreement_org_name IN pa_organizations_project_v.name%TYPE Required
486: -- p_check_id_flag IN VARCHAR2 Required
487: -- x_agreement_org_id OUT NUMBER Required
488: -- x_return_status OUT VARCHAR2 Required
489: -- x_error_msg_code OUT VARCHAR2 Required

Line 498: ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE

494: -- 12-OCT-2001 -- anlee created
495: --
496: --
497: procedure Check_agreement_org_name_or_id
498: ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE
499: ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE
500: ,p_check_id_flag IN VARCHAR2
501: ,x_agreement_org_id OUT NOCOPY pa_organizations_project_v.organization_id%TYPE --File.Sql.39 bug 4440895
502: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 499: ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE

495: --
496: --
497: procedure Check_agreement_org_name_or_id
498: ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE
499: ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE
500: ,p_check_id_flag IN VARCHAR2
501: ,x_agreement_org_id OUT NOCOPY pa_organizations_project_v.organization_id%TYPE --File.Sql.39 bug 4440895
502: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
503: ,x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

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

497: procedure Check_agreement_org_name_or_id
498: ( p_agreement_org_id IN pa_organizations_project_v.organization_id%TYPE
499: ,p_agreement_org_name IN pa_organizations_project_v.name%TYPE
500: ,p_check_id_flag IN VARCHAR2
501: ,x_agreement_org_id OUT NOCOPY pa_organizations_project_v.organization_id%TYPE --File.Sql.39 bug 4440895
502: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
503: ,x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
504:
505: