DBA Data[Home] [Help]

APPS.OKS_SLL_PVT dependencies on OKS_STREAM_LEVELS_B

Line 203: -- FUNCTION get_rec for: OKS_STREAM_LEVELS_B

199: BEGIN
200: RETURN(get_rec(p_sllv_rec, l_row_not_found));
201: END get_rec;
202: ---------------------------------------------------------------------------
203: -- FUNCTION get_rec for: OKS_STREAM_LEVELS_B
204: ---------------------------------------------------------------------------
205: FUNCTION get_rec (
206: p_sll_rec IN sll_rec_type,
207: x_no_data_found OUT NOCOPY BOOLEAN

Line 209: CURSOR oks_stream_levels_b_pk_csr (p_id IN NUMBER) IS

205: FUNCTION get_rec (
206: p_sll_rec IN sll_rec_type,
207: x_no_data_found OUT NOCOPY BOOLEAN
208: ) RETURN sll_rec_type IS
209: CURSOR oks_stream_levels_b_pk_csr (p_id IN NUMBER) IS
210: SELECT
211: ID,
212: CHR_ID,
213: CLE_ID,

Line 239: FROM Oks_Stream_Levels_B

235: LAST_UPDATE_LOGIN,
236: ORIG_SYSTEM_ID1,
237: ORIG_SYSTEM_REFERENCE1,
238: ORIG_SYSTEM_SOURCE_CODE
239: FROM Oks_Stream_Levels_B
240: WHERE oks_stream_levels_b.id = p_id;
241: l_oks_stream_levels_b_pk oks_stream_levels_b_pk_csr%ROWTYPE;
242: l_sll_rec sll_rec_type;
243: BEGIN

Line 240: WHERE oks_stream_levels_b.id = p_id;

236: ORIG_SYSTEM_ID1,
237: ORIG_SYSTEM_REFERENCE1,
238: ORIG_SYSTEM_SOURCE_CODE
239: FROM Oks_Stream_Levels_B
240: WHERE oks_stream_levels_b.id = p_id;
241: l_oks_stream_levels_b_pk oks_stream_levels_b_pk_csr%ROWTYPE;
242: l_sll_rec sll_rec_type;
243: BEGIN
244: x_no_data_found := TRUE;

Line 241: l_oks_stream_levels_b_pk oks_stream_levels_b_pk_csr%ROWTYPE;

237: ORIG_SYSTEM_REFERENCE1,
238: ORIG_SYSTEM_SOURCE_CODE
239: FROM Oks_Stream_Levels_B
240: WHERE oks_stream_levels_b.id = p_id;
241: l_oks_stream_levels_b_pk oks_stream_levels_b_pk_csr%ROWTYPE;
242: l_sll_rec sll_rec_type;
243: BEGIN
244: x_no_data_found := TRUE;
245: -- Get current database values

Line 246: OPEN oks_stream_levels_b_pk_csr (p_sll_rec.id);

242: l_sll_rec sll_rec_type;
243: BEGIN
244: x_no_data_found := TRUE;
245: -- Get current database values
246: OPEN oks_stream_levels_b_pk_csr (p_sll_rec.id);
247: FETCH oks_stream_levels_b_pk_csr INTO
248: l_sll_rec.id,
249: l_sll_rec.chr_id,
250: l_sll_rec.cle_id,

Line 247: FETCH oks_stream_levels_b_pk_csr INTO

243: BEGIN
244: x_no_data_found := TRUE;
245: -- Get current database values
246: OPEN oks_stream_levels_b_pk_csr (p_sll_rec.id);
247: FETCH oks_stream_levels_b_pk_csr INTO
248: l_sll_rec.id,
249: l_sll_rec.chr_id,
250: l_sll_rec.cle_id,
251: l_sll_rec.dnz_chr_id,

Line 276: x_no_data_found := oks_stream_levels_b_pk_csr%NOTFOUND;

272: l_sll_rec.last_update_login,
273: l_sll_rec.orig_system_id1,
274: l_sll_rec.orig_system_reference1,
275: l_sll_rec.orig_system_source_code;
276: x_no_data_found := oks_stream_levels_b_pk_csr%NOTFOUND;
277: CLOSE oks_stream_levels_b_pk_csr;
278: RETURN(l_sll_rec);
279: END get_rec;
280:

Line 277: CLOSE oks_stream_levels_b_pk_csr;

273: l_sll_rec.orig_system_id1,
274: l_sll_rec.orig_system_reference1,
275: l_sll_rec.orig_system_source_code;
276: x_no_data_found := oks_stream_levels_b_pk_csr%NOTFOUND;
277: CLOSE oks_stream_levels_b_pk_csr;
278: RETURN(l_sll_rec);
279: END get_rec;
280:
281: ------------------------------------------------------------------

Line 881: -- insert_row for:OKS_STREAM_LEVELS_B --

877: ---------------------------------------------------------------------------
878: -- PROCEDURE insert_row
879: ---------------------------------------------------------------------------
880: ----------------------------------------
881: -- insert_row for:OKS_STREAM_LEVELS_B --
882: ----------------------------------------
883: PROCEDURE insert_row(
884: p_init_msg_list IN VARCHAR2,
885: x_return_status OUT NOCOPY VARCHAR2,

Line 897: -- Set_Attributes for:OKS_STREAM_LEVELS_B --

893: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
894: l_sll_rec sll_rec_type := p_sll_rec;
895: l_def_sll_rec sll_rec_type;
896: --------------------------------------------
897: -- Set_Attributes for:OKS_STREAM_LEVELS_B --
898: --------------------------------------------
899: FUNCTION Set_Attributes (
900: p_sll_rec IN sll_rec_type,
901: x_sll_rec OUT NOCOPY sll_rec_type

Line 928: INSERT INTO OKS_STREAM_LEVELS_B(

924: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
925: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
926: RAISE OKC_API.G_EXCEPTION_ERROR;
927: END IF;
928: INSERT INTO OKS_STREAM_LEVELS_B(
929: id,
930: chr_id,
931: cle_id,
932: dnz_chr_id,

Line 1335: -- lock_row for:OKS_STREAM_LEVELS_B --

1331: ---------------------------------------------------------------------------
1332: -- PROCEDURE lock_row
1333: ---------------------------------------------------------------------------
1334: --------------------------------------
1335: -- lock_row for:OKS_STREAM_LEVELS_B --
1336: --------------------------------------
1337: PROCEDURE lock_row(
1338: p_init_msg_list IN VARCHAR2,
1339: x_return_status OUT NOCOPY VARCHAR2,

Line 1348: FROM OKS_STREAM_LEVELS_B

1344: E_Resource_Busy EXCEPTION;
1345: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1346: CURSOR lock_csr (p_sll_rec IN sll_rec_type) IS
1347: SELECT OBJECT_VERSION_NUMBER
1348: FROM OKS_STREAM_LEVELS_B
1349: WHERE ID = p_sll_rec.id
1350: AND OBJECT_VERSION_NUMBER = p_sll_rec.object_version_number
1351: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1352:

Line 1355: FROM OKS_STREAM_LEVELS_B

1351: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1352:
1353: CURSOR lchk_csr (p_sll_rec IN sll_rec_type) IS
1354: SELECT OBJECT_VERSION_NUMBER
1355: FROM OKS_STREAM_LEVELS_B
1356: WHERE ID = p_sll_rec.id;
1357: l_api_version CONSTANT NUMBER := 1;
1358: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1359: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1360: l_object_version_number OKS_STREAM_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE;

1356: WHERE ID = p_sll_rec.id;
1357: l_api_version CONSTANT NUMBER := 1;
1358: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1359: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1360: l_object_version_number OKS_STREAM_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE;
1361: lc_object_version_number OKS_STREAM_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE;
1362: l_row_notfound BOOLEAN := FALSE;
1363: lc_row_notfound BOOLEAN := FALSE;
1364: BEGIN

Line 1361: lc_object_version_number OKS_STREAM_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE;

1357: l_api_version CONSTANT NUMBER := 1;
1358: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1359: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1360: l_object_version_number OKS_STREAM_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE;
1361: lc_object_version_number OKS_STREAM_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE;
1362: l_row_notfound BOOLEAN := FALSE;
1363: lc_row_notfound BOOLEAN := FALSE;
1364: BEGIN
1365: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1682: -- update_row for:OKS_STREAM_LEVELS_B --

1678: ---------------------------------------------------------------------------
1679: -- PROCEDURE update_row
1680: ---------------------------------------------------------------------------
1681: ----------------------------------------
1682: -- update_row for:OKS_STREAM_LEVELS_B --
1683: ----------------------------------------
1684: PROCEDURE update_row(
1685: p_init_msg_list IN VARCHAR2,
1686: x_return_status OUT NOCOPY VARCHAR2,

Line 1829: -- Set_Attributes for:OKS_STREAM_LEVELS_B --

1825: END IF;
1826: RETURN(l_return_status);
1827: END populate_new_record;
1828: --------------------------------------------
1829: -- Set_Attributes for:OKS_STREAM_LEVELS_B --
1830: --------------------------------------------
1831: FUNCTION Set_Attributes (
1832: p_sll_rec IN sll_rec_type,
1833: x_sll_rec OUT NOCOPY sll_rec_type

Line 1867: UPDATE OKS_STREAM_LEVELS_B

1863: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1864: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1865: RAISE OKC_API.G_EXCEPTION_ERROR;
1866: END IF;
1867: UPDATE OKS_STREAM_LEVELS_B
1868: SET CHR_ID = l_def_sll_rec.chr_id,
1869: CLE_ID = l_def_sll_rec.cle_id,
1870: DNZ_CHR_ID = l_def_sll_rec.dnz_chr_id,
1871: SEQUENCE_NO = l_def_sll_rec.sequence_no,

Line 2391: -- delete_row for:OKS_STREAM_LEVELS_B --

2387: ---------------------------------------------------------------------------
2388: -- PROCEDURE delete_row
2389: ---------------------------------------------------------------------------
2390: ----------------------------------------
2391: -- delete_row for:OKS_STREAM_LEVELS_B --
2392: ----------------------------------------
2393: PROCEDURE delete_row(
2394: p_init_msg_list IN VARCHAR2,
2395: x_return_status OUT NOCOPY VARCHAR2,

Line 2416: DELETE FROM OKS_STREAM_LEVELS_B

2412: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2413: RAISE OKC_API.G_EXCEPTION_ERROR;
2414: END IF;
2415:
2416: DELETE FROM OKS_STREAM_LEVELS_B
2417: WHERE ID = p_sll_rec.id;
2418:
2419: x_return_status := l_return_status;
2420: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);