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_POV_PVT dependencies on OKL_PDT_OPT_VALS

Line 36: -- FUNCTION get_rec for: OKL_PDT_OPT_VALS

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

Line 42: CURSOR okl_pdt_opt_vals_pk_csr (p_id IN NUMBER) IS

38: FUNCTION get_rec (
39: p_pov_rec IN pov_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN
41: ) RETURN pov_rec_type IS
42: CURSOR okl_pdt_opt_vals_pk_csr (p_id IN NUMBER) IS
43: SELECT
44: ID,
45: OVE_ID,
46: PON_ID,

Line 55: FROM Okl_Pdt_Opt_Vals

51: CREATION_DATE,
52: LAST_UPDATED_BY,
53: LAST_UPDATE_DATE,
54: LAST_UPDATE_LOGIN
55: FROM Okl_Pdt_Opt_Vals
56: WHERE okl_pdt_opt_vals.id = p_id;
57: l_okl_pdt_opt_vals_pk okl_pdt_opt_vals_pk_csr%ROWTYPE;
58: l_pov_rec pov_rec_type;
59: BEGIN

Line 56: WHERE okl_pdt_opt_vals.id = p_id;

52: LAST_UPDATED_BY,
53: LAST_UPDATE_DATE,
54: LAST_UPDATE_LOGIN
55: FROM Okl_Pdt_Opt_Vals
56: WHERE okl_pdt_opt_vals.id = p_id;
57: l_okl_pdt_opt_vals_pk okl_pdt_opt_vals_pk_csr%ROWTYPE;
58: l_pov_rec pov_rec_type;
59: BEGIN
60: x_no_data_found := TRUE;

Line 57: l_okl_pdt_opt_vals_pk okl_pdt_opt_vals_pk_csr%ROWTYPE;

53: LAST_UPDATE_DATE,
54: LAST_UPDATE_LOGIN
55: FROM Okl_Pdt_Opt_Vals
56: WHERE okl_pdt_opt_vals.id = p_id;
57: l_okl_pdt_opt_vals_pk okl_pdt_opt_vals_pk_csr%ROWTYPE;
58: l_pov_rec pov_rec_type;
59: BEGIN
60: x_no_data_found := TRUE;
61: -- Get current database values

Line 62: OPEN okl_pdt_opt_vals_pk_csr (p_pov_rec.id);

58: l_pov_rec pov_rec_type;
59: BEGIN
60: x_no_data_found := TRUE;
61: -- Get current database values
62: OPEN okl_pdt_opt_vals_pk_csr (p_pov_rec.id);
63: FETCH okl_pdt_opt_vals_pk_csr INTO
64: l_pov_rec.ID,
65: l_pov_rec.OVE_ID,
66: l_pov_rec.PON_ID,

Line 63: FETCH okl_pdt_opt_vals_pk_csr INTO

59: BEGIN
60: x_no_data_found := TRUE;
61: -- Get current database values
62: OPEN okl_pdt_opt_vals_pk_csr (p_pov_rec.id);
63: FETCH okl_pdt_opt_vals_pk_csr INTO
64: l_pov_rec.ID,
65: l_pov_rec.OVE_ID,
66: l_pov_rec.PON_ID,
67: l_pov_rec.FROM_DATE,

Line 75: x_no_data_found := okl_pdt_opt_vals_pk_csr%NOTFOUND;

71: l_pov_rec.CREATION_DATE,
72: l_pov_rec.LAST_UPDATED_BY,
73: l_pov_rec.LAST_UPDATE_DATE,
74: l_pov_rec.LAST_UPDATE_LOGIN;
75: x_no_data_found := okl_pdt_opt_vals_pk_csr%NOTFOUND;
76: CLOSE okl_pdt_opt_vals_pk_csr;
77: RETURN(l_pov_rec);
78: END get_rec;
79:

Line 76: CLOSE okl_pdt_opt_vals_pk_csr;

72: l_pov_rec.LAST_UPDATED_BY,
73: l_pov_rec.LAST_UPDATE_DATE,
74: l_pov_rec.LAST_UPDATE_LOGIN;
75: x_no_data_found := okl_pdt_opt_vals_pk_csr%NOTFOUND;
76: CLOSE okl_pdt_opt_vals_pk_csr;
77: RETURN(l_pov_rec);
78: END get_rec;
79:
80: FUNCTION get_rec (

Line 88: -- FUNCTION get_rec for: OKL_PDT_OPT_VALS_V

84: BEGIN
85: RETURN(get_rec(p_pov_rec, l_row_notfound));
86: END get_rec;
87: ---------------------------------------------------------------------------
88: -- FUNCTION get_rec for: OKL_PDT_OPT_VALS_V
89: ---------------------------------------------------------------------------
90: FUNCTION get_rec (
91: p_povv_rec IN povv_rec_type,
92: x_no_data_found OUT NOCOPY BOOLEAN

Line 107: FROM Okl_Pdt_Opt_Vals_V

103: CREATION_DATE,
104: LAST_UPDATED_BY,
105: LAST_UPDATE_DATE,
106: LAST_UPDATE_LOGIN
107: FROM Okl_Pdt_Opt_Vals_V
108: WHERE okl_pdt_opt_vals_v.id = p_id;
109: l_okl_povv_pk okl_povv_pk_csr%ROWTYPE;
110: l_povv_rec povv_rec_type;
111: BEGIN

Line 108: WHERE okl_pdt_opt_vals_v.id = p_id;

104: LAST_UPDATED_BY,
105: LAST_UPDATE_DATE,
106: LAST_UPDATE_LOGIN
107: FROM Okl_Pdt_Opt_Vals_V
108: WHERE okl_pdt_opt_vals_v.id = p_id;
109: l_okl_povv_pk okl_povv_pk_csr%ROWTYPE;
110: l_povv_rec povv_rec_type;
111: BEGIN
112: x_no_data_found := TRUE;

Line 141: -- FUNCTION null_out_defaults for: OKL_PDT_OPT_VALS_V --

137: RETURN(get_rec(p_povv_rec, l_row_notfound));
138: END get_rec;
139:
140: --------------------------------------------------------
141: -- FUNCTION null_out_defaults for: OKL_PDT_OPT_VALS_V --
142: --------------------------------------------------------
143: FUNCTION null_out_defaults (
144: p_povv_rec IN povv_rec_type
145: ) RETURN povv_rec_type IS

Line 184: -- Validate_Attributes for:OKL_PDT_OPT_VALS_V --

180: ---------------------------------------------------------------------------
181: -- PROCEDURE Validate_Attributes
182: ---------------------------------------------------------------------------
183: ------------------------------------------------
184: -- Validate_Attributes for:OKL_PDT_OPT_VALS_V --
185: ------------------------------------------------
186:
187: ----------------TCHGS NEW CHANGS BEGIN --------------------------
188:

Line 283: CURSOR okl_pdt_opt_vals_foreign1 (p_foreign OKL_PDT_OPT_VALS.OVE_ID%TYPE) IS

279: p_povv_rec IN povv_rec_type,
280: x_return_status OUT NOCOPY VARCHAR2
281: ) IS
282: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
283: CURSOR okl_pdt_opt_vals_foreign1 (p_foreign OKL_PDT_OPT_VALS.OVE_ID%TYPE) IS
284: SELECT ID
285: FROM OKL_OPT_VALUES_V
286: WHERE OKL_OPT_VALUES_V.ID = p_foreign;
287:

Line 288: l_foreign_key OKL_PDT_OPT_VALS_V.OVE_ID%TYPE;

284: SELECT ID
285: FROM OKL_OPT_VALUES_V
286: WHERE OKL_OPT_VALUES_V.ID = p_foreign;
287:
288: l_foreign_key OKL_PDT_OPT_VALS_V.OVE_ID%TYPE;
289:
290:
291: BEGIN
292: -- initialize return status

Line 303: OPEN okl_pdt_opt_vals_foreign1 (p_povv_rec.ove_id);

299: x_return_status := OKC_API.G_RET_STS_ERROR;
300: END IF;
301:
302: IF p_povv_rec.ove_id IS NOT NULL THEN
303: OPEN okl_pdt_opt_vals_foreign1 (p_povv_rec.ove_id);
304: FETCH okl_pdt_opt_vals_foreign1 INTO l_foreign_key;
305: IF okl_pdt_opt_vals_foreign1%NOTFOUND THEN
306: OKC_API.set_message(G_APP_NAME, G_INVALID_KEY,G_COL_NAME_TOKEN,'ove_id');
307: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 304: FETCH okl_pdt_opt_vals_foreign1 INTO l_foreign_key;

300: END IF;
301:
302: IF p_povv_rec.ove_id IS NOT NULL THEN
303: OPEN okl_pdt_opt_vals_foreign1 (p_povv_rec.ove_id);
304: FETCH okl_pdt_opt_vals_foreign1 INTO l_foreign_key;
305: IF okl_pdt_opt_vals_foreign1%NOTFOUND THEN
306: OKC_API.set_message(G_APP_NAME, G_INVALID_KEY,G_COL_NAME_TOKEN,'ove_id');
307: x_return_status := OKC_API.G_RET_STS_ERROR;
308:

Line 305: IF okl_pdt_opt_vals_foreign1%NOTFOUND THEN

301:
302: IF p_povv_rec.ove_id IS NOT NULL THEN
303: OPEN okl_pdt_opt_vals_foreign1 (p_povv_rec.ove_id);
304: FETCH okl_pdt_opt_vals_foreign1 INTO l_foreign_key;
305: IF okl_pdt_opt_vals_foreign1%NOTFOUND THEN
306: OKC_API.set_message(G_APP_NAME, G_INVALID_KEY,G_COL_NAME_TOKEN,'ove_id');
307: x_return_status := OKC_API.G_RET_STS_ERROR;
308:
309: ELSE

Line 312: CLOSE okl_pdt_opt_vals_foreign1;

308:
309: ELSE
310: x_return_status := OKC_API.G_RET_STS_SUCCESS;
311: END IF;
312: CLOSE okl_pdt_opt_vals_foreign1;
313: END IF;
314:
315:
316: EXCEPTION

Line 347: CURSOR okl_pdt_opt_vals_foreign2 (p_foreign OKL_PDT_OPT_VALS.PON_ID%TYPE) IS

343: p_povv_rec IN povv_rec_type,
344: x_return_status OUT NOCOPY VARCHAR2
345: ) IS
346: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
347: CURSOR okl_pdt_opt_vals_foreign2 (p_foreign OKL_PDT_OPT_VALS.PON_ID%TYPE) IS
348: SELECT ID
349: FROM OKL_PDT_OPTS_V
350: WHERE OKL_PDT_OPTS_V.ID = p_foreign;
351:

Line 352: l_foreign_key OKL_PDT_OPT_VALS_V.PON_ID%TYPE;

348: SELECT ID
349: FROM OKL_PDT_OPTS_V
350: WHERE OKL_PDT_OPTS_V.ID = p_foreign;
351:
352: l_foreign_key OKL_PDT_OPT_VALS_V.PON_ID%TYPE;
353:
354:
355: BEGIN
356: -- initialize return status

Line 367: OPEN okl_pdt_opt_vals_foreign2 (p_povv_rec.pon_id);

363: x_return_status := OKC_API.G_RET_STS_ERROR;
364: END IF;
365:
366: IF p_povv_rec.pon_id IS NOT NULL THEN
367: OPEN okl_pdt_opt_vals_foreign2 (p_povv_rec.pon_id);
368: FETCH okl_pdt_opt_vals_foreign2 INTO l_foreign_key;
369: IF okl_pdt_opt_vals_foreign2%NOTFOUND THEN
370: OKC_API.set_message(G_APP_NAME, G_INVALID_KEY,G_COL_NAME_TOKEN,'pon_id');
371: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 368: FETCH okl_pdt_opt_vals_foreign2 INTO l_foreign_key;

364: END IF;
365:
366: IF p_povv_rec.pon_id IS NOT NULL THEN
367: OPEN okl_pdt_opt_vals_foreign2 (p_povv_rec.pon_id);
368: FETCH okl_pdt_opt_vals_foreign2 INTO l_foreign_key;
369: IF okl_pdt_opt_vals_foreign2%NOTFOUND THEN
370: OKC_API.set_message(G_APP_NAME, G_INVALID_KEY,G_COL_NAME_TOKEN,'pon_id');
371: x_return_status := OKC_API.G_RET_STS_ERROR;
372:

