APPS.OKL_MST_PVT dependencies on OKL_MASS_RBK_CRITERIA

Line 9: -- Validates FK with OKL_MASS_RBK_CRITERIA.ID

5:
6: ---------------------------------
7: -- Validate_Attributes for: request_name --
8: -- Hand Coded by DEDEY
9: -- Validates FK with OKL_MASS_RBK_CRITERIA.ID
10: ---------------------------------
11:
12: PROCEDURE validate_request_name(
13: x_return_status OUT NOCOPY VARCHAR2,

Line 14: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE

10: ---------------------------------
11:
12: PROCEDURE validate_request_name(
13: x_return_status OUT NOCOPY VARCHAR2,
14: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE
15: ) IS
16:
17: l_present VARCHAR2(1) := 'N';
18:

Line 19: CURSOR crit_csr (p_request_name OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE) IS

15: ) IS
16:
17: l_present VARCHAR2(1) := 'N';
18:
19: CURSOR crit_csr (p_request_name OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE) IS
20: SELECT 'Y'
21: FROM okl_mass_rbk_criteria
22: WHERE request_name = p_request_name;
23:

Line 21: FROM okl_mass_rbk_criteria

17: l_present VARCHAR2(1) := 'N';
18:
19: CURSOR crit_csr (p_request_name OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE) IS
20: SELECT 'Y'
21: FROM okl_mass_rbk_criteria
22: WHERE request_name = p_request_name;
23:
24: BEGIN
25: x_return_status := OKL_API.G_RET_STS_SUCCESS;