DBA Data[Home] [Help]

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 1307: -- insert_row for:OKC_K_HISTORY_B --

1303: ---------------------------------------------------------------------------
1304: -- PROCEDURE insert_row
1305: ---------------------------------------------------------------------------
1306: ------------------------------------
1307: -- insert_row for:OKC_K_HISTORY_B --
1308: ------------------------------------
1309: PROCEDURE insert_row(
1310: p_init_msg_list IN VARCHAR2 ,
1311: x_return_status OUT NOCOPY VARCHAR2,

Line 1323: -- Set_Attributes for:OKC_K_HISTORY_B --

1319: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1320: l_hst_rec hst_rec_type := p_hst_rec;
1321: l_def_hst_rec hst_rec_type;
1322: ----------------------------------------
1323: -- Set_Attributes for:OKC_K_HISTORY_B --
1324: ----------------------------------------
1325: FUNCTION Set_Attributes (
1326: p_hst_rec IN hst_rec_type,
1327: x_hst_rec OUT NOCOPY hst_rec_type

Line 1354: INSERT INTO OKC_K_HISTORY_B(

1350: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1351: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1352: RAISE OKC_API.G_EXCEPTION_ERROR;
1353: END IF;
1354: INSERT INTO OKC_K_HISTORY_B(
1355: id,
1356: chr_id,
1357: cle_id,
1358: contract_version,

Line 1912: -- lock_row for:OKC_K_HISTORY_B --

1908: ---------------------------------------------------------------------------
1909: -- PROCEDURE lock_row
1910: ---------------------------------------------------------------------------
1911: ----------------------------------
1912: -- lock_row for:OKC_K_HISTORY_B --
1913: ----------------------------------
1914: PROCEDURE lock_row(
1915: p_init_msg_list IN VARCHAR2 ,
1916: x_return_status OUT NOCOPY VARCHAR2,

Line 1925: FROM OKC_K_HISTORY_B

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

Line 1932: FROM OKC_K_HISTORY_B

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

Line 1937: l_object_version_number OKC_K_HISTORY_B.OBJECT_VERSION_NUMBER%TYPE;

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

Line 1938: lc_object_version_number OKC_K_HISTORY_B.OBJECT_VERSION_NUMBER%TYPE;

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

Line 2359: -- update_row for:OKC_K_HISTORY_B --

2355: ---------------------------------------------------------------------------
2356: -- PROCEDURE update_row
2357: ---------------------------------------------------------------------------
2358: ------------------------------------
2359: -- update_row for:OKC_K_HISTORY_B --
2360: ------------------------------------
2361: PROCEDURE update_row(
2362: p_init_msg_list IN VARCHAR2 ,
2363: x_return_status OUT NOCOPY VARCHAR2,

Line 2474: -- Set_Attributes for:OKC_K_HISTORY_B --

2470: END IF;
2471: RETURN(l_return_status);
2472: END populate_new_record;
2473: ----------------------------------------
2474: -- Set_Attributes for:OKC_K_HISTORY_B --
2475: ----------------------------------------
2476: FUNCTION Set_Attributes (
2477: p_hst_rec IN hst_rec_type,
2478: x_hst_rec OUT NOCOPY hst_rec_type

Line 2512: UPDATE OKC_K_HISTORY_B

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

Line 3174: -- delete_row for:OKC_K_HISTORY_B --

3170: ---------------------------------------------------------------------------
3171: -- PROCEDURE delete_row
3172: ---------------------------------------------------------------------------
3173: ------------------------------------
3174: -- delete_row for:OKC_K_HISTORY_B --
3175: ------------------------------------
3176: PROCEDURE delete_row(
3177: p_init_msg_list IN VARCHAR2 ,
3178: x_return_status OUT NOCOPY VARCHAR2,

Line 3199: DELETE FROM OKC_K_HISTORY_B

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

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

3554: -- PROCEDURE delete_all_rows
3555: ---------------------------------------------------------------------------
3556:
3557: --------------------------------------------------------------
3558: -- delete_all_rows for:OKC_K_HISTORY_TL and OKC_K_HISTORY_B --
3559: --------------------------------------------------------------
3560: PROCEDURE delete_all_rows(
3561: p_init_msg_list IN VARCHAR2 ,
3562: x_return_status OUT NOCOPY VARCHAR2,

Line 3585: FROM OKC_K_HISTORY_B

3581: END IF;
3582:
3583: DELETE FROM OKC_K_HISTORY_TL
3584: WHERE ID IN (SELECT ID
3585: FROM OKC_K_HISTORY_B
3586: WHERE CHR_ID = p_chr_id);
3587:
3588: DELETE FROM OKC_K_HISTORY_B
3589: WHERE CHR_ID = p_chr_id;

Line 3588: DELETE FROM OKC_K_HISTORY_B

3584: WHERE ID IN (SELECT ID
3585: FROM OKC_K_HISTORY_B
3586: WHERE CHR_ID = p_chr_id);
3587:
3588: DELETE FROM OKC_K_HISTORY_B
3589: WHERE CHR_ID = p_chr_id;
3590:
3591: x_return_status := l_return_status;
3592: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);