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_V

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 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 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 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(