[Home] [Help]
159: --
160: -- Desciption :
161: --
162: -- Validate that on insert cagr_api_id is not null and that
163: -- it exists in per_cagr_apis.
164: --
165: --
166: -- Pre-conditions :
167: --
192: l_dummy NUMBER := NULL;
193: --
194: CURSOR csr_cagr_api_id IS
195: SELECT null
196: FROM per_cagr_apis per
197: WHERE per.cagr_api_id = p_cagr_api_id;
198: --
199: BEGIN
200: --