APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_CLASS_CODES

Line 1972: p_classcode_id IN pa_class_codes.class_code_id%TYPE

1968: --
1969: -- 20-Nov-2002 -- adabdull - Created
1970:
1971: PROCEDURE Check_ClassCode_Name_Or_Id(
1972: p_classcode_id IN pa_class_codes.class_code_id%TYPE
1973: ,p_classcode_name IN pa_class_codes.class_code%TYPE
1974: ,p_classcategory IN pa_class_codes.class_category%TYPE
1975: ,p_check_id_flag IN VARCHAR2
1976: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895

Line 1973: ,p_classcode_name IN pa_class_codes.class_code%TYPE

1969: -- 20-Nov-2002 -- adabdull - Created
1970:
1971: PROCEDURE Check_ClassCode_Name_Or_Id(
1972: p_classcode_id IN pa_class_codes.class_code_id%TYPE
1973: ,p_classcode_name IN pa_class_codes.class_code%TYPE
1974: ,p_classcategory IN pa_class_codes.class_category%TYPE
1975: ,p_check_id_flag IN VARCHAR2
1976: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895
1977: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1974: ,p_classcategory IN pa_class_codes.class_category%TYPE

1970:
1971: PROCEDURE Check_ClassCode_Name_Or_Id(
1972: p_classcode_id IN pa_class_codes.class_code_id%TYPE
1973: ,p_classcode_name IN pa_class_codes.class_code%TYPE
1974: ,p_classcategory IN pa_class_codes.class_category%TYPE
1975: ,p_check_id_flag IN VARCHAR2
1976: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895
1977: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1978: ,x_error_message_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

1972: p_classcode_id IN pa_class_codes.class_code_id%TYPE
1973: ,p_classcode_name IN pa_class_codes.class_code%TYPE
1974: ,p_classcategory IN pa_class_codes.class_category%TYPE
1975: ,p_check_id_flag IN VARCHAR2
1976: ,x_classcode_id OUT NOCOPY pa_class_codes.class_code_id%TYPE --File.Sql.39 bug 4440895
1977: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1978: ,x_error_message_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1979: IS
1980:

Line 1983: FROM pa_class_codes

1979: IS
1980:
1981: CURSOR c_ids IS
1982: SELECT class_code_id
1983: FROM pa_class_codes
1984: WHERE class_category = p_classcategory
1985: AND class_code = p_classcode_name;
1986:
1987: l_current_id NUMBER := NULL;

Line 2000: FROM pa_class_codes

1996:
1997: IF p_check_id_flag = 'Y' THEN
1998: SELECT class_code_id
1999: INTO x_classcode_id
2000: FROM pa_class_codes
2001: WHERE class_category = p_classcategory
2002: AND class_code_id = p_classcode_id;
2003:
2004: ELSIF (p_check_id_flag = 'N') then

Line 2045: FROM pa_class_codes

2041:
2042: IF (p_classcode_name IS NOT NULL) then
2043: SELECT class_code_id
2044: INTO x_classcode_id
2045: FROM pa_class_codes
2046: WHERE class_category = p_classcategory
2047: AND class_code = p_classcode_name;
2048:
2049: ELSE