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.

[Home] [Help]

APPS.OKC_CAC_PVT dependencies on OKC_K_ACCESSES

Line 13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_K_ACCESSES_V';

9: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_K_ACCESSES_V';
14: G_EXCEPTION_HALT_VALIDATION exception;
15: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16:
17: -- Start of comments

Line 385: -- FUNCTION get_rec for: OKC_K_ACCESSES

381:
382: END api_copy;
383:
384: ---------------------------------------------------------------------------
385: -- FUNCTION get_rec for: OKC_K_ACCESSES
386: ---------------------------------------------------------------------------
387: FUNCTION get_rec (
388: p_cac_rec IN cac_rec_type,
389: x_no_data_found OUT NOCOPY BOOLEAN

Line 404: FROM Okc_K_Accesses

400: CREATION_DATE,
401: LAST_UPDATED_BY,
402: LAST_UPDATE_DATE,
403: LAST_UPDATE_LOGIN
404: FROM Okc_K_Accesses
405: WHERE okc_k_accesses.id = p_id;
406: l_cac_pk cac_pk_csr%ROWTYPE;
407: l_cac_rec cac_rec_type;
408: BEGIN

Line 405: WHERE okc_k_accesses.id = p_id;

401: LAST_UPDATED_BY,
402: LAST_UPDATE_DATE,
403: LAST_UPDATE_LOGIN
404: FROM Okc_K_Accesses
405: WHERE okc_k_accesses.id = p_id;
406: l_cac_pk cac_pk_csr%ROWTYPE;
407: l_cac_rec cac_rec_type;
408: BEGIN
409:

Line 452: -- FUNCTION get_rec for: OKC_K_ACCESSES_V

448: RETURN(get_rec(p_cac_rec, l_row_notfound));
449:
450: END get_rec;
451: ---------------------------------------------------------------------------
452: -- FUNCTION get_rec for: OKC_K_ACCESSES_V
453: ---------------------------------------------------------------------------
454: FUNCTION get_rec (
455: p_cacv_rec IN cacv_rec_type,
456: x_no_data_found OUT NOCOPY BOOLEAN

Line 471: FROM Okc_K_Accesses_V

467: CREATION_DATE,
468: LAST_UPDATED_BY,
469: LAST_UPDATE_DATE,
470: LAST_UPDATE_LOGIN
471: FROM Okc_K_Accesses_V
472: WHERE okc_k_accesses_v.id = p_id;
473: l_okc_cacv_pk okc_cacv_pk_csr%ROWTYPE;
474: l_cacv_rec cacv_rec_type;
475: BEGIN

Line 472: WHERE okc_k_accesses_v.id = p_id;

468: LAST_UPDATED_BY,
469: LAST_UPDATE_DATE,
470: LAST_UPDATE_LOGIN
471: FROM Okc_K_Accesses_V
472: WHERE okc_k_accesses_v.id = p_id;
473: l_okc_cacv_pk okc_cacv_pk_csr%ROWTYPE;
474: l_cacv_rec cacv_rec_type;
475: BEGIN
476:

Line 520: -- FUNCTION null_out_defaults for: OKC_K_ACCESSES_V --

516:
517: END get_rec;
518:
519: ------------------------------------------------------
520: -- FUNCTION null_out_defaults for: OKC_K_ACCESSES_V --
521: ------------------------------------------------------
522: FUNCTION null_out_defaults (
523: p_cacv_rec IN cacv_rec_type
524: ) RETURN cacv_rec_type IS

Line 576: -- Validate_Attributes for:OKC_K_ACCESSES_V --

572: ---------------------------------------------------------------------------
573: -- PROCEDURE Validate_Attributes
574: ---------------------------------------------------------------------------
575: ----------------------------------------------
576: -- Validate_Attributes for:OKC_K_ACCESSES_V --
577: ----------------------------------------------
578: FUNCTION Validate_Attributes (
579: p_cacv_rec IN cacv_rec_type
580: ) RETURN VARCHAR2 IS

Line 675: -- Validate_Record for:OKC_K_ACCESSES_V --

671: ---------------------------------------------------------------------------
672: -- PROCEDURE Validate_Record
673: ---------------------------------------------------------------------------
674: ------------------------------------------
675: -- Validate_Record for:OKC_K_ACCESSES_V --
676: ------------------------------------------
677: FUNCTION Validate_Record (
678: p_cacv_rec IN cacv_rec_type
679: ) RETURN VARCHAR2 IS

Line 689: FROM okc_k_accesses

685: -- Two cursors with and without null condition on columns.
686: -- ------------------------------------------------------
687: CURSOR cur_cac_1 IS
688: SELECT 'x'
689: FROM okc_k_accesses
690: WHERE chr_id = p_cacv_rec.CHR_ID
691: AND resource_id = p_cacv_rec.RESOURCE_ID
692: AND group_id IS NULL
693: AND id <> NVL(p_cacv_rec.ID,-9999);

Line 697: FROM okc_k_accesses

693: AND id <> NVL(p_cacv_rec.ID,-9999);
694:
695: CURSOR cur_cac_2 IS
696: SELECT 'x'
697: FROM okc_k_accesses
698: WHERE chr_id = p_cacv_rec.CHR_ID
699: AND resource_id IS NULL
700: AND group_id = p_cacv_rec.GROUP_ID
701: AND id <> NVL(p_cacv_rec.ID,-9999);

Line 864: -- validate_row for:OKC_K_ACCESSES_V --

860: ---------------------------------------------------------------------------
861: -- PROCEDURE validate_row
862: ---------------------------------------------------------------------------
863: ---------------------------------------
864: -- validate_row for:OKC_K_ACCESSES_V --
865: ---------------------------------------
866: PROCEDURE validate_row(
867: p_api_version IN NUMBER,
868: p_init_msg_list IN VARCHAR2 ,

Line 1081: -- insert_row for:OKC_K_ACCESSES --

1077: ---------------------------------------------------------------------------
1078: -- PROCEDURE insert_row
1079: ---------------------------------------------------------------------------
1080: -----------------------------------
1081: -- insert_row for:OKC_K_ACCESSES --
1082: -----------------------------------
1083: PROCEDURE insert_row(
1084: p_init_msg_list IN VARCHAR2 ,
1085: x_return_status OUT NOCOPY VARCHAR2,

Line 1097: -- Set_Attributes for:OKC_K_ACCESSES --

1093: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1094: l_cac_rec cac_rec_type := p_cac_rec;
1095: l_def_cac_rec cac_rec_type;
1096: ---------------------------------------
1097: -- Set_Attributes for:OKC_K_ACCESSES --
1098: ---------------------------------------
1099: FUNCTION Set_Attributes (
1100: p_cac_rec IN cac_rec_type,
1101: x_cac_rec OUT NOCOPY cac_rec_type

Line 1136: INSERT INTO OKC_K_ACCESSES(

1132: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1134: RAISE OKC_API.G_EXCEPTION_ERROR;
1135: END IF;
1136: INSERT INTO OKC_K_ACCESSES(
1137: id,
1138: chr_id,
1139: group_id,
1140: resource_id,

Line 1221: -- insert_row for:OKC_K_ACCESSES_V --

1217: );
1218:
1219: END insert_row;
1220: -------------------------------------
1221: -- insert_row for:OKC_K_ACCESSES_V --
1222: -------------------------------------
1223: PROCEDURE insert_row(
1224: p_api_version IN NUMBER,
1225: p_init_msg_list IN VARCHAR2 ,

Line 1268: -- Set_Attributes for:OKC_K_ACCESSES_V --

1264: RETURN(l_cacv_rec);
1265:
1266: END fill_who_columns;
1267: -----------------------------------------
1268: -- Set_Attributes for:OKC_K_ACCESSES_V --
1269: -----------------------------------------
1270: FUNCTION Set_Attributes (
1271: p_cacv_rec IN cacv_rec_type,
1272: x_cacv_rec OUT NOCOPY cacv_rec_type

Line 1537: -- lock_row for:OKC_K_ACCESSES --

1533: ---------------------------------------------------------------------------
1534: -- PROCEDURE lock_row
1535: ---------------------------------------------------------------------------
1536: ---------------------------------
1537: -- lock_row for:OKC_K_ACCESSES --
1538: ---------------------------------
1539: PROCEDURE lock_row(
1540: p_init_msg_list IN VARCHAR2 ,
1541: x_return_status OUT NOCOPY VARCHAR2,

Line 1550: FROM OKC_K_ACCESSES

1546: E_Resource_Busy EXCEPTION;
1547: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1548: CURSOR lock_csr (p_cac_rec IN cac_rec_type) IS
1549: SELECT OBJECT_VERSION_NUMBER
1550: FROM OKC_K_ACCESSES
1551: WHERE ID = p_cac_rec.id
1552: AND OBJECT_VERSION_NUMBER = p_cac_rec.object_version_number
1553: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1554:

Line 1557: FROM OKC_K_ACCESSES

1553: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1554:
1555: CURSOR lchk_csr (p_cac_rec IN cac_rec_type) IS
1556: SELECT OBJECT_VERSION_NUMBER
1557: FROM OKC_K_ACCESSES
1558: WHERE ID = p_cac_rec.id;
1559: l_api_version CONSTANT NUMBER := 1;
1560: l_api_name CONSTANT VARCHAR2(30) := 'ACCESSES_lock_row';
1561: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1562: l_object_version_number OKC_K_ACCESSES.OBJECT_VERSION_NUMBER%TYPE;

1558: WHERE ID = p_cac_rec.id;
1559: l_api_version CONSTANT NUMBER := 1;
1560: l_api_name CONSTANT VARCHAR2(30) := 'ACCESSES_lock_row';
1561: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1562: l_object_version_number OKC_K_ACCESSES.OBJECT_VERSION_NUMBER%TYPE;
1563: lc_object_version_number OKC_K_ACCESSES.OBJECT_VERSION_NUMBER%TYPE;
1564: l_row_notfound BOOLEAN := FALSE;
1565: lc_row_notfound BOOLEAN := FALSE;
1566: BEGIN

Line 1563: lc_object_version_number OKC_K_ACCESSES.OBJECT_VERSION_NUMBER%TYPE;

1559: l_api_version CONSTANT NUMBER := 1;
1560: l_api_name CONSTANT VARCHAR2(30) := 'ACCESSES_lock_row';
1561: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1562: l_object_version_number OKC_K_ACCESSES.OBJECT_VERSION_NUMBER%TYPE;
1563: lc_object_version_number OKC_K_ACCESSES.OBJECT_VERSION_NUMBER%TYPE;
1564: l_row_notfound BOOLEAN := FALSE;
1565: lc_row_notfound BOOLEAN := FALSE;
1566: BEGIN
1567:

Line 1692: -- lock_row for:OKC_K_ACCESSES_V --

1688: );
1689:
1690: END lock_row;
1691: -----------------------------------
1692: -- lock_row for:OKC_K_ACCESSES_V --
1693: -----------------------------------
1694: PROCEDURE lock_row(
1695: p_api_version IN NUMBER,
1696: p_init_msg_list IN VARCHAR2 ,

Line 1913: -- update_row for:OKC_K_ACCESSES --

1909: ---------------------------------------------------------------------------
1910: -- PROCEDURE update_row
1911: ---------------------------------------------------------------------------
1912: -----------------------------------
1913: -- update_row for:OKC_K_ACCESSES --
1914: -----------------------------------
1915: PROCEDURE update_row(
1916: p_init_msg_list IN VARCHAR2 ,
1917: x_return_status OUT NOCOPY VARCHAR2,

Line 2006: -- Set_Attributes for:OKC_K_ACCESSES --

2002: RETURN(l_return_status);
2003:
2004: END populate_new_record;
2005: ---------------------------------------
2006: -- Set_Attributes for:OKC_K_ACCESSES --
2007: ---------------------------------------
2008: FUNCTION Set_Attributes (
2009: p_cac_rec IN cac_rec_type,
2010: x_cac_rec OUT NOCOPY cac_rec_type

Line 2050: UPDATE OKC_K_ACCESSES

2046: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2047: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2048: RAISE OKC_API.G_EXCEPTION_ERROR;
2049: END IF;
2050: UPDATE OKC_K_ACCESSES
2051: SET CHR_ID = l_def_cac_rec.chr_id,
2052: GROUP_ID = l_def_cac_rec.group_id,
2053: RESOURCE_ID = l_def_cac_rec.resource_id,
2054: ACCESS_LEVEL = l_def_cac_rec.access_level,

Line 2123: -- update_row for:OKC_K_ACCESSES_V --

2119: );
2120:
2121: END update_row;
2122: -------------------------------------
2123: -- update_row for:OKC_K_ACCESSES_V --
2124: -------------------------------------
2125: PROCEDURE update_row(
2126: p_api_version IN NUMBER,
2127: p_init_msg_list IN VARCHAR2 ,

Line 2233: -- Set_Attributes for:OKC_K_ACCESSES_V --

2229: RETURN(l_return_status);
2230:
2231: END populate_new_record;
2232: -----------------------------------------
2233: -- Set_Attributes for:OKC_K_ACCESSES_V --
2234: -----------------------------------------
2235: FUNCTION Set_Attributes (
2236: p_cacv_rec IN cacv_rec_type,
2237: x_cacv_rec OUT NOCOPY cacv_rec_type

Line 2494: -- delete_row for:OKC_K_ACCESSES --

2490: ---------------------------------------------------------------------------
2491: -- PROCEDURE delete_row
2492: ---------------------------------------------------------------------------
2493: -----------------------------------
2494: -- delete_row for:OKC_K_ACCESSES --
2495: -----------------------------------
2496: PROCEDURE delete_row(
2497: p_init_msg_list IN VARCHAR2 ,
2498: x_return_status OUT NOCOPY VARCHAR2,

Line 2524: DELETE FROM OKC_K_ACCESSES

2520: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2521: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2522: RAISE OKC_API.G_EXCEPTION_ERROR;
2523: END IF;
2524: DELETE FROM OKC_K_ACCESSES
2525: WHERE ID = l_cac_rec.id;
2526:
2527: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2528:

Line 2586: -- delete_row for:OKC_K_ACCESSES_V --

2582: );
2583:
2584: END delete_row;
2585: -------------------------------------
2586: -- delete_row for:OKC_K_ACCESSES_V --
2587: -------------------------------------
2588: PROCEDURE delete_row(
2589: p_api_version IN NUMBER,
2590: p_init_msg_list IN VARCHAR2 ,

Line 2822: INSERT INTO okc_k_accesses_h

2818: okc_debug.Set_Indentation('OKC_CAC_PVT');
2819: okc_debug.log('10900: Entered create_version', 2);
2820: END IF;
2821:
2822: INSERT INTO okc_k_accesses_h
2823: (
2824: major_version,
2825: id,
2826: chr_id,

Line 2850: FROM okc_k_accesses

2846: creation_date,
2847: last_updated_by,
2848: last_update_date,
2849: last_update_login
2850: FROM okc_k_accesses
2851: WHERE chr_id = p_chr_id;
2852:
2853: IF (l_debug = 'Y') THEN
2854: okc_debug.log('10000: Leaving create_version', 2);

Line 2901: INSERT INTO okc_k_accesses

2897: okc_debug.Set_Indentation('OKC_CAC_PVT');
2898: okc_debug.log('11300: Entered restore_version', 2);
2899: END IF;
2900:
2901: INSERT INTO okc_k_accesses
2902: (
2903: id,
2904: chr_id,
2905: group_id,

Line 2927: FROM okc_k_accesses_h

2923: creation_date,
2924: last_updated_by,
2925: last_update_date,
2926: last_update_login
2927: FROM okc_k_accesses_h
2928: WHERE chr_id = p_chr_id
2929: AND major_version = p_major_version;
2930:
2931: IF (l_debug = 'Y') THEN