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.OKL_ITI_PVT dependencies on OKL_TXL_ITM_INSTS

Line 340: CURSOR c_object_id1_new_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE) is

336:
337: PROCEDURE validate_object_id1_new(x_return_status OUT NOCOPY VARCHAR2,
338: p_itiv_rec IN itiv_rec_type) IS
339: ln_dummy number := 0;
340: CURSOR c_object_id1_new_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE) is
341: SELECT 1
342: FROM DUAL
343: WHERE EXISTS (SELECT '1'
344: FROM OKX_PARTY_SITE_USES_V

Line 419: CURSOR c_object_id2_new_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,

415:
416: PROCEDURE validate_object_id2_new(x_return_status OUT NOCOPY VARCHAR2,
417: p_itiv_rec IN itiv_rec_type) IS
418: ln_dummy number := 0;
419: CURSOR c_object_id2_new_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
420: p_id2 OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE) is
421: SELECT 1
422: FROM DUAL
423: WHERE EXISTS (SELECT '1'

Line 420: p_id2 OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE) is

416: PROCEDURE validate_object_id2_new(x_return_status OUT NOCOPY VARCHAR2,
417: p_itiv_rec IN itiv_rec_type) IS
418: ln_dummy number := 0;
419: CURSOR c_object_id2_new_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE,
420: p_id2 OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE) is
421: SELECT 1
422: FROM DUAL
423: WHERE EXISTS (SELECT '1'
424: FROM OKX_PARTY_SITE_USES_V

Line 502: p_jtot_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE) is

498: PROCEDURE validate_jtot_object_code_new(x_return_status OUT NOCOPY VARCHAR2,
499: p_itiv_rec IN itiv_rec_type) IS
500: ln_dummy number := 0;
501: CURSOR c_jtot_code_new_validate(
502: p_jtot_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE) is
503: SELECT 1
504: FROM DUAL
505: WHERE EXISTS (SELECT '1'
506: FROM JTF_OBJECTS_B

Line 580: CURSOR c_object_id1_old_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE) is

576:
577: PROCEDURE validate_object_id1_old(x_return_status OUT NOCOPY VARCHAR2,
578: p_itiv_rec IN itiv_rec_type) IS
579: ln_dummy number := 0;
580: CURSOR c_object_id1_old_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE) is
581: SELECT 1
582: FROM DUAL
583: WHERE EXISTS (SELECT '1'
584: FROM OKX_PARTY_SITE_USES_V

Line 654: CURSOR c_object_id2_old_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE,

650:
651: PROCEDURE validate_object_id2_old(x_return_status OUT NOCOPY VARCHAR2,
652: p_itiv_rec IN itiv_rec_type) IS
653: ln_dummy number := 0;
654: CURSOR c_object_id2_old_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE,
655: p_id2 OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE) is
656: SELECT 1
657: FROM DUAL
658: WHERE EXISTS (SELECT '1'

Line 655: p_id2 OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE) is

651: PROCEDURE validate_object_id2_old(x_return_status OUT NOCOPY VARCHAR2,
652: p_itiv_rec IN itiv_rec_type) IS
653: ln_dummy number := 0;
654: CURSOR c_object_id2_old_validate(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE,
655: p_id2 OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE) is
656: SELECT 1
657: FROM DUAL
658: WHERE EXISTS (SELECT '1'
659: FROM OKX_PARTY_SITE_USES_V

Line 732: p_jtot_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE) is

