APPS.OKL_SETUPFORMULAE_PVT dependencies on OKL_OPERANDS_V

Line 267: p_start_date IN Okl_Operands_V.START_DATE%TYPE,

263: x_return_status OUT NOCOPY VARCHAR2,
264: x_valid OUT NOCOPY BOOLEAN
265: ) IS
266: CURSOR okl_fma_constraints_csr (p_fma_id IN Okl_Fmla_Oprnds_V.fma_id%TYPE,
267: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
268: p_end_date IN Okl_Operands_V.END_DATE%TYPE
269:
270: ) IS
271: SELECT '1'

Line 268: p_end_date IN Okl_Operands_V.END_DATE%TYPE

264: x_valid OUT NOCOPY BOOLEAN
265: ) IS
266: CURSOR okl_fma_constraints_csr (p_fma_id IN Okl_Fmla_Oprnds_V.fma_id%TYPE,
267: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
268: p_end_date IN Okl_Operands_V.END_DATE%TYPE
269:
270: ) IS
271: SELECT '1'
272: FROM Okl_Fmla_Oprnds_V fod,

Line 273: Okl_Operands_V opd

269:
270: ) IS
271: SELECT '1'
272: FROM Okl_Fmla_Oprnds_V fod,
273: Okl_Operands_V opd
274: WHERE fod.FMA_ID = p_fma_id
275: AND opd.ID = fod.OPD_ID
276: AND (opd.START_DATE > p_start_date OR
277: NVL(opd.END_DATE, p_end_date) < p_end_date);

Line 281: FROM Okl_Operands_V opd

277: NVL(opd.END_DATE, p_end_date) < p_end_date);
278:
279:
280: SELECT '1'
281: FROM Okl_Operands_V opd
282: WHERE OPD.FMA_ID = p_fma_id
283: AND ((opd.START_DATE < p_start_date) OR
284: (NVL(opd.END_DATE, to_date('31/12/9999', 'DD/MM/YYYY'))) >
285: (NVL(p_end_date, to_date('31/12/9999', 'DD/MM/YYYY'))));

Line 308: p_token2_value => 'Okl_Operands_V');

304: p_msg_name => G_DATES_MISMATCH,
305: p_token1 => G_PARENT_TABLE_TOKEN,
306: p_token1_value => 'Okl_Formulae_V',
307: p_token2 => G_CHILD_TABLE_TOKEN,
308: p_token2_value => 'Okl_Operands_V');
309: x_valid := FALSE;
310: x_return_status := OKL_API.G_RET_STS_ERROR;
311: END IF;
312:

Line 384: p_token2_value => 'Okl_Operands_V');

380: p_msg_name => G_DATES_MISMATCH,
381: p_token1 => G_PARENT_TABLE_TOKEN,
382: p_token1_value => 'Okl_Formulae_V',
383: p_token2 => G_CHILD_TABLE_TOKEN,
384: p_token2_value => 'Okl_Operands_V');
385: RAISE G_EXCEPTION_HALT_PROCESSING;
386: END IF;
387:
388: EXCEPTION

Line 427: CURSOR okl_fma_linkedopds_csr (p_fma_id IN Okl_Operands_V.fma_id%TYPE,

423: p_fmav_rec IN fmav_rec_type,
424: x_return_status OUT NOCOPY VARCHAR2
425: ) IS
426:
427: CURSOR okl_fma_linkedopds_csr (p_fma_id IN Okl_Operands_V.fma_id%TYPE,
428: p_start_date DATE, p_end_date DATE) IS
429: SELECT '1'
430: FROM Okl_Operands_B opd
431: WHERE opd.FMA_ID = p_fma_id