APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_CLASS_CODES

Line 1985: p_classcode_id IN pa_class_codes.class_code_id%TYPE

1981: --
1982: -- 20-Nov-2002 -- adabdull - Created
1983:
1984: PROCEDURE Check_ClassCode_Name_Or_Id(
1985: p_classcode_id IN pa_class_codes.class_code_id%TYPE
1986: ,p_classcode_name IN pa_class_codes.class_code%TYPE
1987: ,p_classcategory IN pa_class_codes.class_category%TYPE
1988: ,p_check_id_flag IN VARCHAR2
1989: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895

Line 1986: ,p_classcode_name IN pa_class_codes.class_code%TYPE

1982: -- 20-Nov-2002 -- adabdull - Created
1983:
1984: PROCEDURE Check_ClassCode_Name_Or_Id(
1985: p_classcode_id IN pa_class_codes.class_code_id%TYPE
1986: ,p_classcode_name IN pa_class_codes.class_code%TYPE
1987: ,p_classcategory IN pa_class_codes.class_category%TYPE
1988: ,p_check_id_flag IN VARCHAR2
1989: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895
1990: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1987: ,p_classcategory IN pa_class_codes.class_category%TYPE

1983:
1984: PROCEDURE Check_ClassCode_Name_Or_Id(
1985: p_classcode_id IN pa_class_codes.class_code_id%TYPE
1986: ,p_classcode_name IN pa_class_codes.class_code%TYPE
1987: ,p_classcategory IN pa_class_codes.class_category%TYPE
1988: ,p_check_id_flag IN VARCHAR2
1989: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895
1990: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1991: ,x_error_message_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

1985: p_classcode_id IN pa_class_codes.class_code_id%TYPE
1986: ,p_classcode_name IN pa_class_codes.class_code%TYPE
1987: ,p_classcategory IN pa_class_codes.class_category%TYPE
1988: ,p_check_id_flag IN VARCHAR2
1989: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895
1990: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1991: ,x_error_message_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1992: IS
1993:

Line 1996: FROM pa_class_codes

1992: IS
1993:
1994: CURSOR c_ids IS
1995: SELECT class_code_id
1996: FROM pa_class_codes
1997: WHERE class_category = p_classcategory
1998: AND class_code = p_classcode_name;
1999:
2000: l_current_id NUMBER := NULL;

Line 2013: FROM pa_class_codes

2009:
2010: IF p_check_id_flag = 'Y' THEN
2011: SELECT class_code_id
2012: INTO x_classcode_id
2013: FROM pa_class_codes
2014: WHERE class_category = p_classcategory
2015: AND class_code_id = p_classcode_id;
2016:
2017: ELSIF (p_check_id_flag = 'N') then

Line 2058: FROM pa_class_codes

2054:
2055: IF (p_classcode_name IS NOT NULL) then
2056: SELECT class_code_id
2057: INTO x_classcode_id
2058: FROM pa_class_codes
2059: WHERE class_category = p_classcategory
2060: AND class_code = p_classcode_name;
2061:
2062: ELSE