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.OKS_PML_PVT dependencies on OKS_PM_STREAM_LEVELS

Line 95: -- FUNCTION get_rec for: OKS_PM_STREAM_LEVELS_V

91: null;
92: END api_copy;
93:
94: ---------------------------------------------------------------------------
95: -- FUNCTION get_rec for: OKS_PM_STREAM_LEVELS_V
96: ---------------------------------------------------------------------------
97: FUNCTION get_rec (
98: p_pmlv_rec IN pmlv_rec_type,
99: x_no_data_found OUT NOCOPY BOOLEAN

Line 132: FROM Oks_Pm_Stream_Levels_V

128: ORIG_SYSTEM_ID1 ,
129: ORIG_SYSTEM_REFERENCE1,
130: ORIG_SYSTEM_SOURCE_CODE
131: -- R12 Data Model Changes 4485150 End
132: FROM Oks_Pm_Stream_Levels_V
133: WHERE oks_pm_stream_levels_v.id = p_id;
134: l_oks_pmlv_pk oks_pmlv_pk_csr%ROWTYPE;
135: l_pmlv_rec pmlv_rec_type;
136: BEGIN

Line 133: WHERE oks_pm_stream_levels_v.id = p_id;

129: ORIG_SYSTEM_REFERENCE1,
130: ORIG_SYSTEM_SOURCE_CODE
131: -- R12 Data Model Changes 4485150 End
132: FROM Oks_Pm_Stream_Levels_V
133: WHERE oks_pm_stream_levels_v.id = p_id;
134: l_oks_pmlv_pk oks_pmlv_pk_csr%ROWTYPE;
135: l_pmlv_rec pmlv_rec_type;
136: BEGIN
137: x_no_data_found := TRUE;

Line 205: -- FUNCTION get_rec for: OKS_PM_STREAM_LEVELS

201: BEGIN
202: RETURN(get_rec(p_pmlv_rec, l_row_not_found));
203: END get_rec;
204: ---------------------------------------------------------------------------
205: -- FUNCTION get_rec for: OKS_PM_STREAM_LEVELS
206: ---------------------------------------------------------------------------
207: FUNCTION get_rec (
208: p_pml_rec IN pml_rec_type,
209: x_no_data_found OUT NOCOPY BOOLEAN

Line 211: CURSOR oks_pm_stream_levels_pk_csr (p_id IN NUMBER) IS

207: FUNCTION get_rec (
208: p_pml_rec IN pml_rec_type,
209: x_no_data_found OUT NOCOPY BOOLEAN
210: ) RETURN pml_rec_type IS
211: CURSOR oks_pm_stream_levels_pk_csr (p_id IN NUMBER) IS
212: SELECT
213: ID,
214: CLE_ID,
215: DNZ_CHR_ID,

Line 241: FROM Oks_Pm_Stream_Levels

237: ORIG_SYSTEM_ID1 ,
238: ORIG_SYSTEM_REFERENCE1,
239: ORIG_SYSTEM_SOURCE_CODE
240: -- R12 Data Model Changes 4485150 End
241: FROM Oks_Pm_Stream_Levels
242: WHERE oks_pm_stream_levels.id = p_id;
243: l_oks_pm_stream_levels_pk oks_pm_stream_levels_pk_csr%ROWTYPE;
244: l_pml_rec pml_rec_type;
245: BEGIN

Line 242: WHERE oks_pm_stream_levels.id = p_id;

238: ORIG_SYSTEM_REFERENCE1,
239: ORIG_SYSTEM_SOURCE_CODE
240: -- R12 Data Model Changes 4485150 End
241: FROM Oks_Pm_Stream_Levels
242: WHERE oks_pm_stream_levels.id = p_id;
243: l_oks_pm_stream_levels_pk oks_pm_stream_levels_pk_csr%ROWTYPE;
244: l_pml_rec pml_rec_type;
245: BEGIN
246: x_no_data_found := TRUE;

Line 243: l_oks_pm_stream_levels_pk oks_pm_stream_levels_pk_csr%ROWTYPE;

239: ORIG_SYSTEM_SOURCE_CODE
240: -- R12 Data Model Changes 4485150 End
241: FROM Oks_Pm_Stream_Levels
242: WHERE oks_pm_stream_levels.id = p_id;
243: l_oks_pm_stream_levels_pk oks_pm_stream_levels_pk_csr%ROWTYPE;
244: l_pml_rec pml_rec_type;
245: BEGIN
246: x_no_data_found := TRUE;
247: -- Get current database values

Line 248: OPEN oks_pm_stream_levels_pk_csr (p_pml_rec.id);

244: l_pml_rec pml_rec_type;
245: BEGIN
246: x_no_data_found := TRUE;
247: -- Get current database values
248: OPEN oks_pm_stream_levels_pk_csr (p_pml_rec.id);
249: FETCH oks_pm_stream_levels_pk_csr INTO
250: l_pml_rec.id,
251: l_pml_rec.cle_id,
252: l_pml_rec.dnz_chr_id,

Line 249: FETCH oks_pm_stream_levels_pk_csr INTO

245: BEGIN
246: x_no_data_found := TRUE;
247: -- Get current database values
248: OPEN oks_pm_stream_levels_pk_csr (p_pml_rec.id);
249: FETCH oks_pm_stream_levels_pk_csr INTO
250: l_pml_rec.id,
251: l_pml_rec.cle_id,
252: l_pml_rec.dnz_chr_id,
253: l_pml_rec.activity_line_id,

Line 279: x_no_data_found := oks_pm_stream_levels_pk_csr%NOTFOUND;

275: l_pml_rec.orig_system_reference1,
276: l_pml_rec.orig_system_source_code
277: -- R12 Data Model Changes 4485150 End
278: ;
279: x_no_data_found := oks_pm_stream_levels_pk_csr%NOTFOUND;
280: CLOSE oks_pm_stream_levels_pk_csr;
281: RETURN(l_pml_rec);
282: END get_rec;
283:

Line 280: CLOSE oks_pm_stream_levels_pk_csr;

276: l_pml_rec.orig_system_source_code
277: -- R12 Data Model Changes 4485150 End
278: ;
279: x_no_data_found := oks_pm_stream_levels_pk_csr%NOTFOUND;
280: CLOSE oks_pm_stream_levels_pk_csr;
281: RETURN(l_pml_rec);
282: END get_rec;
283:
284: ------------------------------------------------------------------

Line 313: -- FUNCTION null_out_defaults for: OKS_PM_STREAM_LEVELS_V

309: BEGIN
310: RETURN(get_rec(p_pml_rec, l_row_not_found));
311: END get_rec;
312: ---------------------------------------------------------------------------
313: -- FUNCTION null_out_defaults for: OKS_PM_STREAM_LEVELS_V
314: ---------------------------------------------------------------------------
315: FUNCTION null_out_defaults (
316: p_pmlv_rec IN pmlv_rec_type
317: ) RETURN pmlv_rec_type IS

Line 436: -- Validate_Attributes for:OKS_PM_STREAM_LEVELS_V --

432: ---------------------------------------------------------------------------
433: -- FUNCTION Validate_Attributes
434: ---------------------------------------------------------------------------
435: ----------------------------------------------------
436: -- Validate_Attributes for:OKS_PM_STREAM_LEVELS_V --
437: ----------------------------------------------------
438: FUNCTION Validate_Attributes (
439: p_pmlv_rec IN pmlv_rec_type
440: ) RETURN VARCHAR2 IS

Line 474: -- Validate Record for:OKS_PM_STREAM_LEVELS_V --

470: ---------------------------------------------------------------------------
471: -- PROCEDURE Validate_Record
472: ---------------------------------------------------------------------------
473: ------------------------------------------------
474: -- Validate Record for:OKS_PM_STREAM_LEVELS_V --
475: ------------------------------------------------
476: FUNCTION Validate_Record (
477: p_pmlv_rec IN pmlv_rec_type,
478: p_db_pmlv_rec IN pmlv_rec_type

Line 570: -- validate_row for:OKS_PM_STREAM_LEVELS_V --

566: ---------------------------------------------------------------------------
567: -- PROCEDURE validate_row
568: ---------------------------------------------------------------------------
569: ---------------------------------------------
570: -- validate_row for:OKS_PM_STREAM_LEVELS_V --
571: ---------------------------------------------
572: PROCEDURE validate_row(
573: p_api_version IN NUMBER,
574: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 647: -- PL/SQL TBL validate_row for:OKS_PM_STREAM_LEVELS_V --

643: '_PVT'
644: );
645: END validate_row;
646: --------------------------------------------------------
647: -- PL/SQL TBL validate_row for:OKS_PM_STREAM_LEVELS_V --
648: --------------------------------------------------------
649: PROCEDURE validate_row(
650: p_api_version IN NUMBER,
651: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 743: -- PL/SQL TBL validate_row for:OKS_PM_STREAM_LEVELS_V --

739: );
740: END validate_row;
741:
742: --------------------------------------------------------
743: -- PL/SQL TBL validate_row for:OKS_PM_STREAM_LEVELS_V --
744: --------------------------------------------------------
745: PROCEDURE validate_row(
746: p_api_version IN NUMBER,
747: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 808: -- insert_row for:OKS_PM_STREAM_LEVELS --

804: ---------------------------------------------------------------------------
805: -- PROCEDURE insert_row
806: ---------------------------------------------------------------------------
807: -----------------------------------------
808: -- insert_row for:OKS_PM_STREAM_LEVELS --
809: -----------------------------------------
810: PROCEDURE insert_row(
811: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
812: x_return_status OUT NOCOPY VARCHAR2,

Line 824: -- Set_Attributes for:OKS_PM_STREAM_LEVELS --

820: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
821: l_pml_rec pml_rec_type := p_pml_rec;
822: l_def_pml_rec pml_rec_type;
823: ---------------------------------------------
824: -- Set_Attributes for:OKS_PM_STREAM_LEVELS --
825: ---------------------------------------------
826: FUNCTION Set_Attributes (
827: p_pml_rec IN pml_rec_type,
828: x_pml_rec OUT NOCOPY pml_rec_type

Line 855: INSERT INTO OKS_PM_STREAM_LEVELS(

851: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
852: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
853: RAISE OKC_API.G_EXCEPTION_ERROR;
854: END IF;
855: INSERT INTO OKS_PM_STREAM_LEVELS(
856: id,
857: cle_id,
858: dnz_chr_id,
859: activity_line_id,

Line 952: -- insert_row for :OKS_PM_STREAM_LEVELS_V --

948: '_PVT'
949: );
950: END insert_row;
951: --------------------------------------------
952: -- insert_row for :OKS_PM_STREAM_LEVELS_V --
953: --------------------------------------------
954: PROCEDURE insert_row(
955: p_api_version IN NUMBER,
956: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 986: -- Set_Attributes for:OKS_PM_STREAM_LEVELS_V --

982: l_pmlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
983: RETURN(l_pmlv_rec);
984: END fill_who_columns;
985: -----------------------------------------------
986: -- Set_Attributes for:OKS_PM_STREAM_LEVELS_V --
987: -----------------------------------------------
988: FUNCTION Set_Attributes (
989: p_pmlv_rec IN pmlv_rec_type,
990: x_pmlv_rec OUT NOCOPY pmlv_rec_type

Line 1262: -- lock_row for:OKS_PM_STREAM_LEVELS --

1258: ---------------------------------------------------------------------------
1259: -- PROCEDURE lock_row
1260: ---------------------------------------------------------------------------
1261: ---------------------------------------
1262: -- lock_row for:OKS_PM_STREAM_LEVELS --
1263: ---------------------------------------
1264: PROCEDURE lock_row(
1265: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1266: x_return_status OUT NOCOPY VARCHAR2,

Line 1275: FROM OKS_PM_STREAM_LEVELS

1271: E_Resource_Busy EXCEPTION;
1272: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1273: CURSOR lock_csr (p_pml_rec IN pml_rec_type) IS
1274: SELECT OBJECT_VERSION_NUMBER
1275: FROM OKS_PM_STREAM_LEVELS
1276: WHERE ID = p_pml_rec.id
1277: AND OBJECT_VERSION_NUMBER = p_pml_rec.object_version_number
1278: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1279:

Line 1282: FROM OKS_PM_STREAM_LEVELS

1278: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1279:
1280: CURSOR lchk_csr (p_pml_rec IN pml_rec_type) IS
1281: SELECT OBJECT_VERSION_NUMBER
1282: FROM OKS_PM_STREAM_LEVELS
1283: WHERE ID = p_pml_rec.id;
1284: l_api_version CONSTANT NUMBER := 1;
1285: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1286: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1287: l_object_version_number OKS_PM_STREAM_LEVELS.OBJECT_VERSION_NUMBER%TYPE;

1283: WHERE ID = p_pml_rec.id;
1284: l_api_version CONSTANT NUMBER := 1;
1285: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1286: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1287: l_object_version_number OKS_PM_STREAM_LEVELS.OBJECT_VERSION_NUMBER%TYPE;
1288: lc_object_version_number OKS_PM_STREAM_LEVELS.OBJECT_VERSION_NUMBER%TYPE;
1289: l_row_notfound BOOLEAN := FALSE;
1290: lc_row_notfound BOOLEAN := FALSE;
1291: BEGIN

Line 1288: lc_object_version_number OKS_PM_STREAM_LEVELS.OBJECT_VERSION_NUMBER%TYPE;

1284: l_api_version CONSTANT NUMBER := 1;
1285: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1286: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1287: l_object_version_number OKS_PM_STREAM_LEVELS.OBJECT_VERSION_NUMBER%TYPE;
1288: lc_object_version_number OKS_PM_STREAM_LEVELS.OBJECT_VERSION_NUMBER%TYPE;
1289: l_row_notfound BOOLEAN := FALSE;
1290: lc_row_notfound BOOLEAN := FALSE;
1291: BEGIN
1292: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1369: -- lock_row for: OKS_PM_STREAM_LEVELS_V --

1365: '_PVT'
1366: );
1367: END lock_row;
1368: ------------------------------------------
1369: -- lock_row for: OKS_PM_STREAM_LEVELS_V --
1370: ------------------------------------------
1371: PROCEDURE lock_row(
1372: p_api_version IN NUMBER,
1373: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1609: -- update_row for:OKS_PM_STREAM_LEVELS --

1605: ---------------------------------------------------------------------------
1606: -- PROCEDURE update_row
1607: ---------------------------------------------------------------------------
1608: -----------------------------------------
1609: -- update_row for:OKS_PM_STREAM_LEVELS --
1610: -----------------------------------------
1611: PROCEDURE update_row(
1612: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1613: x_return_status OUT NOCOPY VARCHAR2,

Line 1750: -- Set_Attributes for:OKS_PM_STREAM_LEVELS --

1746: END IF;
1747: RETURN(l_return_status);
1748: END populate_new_record;
1749: ---------------------------------------------
1750: -- Set_Attributes for:OKS_PM_STREAM_LEVELS --
1751: ---------------------------------------------
1752: FUNCTION Set_Attributes (
1753: p_pml_rec IN pml_rec_type,
1754: x_pml_rec OUT NOCOPY pml_rec_type

Line 1788: UPDATE OKS_PM_STREAM_LEVELS

1784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1785: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1786: RAISE OKC_API.G_EXCEPTION_ERROR;
1787: END IF;
1788: UPDATE OKS_PM_STREAM_LEVELS
1789: SET CLE_ID = l_def_pml_rec.cle_id,
1790: DNZ_CHR_ID = l_def_pml_rec.dnz_chr_id,
1791: ACTIVITY_LINE_ID = l_def_pml_rec.activity_line_id,
1792: SEQUENCE_NUMBER = l_def_pml_rec.sequence_number,

Line 1854: -- update_row for:OKS_PM_STREAM_LEVELS_V --

1850: '_PVT'
1851: );
1852: END update_row;
1853: -------------------------------------------
1854: -- update_row for:OKS_PM_STREAM_LEVELS_V --
1855: -------------------------------------------
1856: PROCEDURE update_row(
1857: p_api_version IN NUMBER,
1858: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2013: -- Set_Attributes for:OKS_PM_STREAM_LEVELS_V --

2009: END IF;
2010: RETURN(l_return_status);
2011: END populate_new_record;
2012: -----------------------------------------------
2013: -- Set_Attributes for:OKS_PM_STREAM_LEVELS_V --
2014: -----------------------------------------------
2015: FUNCTION Set_Attributes (
2016: p_pmlv_rec IN pmlv_rec_type,
2017: x_pmlv_rec OUT NOCOPY pmlv_rec_type

Line 2305: -- delete_row for:OKS_PM_STREAM_LEVELS --

2301: ---------------------------------------------------------------------------
2302: -- PROCEDURE delete_row
2303: ---------------------------------------------------------------------------
2304: -----------------------------------------
2305: -- delete_row for:OKS_PM_STREAM_LEVELS --
2306: -----------------------------------------
2307: PROCEDURE delete_row(
2308: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2309: x_return_status OUT NOCOPY VARCHAR2,

Line 2330: DELETE FROM OKS_PM_STREAM_LEVELS

2326: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2327: RAISE OKC_API.G_EXCEPTION_ERROR;
2328: END IF;
2329:
2330: DELETE FROM OKS_PM_STREAM_LEVELS
2331: WHERE ID = p_pml_rec.id;
2332:
2333: x_return_status := l_return_status;
2334: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2368: -- delete_row for:OKS_PM_STREAM_LEVELS_V --

2364: '_PVT'
2365: );
2366: END delete_row;
2367: -------------------------------------------
2368: -- delete_row for:OKS_PM_STREAM_LEVELS_V --
2369: -------------------------------------------
2370: PROCEDURE delete_row(
2371: p_api_version IN NUMBER,
2372: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2450: -- PL/SQL TBL delete_row for:OKS_PM_STREAM_LEVELS_V --

2446: '_PVT'
2447: );
2448: END delete_row;
2449: ------------------------------------------------------
2450: -- PL/SQL TBL delete_row for:OKS_PM_STREAM_LEVELS_V --
2451: ------------------------------------------------------
2452: PROCEDURE delete_row(
2453: p_api_version IN NUMBER,
2454: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2546: -- PL/SQL TBL delete_row for:OKS_PM_STREAM_LEVELS_V --

2542: );
2543: END delete_row;
2544:
2545: ------------------------------------------------------
2546: -- PL/SQL TBL delete_row for:OKS_PM_STREAM_LEVELS_V --
2547: ------------------------------------------------------
2548: PROCEDURE delete_row(
2549: p_api_version IN NUMBER,
2550: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2615: INSERT INTO OKS_PM_STREAM_LEVELS_H(

2611:
2612: BEGIN
2613:
2614:
2615: INSERT INTO OKS_PM_STREAM_LEVELS_H(
2616: id,
2617: cle_id,
2618: dnz_chr_id,
2619: activity_line_id,

Line 2666: FROM OKS_PM_STREAM_LEVELS

2662: last_updated_by,
2663: last_update_date,
2664: last_update_login,
2665: p_major_version
2666: FROM OKS_PM_STREAM_LEVELS
2667: WHERE DNZ_CHR_ID = P_Id;
2668:
2669: RETURN l_return_status;
2670:

Line 2698: DELETE FROM OKS_PM_STREAM_LEVELS

2694: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2695:
2696: BEGIN
2697:
2698: DELETE FROM OKS_PM_STREAM_LEVELS
2699: WHERE DNZ_CHR_ID = p_id;
2700:
2701: INSERT INTO OKS_PM_STREAM_LEVELS(
2702: id,

Line 2701: INSERT INTO OKS_PM_STREAM_LEVELS(

2697:
2698: DELETE FROM OKS_PM_STREAM_LEVELS
2699: WHERE DNZ_CHR_ID = p_id;
2700:
2701: INSERT INTO OKS_PM_STREAM_LEVELS(
2702: id,
2703: cle_id,
2704: dnz_chr_id,
2705: activity_line_id,

Line 2750: FROM OKS_PM_STREAM_LEVELS_H

2746: creation_date,
2747: last_updated_by,
2748: last_update_date,
2749: last_update_login
2750: FROM OKS_PM_STREAM_LEVELS_H
2751: WHERE DNZ_CHR_ID = P_Id
2752: AND major_version=p_major_version;
2753:
2754: RETURN l_return_status;