Line 369: IF okl_pdt_opt_vals_foreign2%NOTFOUND THEN

365:
366: IF p_povv_rec.pon_id IS NOT NULL THEN
367: OPEN okl_pdt_opt_vals_foreign2 (p_povv_rec.pon_id);
368: FETCH okl_pdt_opt_vals_foreign2 INTO l_foreign_key;
369: IF okl_pdt_opt_vals_foreign2%NOTFOUND THEN
370: OKC_API.set_message(G_APP_NAME, G_INVALID_KEY,G_COL_NAME_TOKEN,'pon_id');
371: x_return_status := OKC_API.G_RET_STS_ERROR;
372:
373: ELSE

Line 376: CLOSE okl_pdt_opt_vals_foreign2;

372:
373: ELSE
374: x_return_status := OKC_API.G_RET_STS_SUCCESS;
375: END IF;
376: CLOSE okl_pdt_opt_vals_foreign2;
377: END IF;
378:
379: EXCEPTION
380: WHEN OTHERS THEN

Line 502: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS

498: p_povv_rec IN povv_rec_type,
499: x_return_status OUT NOCOPY VARCHAR2
500: ) IS
501:
502: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS
503: SELECT '1'
504: FROM OKL_PDT_OPT_VALS_V
505: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
506: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND

Line 504: FROM OKL_PDT_OPT_VALS_V

500: ) IS
501:
502: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS
503: SELECT '1'
504: FROM OKL_PDT_OPT_VALS_V
505: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
506: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
507: OKL_PDT_OPT_VALS_V.ID <> nvl(p_povv_rec.id,-9999);
508:

Line 505: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND

501:
502: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS
503: SELECT '1'
504: FROM OKL_PDT_OPT_VALS_V
505: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
506: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
507: OKL_PDT_OPT_VALS_V.ID <> nvl(p_povv_rec.id,-9999);
508:
509: l_unique_key VARCHAR2(1);

Line 506: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND

502: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS
503: SELECT '1'
504: FROM OKL_PDT_OPT_VALS_V
505: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
506: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
507: OKL_PDT_OPT_VALS_V.ID <> nvl(p_povv_rec.id,-9999);
508:
509: l_unique_key VARCHAR2(1);
510:

Line 507: OKL_PDT_OPT_VALS_V.ID <> nvl(p_povv_rec.id,-9999);

503: SELECT '1'
504: FROM OKL_PDT_OPT_VALS_V
505: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
506: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
507: OKL_PDT_OPT_VALS_V.ID <> nvl(p_povv_rec.id,-9999);
508:
509: l_unique_key VARCHAR2(1);
510:
511: BEGIN

Line 515: OPEN okl_pdt_opt_vals_unique (p_povv_rec.ove_id, p_povv_rec.pon_id);

511: BEGIN
512: -- initialize return status
513: x_return_status := OKC_API.G_RET_STS_SUCCESS;
514:
515: OPEN okl_pdt_opt_vals_unique (p_povv_rec.ove_id, p_povv_rec.pon_id);
516: FETCH okl_pdt_opt_vals_unique INTO l_unique_key;
517: IF okl_pdt_opt_vals_unique%FOUND THEN
518: OKC_API.set_message(G_APP_NAME,G_DUPLICATE_RECORD,G_COL_NAME_TOKEN,'ove_id');
519: OKC_API.set_message(G_APP_NAME,G_DUPLICATE_RECORD,G_COL_NAME_TOKEN,'pon_id');

Line 516: FETCH okl_pdt_opt_vals_unique INTO l_unique_key;

512: -- initialize return status
513: x_return_status := OKC_API.G_RET_STS_SUCCESS;
514:
515: OPEN okl_pdt_opt_vals_unique (p_povv_rec.ove_id, p_povv_rec.pon_id);
516: FETCH okl_pdt_opt_vals_unique INTO l_unique_key;
517: IF okl_pdt_opt_vals_unique%FOUND THEN
518: OKC_API.set_message(G_APP_NAME,G_DUPLICATE_RECORD,G_COL_NAME_TOKEN,'ove_id');
519: OKC_API.set_message(G_APP_NAME,G_DUPLICATE_RECORD,G_COL_NAME_TOKEN,'pon_id');
520: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 517: IF okl_pdt_opt_vals_unique%FOUND THEN

513: x_return_status := OKC_API.G_RET_STS_SUCCESS;
514:
515: OPEN okl_pdt_opt_vals_unique (p_povv_rec.ove_id, p_povv_rec.pon_id);
516: FETCH okl_pdt_opt_vals_unique INTO l_unique_key;
517: IF okl_pdt_opt_vals_unique%FOUND THEN
518: OKC_API.set_message(G_APP_NAME,G_DUPLICATE_RECORD,G_COL_NAME_TOKEN,'ove_id');
519: OKC_API.set_message(G_APP_NAME,G_DUPLICATE_RECORD,G_COL_NAME_TOKEN,'pon_id');
520: x_return_status := OKC_API.G_RET_STS_ERROR;
521: ELSE

Line 524: CLOSE okl_pdt_opt_vals_unique;

