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_BILL_LEVEL_ELEMENTS_PVT dependencies on OKS_LEVEL_ELEMENTS

Line 95: -- FUNCTION get_rec for: OKS_LEVEL_ELEMENTS_V

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

Line 124: FROM Oks_Level_Elements_V

120: CREATED_BY,
121: CREATION_DATE,
122: LAST_UPDATED_BY,
123: LAST_UPDATE_DATE
124: FROM Oks_Level_Elements_V
125: WHERE oks_level_elements_v.id = p_id;
126: l_oks_let_pk oks_let_pk_csr%ROWTYPE;
127: l_letv_rec letv_rec_type;
128: BEGIN

Line 125: WHERE oks_level_elements_v.id = p_id;

121: CREATION_DATE,
122: LAST_UPDATED_BY,
123: LAST_UPDATE_DATE
124: FROM Oks_Level_Elements_V
125: WHERE oks_level_elements_v.id = p_id;
126: l_oks_let_pk oks_let_pk_csr%ROWTYPE;
127: l_letv_rec letv_rec_type;
128: BEGIN
129: x_no_data_found := TRUE;

Line 188: -- FUNCTION get_rec for: OKS_LEVEL_ELEMENTS

184: BEGIN
185: RETURN(get_rec(p_letv_rec, l_row_not_found));
186: END get_rec;
187: ---------------------------------------------------------------------------
188: -- FUNCTION get_rec for: OKS_LEVEL_ELEMENTS
189: ---------------------------------------------------------------------------
190: FUNCTION get_rec (
191: p_let_rec IN let_rec_type,
192: x_no_data_found OUT NOCOPY BOOLEAN

Line 194: CURSOR oks_level_elements_pk_csr (p_id IN NUMBER) IS

190: FUNCTION get_rec (
191: p_let_rec IN let_rec_type,
192: x_no_data_found OUT NOCOPY BOOLEAN
193: ) RETURN let_rec_type IS
194: CURSOR oks_level_elements_pk_csr (p_id IN NUMBER) IS
195: SELECT
196: ID,
197: CLE_ID,
198: DNZ_CHR_ID,

Line 217: FROM Oks_Level_Elements

213: CREATED_BY,
214: CREATION_DATE,
215: LAST_UPDATED_BY,
216: LAST_UPDATE_DATE
217: FROM Oks_Level_Elements
218: WHERE oks_level_elements.id = p_id;
219: l_oks_level_elements_pk oks_level_elements_pk_csr%ROWTYPE;
220: l_let_rec let_rec_type;
221: BEGIN

Line 218: WHERE oks_level_elements.id = p_id;

214: CREATION_DATE,
215: LAST_UPDATED_BY,
216: LAST_UPDATE_DATE
217: FROM Oks_Level_Elements
218: WHERE oks_level_elements.id = p_id;
219: l_oks_level_elements_pk oks_level_elements_pk_csr%ROWTYPE;
220: l_let_rec let_rec_type;
221: BEGIN
222: x_no_data_found := TRUE;

Line 219: l_oks_level_elements_pk oks_level_elements_pk_csr%ROWTYPE;

215: LAST_UPDATED_BY,
216: LAST_UPDATE_DATE
217: FROM Oks_Level_Elements
218: WHERE oks_level_elements.id = p_id;
219: l_oks_level_elements_pk oks_level_elements_pk_csr%ROWTYPE;
220: l_let_rec let_rec_type;
221: BEGIN
222: x_no_data_found := TRUE;
223: -- Get current database values

Line 224: OPEN oks_level_elements_pk_csr (p_let_rec.id);

220: l_let_rec let_rec_type;
221: BEGIN
222: x_no_data_found := TRUE;
223: -- Get current database values
224: OPEN oks_level_elements_pk_csr (p_let_rec.id);
225: FETCH oks_level_elements_pk_csr INTO
226: l_let_rec.id,
227: l_let_rec.cle_id,
228: l_let_rec.dnz_chr_id,

Line 225: FETCH oks_level_elements_pk_csr INTO

221: BEGIN
222: x_no_data_found := TRUE;
223: -- Get current database values
224: OPEN oks_level_elements_pk_csr (p_let_rec.id);
225: FETCH oks_level_elements_pk_csr INTO
226: l_let_rec.id,
227: l_let_rec.cle_id,
228: l_let_rec.dnz_chr_id,
229: l_let_rec.parent_cle_id,

Line 247: x_no_data_found := oks_level_elements_pk_csr%NOTFOUND;

243: l_let_rec.created_by,
244: l_let_rec.creation_date,
245: l_let_rec.last_updated_by,
246: l_let_rec.last_update_date;
247: x_no_data_found := oks_level_elements_pk_csr%NOTFOUND;
248: CLOSE oks_level_elements_pk_csr;
249: RETURN(l_let_rec);
250: END get_rec;
251:

Line 248: CLOSE oks_level_elements_pk_csr;

244: l_let_rec.creation_date,
245: l_let_rec.last_updated_by,
246: l_let_rec.last_update_date;
247: x_no_data_found := oks_level_elements_pk_csr%NOTFOUND;
248: CLOSE oks_level_elements_pk_csr;
249: RETURN(l_let_rec);
250: END get_rec;
251:
252: ------------------------------------------------------------------

Line 281: -- FUNCTION null_out_defaults for: OKS_LEVEL_ELEMENTS_V

277: BEGIN
278: RETURN(get_rec(p_let_rec, l_row_not_found));
279: END get_rec;
280: ---------------------------------------------------------------------------
281: -- FUNCTION null_out_defaults for: OKS_LEVEL_ELEMENTS_V
282: ---------------------------------------------------------------------------
283: FUNCTION null_out_defaults (
284: p_letv_rec IN letv_rec_type
285: ) RETURN letv_rec_type IS

Line 438: -- Validate_Attributes for:OKS_LEVEL_ELEMENTS_V --

434: ---------------------------------------------------------------------------
435: -- FUNCTION Validate_Attributes
436: ---------------------------------------------------------------------------
437: --------------------------------------------------
438: -- Validate_Attributes for:OKS_LEVEL_ELEMENTS_V --
439: --------------------------------------------------
440: FUNCTION Validate_Attributes (
441: p_letv_rec IN letv_rec_type
442: ) RETURN VARCHAR2 IS

Line 494: -- Validate Record for:OKS_LEVEL_ELEMENTS_V --

490: ---------------------------------------------------------------------------
491: -- PROCEDURE Validate_Record
492: ---------------------------------------------------------------------------
493: ----------------------------------------------
494: -- Validate Record for:OKS_LEVEL_ELEMENTS_V --
495: ----------------------------------------------
496: FUNCTION Validate_Record (
497: p_letv_rec IN letv_rec_type,
498: p_db_letv_rec IN letv_rec_type

Line 576: -- validate_row for:OKS_LEVEL_ELEMENTS_V --

572: ---------------------------------------------------------------------------
573: -- PROCEDURE validate_row
574: ---------------------------------------------------------------------------
575: -------------------------------------------
576: -- validate_row for:OKS_LEVEL_ELEMENTS_V --
577: -------------------------------------------
578: PROCEDURE validate_row(
579: p_api_version IN NUMBER,
580: p_init_msg_list IN VARCHAR2,

Line 653: -- PL/SQL TBL validate_row for:OKS_LEVEL_ELEMENTS_V --

649: '_PVT'
650: );
651: END validate_row;
652: ------------------------------------------------------
653: -- PL/SQL TBL validate_row for:OKS_LEVEL_ELEMENTS_V --
654: ------------------------------------------------------
655: PROCEDURE validate_row(
656: p_api_version IN NUMBER,
657: p_init_msg_list IN VARCHAR2,

Line 749: -- PL/SQL TBL validate_row for:OKS_LEVEL_ELEMENTS_V --

745: );
746: END validate_row;
747:
748: ------------------------------------------------------
749: -- PL/SQL TBL validate_row for:OKS_LEVEL_ELEMENTS_V --
750: ------------------------------------------------------
751: PROCEDURE validate_row(
752: p_api_version IN NUMBER,
753: p_init_msg_list IN VARCHAR2,

Line 814: -- insert_row for:OKS_LEVEL_ELEMENTS --

810: ---------------------------------------------------------------------------
811: -- PROCEDURE insert_row
812: ---------------------------------------------------------------------------
813: ---------------------------------------
814: -- insert_row for:OKS_LEVEL_ELEMENTS --
815: ---------------------------------------
816: PROCEDURE insert_row(
817: p_init_msg_list IN VARCHAR2,
818: x_return_status OUT NOCOPY VARCHAR2,

Line 830: -- Set_Attributes for:OKS_LEVEL_ELEMENTS --

826: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
827: l_let_rec let_rec_type := p_let_rec;
828: l_def_let_rec let_rec_type;
829: -------------------------------------------
830: -- Set_Attributes for:OKS_LEVEL_ELEMENTS --
831: -------------------------------------------
832: FUNCTION Set_Attributes (
833: p_let_rec IN let_rec_type,
834: x_let_rec OUT NOCOPY let_rec_type

Line 861: INSERT INTO OKS_LEVEL_ELEMENTS(

857: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
858: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
859: RAISE OKC_API.G_EXCEPTION_ERROR;
860: END IF;
861: INSERT INTO OKS_LEVEL_ELEMENTS(
862: id,
863: cle_id,
864: dnz_chr_id,
865: parent_cle_id,

Line 942: -- insert_row for :OKS_LEVEL_ELEMENTS_V --

938: '_PVT'
939: );
940: END insert_row;
941: ------------------------------------------
942: -- insert_row for :OKS_LEVEL_ELEMENTS_V --
943: ------------------------------------------
944: PROCEDURE insert_row(
945: p_api_version IN NUMBER,
946: p_init_msg_list IN VARCHAR2,

Line 976: -- Set_Attributes for:OKS_LEVEL_ELEMENTS_V --

972: -- l_letv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
973: RETURN(l_letv_rec);
974: END fill_who_columns;
975: ---------------------------------------------
976: -- Set_Attributes for:OKS_LEVEL_ELEMENTS_V --
977: ---------------------------------------------
978: FUNCTION Set_Attributes (
979: p_letv_rec IN letv_rec_type,
980: x_letv_rec OUT NOCOPY letv_rec_type

Line 1254: -- lock_row for:OKS_LEVEL_ELEMENTS --

1250: ---------------------------------------------------------------------------
1251: -- PROCEDURE lock_row
1252: ---------------------------------------------------------------------------
1253: -------------------------------------
1254: -- lock_row for:OKS_LEVEL_ELEMENTS --
1255: -------------------------------------
1256: PROCEDURE lock_row(
1257: p_init_msg_list IN VARCHAR2,
1258: x_return_status OUT NOCOPY VARCHAR2,

Line 1267: FROM OKS_LEVEL_ELEMENTS

1263: E_Resource_Busy EXCEPTION;
1264: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1265: CURSOR lock_csr (p_let_rec IN let_rec_type) IS
1266: SELECT OBJECT_VERSION_NUMBER
1267: FROM OKS_LEVEL_ELEMENTS
1268: WHERE ID = p_let_rec.id
1269: AND OBJECT_VERSION_NUMBER = p_let_rec.object_version_number
1270: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1271:

Line 1274: FROM OKS_LEVEL_ELEMENTS

1270: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1271:
1272: CURSOR lchk_csr (p_let_rec IN let_rec_type) IS
1273: SELECT OBJECT_VERSION_NUMBER
1274: FROM OKS_LEVEL_ELEMENTS
1275: WHERE ID = p_let_rec.id;
1276: l_api_version CONSTANT NUMBER := 1;
1277: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1278: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1279: l_object_version_number OKS_LEVEL_ELEMENTS.OBJECT_VERSION_NUMBER%TYPE;

1275: WHERE ID = p_let_rec.id;
1276: l_api_version CONSTANT NUMBER := 1;
1277: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1278: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1279: l_object_version_number OKS_LEVEL_ELEMENTS.OBJECT_VERSION_NUMBER%TYPE;
1280: lc_object_version_number OKS_LEVEL_ELEMENTS.OBJECT_VERSION_NUMBER%TYPE;
1281: l_row_notfound BOOLEAN := FALSE;
1282: lc_row_notfound BOOLEAN := FALSE;
1283: BEGIN

Line 1280: lc_object_version_number OKS_LEVEL_ELEMENTS.OBJECT_VERSION_NUMBER%TYPE;

1276: l_api_version CONSTANT NUMBER := 1;
1277: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1278: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1279: l_object_version_number OKS_LEVEL_ELEMENTS.OBJECT_VERSION_NUMBER%TYPE;
1280: lc_object_version_number OKS_LEVEL_ELEMENTS.OBJECT_VERSION_NUMBER%TYPE;
1281: l_row_notfound BOOLEAN := FALSE;
1282: lc_row_notfound BOOLEAN := FALSE;
1283: BEGIN
1284: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1361: -- lock_row for: OKS_LEVEL_ELEMENTS_V --

1357: '_PVT'
1358: );
1359: END lock_row;
1360: ----------------------------------------
1361: -- lock_row for: OKS_LEVEL_ELEMENTS_V --
1362: ----------------------------------------
1363: PROCEDURE lock_row(
1364: p_api_version IN NUMBER,
1365: p_init_msg_list IN VARCHAR2,

Line 1601: -- update_row for:OKS_LEVEL_ELEMENTS --

1597: ---------------------------------------------------------------------------
1598: -- PROCEDURE update_row
1599: ---------------------------------------------------------------------------
1600: ---------------------------------------
1601: -- update_row for:OKS_LEVEL_ELEMENTS --
1602: ---------------------------------------
1603: PROCEDURE update_row(
1604: p_init_msg_list IN VARCHAR2,
1605: x_return_status OUT NOCOPY VARCHAR2,

Line 1720: -- Set_Attributes for:OKS_LEVEL_ELEMENTS --

1716: END IF;
1717: RETURN(l_return_status);
1718: END populate_new_record;
1719: -------------------------------------------
1720: -- Set_Attributes for:OKS_LEVEL_ELEMENTS --
1721: -------------------------------------------
1722: FUNCTION Set_Attributes (
1723: p_let_rec IN let_rec_type,
1724: x_let_rec OUT NOCOPY let_rec_type

Line 1758: UPDATE OKS_LEVEL_ELEMENTS

1754: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1755: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1756: RAISE OKC_API.G_EXCEPTION_ERROR;
1757: END IF;
1758: UPDATE OKS_LEVEL_ELEMENTS
1759: SET CLE_ID = l_def_let_rec.cle_id,
1760: DNZ_CHR_ID = l_def_let_rec.dnz_chr_id,
1761: PARENT_CLE_ID = l_def_let_rec.parent_cle_id,
1762: SEQUENCE_NUMBER = l_def_let_rec.sequence_number,

Line 1817: -- update_row for:OKS_LEVEL_ELEMENTS_V --

1813: '_PVT'
1814: );
1815: END update_row;
1816: -----------------------------------------
1817: -- update_row for:OKS_LEVEL_ELEMENTS_V --
1818: -----------------------------------------
1819: PROCEDURE update_row(
1820: p_api_version IN NUMBER,
1821: p_init_msg_list IN VARCHAR2,

Line 1949: -- Set_Attributes for:OKS_LEVEL_ELEMENTS_V --

1945: END IF;
1946: RETURN(l_return_status);
1947: END populate_new_record;
1948: ---------------------------------------------
1949: -- Set_Attributes for:OKS_LEVEL_ELEMENTS_V --
1950: ---------------------------------------------
1951: FUNCTION Set_Attributes (
1952: p_letv_rec IN letv_rec_type,
1953: x_letv_rec OUT NOCOPY letv_rec_type

Line 2243: -- delete_row for:OKS_LEVEL_ELEMENTS --

2239: ---------------------------------------------------------------------------
2240: -- PROCEDURE delete_row
2241: ---------------------------------------------------------------------------
2242: ---------------------------------------
2243: -- delete_row for:OKS_LEVEL_ELEMENTS --
2244: ---------------------------------------
2245: PROCEDURE delete_row(
2246: p_init_msg_list IN VARCHAR2,
2247: x_return_status OUT NOCOPY VARCHAR2,

Line 2268: DELETE FROM OKS_LEVEL_ELEMENTS

2264: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2265: RAISE OKC_API.G_EXCEPTION_ERROR;
2266: END IF;
2267:
2268: DELETE FROM OKS_LEVEL_ELEMENTS
2269: WHERE ID = p_let_rec.id;
2270:
2271: x_return_status := l_return_status;
2272: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2306: -- delete_row for:OKS_LEVEL_ELEMENTS_V --

2302: '_PVT'
2303: );
2304: END delete_row;
2305: -----------------------------------------
2306: -- delete_row for:OKS_LEVEL_ELEMENTS_V --
2307: -----------------------------------------
2308: PROCEDURE delete_row(
2309: p_api_version IN NUMBER,
2310: p_init_msg_list IN VARCHAR2,

Line 2388: -- PL/SQL TBL delete_row for:OKS_LEVEL_ELEMENTS_V --

2384: '_PVT'
2385: );
2386: END delete_row;
2387: ----------------------------------------------------
2388: -- PL/SQL TBL delete_row for:OKS_LEVEL_ELEMENTS_V --
2389: ----------------------------------------------------
2390: PROCEDURE delete_row(
2391: p_api_version IN NUMBER,
2392: p_init_msg_list IN VARCHAR2,

Line 2484: -- PL/SQL TBL delete_row for:OKS_LEVEL_ELEMENTS_V --

2480: );
2481: END delete_row;
2482:
2483: ----------------------------------------------------
2484: -- PL/SQL TBL delete_row for:OKS_LEVEL_ELEMENTS_V --
2485: ----------------------------------------------------
2486: PROCEDURE delete_row(
2487: p_api_version IN NUMBER,
2488: p_init_msg_list IN VARCHAR2,