eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUPPOPTIONS_PVT dependencies on OKL_PDT_OPTS

Line 10: -- PROCEDURE get_rec for: OKL_PDT_OPTS_V

6: G_COLUMN_TOKEN CONSTANT VARCHAR2(100) := 'COLUMN';
7: G_ITEM_NOT_FOUND_ERROR EXCEPTION;
8:
9: ---------------------------------------------------------------------------
10: -- PROCEDURE get_rec for: OKL_PDT_OPTS_V
11: ---------------------------------------------------------------------------
12: PROCEDURE get_rec (
13: p_ponv_rec IN ponv_rec_type,
14: x_no_data_found OUT NOCOPY BOOLEAN,

Line 32: FROM Okl_Pdt_Opts_V

28: CREATION_DATE,
29: LAST_UPDATED_BY,
30: LAST_UPDATE_DATE,
31: LAST_UPDATE_LOGIN
32: FROM Okl_Pdt_Opts_V
33: WHERE okl_pdt_opts_v.id = p_id;
34: l_okl_ponv_pk okl_ponv_pk_csr%ROWTYPE;
35: l_ponv_rec ponv_rec_type;
36: BEGIN

Line 33: WHERE okl_pdt_opts_v.id = p_id;

29: LAST_UPDATED_BY,
30: LAST_UPDATE_DATE,
31: LAST_UPDATE_LOGIN
32: FROM Okl_Pdt_Opts_V
33: WHERE okl_pdt_opts_v.id = p_id;
34: l_okl_ponv_pk okl_ponv_pk_csr%ROWTYPE;
35: l_ponv_rec ponv_rec_type;
36: BEGIN
37: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 77: -- PROCEDURE get_parent_dates for: OKL_PDT_OPTS_V

73: END get_rec;
74:
75:
76: ---------------------------------------------------------------------------
77: -- PROCEDURE get_parent_dates for: OKL_PDT_OPTS_V
78: ---------------------------------------------------------------------------
79:
80: PROCEDURE get_parent_dates(
81: p_ponv_rec IN ponv_rec_type,

Line 123: -- PROCEDURE check_constraints for: OKL_PDT_OPTS_V

119:
120: END get_parent_dates;
121:
122: -----------------------------------------------------------------------------
123: -- PROCEDURE check_constraints for: OKL_PDT_OPTS_V
124: -----------------------------------------------------------------------------
125:
126: PROCEDURE Check_Constraints (
127: p_api_version IN NUMBER,

Line 173: FROM okl_pdt_opts pon,

169: SELECT pon.pdt_id,pon.opt_id,
170: orl.rgr_rdf_code,orl.lrg_lse_id,
171: orl.rgr_rgd_code,orl.srd_id_for,
172: orl.lrg_srd_id
173: FROM okl_pdt_opts pon,
174: okl_opt_rules orl
175: WHERE pon.opt_id = orl.opt_id
176: AND pon.pdt_id = p_pdt_id;
177:

Line 178: CURSOR okl_pdt_opts_unique (p_unique1 OKL_PDT_OPTS.OPT_ID%TYPE, p_unique2 OKL_PDT_OPTS.PDT_ID%TYPE) IS

174: okl_opt_rules orl
175: WHERE pon.opt_id = orl.opt_id
176: AND pon.pdt_id = p_pdt_id;
177:
178: CURSOR okl_pdt_opts_unique (p_unique1 OKL_PDT_OPTS.OPT_ID%TYPE, p_unique2 OKL_PDT_OPTS.PDT_ID%TYPE) IS
179: SELECT '1'
180: FROM OKL_PDT_OPTS_V
181: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND
182: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND

Line 180: FROM OKL_PDT_OPTS_V

176: AND pon.pdt_id = p_pdt_id;
177:
178: CURSOR okl_pdt_opts_unique (p_unique1 OKL_PDT_OPTS.OPT_ID%TYPE, p_unique2 OKL_PDT_OPTS.PDT_ID%TYPE) IS
179: SELECT '1'
180: FROM OKL_PDT_OPTS_V
181: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND
182: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND
183: OKL_PDT_OPTS_V.ID <> NVL(p_ponv_rec.id,-9999);
184:

Line 181: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND

177:
178: CURSOR okl_pdt_opts_unique (p_unique1 OKL_PDT_OPTS.OPT_ID%TYPE, p_unique2 OKL_PDT_OPTS.PDT_ID%TYPE) IS
179: SELECT '1'
180: FROM OKL_PDT_OPTS_V
181: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND
182: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND
183: OKL_PDT_OPTS_V.ID <> NVL(p_ponv_rec.id,-9999);
184:
185: l_unique_key OKL_PDT_OPTS_V.OPT_ID%TYPE;

Line 182: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND

178: CURSOR okl_pdt_opts_unique (p_unique1 OKL_PDT_OPTS.OPT_ID%TYPE, p_unique2 OKL_PDT_OPTS.PDT_ID%TYPE) IS
179: SELECT '1'
180: FROM OKL_PDT_OPTS_V
181: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND
182: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND
183: OKL_PDT_OPTS_V.ID <> NVL(p_ponv_rec.id,-9999);
184:
185: l_unique_key OKL_PDT_OPTS_V.OPT_ID%TYPE;
186: l_check VARCHAR2(1) := '?';

Line 183: OKL_PDT_OPTS_V.ID <> NVL(p_ponv_rec.id,-9999);

179: SELECT '1'
180: FROM OKL_PDT_OPTS_V
181: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND
182: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND
183: OKL_PDT_OPTS_V.ID <> NVL(p_ponv_rec.id,-9999);
184:
185: l_unique_key OKL_PDT_OPTS_V.OPT_ID%TYPE;
186: l_check VARCHAR2(1) := '?';
187: l_row_not_found BOOLEAN := FALSE;

Line 185: l_unique_key OKL_PDT_OPTS_V.OPT_ID%TYPE;

181: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND
182: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND
183: OKL_PDT_OPTS_V.ID <> NVL(p_ponv_rec.id,-9999);
184:
185: l_unique_key OKL_PDT_OPTS_V.OPT_ID%TYPE;
186: l_check VARCHAR2(1) := '?';
187: l_row_not_found BOOLEAN := FALSE;
188: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/RRRR'), 'DD/MM/RRRR');
189: l_token_1 VARCHAR2(9999);

Line 259: OPEN okl_pdt_opts_unique (p_ponv_rec.opt_id, p_ponv_rec.pdt_id);

255: END IF;*/
256:
257: --CHECK FOR UNIQUENESS
258: IF p_ponv_rec.id = Okl_Api.G_MISS_NUM THEN
259: OPEN okl_pdt_opts_unique (p_ponv_rec.opt_id, p_ponv_rec.pdt_id);
260: FETCH okl_pdt_opts_unique INTO l_unique_key;
261: IF okl_pdt_opts_unique%FOUND THEN
262: --Okl_Api.set_message(G_APP_NAME,G_UNQS, G_TABLE_TOKEN,l_token_6);
263: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 260: FETCH okl_pdt_opts_unique INTO l_unique_key;

256:
257: --CHECK FOR UNIQUENESS
258: IF p_ponv_rec.id = Okl_Api.G_MISS_NUM THEN
259: OPEN okl_pdt_opts_unique (p_ponv_rec.opt_id, p_ponv_rec.pdt_id);
260: FETCH okl_pdt_opts_unique INTO l_unique_key;
261: IF okl_pdt_opts_unique%FOUND THEN
262: --Okl_Api.set_message(G_APP_NAME,G_UNQS, G_TABLE_TOKEN,l_token_6);
263: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
264: p_msg_name => 'OKL_COLUMN_NOT_UNIQUE',

Line 261: IF okl_pdt_opts_unique%FOUND THEN

257: --CHECK FOR UNIQUENESS
258: IF p_ponv_rec.id = Okl_Api.G_MISS_NUM THEN
259: OPEN okl_pdt_opts_unique (p_ponv_rec.opt_id, p_ponv_rec.pdt_id);
260: FETCH okl_pdt_opts_unique INTO l_unique_key;
261: IF okl_pdt_opts_unique%FOUND THEN
262: --Okl_Api.set_message(G_APP_NAME,G_UNQS, G_TABLE_TOKEN,l_token_6);
263: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
264: p_msg_name => 'OKL_COLUMN_NOT_UNIQUE',
265: p_token1 => G_TABLE_TOKEN,

Line 275: CLOSE okl_pdt_opts_unique;

271: RAISE G_EXCEPTION_HALT_PROCESSING;
272: ELSE
273: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
274: END IF;
275: CLOSE okl_pdt_opts_unique;
276: END IF;
277:
278: -- Check for constraints dates
279: IF p_ponv_rec.id = Okl_Api.G_MISS_NUM THEN

Line 368: IF (okl_pdt_opts_unique%ISOPEN) THEN

364: IF (okl_pon_constraints_csr%ISOPEN) THEN
365: CLOSE okl_pon_constraints_csr;
366: END IF;
367:
368: IF (okl_pdt_opts_unique%ISOPEN) THEN
369: CLOSE okl_pdt_opts_unique;
370: END IF;
371:
372: END Check_Constraints;

Line 369: CLOSE okl_pdt_opts_unique;

365: CLOSE okl_pon_constraints_csr;
366: END IF;
367:
368: IF (okl_pdt_opts_unique%ISOPEN) THEN
369: CLOSE okl_pdt_opts_unique;
370: END IF;
371:
372: END Check_Constraints;
373:

Line 392: CURSOR okl_pdt_opts_foreign1 (p_foreign OKL_PDT_OPTS.OPT_ID%TYPE) IS

388: p_ponv_rec IN ponv_rec_type,
389: x_return_status OUT NOCOPY VARCHAR2
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:

Line 397: l_foreign_key OKL_PDT_OPTS_V.OPT_ID%TYPE;

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:
400: BEGIN
401: -- initialize return status

Line 416: OPEN okl_pdt_opts_foreign1 (p_ponv_rec.opt_id);

412: RAISE G_ITEM_NOT_FOUND_ERROR;
413: END IF;
414:
415: IF p_ponv_rec.opt_id IS NOT NULL THEN
416: OPEN okl_pdt_opts_foreign1 (p_ponv_rec.opt_id);
417: FETCH okl_pdt_opts_foreign1 INTO l_foreign_key;
418: IF okl_pdt_opts_foreign1%NOTFOUND THEN
419: Okl_Api.set_message(Okl_Pon_Pvt.G_APP_NAME, Okl_Pon_Pvt.G_INVALID_VALUE,Okl_Pon_Pvt.G_COL_NAME_TOKEN,l_token_1);
420: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 417: FETCH okl_pdt_opts_foreign1 INTO l_foreign_key;

413: END IF;
414:
415: IF p_ponv_rec.opt_id IS NOT NULL THEN
416: OPEN okl_pdt_opts_foreign1 (p_ponv_rec.opt_id);
417: FETCH okl_pdt_opts_foreign1 INTO l_foreign_key;
418: IF okl_pdt_opts_foreign1%NOTFOUND THEN
419: Okl_Api.set_message(Okl_Pon_Pvt.G_APP_NAME, Okl_Pon_Pvt.G_INVALID_VALUE,Okl_Pon_Pvt.G_COL_NAME_TOKEN,l_token_1);
420: x_return_status := Okl_Api.G_RET_STS_ERROR;
421: RAISE G_ITEM_NOT_FOUND_ERROR;

Line 418: IF okl_pdt_opts_foreign1%NOTFOUND THEN

414:
415: IF p_ponv_rec.opt_id IS NOT NULL THEN
416: OPEN okl_pdt_opts_foreign1 (p_ponv_rec.opt_id);
417: FETCH okl_pdt_opts_foreign1 INTO l_foreign_key;
418: IF okl_pdt_opts_foreign1%NOTFOUND THEN
419: Okl_Api.set_message(Okl_Pon_Pvt.G_APP_NAME, Okl_Pon_Pvt.G_INVALID_VALUE,Okl_Pon_Pvt.G_COL_NAME_TOKEN,l_token_1);
420: x_return_status := Okl_Api.G_RET_STS_ERROR;
421: RAISE G_ITEM_NOT_FOUND_ERROR;
422: ELSE

Line 425: CLOSE okl_pdt_opts_foreign1;

421: RAISE G_ITEM_NOT_FOUND_ERROR;
422: ELSE
423: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
424: END IF;
425: CLOSE okl_pdt_opts_foreign1;
426: END IF;
427:
428: EXCEPTION
429: WHEN G_ITEM_NOT_FOUND_ERROR THEN

Line 498: -- PROCEDURE insert_poptions for: OKL_PDT_OPTS_V

494:
495:
496:
497: ---------------------------------------------------------------------------
498: -- PROCEDURE insert_poptions for: OKL_PDT_OPTS_V
499: ---------------------------------------------------------------------------
500:
501: PROCEDURE insert_poptions(p_api_version IN NUMBER,
502: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 627: -- PROCEDURE delete_pdt_pqys for: OKL_PDT_OPTS_V

623:
624: END insert_poptions;
625:
626: ---------------------------------------------------------------------------
627: -- PROCEDURE delete_pdt_pqys for: OKL_PDT_OPTS_V
628: -- Private procedure called from delete_poptions.
629: ---------------------------------------------------------------------------
630:
631: PROCEDURE delete_pdt_opt_vals(

Line 704: -- PROCEDURE delete_poptions for: OKL_PDT_OPTS_V

700: END delete_pdt_opt_vals;
701:
702:
703: ----------------------------------------------------------------------------
704: -- PROCEDURE delete_poptions for: OKL_PDT_OPTS_V
705: -- This allows the user to delete table of records
706: ----------------------------------------------------------------------------
707:
708: PROCEDURE delete_poptions(