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_HST_PVT dependencies on OKC_K_HISTORY_B

Line 106: FROM OKC_K_HISTORY_B B

102: /*
103: DELETE FROM OKC_K_HISTORY_TL T
104: WHERE NOT EXISTS (
105: SELECT NULL
106: FROM OKC_K_HISTORY_B B
107: WHERE B.ID =T.ID
108: );
109:
110: UPDATE OKC_K_HISTORY_TL T SET(

Line 254: -- FUNCTION get_rec for: OKC_K_HISTORY_B

250: BEGIN
251: RETURN(get_rec(p_hstv_rec, l_row_not_found));
252: END get_rec;
253: ---------------------------------------------------------------------------
254: -- FUNCTION get_rec for: OKC_K_HISTORY_B
255: ---------------------------------------------------------------------------
256: FUNCTION get_rec (
257: p_hst_rec IN hst_rec_type,
258: x_no_data_found OUT NOCOPY BOOLEAN

Line 282: FROM Okc_K_History_B

278: PROGRAM_APPLICATION_ID,
279: PROGRAM_ID,
280: PROGRAM_UPDATE_DATE,
281: REQUEST_ID
282: FROM Okc_K_History_B
283: WHERE okc_k_history_b.id = p_id;
284: l_okc_k_history_pk okc_k_history_pk_csr%ROWTYPE;
285: l_hst_rec hst_rec_type;
286: BEGIN

Line 283: WHERE okc_k_history_b.id = p_id;

279: PROGRAM_ID,
280: PROGRAM_UPDATE_DATE,
281: REQUEST_ID
282: FROM Okc_K_History_B
283: WHERE okc_k_history_b.id = p_id;
284: l_okc_k_history_pk okc_k_history_pk_csr%ROWTYPE;
285: l_hst_rec hst_rec_type;
286: BEGIN
287: x_no_data_found := TRUE;

Line 1311: -- insert_row for:OKC_K_HISTORY_B --

1307: ---------------------------------------------------------------------------
1308: -- PROCEDURE insert_row
1309: ---------------------------------------------------------------------------
1310: ------------------------------------
1311: -- insert_row for:OKC_K_HISTORY_B --
1312: ------------------------------------
1313: PROCEDURE insert_row(
1314: p_init_msg_list IN VARCHAR2 ,
1315: x_return_status OUT NOCOPY VARCHAR2,

Line 1327: -- Set_Attributes for:OKC_K_HISTORY_B --

1323: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1324: l_hst_rec hst_rec_type := p_hst_rec;
1325: l_def_hst_rec hst_rec_type;
1326: ----------------------------------------
1327: -- Set_Attributes for:OKC_K_HISTORY_B --
1328: ----------------------------------------
1329: FUNCTION Set_Attributes (
1330: p_hst_rec IN hst_rec_type,
1331: x_hst_rec OUT NOCOPY hst_rec_type

Line 1358: INSERT INTO OKC_K_HISTORY_B(

1354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1355: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1356: RAISE OKC_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: INSERT INTO OKC_K_HISTORY_B(
1359: id,
1360: chr_id,
1361: cle_id,
1362: contract_version,

Line 1916: -- lock_row for:OKC_K_HISTORY_B --

1912: ---------------------------------------------------------------------------
1913: -- PROCEDURE lock_row
1914: ---------------------------------------------------------------------------
1915: ----------------------------------
1916: -- lock_row for:OKC_K_HISTORY_B --
1917: ----------------------------------
1918: PROCEDURE lock_row(
1919: p_init_msg_list IN VARCHAR2 ,
1920: x_return_status OUT NOCOPY VARCHAR2,

Line 1929: FROM OKC_K_HISTORY_B

1925: E_Resource_Busy EXCEPTION;
1926: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1927: CURSOR lock_csr (p_hst_rec IN hst_rec_type) IS
1928: SELECT OBJECT_VERSION_NUMBER
1929: FROM OKC_K_HISTORY_B
1930: WHERE ID = p_hst_rec.id
1931: AND OBJECT_VERSION_NUMBER = p_hst_rec.object_version_number
1932: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1933:

Line 1936: FROM OKC_K_HISTORY_B

1932: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1933:
1934: CURSOR lchk_csr (p_hst_rec IN hst_rec_type) IS
1935: SELECT OBJECT_VERSION_NUMBER
1936: FROM OKC_K_HISTORY_B
1937: WHERE ID = p_hst_rec.id;
1938: l_api_version CONSTANT NUMBER := 1;
1939: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1940: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1941: l_object_version_number OKC_K_HISTORY_B.OBJECT_VERSION_NUMBER%TYPE;

1937: WHERE ID = p_hst_rec.id;
1938: l_api_version CONSTANT NUMBER := 1;
1939: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1940: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1941: l_object_version_number OKC_K_HISTORY_B.OBJECT_VERSION_NUMBER%TYPE;
1942: lc_object_version_number OKC_K_HISTORY_B.OBJECT_VERSION_NUMBER%TYPE;
1943: l_row_notfound BOOLEAN := FALSE;
1944: lc_row_notfound BOOLEAN := FALSE;
1945: BEGIN

Line 1942: lc_object_version_number OKC_K_HISTORY_B.OBJECT_VERSION_NUMBER%TYPE;

1938: l_api_version CONSTANT NUMBER := 1;
1939: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1940: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1941: l_object_version_number OKC_K_HISTORY_B.OBJECT_VERSION_NUMBER%TYPE;
1942: lc_object_version_number OKC_K_HISTORY_B.OBJECT_VERSION_NUMBER%TYPE;
1943: l_row_notfound BOOLEAN := FALSE;
1944: lc_row_notfound BOOLEAN := FALSE;
1945: BEGIN
1946: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2363: -- update_row for:OKC_K_HISTORY_B --

2359: ---------------------------------------------------------------------------
2360: -- PROCEDURE update_row
2361: ---------------------------------------------------------------------------
2362: ------------------------------------
2363: -- update_row for:OKC_K_HISTORY_B --
2364: ------------------------------------
2365: PROCEDURE update_row(
2366: p_init_msg_list IN VARCHAR2 ,
2367: x_return_status OUT NOCOPY VARCHAR2,

Line 2478: -- Set_Attributes for:OKC_K_HISTORY_B --

2474: END IF;
2475: RETURN(l_return_status);
2476: END populate_new_record;
2477: ----------------------------------------
2478: -- Set_Attributes for:OKC_K_HISTORY_B --
2479: ----------------------------------------
2480: FUNCTION Set_Attributes (
2481: p_hst_rec IN hst_rec_type,
2482: x_hst_rec OUT NOCOPY hst_rec_type

Line 2516: UPDATE OKC_K_HISTORY_B

2512: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2513: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2514: RAISE OKC_API.G_EXCEPTION_ERROR;
2515: END IF;
2516: UPDATE OKC_K_HISTORY_B
2517: SET CHR_ID = l_def_hst_rec.chr_id,
2518: CLE_ID = l_def_hst_rec.cle_id,
2519: CONTRACT_VERSION = l_def_hst_rec.contract_version,
2520: STS_CODE_FROM = l_def_hst_rec.sts_code_from,

Line 3178: -- delete_row for:OKC_K_HISTORY_B --

3174: ---------------------------------------------------------------------------
3175: -- PROCEDURE delete_row
3176: ---------------------------------------------------------------------------
3177: ------------------------------------
3178: -- delete_row for:OKC_K_HISTORY_B --
3179: ------------------------------------
3180: PROCEDURE delete_row(
3181: p_init_msg_list IN VARCHAR2 ,
3182: x_return_status OUT NOCOPY VARCHAR2,

Line 3203: DELETE FROM OKC_K_HISTORY_B

3199: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3200: RAISE OKC_API.G_EXCEPTION_ERROR;
3201: END IF;
3202:
3203: DELETE FROM OKC_K_HISTORY_B
3204: WHERE ID = p_hst_rec.id;
3205:
3206: x_return_status := l_return_status;
3207: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3562: -- delete_all_rows for:OKC_K_HISTORY_TL and OKC_K_HISTORY_B --

3558: -- PROCEDURE delete_all_rows
3559: ---------------------------------------------------------------------------
3560:
3561: --------------------------------------------------------------
3562: -- delete_all_rows for:OKC_K_HISTORY_TL and OKC_K_HISTORY_B --
3563: --------------------------------------------------------------
3564: PROCEDURE delete_all_rows(
3565: p_init_msg_list IN VARCHAR2 ,
3566: x_return_status OUT NOCOPY VARCHAR2,

Line 3589: FROM OKC_K_HISTORY_B

3585: END IF;
3586:
3587: DELETE FROM OKC_K_HISTORY_TL
3588: WHERE ID IN (SELECT ID
3589: FROM OKC_K_HISTORY_B
3590: WHERE CHR_ID = p_chr_id);
3591:
3592: DELETE FROM OKC_K_HISTORY_B
3593: WHERE CHR_ID = p_chr_id;

Line 3592: DELETE FROM OKC_K_HISTORY_B

3588: WHERE ID IN (SELECT ID
3589: FROM OKC_K_HISTORY_B
3590: WHERE CHR_ID = p_chr_id);
3591:
3592: DELETE FROM OKC_K_HISTORY_B
3593: WHERE CHR_ID = p_chr_id;
3594:
3595: x_return_status := l_return_status;
3596: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);