DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_CLASS_CODES

Line 640: p_classcode_id IN pa_class_codes.class_code_id%TYPE

636: --
637: -- 20-Nov-2002 -- adabdull - Created
638:
639: PROCEDURE Check_ClassCode_Name_Or_Id(
640: p_classcode_id IN pa_class_codes.class_code_id%TYPE
641: ,p_classcode_name IN pa_class_codes.class_code%TYPE
642: ,p_classcategory IN pa_class_codes.class_category%TYPE
643: ,p_check_id_flag IN VARCHAR2 DEFAULT 'A'
644: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895

Line 641: ,p_classcode_name IN pa_class_codes.class_code%TYPE

637: -- 20-Nov-2002 -- adabdull - Created
638:
639: PROCEDURE Check_ClassCode_Name_Or_Id(
640: p_classcode_id IN pa_class_codes.class_code_id%TYPE
641: ,p_classcode_name IN pa_class_codes.class_code%TYPE
642: ,p_classcategory IN pa_class_codes.class_category%TYPE
643: ,p_check_id_flag IN VARCHAR2 DEFAULT 'A'
644: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895
645: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 642: ,p_classcategory IN pa_class_codes.class_category%TYPE

638:
639: PROCEDURE Check_ClassCode_Name_Or_Id(
640: p_classcode_id IN pa_class_codes.class_code_id%TYPE
641: ,p_classcode_name IN pa_class_codes.class_code%TYPE
642: ,p_classcategory IN pa_class_codes.class_category%TYPE
643: ,p_check_id_flag IN VARCHAR2 DEFAULT 'A'
644: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895
645: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
646: ,x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 644: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895

640: p_classcode_id IN pa_class_codes.class_code_id%TYPE
641: ,p_classcode_name IN pa_class_codes.class_code%TYPE
642: ,p_classcategory IN pa_class_codes.class_category%TYPE
643: ,p_check_id_flag IN VARCHAR2 DEFAULT 'A'
644: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895
645: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
646: ,x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
647: );
648: