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_CIM_PVT dependencies on OKC_K_ITEMS

Line 53: -- FUNCTION get_rec for: OKC_K_ITEMS

49:
50: END api_copy;
51:
52: ---------------------------------------------------------------------------
53: -- FUNCTION get_rec for: OKC_K_ITEMS
54: ---------------------------------------------------------------------------
55: FUNCTION get_rec (
56: p_cim_rec IN cim_rec_type,
57: x_no_data_found OUT NOCOPY BOOLEAN

Line 85: FROM Okc_K_Items

81: REQUEST_ID,
82: PROGRAM_APPLICATION_ID,
83: PROGRAM_ID,
84: PROGRAM_UPDATE_DATE
85: FROM Okc_K_Items
86: WHERE okc_k_items.id = p_id;
87: l_cim_pk cim_pk_csr%ROWTYPE;
88: l_cim_rec cim_rec_type;
89: BEGIN

Line 86: WHERE okc_k_items.id = p_id;

82: PROGRAM_APPLICATION_ID,
83: PROGRAM_ID,
84: PROGRAM_UPDATE_DATE
85: FROM Okc_K_Items
86: WHERE okc_k_items.id = p_id;
87: l_cim_pk cim_pk_csr%ROWTYPE;
88: l_cim_rec cim_rec_type;
89: BEGIN
90:

Line 146: -- FUNCTION get_rec for: OKC_K_ITEMS_V

142: RETURN(get_rec(p_cim_rec, l_row_notfound));
143:
144: END get_rec;
145: ---------------------------------------------------------------------------
146: -- FUNCTION get_rec for: OKC_K_ITEMS_V
147: ---------------------------------------------------------------------------
148: FUNCTION get_rec (
149: p_cimv_rec IN cimv_rec_type,
150: x_no_data_found OUT NOCOPY BOOLEAN

Line 178: FROM Okc_K_Items_V

174: REQUEST_ID,
175: PROGRAM_APPLICATION_ID,
176: PROGRAM_ID,
177: PROGRAM_UPDATE_DATE
178: FROM Okc_K_Items_V
179: WHERE okc_k_items_v.id = p_id;
180: l_okc_cimv_pk okc_cimv_pk_csr%ROWTYPE;
181: l_cimv_rec cimv_rec_type;
182: BEGIN

Line 179: WHERE okc_k_items_v.id = p_id;

175: PROGRAM_APPLICATION_ID,
176: PROGRAM_ID,
177: PROGRAM_UPDATE_DATE
178: FROM Okc_K_Items_V
179: WHERE okc_k_items_v.id = p_id;
180: l_okc_cimv_pk okc_cimv_pk_csr%ROWTYPE;
181: l_cimv_rec cimv_rec_type;
182: BEGIN
183:

Line 241: -- FUNCTION null_out_defaults for: OKC_K_ITEMS_V --

237:
238: END get_rec;
239:
240: ---------------------------------------------------
241: -- FUNCTION null_out_defaults for: OKC_K_ITEMS_V --
242: ---------------------------------------------------
243: FUNCTION null_out_defaults (
244: p_cimv_rec IN cimv_rec_type
245: ) RETURN cimv_rec_type IS

Line 923: -- Validate_Attributes for:OKC_K_ITEMS_V --

919: end validate_dnz_chr_id;
920:
921: /*+++++++++++++End of hand code +++++++++++++++++++*/
922: -------------------------------------------
923: -- Validate_Attributes for:OKC_K_ITEMS_V --
924: -------------------------------------------
925: FUNCTION Validate_Attributes (
926: p_cimv_rec IN cimv_rec_type
927: ) RETURN VARCHAR2 IS

Line 1072: -- Validate_Record for:OKC_K_ITEMS_V --

1068: ---------------------------------------------------------------------------
1069: -- PROCEDURE Validate_Record
1070: ---------------------------------------------------------------------------
1071: ---------------------------------------
1072: -- Validate_Record for:OKC_K_ITEMS_V --
1073: ---------------------------------------
1074: FUNCTION Validate_Record (
1075: p_cimv_rec IN cimv_rec_type
1076: ) RETURN VARCHAR2 IS

Line 1252: -- validate_row for:OKC_K_ITEMS_V --

1248: ---------------------------------------------------------------------------
1249: -- PROCEDURE validate_row
1250: ---------------------------------------------------------------------------
1251: ------------------------------------
1252: -- validate_row for:OKC_K_ITEMS_V --
1253: ------------------------------------
1254: PROCEDURE validate_row(
1255: p_api_version IN NUMBER,
1256: p_init_msg_list IN VARCHAR2 ,

Line 1458: -- insert_row for:OKC_K_ITEMS --

1454: ---------------------------------------------------------------------------
1455: -- PROCEDURE insert_row
1456: ---------------------------------------------------------------------------
1457: --------------------------------
1458: -- insert_row for:OKC_K_ITEMS --
1459: --------------------------------
1460: PROCEDURE insert_row(
1461: p_init_msg_list IN VARCHAR2 ,
1462: x_return_status OUT NOCOPY VARCHAR2,

Line 1474: -- Set_Attributes for:OKC_K_ITEMS --

1470: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1471: l_cim_rec cim_rec_type := p_cim_rec;
1472: l_def_cim_rec cim_rec_type;
1473: ------------------------------------
1474: -- Set_Attributes for:OKC_K_ITEMS --
1475: ------------------------------------
1476: FUNCTION Set_Attributes (
1477: p_cim_rec IN cim_rec_type,
1478: x_cim_rec OUT NOCOPY cim_rec_type

Line 1514: INSERT INTO OKC_K_ITEMS(

1510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_ERROR;
1513: END IF;
1514: INSERT INTO OKC_K_ITEMS(
1515: id,
1516: cle_id,
1517: chr_id,
1518: cle_id_for,

Line 1626: -- insert_row for:OKC_K_ITEMS_V --

1622: );
1623:
1624: END insert_row;
1625: ----------------------------------
1626: -- insert_row for:OKC_K_ITEMS_V --
1627: ----------------------------------
1628: PROCEDURE insert_row(
1629: p_api_version IN NUMBER,
1630: p_init_msg_list IN VARCHAR2 ,

Line 1663: -- Set_Attributes for:OKC_K_ITEMS_V --

1659: RETURN(l_cimv_rec);
1660:
1661: END fill_who_columns;
1662: --------------------------------------
1663: -- Set_Attributes for:OKC_K_ITEMS_V --
1664: --------------------------------------
1665: FUNCTION Set_Attributes (
1666: p_cimv_rec IN cimv_rec_type,
1667: x_cimv_rec OUT NOCOPY cimv_rec_type

Line 1907: -- lock_row for:OKC_K_ITEMS --

1903: ---------------------------------------------------------------------------
1904: -- PROCEDURE lock_row
1905: ---------------------------------------------------------------------------
1906: ------------------------------
1907: -- lock_row for:OKC_K_ITEMS --
1908: ------------------------------
1909: PROCEDURE lock_row(
1910: p_init_msg_list IN VARCHAR2 ,
1911: x_return_status OUT NOCOPY VARCHAR2,

Line 1920: FROM OKC_K_ITEMS

1916: E_Resource_Busy EXCEPTION;
1917: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1918: CURSOR lock_csr (p_cim_rec IN cim_rec_type) IS
1919: SELECT OBJECT_VERSION_NUMBER
1920: FROM OKC_K_ITEMS
1921: WHERE ID = p_cim_rec.id
1922: AND OBJECT_VERSION_NUMBER = p_cim_rec.object_version_number
1923: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1924:

Line 1927: FROM OKC_K_ITEMS

1923: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1924:
1925: CURSOR lchk_csr (p_cim_rec IN cim_rec_type) IS
1926: SELECT OBJECT_VERSION_NUMBER
1927: FROM OKC_K_ITEMS
1928: WHERE ID = p_cim_rec.id;
1929: l_api_version CONSTANT NUMBER := 1;
1930: l_api_name CONSTANT VARCHAR2(30) := 'ITEMS_lock_row';
1931: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1932: l_object_version_number OKC_K_ITEMS.OBJECT_VERSION_NUMBER%TYPE;

1928: WHERE ID = p_cim_rec.id;
1929: l_api_version CONSTANT NUMBER := 1;
1930: l_api_name CONSTANT VARCHAR2(30) := 'ITEMS_lock_row';
1931: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1932: l_object_version_number OKC_K_ITEMS.OBJECT_VERSION_NUMBER%TYPE;
1933: lc_object_version_number OKC_K_ITEMS.OBJECT_VERSION_NUMBER%TYPE;
1934: l_row_notfound BOOLEAN := FALSE;
1935: lc_row_notfound BOOLEAN := FALSE;
1936: BEGIN

Line 1933: lc_object_version_number OKC_K_ITEMS.OBJECT_VERSION_NUMBER%TYPE;

1929: l_api_version CONSTANT NUMBER := 1;
1930: l_api_name CONSTANT VARCHAR2(30) := 'ITEMS_lock_row';
1931: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1932: l_object_version_number OKC_K_ITEMS.OBJECT_VERSION_NUMBER%TYPE;
1933: lc_object_version_number OKC_K_ITEMS.OBJECT_VERSION_NUMBER%TYPE;
1934: l_row_notfound BOOLEAN := FALSE;
1935: lc_row_notfound BOOLEAN := FALSE;
1936: BEGIN
1937:

Line 2062: -- lock_row for:OKC_K_ITEMS_V --

2058: );
2059:
2060: END lock_row;
2061: --------------------------------
2062: -- lock_row for:OKC_K_ITEMS_V --
2063: --------------------------------
2064: PROCEDURE lock_row(
2065: p_api_version IN NUMBER,
2066: p_init_msg_list IN VARCHAR2 ,

Line 2272: -- update_row for:OKC_K_ITEMS --

2268: ---------------------------------------------------------------------------
2269: -- PROCEDURE update_row
2270: ---------------------------------------------------------------------------
2271: --------------------------------
2272: -- update_row for:OKC_K_ITEMS --
2273: --------------------------------
2274: PROCEDURE update_row(
2275: p_init_msg_list IN VARCHAR2 ,
2276: x_return_status OUT NOCOPY VARCHAR2,

Line 2417: -- Set_Attributes for:OKC_K_ITEMS --

2413:
2414: RETURN(l_return_status);
2415: END populate_new_record;
2416: ------------------------------------
2417: -- Set_Attributes for:OKC_K_ITEMS --
2418: ------------------------------------
2419: FUNCTION Set_Attributes (
2420: p_cim_rec IN cim_rec_type,
2421: x_cim_rec OUT NOCOPY cim_rec_type

Line 2462: UPDATE OKC_K_ITEMS

2458: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2460: RAISE OKC_API.G_EXCEPTION_ERROR;
2461: END IF;
2462: UPDATE OKC_K_ITEMS
2463: SET CLE_ID = l_def_cim_rec.cle_id,
2464: CHR_ID = l_def_cim_rec.chr_id,
2465: CLE_ID_FOR = l_def_cim_rec.cle_id_for,
2466: DNZ_CHR_ID = l_def_cim_rec.dnz_chr_id,

Line 2548: -- update_row for:OKC_K_ITEMS_V --

2544: );
2545:
2546: END update_row;
2547: ----------------------------------
2548: -- update_row for:OKC_K_ITEMS_V --
2549: ----------------------------------
2550: PROCEDURE update_row(
2551: p_api_version IN NUMBER,
2552: p_init_msg_list IN VARCHAR2 ,

Line 2714: -- Set_Attributes for:OKC_K_ITEMS_V --

2710: RETURN(l_return_status);
2711:
2712: END populate_new_record;
2713: --------------------------------------
2714: -- Set_Attributes for:OKC_K_ITEMS_V --
2715: --------------------------------------
2716: FUNCTION Set_Attributes (
2717: p_cimv_rec IN cimv_rec_type,
2718: x_cimv_rec OUT NOCOPY cimv_rec_type

Line 2961: -- delete_row for:OKC_K_ITEMS --

2957: ---------------------------------------------------------------------------
2958: -- PROCEDURE delete_row
2959: ---------------------------------------------------------------------------
2960: --------------------------------
2961: -- delete_row for:OKC_K_ITEMS --
2962: --------------------------------
2963: PROCEDURE delete_row(
2964: p_init_msg_list IN VARCHAR2 ,
2965: x_return_status OUT NOCOPY VARCHAR2,

Line 2991: DELETE FROM OKC_K_ITEMS

2987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2989: RAISE OKC_API.G_EXCEPTION_ERROR;
2990: END IF;
2991: DELETE FROM OKC_K_ITEMS
2992: WHERE ID = l_cim_rec.id;
2993:
2994: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2995:

Line 3053: -- delete_row for:OKC_K_ITEMS_V --

3049: );
3050:
3051: END delete_row;
3052: ----------------------------------
3053: -- delete_row for:OKC_K_ITEMS_V --
3054: ----------------------------------
3055: PROCEDURE delete_row(
3056: p_api_version IN NUMBER,
3057: p_init_msg_list IN VARCHAR2 ,

Line 3261: -- Procedure for mass insert in OKC_K_ITEMS table

3257:
3258: END delete_row;
3259:
3260: ---------------------------------------------------------------
3261: -- Procedure for mass insert in OKC_K_ITEMS table
3262: ---------------------------------------------------------------
3263: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_cimv_tbl cimv_tbl_type) IS
3264: l_tabsize NUMBER := p_cimv_tbl.COUNT;
3265: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

Line 3354: INTO OKC_K_ITEMS

3350: END LOOP;
3351:
3352: FORALL i in 1..l_tabsize
3353: INSERT
3354: INTO OKC_K_ITEMS
3355: (
3356: id,
3357: cle_id,
3358: chr_id,

Line 3453: INSERT INTO okc_k_items_h

3449: okc_debug.Set_Indentation('OKC_CIM_PVT');
3450: okc_debug.log('12800: Entered create_version', 2);
3451: END IF;
3452:
3453: INSERT INTO okc_k_items_h
3454: (
3455: major_version,
3456: id,
3457: cle_id,

Line 3503: FROM okc_k_items

3499: request_id,
3500: program_id,
3501: Program_application_id,
3502: program_update_date
3503: FROM okc_k_items
3504: WHERE dnz_chr_id = p_chr_id;
3505:
3506:
3507: IF (l_debug = 'Y') THEN

Line 3555: INSERT INTO okc_k_items

3551: okc_debug.Set_Indentation('OKC_CIM_PVT');
3552: okc_debug.log('13100: Entered restore_version', 2);
3553: END IF;
3554:
3555: INSERT INTO okc_k_items
3556: (
3557: id,
3558: cle_id,
3559: chr_id,

Line 3603: FROM okc_k_items_h

3599: request_id,
3600: program_id,
3601: Program_application_id,
3602: program_update_date
3603: FROM okc_k_items_h
3604: WHERE dnz_chr_id = p_chr_id
3605: AND major_version = p_major_version;
3606:
3607: IF (l_debug = 'Y') THEN