728: PROCEDURE validate_jtot_object_code_old(x_return_status OUT NOCOPY VARCHAR2,
729: p_itiv_rec IN itiv_rec_type) IS
730: ln_dummy number := 0;
731: CURSOR c_jtot_code_old_validate(
732: p_jtot_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE) is
733: SELECT 1
734: FROM DUAL
735: WHERE EXISTS (SELECT '1'
736: FROM JTF_OBJECTS_B

Line 1308: -- FUNCTION get_rec for: OKL_TXL_ITM_INSTS

1304: null;
1305: END api_copy;
1306:
1307: ---------------------------------------------------------------------------
1308: -- FUNCTION get_rec for: OKL_TXL_ITM_INSTS
1309: ---------------------------------------------------------------------------
1310: FUNCTION get_rec (
1311: p_iti_rec IN iti_rec_type,
1312: x_no_data_found OUT NOCOPY BOOLEAN)

Line 1314: CURSOR okl_txl_itm_insts_b_pk_csr(

1310: FUNCTION get_rec (
1311: p_iti_rec IN iti_rec_type,
1312: x_no_data_found OUT NOCOPY BOOLEAN)
1313: RETURN iti_rec_type IS
1314: CURSOR okl_txl_itm_insts_b_pk_csr(
1315: p_id IN NUMBER) IS
1316: SELECT ID,
1317: OBJECT_VERSION_NUMBER,
1318: TAS_ID,

Line 1361: FROM OKL_TXL_ITM_INSTS iti

1357: --Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
1358: instance_id,
1359: selected_for_split_flag,
1360: asd_id
1361: FROM OKL_TXL_ITM_INSTS iti
1362: WHERE iti.id = p_id;
1363: l_okl_txl_itm_insts_b_pk okl_txl_itm_insts_b_pk_csr%ROWTYPE;
1364: l_iti_rec iti_rec_type;
1365: BEGIN

Line 1363: l_okl_txl_itm_insts_b_pk okl_txl_itm_insts_b_pk_csr%ROWTYPE;

1359: selected_for_split_flag,
1360: asd_id
1361: FROM OKL_TXL_ITM_INSTS iti
1362: WHERE iti.id = p_id;
1363: l_okl_txl_itm_insts_b_pk okl_txl_itm_insts_b_pk_csr%ROWTYPE;
1364: l_iti_rec iti_rec_type;
1365: BEGIN
1366: x_no_data_found := TRUE;
1367: -- Get current database values

Line 1368: OPEN okl_txl_itm_insts_b_pk_csr (p_iti_rec.id);

1364: l_iti_rec iti_rec_type;
1365: BEGIN
1366: x_no_data_found := TRUE;
1367: -- Get current database values
1368: OPEN okl_txl_itm_insts_b_pk_csr (p_iti_rec.id);
1369: FETCH okl_txl_itm_insts_b_pk_csr INTO
1370: l_iti_rec.ID,
1371: l_iti_rec.OBJECT_VERSION_NUMBER,
1372: l_iti_rec.TAS_ID,

Line 1369: FETCH okl_txl_itm_insts_b_pk_csr INTO

1365: BEGIN
1366: x_no_data_found := TRUE;
1367: -- Get current database values
1368: OPEN okl_txl_itm_insts_b_pk_csr (p_iti_rec.id);
1369: FETCH okl_txl_itm_insts_b_pk_csr INTO
1370: l_iti_rec.ID,
1371: l_iti_rec.OBJECT_VERSION_NUMBER,
1372: l_iti_rec.TAS_ID,
1373: l_iti_rec.TAL_ID,

Line 1415: x_no_data_found := okl_txl_itm_insts_b_pk_csr%NOTFOUND;

1411: --Bug#2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
1412: l_iti_rec.instance_id,
1413: l_iti_rec.selected_for_split_flag,
1414: l_iti_rec.asd_id;
1415: x_no_data_found := okl_txl_itm_insts_b_pk_csr%NOTFOUND;
1416: CLOSE okl_txl_itm_insts_b_pk_csr;
1417: RETURN(l_iti_rec);
1418: END get_rec;
1419:

Line 1416: CLOSE okl_txl_itm_insts_b_pk_csr;

1412: l_iti_rec.instance_id,
1413: l_iti_rec.selected_for_split_flag,
1414: l_iti_rec.asd_id;
1415: x_no_data_found := okl_txl_itm_insts_b_pk_csr%NOTFOUND;
1416: CLOSE okl_txl_itm_insts_b_pk_csr;
1417: RETURN(l_iti_rec);
1418: END get_rec;
1419:
1420: FUNCTION get_rec (

Line 1480: FROM OKL_TXL_ITM_INSTS_V iti

1476: --Bug#2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
1477: instance_id,
1478: selected_for_split_flag,
1479: asd_id
1480: FROM OKL_TXL_ITM_INSTS_V iti
1481: WHERE iti.id = p_id;
1482: l_okl_itiv_pk okl_itiv_pk_csr%ROWTYPE;
1483: l_itiv_rec itiv_rec_type;
1484: BEGIN

Line 1895: -- Validate_Record for: OKL_TXL_ITM_INSTS_V --

1891: ---------------------------------------------------------------------------
1892: -- PROCEDURE Validate_Record
1893: ---------------------------------------------------------------------------
1894: ------------------------------------------
1895: -- Validate_Record for: OKL_TXL_ITM_INSTS_V --
1896: ------------------------------------------
1897: FUNCTION Validate_Record (
1898: p_itiv_rec IN itiv_rec_type
1899: ) RETURN VARCHAR2 IS

Line 2015: -- validate_row for: OKL_TXL_ITM_INSTS_V --

2011: ---------------------------------------------------------------------------
2012: -- PROCEDURE validate_row
2013: ---------------------------------------------------------------------------
2014: -------------------------------------------
2015: -- validate_row for: OKL_TXL_ITM_INSTS_V --
2016: -------------------------------------------
2017: PROCEDURE validate_row(
2018: p_api_version IN NUMBER,
2019: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2160: -- insert_row for: OKL_TXL_ITM_INSTS --

2156: ---------------------------------------------------------------------------
2157: -- PROCEDURE insert_row
2158: ---------------------------------------------------------------------------
2159: -----------------------------------------
2160: -- insert_row for: OKL_TXL_ITM_INSTS --
2161: -----------------------------------------
2162: PROCEDURE insert_row(
2163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2164: x_return_status OUT NOCOPY VARCHAR2,

Line 2176: -- Set_Attributes for: OKL_TXL_ITM_INSTS --

2172: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2173: l_iti_rec iti_rec_type := p_iti_rec;
2174: l_def_iti_rec iti_rec_type;
2175: -----------------------------------------
2176: -- Set_Attributes for: OKL_TXL_ITM_INSTS --
2177: -----------------------------------------
2178: FUNCTION Set_Attributes (
2179: p_iti_rec IN iti_rec_type,
2180: x_iti_rec OUT NOCOPY iti_rec_type

Line 2207: INSERT INTO OKL_TXL_ITM_INSTS(

2203: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2204: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2205: RAISE OKC_API.G_EXCEPTION_ERROR;
2206: END IF;
2207: INSERT INTO OKL_TXL_ITM_INSTS(
2208: ID,
2209: OBJECT_VERSION_NUMBER,
2210: TAS_ID,
2211: TAL_ID,

Line 2336: -- insert_row for: OKL_TXL_ITM_INSTS_V --

2332: '_PVT'
2333: );
2334: END insert_row;
2335: -------------------------------------
2336: -- insert_row for: OKL_TXL_ITM_INSTS_V --
2337: -------------------------------------
2338: PROCEDURE insert_row(
2339: p_api_version IN NUMBER,
2340: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2371: -- Set_Attributes for: OKL_TXL_ITM_INSTS_V --

2367: l_itiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2368: RETURN(l_itiv_rec);
2369: END fill_who_columns;
2370: ---------------------------------------------
2371: -- Set_Attributes for: OKL_TXL_ITM_INSTS_V --
2372: ---------------------------------------------
2373: FUNCTION Set_Attributes (
2374: p_itiv_rec IN itiv_rec_type,
2375: x_itiv_rec OUT NOCOPY itiv_rec_type

Line 2550: -- lock_row for: OKL_TXL_ITM_INSTS --

2546: ---------------------------------------------------------------------------
2547: -- PROCEDURE lock_row
2548: ---------------------------------------------------------------------------
2549: -----------------------------------
2550: -- lock_row for: OKL_TXL_ITM_INSTS --
2551: -----------------------------------
2552: PROCEDURE lock_row(
2553: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2554: x_return_status OUT NOCOPY VARCHAR2,

Line 2563: FROM OKL_TXL_ITM_INSTS

2559: E_Resource_Busy EXCEPTION;
2560: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2561: CURSOR lock_csr (p_iti_rec IN iti_rec_type) IS
2562: SELECT OBJECT_VERSION_NUMBER
2563: FROM OKL_TXL_ITM_INSTS
2564: WHERE ID = p_iti_rec.id
2565: AND OBJECT_VERSION_NUMBER = p_iti_rec.object_version_number
2566: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2567:

Line 2570: FROM OKL_TXL_ITM_INSTS

2566: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2567:
2568: CURSOR lchk_csr (p_iti_rec IN iti_rec_type) IS
2569: SELECT OBJECT_VERSION_NUMBER
2570: FROM OKL_TXL_ITM_INSTS
2571: WHERE ID = p_iti_rec.id;
2572: l_api_version CONSTANT NUMBER := 1;
2573: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2574: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2656: -- lock_row for: OKL_TXL_ITM_INSTS_V --

2652: '_PVT'
2653: );
2654: END lock_row;
2655: -----------------------------------
2656: -- lock_row for: OKL_TXL_ITM_INSTS_V --
2657: -----------------------------------
2658: PROCEDURE lock_row(
2659: p_api_version IN NUMBER,
2660: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2804: -- update_row for: OKL_TXL_ITM_INSTS --

2800: ---------------------------------------------------------------------------
2801: -- PROCEDURE update_row
2802: ---------------------------------------------------------------------------
2803: -----------------------------------------
2804: -- update_row for: OKL_TXL_ITM_INSTS --
2805: -----------------------------------------
2806: PROCEDURE update_row(
2807: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2808: x_return_status OUT NOCOPY VARCHAR2,

Line 2974: -- Set_Attributes for:OKL_TXL_ITM_INSTS --

2970: END IF;
2971: RETURN(l_return_status);
2972: END populate_new_record;
2973: -----------------------------------------
2974: -- Set_Attributes for:OKL_TXL_ITM_INSTS --
2975: -----------------------------------------
2976: FUNCTION Set_Attributes (
2977: p_iti_rec IN iti_rec_type,
2978: x_iti_rec OUT NOCOPY iti_rec_type

Line 3011: UPDATE OKL_TXL_ITM_INSTS

3007: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3008: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3009: RAISE OKC_API.G_EXCEPTION_ERROR;
3010: END IF;
3011: UPDATE OKL_TXL_ITM_INSTS
3012: SET ID = l_def_iti_rec.ID,
3013: OBJECT_VERSION_NUMBER = l_def_iti_rec.OBJECT_VERSION_NUMBER,
3014: TAS_ID = l_def_iti_rec.TAS_ID,
3015: TAL_ID = l_def_iti_rec.TAL_ID,

Line 3093: -- update_row for:OKL_TXL_ITM_INSTS_V --

3089: '_PVT'
3090: );
3091: END update_row;
3092: ----------------------------------------
3093: -- update_row for:OKL_TXL_ITM_INSTS_V --
3094: ----------------------------------------
3095: PROCEDURE update_row(
3096: p_api_version IN NUMBER,
3097: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3278: -- Set_Attributes for:OKL_TXL_ITM_INSTS_V --

3274: END IF;
3275: RETURN(l_return_status);
3276: END populate_new_record;
3277: -----------------------------------------
3278: -- Set_Attributes for:OKL_TXL_ITM_INSTS_V --
3279: -----------------------------------------
3280: FUNCTION Set_Attributes (
3281: p_itiv_rec IN itiv_rec_type,
3282: x_itiv_rec OUT NOCOPY itiv_rec_type

Line 3458: -- delete_row for:OKL_TXL_ITM_INSTS --

3454: ---------------------------------------------------------------------------
3455: -- PROCEDURE delete_row
3456: ---------------------------------------------------------------------------
3457: -------------------------------------
3458: -- delete_row for:OKL_TXL_ITM_INSTS --
3459: -------------------------------------
3460: PROCEDURE delete_row(
3461: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3462: x_return_status OUT NOCOPY VARCHAR2,

Line 3482: DELETE FROM OKL_TXL_ITM_INSTS

3478: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3479: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3480: RAISE OKC_API.G_EXCEPTION_ERROR;
3481: END IF;
3482: DELETE FROM OKL_TXL_ITM_INSTS
3483: WHERE ID = l_iti_rec.id;
3484:
3485: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3486: EXCEPTION

Line 3519: -- delete_row for:OKL_TXL_ITM_INSTS_V --

3515: '_PVT'
3516: );
3517: END delete_row;
3518: -------------------------------------
3519: -- delete_row for:OKL_TXL_ITM_INSTS_V --
3520: -------------------------------------
3521: PROCEDURE delete_row(
3522: p_api_version IN NUMBER,
3523: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,