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_V

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 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 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 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 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 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,