617: --
618: -- 20-Nov-2002 -- adabdull - Created
619:
620: PROCEDURE Check_ClassCategory_Name_Or_Id(
621: p_class_category_id IN pa_class_categories.class_category_id%TYPE
622: ,p_class_category_name IN pa_class_categories.class_category%TYPE
623: ,p_check_id_flag IN VARCHAR2 DEFAULT 'A'
624: ,x_class_category_id OUT NOCOPY pa_class_categories.class_category_id%TYPE --File.Sql.39 bug 4440895
625: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
618: -- 20-Nov-2002 -- adabdull - Created
619:
620: PROCEDURE Check_ClassCategory_Name_Or_Id(
621: p_class_category_id IN pa_class_categories.class_category_id%TYPE
622: ,p_class_category_name IN pa_class_categories.class_category%TYPE
623: ,p_check_id_flag IN VARCHAR2 DEFAULT 'A'
624: ,x_class_category_id OUT NOCOPY pa_class_categories.class_category_id%TYPE --File.Sql.39 bug 4440895
625: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
626: ,x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
620: PROCEDURE Check_ClassCategory_Name_Or_Id(
621: p_class_category_id IN pa_class_categories.class_category_id%TYPE
622: ,p_class_category_name IN pa_class_categories.class_category%TYPE
623: ,p_check_id_flag IN VARCHAR2 DEFAULT 'A'
624: ,x_class_category_id OUT NOCOPY pa_class_categories.class_category_id%TYPE --File.Sql.39 bug 4440895
625: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
626: ,x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
627: );
628: