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_PON_PVT dependencies on OKL_PDT_OPTS

Line 36: -- FUNCTION get_rec for: OKL_PDT_OPTS

32: null;
33: END api_copy;
34:
35: ---------------------------------------------------------------------------
36: -- FUNCTION get_rec for: OKL_PDT_OPTS
37: ---------------------------------------------------------------------------
38: FUNCTION get_rec (
39: p_pon_rec IN pon_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN

Line 42: CURSOR okl_pdt_opts_pk_csr (p_id IN NUMBER) IS

38: FUNCTION get_rec (
39: p_pon_rec IN pon_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN
41: ) RETURN pon_rec_type IS
42: CURSOR okl_pdt_opts_pk_csr (p_id IN NUMBER) IS
43: SELECT
44: ID,
45: OPT_ID,
46: PDT_ID,

Line 56: FROM Okl_Pdt_Opts

52: CREATION_DATE,
53: LAST_UPDATED_BY,
54: LAST_UPDATE_DATE,
55: LAST_UPDATE_LOGIN
56: FROM Okl_Pdt_Opts
57: WHERE okl_pdt_opts.id = p_id;
58: l_okl_pdt_opts_pk okl_pdt_opts_pk_csr%ROWTYPE;
59: l_pon_rec pon_rec_type;
60: BEGIN

Line 57: WHERE okl_pdt_opts.id = p_id;

53: LAST_UPDATED_BY,
54: LAST_UPDATE_DATE,
55: LAST_UPDATE_LOGIN
56: FROM Okl_Pdt_Opts
57: WHERE okl_pdt_opts.id = p_id;
58: l_okl_pdt_opts_pk okl_pdt_opts_pk_csr%ROWTYPE;
59: l_pon_rec pon_rec_type;
60: BEGIN
61: x_no_data_found := TRUE;

Line 58: l_okl_pdt_opts_pk okl_pdt_opts_pk_csr%ROWTYPE;

54: LAST_UPDATE_DATE,
55: LAST_UPDATE_LOGIN
56: FROM Okl_Pdt_Opts
57: WHERE okl_pdt_opts.id = p_id;
58: l_okl_pdt_opts_pk okl_pdt_opts_pk_csr%ROWTYPE;
59: l_pon_rec pon_rec_type;
60: BEGIN
61: x_no_data_found := TRUE;
62: -- Get current database values

Line 63: OPEN okl_pdt_opts_pk_csr (p_pon_rec.id);

59: l_pon_rec pon_rec_type;
60: BEGIN
61: x_no_data_found := TRUE;
62: -- Get current database values
63: OPEN okl_pdt_opts_pk_csr (p_pon_rec.id);
64: FETCH okl_pdt_opts_pk_csr INTO
65: l_pon_rec.ID,
66: l_pon_rec.OPT_ID,
67: l_pon_rec.PDT_ID,

Line 64: FETCH okl_pdt_opts_pk_csr INTO

60: BEGIN
61: x_no_data_found := TRUE;
62: -- Get current database values
63: OPEN okl_pdt_opts_pk_csr (p_pon_rec.id);
64: FETCH okl_pdt_opts_pk_csr INTO
65: l_pon_rec.ID,
66: l_pon_rec.OPT_ID,
67: l_pon_rec.PDT_ID,
68: l_pon_rec.OPTIONAL_YN,

Line 77: x_no_data_found := okl_pdt_opts_pk_csr%NOTFOUND;

73: l_pon_rec.CREATION_DATE,
74: l_pon_rec.LAST_UPDATED_BY,
75: l_pon_rec.LAST_UPDATE_DATE,
76: l_pon_rec.LAST_UPDATE_LOGIN;
77: x_no_data_found := okl_pdt_opts_pk_csr%NOTFOUND;
78: CLOSE okl_pdt_opts_pk_csr;
79: RETURN(l_pon_rec);
80: END get_rec;
81:

Line 78: CLOSE okl_pdt_opts_pk_csr;

74: l_pon_rec.LAST_UPDATED_BY,
75: l_pon_rec.LAST_UPDATE_DATE,
76: l_pon_rec.LAST_UPDATE_LOGIN;
77: x_no_data_found := okl_pdt_opts_pk_csr%NOTFOUND;
78: CLOSE okl_pdt_opts_pk_csr;
79: RETURN(l_pon_rec);
80: END get_rec;
81:
82: FUNCTION get_rec (

Line 90: -- FUNCTION get_rec for: OKL_PDT_OPTS_V

86: BEGIN
87: RETURN(get_rec(p_pon_rec, l_row_notfound));
88: END get_rec;
89: ---------------------------------------------------------------------------
90: -- FUNCTION get_rec for: OKL_PDT_OPTS_V
91: ---------------------------------------------------------------------------
92: FUNCTION get_rec (
93: p_ponv_rec IN ponv_rec_type,
94: x_no_data_found OUT NOCOPY BOOLEAN

Line 110: FROM Okl_Pdt_Opts_V

106: CREATION_DATE,
107: LAST_UPDATED_BY,
108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN
110: FROM Okl_Pdt_Opts_V
111: WHERE okl_pdt_opts_v.id = p_id;
112: l_okl_ponv_pk okl_ponv_pk_csr%ROWTYPE;
113: l_ponv_rec ponv_rec_type;
114: BEGIN

Line 111: WHERE okl_pdt_opts_v.id = p_id;

107: LAST_UPDATED_BY,
108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN
110: FROM Okl_Pdt_Opts_V
111: WHERE okl_pdt_opts_v.id = p_id;
112: l_okl_ponv_pk okl_ponv_pk_csr%ROWTYPE;
113: l_ponv_rec ponv_rec_type;
114: BEGIN
115: x_no_data_found := TRUE;

Line 145: -- FUNCTION null_out_defaults for: OKL_PDT_OPTS_V --

141: RETURN(get_rec(p_ponv_rec, l_row_notfound));
142: END get_rec;
143:
144: ----------------------------------------------------
145: -- FUNCTION null_out_defaults for: OKL_PDT_OPTS_V --
146: ----------------------------------------------------
147: FUNCTION null_out_defaults (
148: p_ponv_rec IN ponv_rec_type
149: ) RETURN ponv_rec_type IS

Line 191: -- Validate_Attributes for:OKL_PDT_OPTS_V --

187: ---------------------------------------------------------------------------
188: -- PROCEDURE Validate_Attributes
189: ---------------------------------------------------------------------------
190: --------------------------------------------
191: -- Validate_Attributes for:OKL_PDT_OPTS_V --
192: --------------------------------------------
193: ----------------TCHGS NEW CHANGS BEGIN --------------------------
194:
195: ---------------------------------------------------------------------------

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

284: p_ponv_rec IN ponv_rec_type,
285: x_return_status OUT NOCOPY VARCHAR2
286: ) IS
287: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
288: CURSOR okl_pdt_opts_foreign1 (p_foreign OKL_PDT_OPTS.OPT_ID%TYPE) IS
289: SELECT ID
290: FROM OKL_OPTIONS_V
291: WHERE OKL_OPTIONS_V.ID = p_foreign;
292:

Line 293: l_foreign_key OKL_PDT_OPTS_V.OPT_ID%TYPE;

289: SELECT ID
290: FROM OKL_OPTIONS_V
291: WHERE OKL_OPTIONS_V.ID = p_foreign;
292:
293: l_foreign_key OKL_PDT_OPTS_V.OPT_ID%TYPE;
294:
295:
296: BEGIN
297: -- initialize return status

Line 308: OPEN okl_pdt_opts_foreign1 (p_ponv_rec.opt_id);

304: x_return_status := OKC_API.G_RET_STS_ERROR;
305: END IF;
306:
307: IF p_ponv_rec.opt_id IS NOT NULL THEN
308: OPEN okl_pdt_opts_foreign1 (p_ponv_rec.opt_id);
309: FETCH okl_pdt_opts_foreign1 INTO l_foreign_key;
310: IF okl_pdt_opts_foreign1%NOTFOUND THEN
311: OKC_API.set_message(G_APP_NAME, G_INVALID_KEY,G_COL_NAME_TOKEN,'opt_id');
312: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 309: FETCH okl_pdt_opts_foreign1 INTO l_foreign_key;

305: END IF;
306:
307: IF p_ponv_rec.opt_id IS NOT NULL THEN
308: OPEN okl_pdt_opts_foreign1 (p_ponv_rec.opt_id);
309: FETCH okl_pdt_opts_foreign1 INTO l_foreign_key;
310: IF okl_pdt_opts_foreign1%NOTFOUND THEN
311: OKC_API.set_message(G_APP_NAME, G_INVALID_KEY,G_COL_NAME_TOKEN,'opt_id');
312: x_return_status := OKC_API.G_RET_STS_ERROR;
313:

Line 310: IF okl_pdt_opts_foreign1%NOTFOUND THEN

306:
307: IF p_ponv_rec.opt_id IS NOT NULL THEN
308: OPEN okl_pdt_opts_foreign1 (p_ponv_rec.opt_id);
309: FETCH okl_pdt_opts_foreign1 INTO l_foreign_key;
310: IF okl_pdt_opts_foreign1%NOTFOUND THEN
311: OKC_API.set_message(G_APP_NAME, G_INVALID_KEY,G_COL_NAME_TOKEN,'opt_id');
312: x_return_status := OKC_API.G_RET_STS_ERROR;
313:
314: ELSE

Line 317: CLOSE okl_pdt_opts_foreign1;

313:
314: ELSE
315: x_return_status := OKC_API.G_RET_STS_SUCCESS;
316: END IF;
317: CLOSE okl_pdt_opts_foreign1;
318: END IF;
319:
320: EXCEPTION
321: WHEN OTHERS THEN

Line 351: CURSOR okl_pdt_opts_foreign2 (p_foreign OKL_PDT_OPTS.PDT_ID%TYPE) IS

347: p_ponv_rec IN ponv_rec_type,
348: x_return_status OUT NOCOPY VARCHAR2
349: ) IS
350: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
351: CURSOR okl_pdt_opts_foreign2 (p_foreign OKL_PDT_OPTS.PDT_ID%TYPE) IS
352: SELECT ID
353: FROM OKL_PRODUCTS_V
354: WHERE OKL_PRODUCTS_V.ID = p_foreign;
355:

Line 356: l_foreign_key OKL_PDT_OPTS_V.PDT_ID%TYPE;

352: SELECT ID
353: FROM OKL_PRODUCTS_V
354: WHERE OKL_PRODUCTS_V.ID = p_foreign;
355:
356: l_foreign_key OKL_PDT_OPTS_V.PDT_ID%TYPE;
357:
358:
359: BEGIN
360: -- initialize return status

Line 371: OPEN okl_pdt_opts_foreign2 (p_ponv_rec.pdt_id);

367: x_return_status := OKC_API.G_RET_STS_ERROR;
368: END IF;
369:
370: IF p_ponv_rec.pdt_id IS NOT NULL THEN
371: OPEN okl_pdt_opts_foreign2 (p_ponv_rec.pdt_id);
372: FETCH okl_pdt_opts_foreign2 INTO l_foreign_key;
373: IF okl_pdt_opts_foreign2%NOTFOUND THEN
374: OKC_API.set_message(G_APP_NAME, G_INVALID_KEY,G_COL_NAME_TOKEN,'pdt_id');
375: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 372: FETCH okl_pdt_opts_foreign2 INTO l_foreign_key;

368: END IF;
369:
370: IF p_ponv_rec.pdt_id IS NOT NULL THEN
371: OPEN okl_pdt_opts_foreign2 (p_ponv_rec.pdt_id);
372: FETCH okl_pdt_opts_foreign2 INTO l_foreign_key;
373: IF okl_pdt_opts_foreign2%NOTFOUND THEN
374: OKC_API.set_message(G_APP_NAME, G_INVALID_KEY,G_COL_NAME_TOKEN,'pdt_id');
375: x_return_status := OKC_API.G_RET_STS_ERROR;
376:

Line 373: IF okl_pdt_opts_foreign2%NOTFOUND THEN

369:
370: IF p_ponv_rec.pdt_id IS NOT NULL THEN
371: OPEN okl_pdt_opts_foreign2 (p_ponv_rec.pdt_id);
372: FETCH okl_pdt_opts_foreign2 INTO l_foreign_key;
373: IF okl_pdt_opts_foreign2%NOTFOUND THEN
374: OKC_API.set_message(G_APP_NAME, G_INVALID_KEY,G_COL_NAME_TOKEN,'pdt_id');
375: x_return_status := OKC_API.G_RET_STS_ERROR;
376:
377: ELSE

Line 380: CLOSE okl_pdt_opts_foreign2;

376:
377: ELSE
378: x_return_status := OKC_API.G_RET_STS_SUCCESS;
379: END IF;
380: CLOSE okl_pdt_opts_foreign2;
381: END IF;
382:
383: EXCEPTION
384: WHEN OTHERS THEN

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

558: p_ponv_rec IN ponv_rec_type,
559: x_return_status OUT NOCOPY VARCHAR2
560: ) IS
561:
562: CURSOR okl_pdt_opts_unique (p_unique1 OKL_PDT_OPTS.OPT_ID%TYPE, p_unique2 OKL_PDT_OPTS.PDT_ID%TYPE) IS
563: SELECT '1'
564: FROM OKL_PDT_OPTS_V
565: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND
566: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND

Line 564: FROM OKL_PDT_OPTS_V

560: ) IS
561:
562: CURSOR okl_pdt_opts_unique (p_unique1 OKL_PDT_OPTS.OPT_ID%TYPE, p_unique2 OKL_PDT_OPTS.PDT_ID%TYPE) IS
563: SELECT '1'
564: FROM OKL_PDT_OPTS_V
565: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND
566: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND
567: OKL_PDT_OPTS_V.ID <> nvl(p_ponv_rec.id,-9999);
568:

Line 565: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND

561:
562: CURSOR okl_pdt_opts_unique (p_unique1 OKL_PDT_OPTS.OPT_ID%TYPE, p_unique2 OKL_PDT_OPTS.PDT_ID%TYPE) IS
563: SELECT '1'
564: FROM OKL_PDT_OPTS_V
565: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND
566: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND
567: OKL_PDT_OPTS_V.ID <> nvl(p_ponv_rec.id,-9999);
568:
569: l_unique_key OKL_PDT_OPTS_V.OPT_ID%TYPE;

Line 566: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND

562: CURSOR okl_pdt_opts_unique (p_unique1 OKL_PDT_OPTS.OPT_ID%TYPE, p_unique2 OKL_PDT_OPTS.PDT_ID%TYPE) IS
563: SELECT '1'
564: FROM OKL_PDT_OPTS_V
565: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND
566: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND
567: OKL_PDT_OPTS_V.ID <> nvl(p_ponv_rec.id,-9999);
568:
569: l_unique_key OKL_PDT_OPTS_V.OPT_ID%TYPE;
570:

Line 567: OKL_PDT_OPTS_V.ID <> nvl(p_ponv_rec.id,-9999);

563: SELECT '1'
564: FROM OKL_PDT_OPTS_V
565: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND
566: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND
567: OKL_PDT_OPTS_V.ID <> nvl(p_ponv_rec.id,-9999);
568:
569: l_unique_key OKL_PDT_OPTS_V.OPT_ID%TYPE;
570:
571:

Line 569: l_unique_key OKL_PDT_OPTS_V.OPT_ID%TYPE;

565: WHERE OKL_PDT_OPTS_V.OPT_ID = p_unique1 AND
566: OKL_PDT_OPTS_V.PDT_ID = p_unique2 AND
567: OKL_PDT_OPTS_V.ID <> nvl(p_ponv_rec.id,-9999);
568:
569: l_unique_key OKL_PDT_OPTS_V.OPT_ID%TYPE;
570:
571:
572: BEGIN
573: -- initialize return status

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

572: BEGIN
573: -- initialize return status
574: x_return_status := OKC_API.G_RET_STS_SUCCESS;
575:
576: OPEN okl_pdt_opts_unique (p_ponv_rec.opt_id, p_ponv_rec.pdt_id);
577: FETCH okl_pdt_opts_unique INTO l_unique_key;
578: IF okl_pdt_opts_unique%FOUND THEN
579: OKC_API.set_message(G_APP_NAME,G_DUPLICATE_RECORD,G_COL_NAME_TOKEN,'opt_id');
580: OKC_API.set_message(G_APP_NAME,G_DUPLICATE_RECORD,G_COL_NAME_TOKEN,'pdt_id');

Line 577: FETCH okl_pdt_opts_unique INTO l_unique_key;

573: -- initialize return status
574: x_return_status := OKC_API.G_RET_STS_SUCCESS;
575:
576: OPEN okl_pdt_opts_unique (p_ponv_rec.opt_id, p_ponv_rec.pdt_id);
577: FETCH okl_pdt_opts_unique INTO l_unique_key;
578: IF okl_pdt_opts_unique%FOUND THEN
579: OKC_API.set_message(G_APP_NAME,G_DUPLICATE_RECORD,G_COL_NAME_TOKEN,'opt_id');
580: OKC_API.set_message(G_APP_NAME,G_DUPLICATE_RECORD,G_COL_NAME_TOKEN,'pdt_id');
581: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 578: IF okl_pdt_opts_unique%FOUND THEN

574: x_return_status := OKC_API.G_RET_STS_SUCCESS;
575:
576: OPEN okl_pdt_opts_unique (p_ponv_rec.opt_id, p_ponv_rec.pdt_id);
577: FETCH okl_pdt_opts_unique INTO l_unique_key;
578: IF okl_pdt_opts_unique%FOUND THEN
579: OKC_API.set_message(G_APP_NAME,G_DUPLICATE_RECORD,G_COL_NAME_TOKEN,'opt_id');
580: OKC_API.set_message(G_APP_NAME,G_DUPLICATE_RECORD,G_COL_NAME_TOKEN,'pdt_id');
581: x_return_status := OKC_API.G_RET_STS_ERROR;
582: ELSE

Line 585: CLOSE okl_pdt_opts_unique;

581: x_return_status := OKC_API.G_RET_STS_ERROR;
582: ELSE
583: x_return_status := OKC_API.G_RET_STS_SUCCESS;
584: END IF;
585: CLOSE okl_pdt_opts_unique;
586:
587: EXCEPTION
588: WHEN OTHERS THEN
589: OKC_API.set_message(p_app_name =>G_APP_NAME,

Line 825: -- Validate_Record for:OKL_PDT_OPTS_V --

821: ---------------------------------------------------------------------------
822: -- PROCEDURE Validate_Record
823: ---------------------------------------------------------------------------
824: ----------------------------------------
825: -- Validate_Record for:OKL_PDT_OPTS_V --
826: ----------------------------------------
827: -- FUNCTION Validate_Record (
828: -- p_ponv_rec IN ponv_rec_type
829: -- ) RETURN VARCHAR2 IS

Line 881: -- validate_row for:OKL_PDT_OPTS_V --

877: ---------------------------------------------------------------------------
878: -- PROCEDURE validate_row
879: ---------------------------------------------------------------------------
880: -------------------------------------
881: -- validate_row for:OKL_PDT_OPTS_V --
882: -------------------------------------
883: PROCEDURE validate_row(
884: p_api_version IN NUMBER,
885: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1034: -- insert_row for:OKL_PDT_OPTS --

1030: ---------------------------------------------------------------------------
1031: -- PROCEDURE insert_row
1032: ---------------------------------------------------------------------------
1033: ---------------------------------
1034: -- insert_row for:OKL_PDT_OPTS --
1035: ---------------------------------
1036: PROCEDURE insert_row(
1037: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1038: x_return_status OUT NOCOPY VARCHAR2,

Line 1050: -- Set_Attributes for:OKL_PDT_OPTS --

1046: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1047: l_pon_rec pon_rec_type := p_pon_rec;
1048: l_def_pon_rec pon_rec_type;
1049: -------------------------------------
1050: -- Set_Attributes for:OKL_PDT_OPTS --
1051: -------------------------------------
1052: FUNCTION Set_Attributes (
1053: p_pon_rec IN pon_rec_type,
1054: x_pon_rec OUT NOCOPY pon_rec_type

Line 1081: INSERT INTO OKL_PDT_OPTS(

1077: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1078: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_ERROR;
1080: END IF;
1081: INSERT INTO OKL_PDT_OPTS(
1082: id,
1083: opt_id,
1084: pdt_id,
1085: optional_yn,

Line 1143: -- insert_row for:OKL_PDT_OPTS_V --

1139: '_PVT'
1140: );
1141: END insert_row;
1142: -----------------------------------
1143: -- insert_row for:OKL_PDT_OPTS_V --
1144: -----------------------------------
1145: PROCEDURE insert_row(
1146: p_api_version IN NUMBER,
1147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1177: -- Set_Attributes for:OKL_PDT_OPTS_V --

1173: l_ponv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1174: RETURN(l_ponv_rec);
1175: END fill_who_columns;
1176: ---------------------------------------
1177: -- Set_Attributes for:OKL_PDT_OPTS_V --
1178: ---------------------------------------
1179: FUNCTION Set_Attributes (
1180: p_ponv_rec IN ponv_rec_type,
1181: x_ponv_rec OUT NOCOPY ponv_rec_type

Line 1366: -- lock_row for:OKL_PDT_OPTS --

1362: ---------------------------------------------------------------------------
1363: -- PROCEDURE lock_row
1364: ---------------------------------------------------------------------------
1365: -------------------------------
1366: -- lock_row for:OKL_PDT_OPTS --
1367: -------------------------------
1368: PROCEDURE lock_row(
1369: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1370: x_return_status OUT NOCOPY VARCHAR2,

Line 1379: FROM OKL_PDT_OPTS

1375: E_Resource_Busy EXCEPTION;
1376: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1377: CURSOR lock_csr (p_pon_rec IN pon_rec_type) IS
1378: SELECT OBJECT_VERSION_NUMBER
1379: FROM OKL_PDT_OPTS
1380: WHERE ID = p_pon_rec.id
1381: AND OBJECT_VERSION_NUMBER = p_pon_rec.object_version_number
1382: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1383:

Line 1386: FROM OKL_PDT_OPTS

1382: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1383:
1384: CURSOR lchk_csr (p_pon_rec IN pon_rec_type) IS
1385: SELECT OBJECT_VERSION_NUMBER
1386: FROM OKL_PDT_OPTS
1387: WHERE ID = p_pon_rec.id;
1388: l_api_version CONSTANT NUMBER := 1;
1389: l_api_name CONSTANT VARCHAR2(30) := 'OPTS_lock_row';
1390: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1391: l_object_version_number OKL_PDT_OPTS.OBJECT_VERSION_NUMBER%TYPE;

1387: WHERE ID = p_pon_rec.id;
1388: l_api_version CONSTANT NUMBER := 1;
1389: l_api_name CONSTANT VARCHAR2(30) := 'OPTS_lock_row';
1390: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1391: l_object_version_number OKL_PDT_OPTS.OBJECT_VERSION_NUMBER%TYPE;
1392: lc_object_version_number OKL_PDT_OPTS.OBJECT_VERSION_NUMBER%TYPE;
1393: l_row_notfound BOOLEAN := FALSE;
1394: lc_row_notfound BOOLEAN := FALSE;
1395: BEGIN

Line 1392: lc_object_version_number OKL_PDT_OPTS.OBJECT_VERSION_NUMBER%TYPE;

1388: l_api_version CONSTANT NUMBER := 1;
1389: l_api_name CONSTANT VARCHAR2(30) := 'OPTS_lock_row';
1390: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1391: l_object_version_number OKL_PDT_OPTS.OBJECT_VERSION_NUMBER%TYPE;
1392: lc_object_version_number OKL_PDT_OPTS.OBJECT_VERSION_NUMBER%TYPE;
1393: l_row_notfound BOOLEAN := FALSE;
1394: lc_row_notfound BOOLEAN := FALSE;
1395: BEGIN
1396: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1472: -- lock_row for:OKL_PDT_OPTS_V --

1468: '_PVT'
1469: );
1470: END lock_row;
1471: ---------------------------------
1472: -- lock_row for:OKL_PDT_OPTS_V --
1473: ---------------------------------
1474: PROCEDURE lock_row(
1475: p_api_version IN NUMBER,
1476: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1629: -- update_row for:OKL_PDT_OPTS --

1625: ---------------------------------------------------------------------------
1626: -- PROCEDURE update_row
1627: ---------------------------------------------------------------------------
1628: ---------------------------------
1629: -- update_row for:OKL_PDT_OPTS --
1630: ---------------------------------
1631: PROCEDURE update_row(
1632: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1633: x_return_status OUT NOCOPY VARCHAR2,

Line 1713: -- Set_Attributes for:OKL_PDT_OPTS --

1709: END IF;
1710: RETURN(l_return_status);
1711: END populate_new_record;
1712: -------------------------------------
1713: -- Set_Attributes for:OKL_PDT_OPTS --
1714: -------------------------------------
1715: FUNCTION Set_Attributes (
1716: p_pon_rec IN pon_rec_type,
1717: x_pon_rec OUT NOCOPY pon_rec_type

Line 1750: UPDATE OKL_PDT_OPTS

1746: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1747: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1748: RAISE OKC_API.G_EXCEPTION_ERROR;
1749: END IF;
1750: UPDATE OKL_PDT_OPTS
1751: SET OPT_ID = l_def_pon_rec.opt_id,
1752: PDT_ID = l_def_pon_rec.pdt_id,
1753: OPTIONAL_YN = l_def_pon_rec.optional_yn,
1754: OBJECT_VERSION_NUMBER = l_def_pon_rec.object_version_number,

Line 1799: -- update_row for:OKL_PDT_OPTS_V --

1795: '_PVT'
1796: );
1797: END update_row;
1798: -----------------------------------
1799: -- update_row for:OKL_PDT_OPTS_V --
1800: -----------------------------------
1801: PROCEDURE update_row(
1802: p_api_version IN NUMBER,
1803: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1898: -- Set_Attributes for:OKL_PDT_OPTS_V --

1894: END IF;
1895: RETURN(l_return_status);
1896: END populate_new_record;
1897: ---------------------------------------
1898: -- Set_Attributes for:OKL_PDT_OPTS_V --
1899: ---------------------------------------
1900: FUNCTION Set_Attributes (
1901: p_ponv_rec IN ponv_rec_type,
1902: x_ponv_rec OUT NOCOPY ponv_rec_type

Line 2090: -- delete_row for:OKL_PDT_OPTS --

2086: ---------------------------------------------------------------------------
2087: -- PROCEDURE delete_row
2088: ---------------------------------------------------------------------------
2089: ---------------------------------
2090: -- delete_row for:OKL_PDT_OPTS --
2091: ---------------------------------
2092: PROCEDURE delete_row(
2093: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2094: x_return_status OUT NOCOPY VARCHAR2,

Line 2114: DELETE FROM OKL_PDT_OPTS

2110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2111: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2112: RAISE OKC_API.G_EXCEPTION_ERROR;
2113: END IF;
2114: DELETE FROM OKL_PDT_OPTS
2115: WHERE ID = l_pon_rec.id;
2116:
2117: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2118: EXCEPTION

Line 2151: -- delete_row for:OKL_PDT_OPTS_V --

2147: '_PVT'
2148: );
2149: END delete_row;
2150: -----------------------------------
2151: -- delete_row for:OKL_PDT_OPTS_V --
2152: -----------------------------------
2153: PROCEDURE delete_row(
2154: p_api_version IN NUMBER,
2155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,