520: x_return_status := OKC_API.G_RET_STS_ERROR;
521: ELSE
522: x_return_status := OKC_API.G_RET_STS_SUCCESS;
523: END IF;
524: CLOSE okl_pdt_opt_vals_unique;
525:
526: EXCEPTION
527: WHEN OTHERS THEN
528: OKC_API.set_message(p_app_name =>G_APP_NAME,

Line 746: -- Validate_Record for:OKL_PDT_OPT_VALS_V --

742: ---------------------------------------------------------------------------
743: -- PROCEDURE Validate_Record
744: ---------------------------------------------------------------------------
745: --------------------------------------------
746: -- Validate_Record for:OKL_PDT_OPT_VALS_V --
747: --------------------------------------------
748: -- FUNCTION Validate_Record (
749: -- p_povv_rec IN povv_rec_type
750: -- ) RETURN VARCHAR2 IS

Line 800: -- validate_row for:OKL_PDT_OPT_VALS_V --

796: ---------------------------------------------------------------------------
797: -- PROCEDURE validate_row
798: ---------------------------------------------------------------------------
799: -----------------------------------------
800: -- validate_row for:OKL_PDT_OPT_VALS_V --
801: -----------------------------------------
802: PROCEDURE validate_row(
803: p_api_version IN NUMBER,
804: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 953: -- insert_row for:OKL_PDT_OPT_VALS --

949: ---------------------------------------------------------------------------
950: -- PROCEDURE insert_row
951: ---------------------------------------------------------------------------
952: -------------------------------------
953: -- insert_row for:OKL_PDT_OPT_VALS --
954: -------------------------------------
955: PROCEDURE insert_row(
956: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
957: x_return_status OUT NOCOPY VARCHAR2,

Line 969: -- Set_Attributes for:OKL_PDT_OPT_VALS --

965: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
966: l_pov_rec pov_rec_type := p_pov_rec;
967: l_def_pov_rec pov_rec_type;
968: -----------------------------------------
969: -- Set_Attributes for:OKL_PDT_OPT_VALS --
970: -----------------------------------------
971: FUNCTION Set_Attributes (
972: p_pov_rec IN pov_rec_type,
973: x_pov_rec OUT NOCOPY pov_rec_type

Line 1000: INSERT INTO OKL_PDT_OPT_VALS(

996: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
998: RAISE OKC_API.G_EXCEPTION_ERROR;
999: END IF;
1000: INSERT INTO OKL_PDT_OPT_VALS(
1001: id,
1002: ove_id,
1003: pon_id,
1004: from_date,

Line 1060: -- insert_row for:OKL_PDT_OPT_VALS_V --

1056: '_PVT'
1057: );
1058: END insert_row;
1059: ---------------------------------------
1060: -- insert_row for:OKL_PDT_OPT_VALS_V --
1061: ---------------------------------------
1062: PROCEDURE insert_row(
1063: p_api_version IN NUMBER,
1064: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1094: -- Set_Attributes for:OKL_PDT_OPT_VALS_V --

1090: l_povv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1091: RETURN(l_povv_rec);
1092: END fill_who_columns;
1093: -------------------------------------------
1094: -- Set_Attributes for:OKL_PDT_OPT_VALS_V --
1095: -------------------------------------------
1096: FUNCTION Set_Attributes (
1097: p_povv_rec IN povv_rec_type,
1098: x_povv_rec OUT NOCOPY povv_rec_type

Line 1283: -- lock_row for:OKL_PDT_OPT_VALS --

1279: ---------------------------------------------------------------------------
1280: -- PROCEDURE lock_row
1281: ---------------------------------------------------------------------------
1282: -----------------------------------
1283: -- lock_row for:OKL_PDT_OPT_VALS --
1284: -----------------------------------
1285: PROCEDURE lock_row(
1286: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1287: x_return_status OUT NOCOPY VARCHAR2,

Line 1296: FROM OKL_PDT_OPT_VALS

1292: E_Resource_Busy EXCEPTION;
1293: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1294: CURSOR lock_csr (p_pov_rec IN pov_rec_type) IS
1295: SELECT OBJECT_VERSION_NUMBER
1296: FROM OKL_PDT_OPT_VALS
1297: WHERE ID = p_pov_rec.id
1298: AND OBJECT_VERSION_NUMBER = p_pov_rec.object_version_number
1299: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1300:

Line 1303: FROM OKL_PDT_OPT_VALS

1299: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1300:
1301: CURSOR lchk_csr (p_pov_rec IN pov_rec_type) IS
1302: SELECT OBJECT_VERSION_NUMBER
1303: FROM OKL_PDT_OPT_VALS
1304: WHERE ID = p_pov_rec.id;
1305: l_api_version CONSTANT NUMBER := 1;
1306: l_api_name CONSTANT VARCHAR2(30) := 'VALS_lock_row';
1307: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1308: l_object_version_number OKL_PDT_OPT_VALS.OBJECT_VERSION_NUMBER%TYPE;

1304: WHERE ID = p_pov_rec.id;
1305: l_api_version CONSTANT NUMBER := 1;
1306: l_api_name CONSTANT VARCHAR2(30) := 'VALS_lock_row';
1307: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1308: l_object_version_number OKL_PDT_OPT_VALS.OBJECT_VERSION_NUMBER%TYPE;
1309: lc_object_version_number OKL_PDT_OPT_VALS.OBJECT_VERSION_NUMBER%TYPE;
1310: l_row_notfound BOOLEAN := FALSE;
1311: lc_row_notfound BOOLEAN := FALSE;
1312: BEGIN

Line 1309: lc_object_version_number OKL_PDT_OPT_VALS.OBJECT_VERSION_NUMBER%TYPE;

1305: l_api_version CONSTANT NUMBER := 1;
1306: l_api_name CONSTANT VARCHAR2(30) := 'VALS_lock_row';
1307: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1308: l_object_version_number OKL_PDT_OPT_VALS.OBJECT_VERSION_NUMBER%TYPE;
1309: lc_object_version_number OKL_PDT_OPT_VALS.OBJECT_VERSION_NUMBER%TYPE;
1310: l_row_notfound BOOLEAN := FALSE;
1311: lc_row_notfound BOOLEAN := FALSE;
1312: BEGIN
1313: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1389: -- lock_row for:OKL_PDT_OPT_VALS_V --

1385: '_PVT'
1386: );
1387: END lock_row;
1388: -------------------------------------
1389: -- lock_row for:OKL_PDT_OPT_VALS_V --
1390: -------------------------------------
1391: PROCEDURE lock_row(
1392: p_api_version IN NUMBER,
1393: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1546: -- update_row for:OKL_PDT_OPT_VALS --

1542: ---------------------------------------------------------------------------
1543: -- PROCEDURE update_row
1544: ---------------------------------------------------------------------------
1545: -------------------------------------
1546: -- update_row for:OKL_PDT_OPT_VALS --
1547: -------------------------------------
1548: PROCEDURE update_row(
1549: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1550: x_return_status OUT NOCOPY VARCHAR2,

Line 1626: -- Set_Attributes for:OKL_PDT_OPT_VALS --

1622: END IF;
1623: RETURN(l_return_status);
1624: END populate_new_record;
1625: -----------------------------------------
1626: -- Set_Attributes for:OKL_PDT_OPT_VALS --
1627: -----------------------------------------
1628: FUNCTION Set_Attributes (
1629: p_pov_rec IN pov_rec_type,
1630: x_pov_rec OUT NOCOPY pov_rec_type

Line 1663: UPDATE OKL_PDT_OPT_VALS

1659: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1660: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1661: RAISE OKC_API.G_EXCEPTION_ERROR;
1662: END IF;
1663: UPDATE OKL_PDT_OPT_VALS
1664: SET OVE_ID = l_def_pov_rec.ove_id,
1665: PON_ID = l_def_pov_rec.pon_id,
1666: FROM_DATE = l_def_pov_rec.from_date,
1667: TO_DATE = l_def_pov_rec.to_date,

Line 1711: -- update_row for:OKL_PDT_OPT_VALS_V --

1707: '_PVT'
1708: );
1709: END update_row;
1710: ---------------------------------------
1711: -- update_row for:OKL_PDT_OPT_VALS_V --
1712: ---------------------------------------
1713: PROCEDURE update_row(
1714: p_api_version IN NUMBER,
1715: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1806: -- Set_Attributes for:OKL_PDT_OPT_VALS_V --

1802: END IF;
1803: RETURN(l_return_status);
1804: END populate_new_record;
1805: -------------------------------------------
1806: -- Set_Attributes for:OKL_PDT_OPT_VALS_V --
1807: -------------------------------------------
1808: FUNCTION Set_Attributes (
1809: p_povv_rec IN povv_rec_type,
1810: x_povv_rec OUT NOCOPY povv_rec_type

Line 1998: -- delete_row for:OKL_PDT_OPT_VALS --

1994: ---------------------------------------------------------------------------
1995: -- PROCEDURE delete_row
1996: ---------------------------------------------------------------------------
1997: -------------------------------------
1998: -- delete_row for:OKL_PDT_OPT_VALS --
1999: -------------------------------------
2000: PROCEDURE delete_row(
2001: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2002: x_return_status OUT NOCOPY VARCHAR2,

Line 2022: DELETE FROM OKL_PDT_OPT_VALS

2018: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2019: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2020: RAISE OKC_API.G_EXCEPTION_ERROR;
2021: END IF;
2022: DELETE FROM OKL_PDT_OPT_VALS
2023: WHERE ID = l_pov_rec.id;
2024:
2025: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2026: EXCEPTION

Line 2059: -- delete_row for:OKL_PDT_OPT_VALS_V --

2055: '_PVT'
2056: );
2057: END delete_row;
2058: ---------------------------------------
2059: -- delete_row for:OKL_PDT_OPT_VALS_V --
2060: ---------------------------------------
2061: PROCEDURE delete_row(
2062: p_api_version IN NUMBER,
2063: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,