APPS.OKL_CSP_PVT dependencies on OKL_PDT_OPT_VALS

Line 96: -- Description : FK validation with OKL_PDT_OPT_VALS

92: ----------------------------------------------------------------------------
93: -- Start of Commnets
94: -- Badrinath Kuchibholta
95: -- Procedure Name : validate_pov_id
96: -- Description : FK validation with OKL_PDT_OPT_VALS
97: -- Business Rules :
98: -- Parameters : OUT Return Status, IN Rec Info
99: -- Version : 1.0
100: -- End of Commnets

Line 106: CURSOR c_pov_id_validate(p_pov_id OKL_PDT_OPT_VALS.ID%TYPE) is

102: PROCEDURE validate_pov_id(x_return_status OUT NOCOPY VARCHAR2,
103: p_cspv_rec IN cspv_rec_type) IS
104:
105: ln_dummy number := 0;
106: CURSOR c_pov_id_validate(p_pov_id OKL_PDT_OPT_VALS.ID%TYPE) is
107: SELECT 1
108: FROM DUAL
109: WHERE EXISTS (SELECT '1'
110: FROM OKL_PDT_OPT_VALS

Line 110: FROM OKL_PDT_OPT_VALS

106: CURSOR c_pov_id_validate(p_pov_id OKL_PDT_OPT_VALS.ID%TYPE) is
107: SELECT 1
108: FROM DUAL
109: WHERE EXISTS (SELECT '1'
110: FROM OKL_PDT_OPT_VALS
111: WHERE id = p_pov_id);
112: BEGIN
113: -- initialize return status
114: x_return_status := OKL_API.G_RET_STS_SUCCESS;