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.OKC_CVM_PVT dependencies on OKC_K_VERS_NUMBERS

Line 106: -- FUNCTION get_rec for: OKC_K_VERS_NUMBERS

102:
103: End validate_chr_id;
104:
105: ---------------------------------------------------------------------------
106: -- FUNCTION get_rec for: OKC_K_VERS_NUMBERS
107: ---------------------------------------------------------------------------
108: FUNCTION get_rec (
109: p_cvm_rec IN cvm_rec_type,
110: x_no_data_found OUT NOCOPY BOOLEAN

Line 123: FROM Okc_K_Vers_Numbers

119: CREATION_DATE,
120: LAST_UPDATED_BY,
121: LAST_UPDATE_DATE,
122: LAST_UPDATE_LOGIN
123: FROM Okc_K_Vers_Numbers
124: WHERE okc_k_vers_numbers.chr_id = p_chr_id;
125: l_cvm_pk cvm_pk_csr%ROWTYPE;
126: l_cvm_rec cvm_rec_type;
127: BEGIN

Line 124: WHERE okc_k_vers_numbers.chr_id = p_chr_id;

120: LAST_UPDATED_BY,
121: LAST_UPDATE_DATE,
122: LAST_UPDATE_LOGIN
123: FROM Okc_K_Vers_Numbers
124: WHERE okc_k_vers_numbers.chr_id = p_chr_id;
125: l_cvm_pk cvm_pk_csr%ROWTYPE;
126: l_cvm_rec cvm_rec_type;
127: BEGIN
128: x_no_data_found := TRUE;

Line 154: -- FUNCTION get_rec for: OKC_K_VERS_NUMBERS_V

150: BEGIN
151: RETURN(get_rec(p_cvm_rec, l_row_notfound));
152: END get_rec;
153: ---------------------------------------------------------------------------
154: -- FUNCTION get_rec for: OKC_K_VERS_NUMBERS_V
155: ---------------------------------------------------------------------------
156: FUNCTION get_rec (
157: p_cvmv_rec IN cvmv_rec_type,
158: x_no_data_found OUT NOCOPY BOOLEAN

Line 171: FROM Okc_K_Vers_Numbers_V

167: CREATION_DATE,
168: LAST_UPDATED_BY,
169: LAST_UPDATE_DATE,
170: LAST_UPDATE_LOGIN
171: FROM Okc_K_Vers_Numbers_V
172: WHERE okc_k_vers_numbers_v.chr_id = p_chr_id;
173: l_okc_cvmv_pk okc_cvmv_pk_csr%ROWTYPE;
174: l_cvmv_rec cvmv_rec_type;
175: BEGIN

Line 172: WHERE okc_k_vers_numbers_v.chr_id = p_chr_id;

168: LAST_UPDATED_BY,
169: LAST_UPDATE_DATE,
170: LAST_UPDATE_LOGIN
171: FROM Okc_K_Vers_Numbers_V
172: WHERE okc_k_vers_numbers_v.chr_id = p_chr_id;
173: l_okc_cvmv_pk okc_cvmv_pk_csr%ROWTYPE;
174: l_cvmv_rec cvmv_rec_type;
175: BEGIN
176: x_no_data_found := TRUE;

Line 203: -- FUNCTION null_out_defaults for: OKC_K_VERS_NUMBERS_V --

199: RETURN(get_rec(p_cvmv_rec, l_row_notfound));
200: END get_rec;
201:
202: ----------------------------------------------------------
203: -- FUNCTION null_out_defaults for: OKC_K_VERS_NUMBERS_V --
204: ----------------------------------------------------------
205: FUNCTION null_out_defaults (
206: p_cvmv_rec IN cvmv_rec_type
207: ) RETURN cvmv_rec_type IS

Line 243: -- Validate_Attributes for:OKC_K_VERS_NUMBERS_V --

239: ---------------------------------------------------------------------------
240: -- PROCEDURE Validate_Attributes
241: ---------------------------------------------------------------------------
242: --------------------------------------------------
243: -- Validate_Attributes for:OKC_K_VERS_NUMBERS_V --
244: --------------------------------------------------
245: FUNCTION Validate_Attributes (
246: p_cvmv_rec IN cvmv_rec_type
247: ) RETURN VARCHAR2 IS

Line 259: -- Validate_Record for:OKC_K_VERS_NUMBERS_V --

255: ---------------------------------------------------------------------------
256: -- PROCEDURE Validate_Record
257: ---------------------------------------------------------------------------
258: ----------------------------------------------
259: -- Validate_Record for:OKC_K_VERS_NUMBERS_V --
260: ----------------------------------------------
261: FUNCTION Validate_Record (
262: p_cvmv_rec IN cvmv_rec_type
263: ) RETURN VARCHAR2 IS

Line 304: p_to OUT NOCOPY okc_k_vers_numbers_h_rec_type

300: p_to.last_update_login := p_from.last_update_login;
301: END migrate;
302: PROCEDURE migrate (
303: p_from IN cvm_rec_type,
304: p_to OUT NOCOPY okc_k_vers_numbers_h_rec_type
305: ) IS
306: BEGIN
307: p_to.chr_id := p_from.chr_id;
308: p_to.major_version := p_from.major_version;

Line 322: -- insert_row for:OKC_K_VERS_NUMBERS_H --

318: ---------------------------------------------------------------------------
319: -- PROCEDURE insert_row
320: ---------------------------------------------------------------------------
321: -----------------------------------------
322: -- insert_row for:OKC_K_VERS_NUMBERS_H --
323: -----------------------------------------
324: PROCEDURE insert_row(
325: p_init_msg_list IN VARCHAR2 ,
326: x_return_status OUT NOCOPY VARCHAR2,

Line 329: p_okc_k_vers_numbers_h_rec IN okc_k_vers_numbers_h_rec_type,

325: p_init_msg_list IN VARCHAR2 ,
326: x_return_status OUT NOCOPY VARCHAR2,
327: x_msg_count OUT NOCOPY NUMBER,
328: x_msg_data OUT NOCOPY VARCHAR2,
329: p_okc_k_vers_numbers_h_rec IN okc_k_vers_numbers_h_rec_type,
330: x_okc_k_vers_numbers_h_rec OUT NOCOPY okc_k_vers_numbers_h_rec_type) IS
331:
332: l_api_version CONSTANT NUMBER := 1;
333: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';

Line 330: x_okc_k_vers_numbers_h_rec OUT NOCOPY okc_k_vers_numbers_h_rec_type) IS

326: x_return_status OUT NOCOPY VARCHAR2,
327: x_msg_count OUT NOCOPY NUMBER,
328: x_msg_data OUT NOCOPY VARCHAR2,
329: p_okc_k_vers_numbers_h_rec IN okc_k_vers_numbers_h_rec_type,
330: x_okc_k_vers_numbers_h_rec OUT NOCOPY okc_k_vers_numbers_h_rec_type) IS
331:
332: l_api_version CONSTANT NUMBER := 1;
333: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
334: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 335: l_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type := p_okc_k_vers_numbers_h_rec;

331:
332: l_api_version CONSTANT NUMBER := 1;
333: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
334: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
335: l_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type := p_okc_k_vers_numbers_h_rec;
336: ldefokckversnumbershrec okc_k_vers_numbers_h_rec_type;
337: ---------------------------------------------
338: -- Set_Attributes for:OKC_K_VERS_NUMBERS_H --
339: ---------------------------------------------

Line 336: ldefokckversnumbershrec okc_k_vers_numbers_h_rec_type;

332: l_api_version CONSTANT NUMBER := 1;
333: l_api_name CONSTANT VARCHAR2(30) := 'H_insert_row';
334: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
335: l_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type := p_okc_k_vers_numbers_h_rec;
336: ldefokckversnumbershrec okc_k_vers_numbers_h_rec_type;
337: ---------------------------------------------
338: -- Set_Attributes for:OKC_K_VERS_NUMBERS_H --
339: ---------------------------------------------
340: FUNCTION Set_Attributes (

Line 338: -- Set_Attributes for:OKC_K_VERS_NUMBERS_H --

334: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
335: l_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type := p_okc_k_vers_numbers_h_rec;
336: ldefokckversnumbershrec okc_k_vers_numbers_h_rec_type;
337: ---------------------------------------------
338: -- Set_Attributes for:OKC_K_VERS_NUMBERS_H --
339: ---------------------------------------------
340: FUNCTION Set_Attributes (
341: p_okc_k_vers_numbers_h_rec IN okc_k_vers_numbers_h_rec_type,
342: x_okc_k_vers_numbers_h_rec OUT NOCOPY okc_k_vers_numbers_h_rec_type

Line 341: p_okc_k_vers_numbers_h_rec IN okc_k_vers_numbers_h_rec_type,

337: ---------------------------------------------
338: -- Set_Attributes for:OKC_K_VERS_NUMBERS_H --
339: ---------------------------------------------
340: FUNCTION Set_Attributes (
341: p_okc_k_vers_numbers_h_rec IN okc_k_vers_numbers_h_rec_type,
342: x_okc_k_vers_numbers_h_rec OUT NOCOPY okc_k_vers_numbers_h_rec_type
343: ) RETURN VARCHAR2 IS
344: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
345: BEGIN

Line 342: x_okc_k_vers_numbers_h_rec OUT NOCOPY okc_k_vers_numbers_h_rec_type

338: -- Set_Attributes for:OKC_K_VERS_NUMBERS_H --
339: ---------------------------------------------
340: FUNCTION Set_Attributes (
341: p_okc_k_vers_numbers_h_rec IN okc_k_vers_numbers_h_rec_type,
342: x_okc_k_vers_numbers_h_rec OUT NOCOPY okc_k_vers_numbers_h_rec_type
343: ) RETURN VARCHAR2 IS
344: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
345: BEGIN
346: x_okc_k_vers_numbers_h_rec := p_okc_k_vers_numbers_h_rec;

Line 346: x_okc_k_vers_numbers_h_rec := p_okc_k_vers_numbers_h_rec;

342: x_okc_k_vers_numbers_h_rec OUT NOCOPY okc_k_vers_numbers_h_rec_type
343: ) RETURN VARCHAR2 IS
344: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
345: BEGIN
346: x_okc_k_vers_numbers_h_rec := p_okc_k_vers_numbers_h_rec;
347: RETURN(l_return_status);
348: END Set_Attributes;
349: BEGIN
350: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 361: p_okc_k_vers_numbers_h_rec, -- IN

357: RAISE OKC_API.G_EXCEPTION_ERROR;
358: END IF;
359: --- Setting item attributes
360: l_return_status := Set_Attributes(
361: p_okc_k_vers_numbers_h_rec, -- IN
362: l_okc_k_vers_numbers_h_rec); -- OUT
363: --- If any errors happen abort API
364: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
365: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 362: l_okc_k_vers_numbers_h_rec); -- OUT

358: END IF;
359: --- Setting item attributes
360: l_return_status := Set_Attributes(
361: p_okc_k_vers_numbers_h_rec, -- IN
362: l_okc_k_vers_numbers_h_rec); -- OUT
363: --- If any errors happen abort API
364: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
365: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
366: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 369: INSERT INTO OKC_K_VERS_NUMBERS_H(

365: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
366: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
367: RAISE OKC_API.G_EXCEPTION_ERROR;
368: END IF;
369: INSERT INTO OKC_K_VERS_NUMBERS_H(
370: chr_id,
371: major_version,
372: minor_version,
373: object_version_number,

Line 380: l_okc_k_vers_numbers_h_rec.chr_id,

376: last_updated_by,
377: last_update_date,
378: last_update_login)
379: VALUES (
380: l_okc_k_vers_numbers_h_rec.chr_id,
381: l_okc_k_vers_numbers_h_rec.major_version,
382: l_okc_k_vers_numbers_h_rec.minor_version,
383: l_okc_k_vers_numbers_h_rec.object_version_number,
384: l_okc_k_vers_numbers_h_rec.created_by,

Line 381: l_okc_k_vers_numbers_h_rec.major_version,

377: last_update_date,
378: last_update_login)
379: VALUES (
380: l_okc_k_vers_numbers_h_rec.chr_id,
381: l_okc_k_vers_numbers_h_rec.major_version,
382: l_okc_k_vers_numbers_h_rec.minor_version,
383: l_okc_k_vers_numbers_h_rec.object_version_number,
384: l_okc_k_vers_numbers_h_rec.created_by,
385: l_okc_k_vers_numbers_h_rec.creation_date,

Line 382: l_okc_k_vers_numbers_h_rec.minor_version,

378: last_update_login)
379: VALUES (
380: l_okc_k_vers_numbers_h_rec.chr_id,
381: l_okc_k_vers_numbers_h_rec.major_version,
382: l_okc_k_vers_numbers_h_rec.minor_version,
383: l_okc_k_vers_numbers_h_rec.object_version_number,
384: l_okc_k_vers_numbers_h_rec.created_by,
385: l_okc_k_vers_numbers_h_rec.creation_date,
386: l_okc_k_vers_numbers_h_rec.last_updated_by,

Line 383: l_okc_k_vers_numbers_h_rec.object_version_number,

379: VALUES (
380: l_okc_k_vers_numbers_h_rec.chr_id,
381: l_okc_k_vers_numbers_h_rec.major_version,
382: l_okc_k_vers_numbers_h_rec.minor_version,
383: l_okc_k_vers_numbers_h_rec.object_version_number,
384: l_okc_k_vers_numbers_h_rec.created_by,
385: l_okc_k_vers_numbers_h_rec.creation_date,
386: l_okc_k_vers_numbers_h_rec.last_updated_by,
387: l_okc_k_vers_numbers_h_rec.last_update_date,

Line 384: l_okc_k_vers_numbers_h_rec.created_by,

380: l_okc_k_vers_numbers_h_rec.chr_id,
381: l_okc_k_vers_numbers_h_rec.major_version,
382: l_okc_k_vers_numbers_h_rec.minor_version,
383: l_okc_k_vers_numbers_h_rec.object_version_number,
384: l_okc_k_vers_numbers_h_rec.created_by,
385: l_okc_k_vers_numbers_h_rec.creation_date,
386: l_okc_k_vers_numbers_h_rec.last_updated_by,
387: l_okc_k_vers_numbers_h_rec.last_update_date,
388: l_okc_k_vers_numbers_h_rec.last_update_login);

Line 385: l_okc_k_vers_numbers_h_rec.creation_date,

381: l_okc_k_vers_numbers_h_rec.major_version,
382: l_okc_k_vers_numbers_h_rec.minor_version,
383: l_okc_k_vers_numbers_h_rec.object_version_number,
384: l_okc_k_vers_numbers_h_rec.created_by,
385: l_okc_k_vers_numbers_h_rec.creation_date,
386: l_okc_k_vers_numbers_h_rec.last_updated_by,
387: l_okc_k_vers_numbers_h_rec.last_update_date,
388: l_okc_k_vers_numbers_h_rec.last_update_login);
389: -- Set OUT values

Line 386: l_okc_k_vers_numbers_h_rec.last_updated_by,

382: l_okc_k_vers_numbers_h_rec.minor_version,
383: l_okc_k_vers_numbers_h_rec.object_version_number,
384: l_okc_k_vers_numbers_h_rec.created_by,
385: l_okc_k_vers_numbers_h_rec.creation_date,
386: l_okc_k_vers_numbers_h_rec.last_updated_by,
387: l_okc_k_vers_numbers_h_rec.last_update_date,
388: l_okc_k_vers_numbers_h_rec.last_update_login);
389: -- Set OUT values
390: x_okc_k_vers_numbers_h_rec := l_okc_k_vers_numbers_h_rec;

Line 387: l_okc_k_vers_numbers_h_rec.last_update_date,

383: l_okc_k_vers_numbers_h_rec.object_version_number,
384: l_okc_k_vers_numbers_h_rec.created_by,
385: l_okc_k_vers_numbers_h_rec.creation_date,
386: l_okc_k_vers_numbers_h_rec.last_updated_by,
387: l_okc_k_vers_numbers_h_rec.last_update_date,
388: l_okc_k_vers_numbers_h_rec.last_update_login);
389: -- Set OUT values
390: x_okc_k_vers_numbers_h_rec := l_okc_k_vers_numbers_h_rec;
391: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 388: l_okc_k_vers_numbers_h_rec.last_update_login);

384: l_okc_k_vers_numbers_h_rec.created_by,
385: l_okc_k_vers_numbers_h_rec.creation_date,
386: l_okc_k_vers_numbers_h_rec.last_updated_by,
387: l_okc_k_vers_numbers_h_rec.last_update_date,
388: l_okc_k_vers_numbers_h_rec.last_update_login);
389: -- Set OUT values
390: x_okc_k_vers_numbers_h_rec := l_okc_k_vers_numbers_h_rec;
391: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
392: EXCEPTION

Line 390: x_okc_k_vers_numbers_h_rec := l_okc_k_vers_numbers_h_rec;

386: l_okc_k_vers_numbers_h_rec.last_updated_by,
387: l_okc_k_vers_numbers_h_rec.last_update_date,
388: l_okc_k_vers_numbers_h_rec.last_update_login);
389: -- Set OUT values
390: x_okc_k_vers_numbers_h_rec := l_okc_k_vers_numbers_h_rec;
391: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
392: EXCEPTION
393: WHEN OKC_API.G_EXCEPTION_ERROR THEN
394: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 434: -- insert_row for:OKC_K_VERS_NUMBERS --

430: );
431: End If;
432: END insert_row;
433: ---------------------------------------
434: -- insert_row for:OKC_K_VERS_NUMBERS --
435: ---------------------------------------
436: PROCEDURE insert_row(
437: p_init_msg_list IN VARCHAR2 ,
438: x_return_status OUT NOCOPY VARCHAR2,

Line 450: -- Set_Attributes for:OKC_K_VERS_NUMBERS --

446: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
447: l_cvm_rec cvm_rec_type := p_cvm_rec;
448: l_def_cvm_rec cvm_rec_type;
449: -------------------------------------------
450: -- Set_Attributes for:OKC_K_VERS_NUMBERS --
451: -------------------------------------------
452: FUNCTION Set_Attributes (
453: p_cvm_rec IN cvm_rec_type,
454: x_cvm_rec OUT NOCOPY cvm_rec_type

Line 483: INSERT INTO OKC_K_VERS_NUMBERS(

479: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
480: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
481: RAISE OKC_API.G_EXCEPTION_ERROR;
482: END IF;
483: INSERT INTO OKC_K_VERS_NUMBERS(
484: chr_id,
485: major_version,
486: minor_version,
487: object_version_number,

Line 539: -- insert_row for:OKC_K_VERS_NUMBERS_V --

535: '_PVT'
536: );
537: END insert_row;
538: -----------------------------------------
539: -- insert_row for:OKC_K_VERS_NUMBERS_V --
540: -----------------------------------------
541: PROCEDURE insert_row(
542: p_api_version IN NUMBER,
543: p_init_msg_list IN VARCHAR2 ,

Line 573: -- Set_Attributes for:OKC_K_VERS_NUMBERS_V --

569: l_cvmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
570: RETURN(l_cvmv_rec);
571: END fill_who_columns;
572: ---------------------------------------------
573: -- Set_Attributes for:OKC_K_VERS_NUMBERS_V --
574: ---------------------------------------------
575: FUNCTION Set_Attributes (
576: p_cvmv_rec IN cvmv_rec_type,
577: x_cvmv_rec OUT NOCOPY cvmv_rec_type

Line 685: -- lock_row for:OKC_K_VERS_NUMBERS --

681: ---------------------------------------------------------------------------
682: -- PROCEDURE lock_row
683: ---------------------------------------------------------------------------
684: -------------------------------------
685: -- lock_row for:OKC_K_VERS_NUMBERS --
686: -------------------------------------
687: PROCEDURE lock_row(
688: p_init_msg_list IN VARCHAR2 ,
689: x_return_status OUT NOCOPY VARCHAR2,

Line 698: FROM OKC_K_VERS_NUMBERS

694: E_Resource_Busy EXCEPTION;
695: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
696: CURSOR lock_csr (p_cvm_rec IN cvm_rec_type) IS
697: SELECT OBJECT_VERSION_NUMBER
698: FROM OKC_K_VERS_NUMBERS
699: WHERE CHR_ID = p_cvm_rec.chr_id
700: AND OBJECT_VERSION_NUMBER IN (p_cvm_rec.object_version_number,
701: OKC_API.G_MISS_NUM)
702: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 706: FROM OKC_K_VERS_NUMBERS

702: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
703:
704: CURSOR lchk_csr (p_cvm_rec IN cvm_rec_type) IS
705: SELECT OBJECT_VERSION_NUMBER
706: FROM OKC_K_VERS_NUMBERS
707: WHERE CHR_ID = p_cvm_rec.chr_id;
708: l_api_version CONSTANT NUMBER := 1;
709: l_api_name CONSTANT VARCHAR2(30) := 'NUMBERS_lock_row';
710: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 711: l_object_version_number OKC_K_VERS_NUMBERS.OBJECT_VERSION_NUMBER%TYPE;

707: WHERE CHR_ID = p_cvm_rec.chr_id;
708: l_api_version CONSTANT NUMBER := 1;
709: l_api_name CONSTANT VARCHAR2(30) := 'NUMBERS_lock_row';
710: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
711: l_object_version_number OKC_K_VERS_NUMBERS.OBJECT_VERSION_NUMBER%TYPE;
712: lc_object_version_number OKC_K_VERS_NUMBERS.OBJECT_VERSION_NUMBER%TYPE;
713: l_row_notfound BOOLEAN := FALSE;
714: lc_row_notfound BOOLEAN := FALSE;
715: BEGIN

Line 712: lc_object_version_number OKC_K_VERS_NUMBERS.OBJECT_VERSION_NUMBER%TYPE;

708: l_api_version CONSTANT NUMBER := 1;
709: l_api_name CONSTANT VARCHAR2(30) := 'NUMBERS_lock_row';
710: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
711: l_object_version_number OKC_K_VERS_NUMBERS.OBJECT_VERSION_NUMBER%TYPE;
712: lc_object_version_number OKC_K_VERS_NUMBERS.OBJECT_VERSION_NUMBER%TYPE;
713: l_row_notfound BOOLEAN := FALSE;
714: lc_row_notfound BOOLEAN := FALSE;
715: BEGIN
716: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 792: -- lock_row for:OKC_K_VERS_NUMBERS_V --

788: '_PVT'
789: );
790: END lock_row;
791: ---------------------------------------
792: -- lock_row for:OKC_K_VERS_NUMBERS_V --
793: ---------------------------------------
794: PROCEDURE lock_row(
795: p_api_version IN NUMBER,
796: p_init_msg_list IN VARCHAR2 ,

Line 952: -- update_row for:OKC_K_VERS_NUMBERS --

948: ---------------------------------------------------------------------------
949: -- PROCEDURE update_row
950: ---------------------------------------------------------------------------
951: ---------------------------------------
952: -- update_row for:OKC_K_VERS_NUMBERS --
953: ---------------------------------------
954: PROCEDURE update_row(
955: p_init_msg_list IN VARCHAR2 ,
956: x_return_status OUT NOCOPY VARCHAR2,

Line 968: l_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type;

964: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
965: l_cvm_rec cvm_rec_type := p_cvm_rec;
966: l_def_cvm_rec cvm_rec_type;
967: l_row_notfound BOOLEAN := TRUE;
968: l_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type;
969: lx_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type;
970: ----------------------------------
971: -- FUNCTION populate_new_record --
972: ----------------------------------

Line 969: lx_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type;

965: l_cvm_rec cvm_rec_type := p_cvm_rec;
966: l_def_cvm_rec cvm_rec_type;
967: l_row_notfound BOOLEAN := TRUE;
968: l_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type;
969: lx_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type;
970: ----------------------------------
971: -- FUNCTION populate_new_record --
972: ----------------------------------
973: FUNCTION populate_new_record (

Line 990: migrate(l_cvm_rec, l_okc_k_vers_numbers_h_rec);

986: END IF;
987: -- Move the "old" record to the history record:
988: -- (1) to get the "old" version
989: -- (2) to avoid 2 hits to the database
990: migrate(l_cvm_rec, l_okc_k_vers_numbers_h_rec);
991: IF (x_cvm_rec.chr_id = OKC_API.G_MISS_NUM)
992: THEN
993: x_cvm_rec.chr_id := l_cvm_rec.chr_id;
994: END IF;

Line 1030: -- Set_Attributes for:OKC_K_VERS_NUMBERS --

1026: END IF;
1027: RETURN(l_return_status);
1028: END populate_new_record;
1029: -------------------------------------------
1030: -- Set_Attributes for:OKC_K_VERS_NUMBERS --
1031: -------------------------------------------
1032: FUNCTION Set_Attributes (
1033: p_cvm_rec IN cvm_rec_type,
1034: x_cvm_rec OUT NOCOPY cvm_rec_type

Line 1082: UPDATE OKC_K_VERS_NUMBERS

1078: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_ERROR;
1080: END IF;
1081:
1082: UPDATE OKC_K_VERS_NUMBERS
1083: SET MAJOR_VERSION = l_def_cvm_rec.major_version,
1084: MINOR_VERSION = l_def_cvm_rec.minor_version,
1085: OBJECT_VERSION_NUMBER = l_def_cvm_rec.object_version_number,
1086: CREATED_BY = l_def_cvm_rec.created_by,

Line 1099: l_okc_k_vers_numbers_h_rec,

1095: p_init_msg_list,
1096: x_return_status,
1097: x_msg_count,
1098: x_msg_data,
1099: l_okc_k_vers_numbers_h_rec,
1100: lx_okc_k_vers_numbers_h_rec
1101: );
1102: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1100: lx_okc_k_vers_numbers_h_rec

1096: x_return_status,
1097: x_msg_count,
1098: x_msg_data,
1099: l_okc_k_vers_numbers_h_rec,
1100: lx_okc_k_vers_numbers_h_rec
1101: );
1102: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1104: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1142: -- update_row for:OKC_K_VERS_NUMBERS_V --

1138: '_PVT'
1139: );
1140: END update_row;
1141: -----------------------------------------
1142: -- update_row for:OKC_K_VERS_NUMBERS_V --
1143: -----------------------------------------
1144: PROCEDURE update_row(
1145: p_api_version IN NUMBER,
1146: p_init_msg_list IN VARCHAR2 ,

Line 1229: -- Set_Attributes for:OKC_K_VERS_NUMBERS_V --

1225: END IF;
1226: RETURN(l_return_status);
1227: END populate_new_record;
1228: ---------------------------------------------
1229: -- Set_Attributes for:OKC_K_VERS_NUMBERS_V --
1230: ---------------------------------------------
1231: FUNCTION Set_Attributes (
1232: p_cvmv_rec IN cvmv_rec_type,
1233: x_cvmv_rec OUT NOCOPY cvmv_rec_type

Line 1360: -- delete_row for:OKC_K_VERS_NUMBERS --

1356: ---------------------------------------------------------------------------
1357: -- PROCEDURE delete_row
1358: ---------------------------------------------------------------------------
1359: ---------------------------------------
1360: -- delete_row for:OKC_K_VERS_NUMBERS --
1361: ---------------------------------------
1362: PROCEDURE delete_row(
1363: p_init_msg_list IN VARCHAR2 ,
1364: x_return_status OUT NOCOPY VARCHAR2,

Line 1374: l_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type;

1370: l_api_name CONSTANT VARCHAR2(30) := 'NUMBERS_delete_row';
1371: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1372: l_cvm_rec cvm_rec_type:= p_cvm_rec;
1373: l_row_notfound BOOLEAN := TRUE;
1374: l_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type;
1375: lx_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type;
1376: BEGIN
1377: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1378: p_init_msg_list,

Line 1375: lx_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type;

1371: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1372: l_cvm_rec cvm_rec_type:= p_cvm_rec;
1373: l_row_notfound BOOLEAN := TRUE;
1374: l_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type;
1375: lx_okc_k_vers_numbers_h_rec okc_k_vers_numbers_h_rec_type;
1376: BEGIN
1377: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1378: p_init_msg_list,
1379: '_PVT',

Line 1391: migrate(l_cvm_rec, l_okc_k_vers_numbers_h_rec);

1387: l_cvm_rec := get_rec(l_cvm_rec, l_row_notfound);
1388: IF (l_row_notfound) THEN
1389: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1390: END IF;
1391: migrate(l_cvm_rec, l_okc_k_vers_numbers_h_rec);
1392: insert_row(
1393: p_init_msg_list,
1394: x_return_status,
1395: x_msg_count,

Line 1397: l_okc_k_vers_numbers_h_rec,

1393: p_init_msg_list,
1394: x_return_status,
1395: x_msg_count,
1396: x_msg_data,
1397: l_okc_k_vers_numbers_h_rec,
1398: lx_okc_k_vers_numbers_h_rec
1399: );
1400: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1398: lx_okc_k_vers_numbers_h_rec

1394: x_return_status,
1395: x_msg_count,
1396: x_msg_data,
1397: l_okc_k_vers_numbers_h_rec,
1398: lx_okc_k_vers_numbers_h_rec
1399: );
1400: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1402: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1405: DELETE FROM OKC_K_VERS_NUMBERS

1401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1402: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1403: RAISE OKC_API.G_EXCEPTION_ERROR;
1404: END IF;
1405: DELETE FROM OKC_K_VERS_NUMBERS
1406: WHERE CHR_ID = l_cvm_rec.chr_id;
1407:
1408: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1409: EXCEPTION

Line 1442: -- delete_row for:OKC_K_VERS_NUMBERS_V --

1438: '_PVT'
1439: );
1440: END delete_row;
1441: -----------------------------------------
1442: -- delete_row for:OKC_K_VERS_NUMBERS_V --
1443: -----------------------------------------
1444: PROCEDURE delete_row(
1445: p_api_version IN NUMBER,
1446: p_init_msg_list IN VARCHAR2 ,

Line 1622: FROM OKC_K_VERS_NUMBERS_V

1618: l_not_found BOOLEAN := FALSE;
1619:
1620: Cursor l_cvmv_csr(p_chr_id NUMBER) Is
1621: SELECT major_version
1622: FROM OKC_K_VERS_NUMBERS_V
1623: WHERE chr_id = p_chr_id;
1624: BEGIN
1625:
1626: l_cvmv_rec := p_cvmv_rec;