APPS.OKL_SETUPPOPTIONS_PVT dependencies on OKL_OPTIONS_V

Line 148: CURSOR okl_pon_constraints_csr(p_opt_id IN Okl_Options_V.ID%TYPE,

144: FROM Okl_products_V pdt
145: WHERE pdt.ID = p_pdt_id
146: AND NVL(pdt.TO_DATE, p_date) < p_date;
147:
148: CURSOR okl_pon_constraints_csr(p_opt_id IN Okl_Options_V.ID%TYPE,
149: p_from_date IN Okl_Options_V.FROM_DATE%TYPE,
150: p_to_date IN Okl_Options_V.TO_DATE%TYPE
151: ) IS
152: SELECT '1'

Line 149: p_from_date IN Okl_Options_V.FROM_DATE%TYPE,

145: WHERE pdt.ID = p_pdt_id
146: AND NVL(pdt.TO_DATE, p_date) < p_date;
147:
148: CURSOR okl_pon_constraints_csr(p_opt_id IN Okl_Options_V.ID%TYPE,
149: p_from_date IN Okl_Options_V.FROM_DATE%TYPE,
150: p_to_date IN Okl_Options_V.TO_DATE%TYPE
151: ) IS
152: SELECT '1'
153: FROM Okl_options_V opt

Line 150: p_to_date IN Okl_Options_V.TO_DATE%TYPE

146: AND NVL(pdt.TO_DATE, p_date) < p_date;
147:
148: CURSOR okl_pon_constraints_csr(p_opt_id IN Okl_Options_V.ID%TYPE,
149: p_from_date IN Okl_Options_V.FROM_DATE%TYPE,
150: p_to_date IN Okl_Options_V.TO_DATE%TYPE
151: ) IS
152: SELECT '1'
153: FROM Okl_options_V opt
154: WHERE opt.ID = p_opt_id

Line 153: FROM Okl_options_V opt

149: p_from_date IN Okl_Options_V.FROM_DATE%TYPE,
150: p_to_date IN Okl_Options_V.TO_DATE%TYPE
151: ) IS
152: SELECT '1'
153: FROM Okl_options_V opt
154: WHERE opt.ID = p_opt_id
155: AND ((opt.FROM_DATE > p_from_date OR
156: p_from_date > NVL(opt.TO_DATE,p_from_date)) OR
157: NVL(opt.TO_DATE, p_to_date) < p_to_date);

Line 394: FROM OKL_OPTIONS_V

390: ) IS
391: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
392: CURSOR okl_pdt_opts_foreign1 (p_foreign OKL_PDT_OPTS.OPT_ID%TYPE) IS
393: SELECT ID
394: FROM OKL_OPTIONS_V
395: WHERE OKL_OPTIONS_V.ID = p_foreign;
396:
397: l_foreign_key OKL_PDT_OPTS_V.OPT_ID%TYPE;
398: l_token_1 VARCHAR2(999);

Line 395: WHERE OKL_OPTIONS_V.ID = p_foreign;

391: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
392: CURSOR okl_pdt_opts_foreign1 (p_foreign OKL_PDT_OPTS.OPT_ID%TYPE) IS
393: SELECT ID
394: FROM OKL_OPTIONS_V
395: WHERE OKL_OPTIONS_V.ID = p_foreign;
396:
397: l_foreign_key OKL_PDT_OPTS_V.OPT_ID%TYPE;
398: l_token_1 VARCHAR2(999);
399: