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_SPLIT_ASSET_PVT dependencies on OKL_TXL_ITM_INSTS

Line 4582: l_serial_number okl_txl_itm_insts.serial_number%TYPE;

4578: --End of comments
4579: --------------------------------------------------------------------------------
4580: PROCEDURE Validate_Serial_Number(x_return_status OUT nocopy VARCHAR2,
4581: p_serial_number IN VARCHAR2) IS
4582: l_serial_number okl_txl_itm_insts.serial_number%TYPE;
4583:
4584: --Cursor to find existence
4585: CURSOR srl_num_csr (Srl_Number IN VARCHAR2) IS
4586: SELECT serial_number

Line 4625: FUNCTION generate_instance_number_ib(x_instance_number_ib OUT NOCOPY OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE)

4621: WHEN OTHERS THEN
4622: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4623: END Validate_Serial_Number;
4624: ---------------------------------------------------------------------------------------------------------------
4625: FUNCTION generate_instance_number_ib(x_instance_number_ib OUT NOCOPY OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE)
4626: RETURN VARCHAR2 IS
4627: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
4628: -- cursor to get sequence number for asset number
4629: CURSOR c_instance_no_ib IS

Line 4664: --Description : API will create serial_number records in OKL_TXL_ITM_INSTS_V

4660: --------------------------------------------------------------------------------
4661: --Start of Comments
4662: --Bug # 2726870: 11.5.9 enhancement for splitting assets by serial number
4663: --API Name : create_split_comp_srl_num
4664: --Description : API will create serial_number records in OKL_TXL_ITM_INSTS_V
4665: -- If financial asset inventory item is serialized for a split asset
4666: -- component
4667: --History : 03-Nov-2002 avsingh Creation (for asset split by serial numbers)
4668: -- Bug# 7047938

Line 4789: l_party_site_use_id okl_txl_itm_insts.object_id1_new%TYPE;

4785:
4786: l_address VARCHAR2(80);
4787: --END BUG# 3569441
4788:
4789: l_party_site_use_id okl_txl_itm_insts.object_id1_new%TYPE;
4790: l_itiv_tbl itiv_tbl_type;
4791: l_itiv_rec itiv_rec_type;
4792: lx_itiv_rec itiv_rec_type;
4793: i NUMBER;

Line 4795: l_instance_number OKL_TXL_ITM_INSTS.instance_number_ib%TYPE;

4791: l_itiv_rec itiv_rec_type;
4792: lx_itiv_rec itiv_rec_type;
4793: i NUMBER;
4794: j NUMBER;
4795: l_instance_number OKL_TXL_ITM_INSTS.instance_number_ib%TYPE;
4796:
4797: --Bug # 7047938
4798: cursor l_tal_csr (p_asd_id in number) is
4799: select tal_id

Line 4958: okl_txl_itm_insts_pub.create_txl_itm_insts

4954: RAISE OKL_API.G_EXCEPTION_ERROR;
4955: END IF;
4956: l_itiv_rec.instance_number_ib := l_instance_number;
4957: --create record
4958: okl_txl_itm_insts_pub.create_txl_itm_insts
4959: (p_api_version => p_api_version,
4960: p_init_msg_list => p_init_msg_list,
4961: x_return_status => x_return_status,
4962: x_msg_count => x_msg_count,

Line 5248: --Description : Local API will create serial_number records in OKL_TXL_ITM_INSTS_V

5244: --------------------------------------------------------------------------------
5245: --Start of Comments
5246: --Bug #2723498 : 11.5.9 enhancement for splitting assets by serial number
5247: --API Name : create_srl_num_trx
5248: --Description : Local API will create serial_number records in OKL_TXL_ITM_INSTS_V
5249: -- If financial asset inventory item is serialized
5250: --History : 03-Nov-2002 avsingh Creation (for asset split by serial numbers)
5251: --End of comments
5252: --------------------------------------------------------------------------------

Line 5355: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

5351: --Bug# 5946411: ER -- End
5352:
5353: srl_num_rec2 srl_num_csr2%ROWTYPE;
5354:
5355: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5356: i NUMBER DEFAULT 0;
5357: lx_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5358:
5359: --Cursor to get install site use id

Line 5357: lx_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

5353: srl_num_rec2 srl_num_csr2%ROWTYPE;
5354:
5355: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5356: i NUMBER DEFAULT 0;
5357: lx_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5358:
5359: --Cursor to get install site use id
5360: CURSOR inst_site_csr (pty_site_id IN NUMBER) IS
5361: SELECT TO_CHAR(Party_site_use_id) party_site_use_id

Line 5390: l_pty_site_use_id okl_txl_itm_insts.object_id1_new%TYPE;

5386:
5387: l_address VARCHAR2(80);
5388: --END BUG# 3569441
5389:
5390: l_pty_site_use_id okl_txl_itm_insts.object_id1_new%TYPE;
5391: l_error_condition EXCEPTION;
5392:
5393: l_ib_tbl ib_tbl_type;
5394: l_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

Line 5666: okl_txl_itm_insts_pub.create_txl_itm_insts(

5662: CLOSE srl_num_csr;
5663: END IF; --srl_tbl count is = 0
5664: IF l_iipv_tbl.COUNT > 0 THEN
5665: --call api to create records for srl num trx
5666: okl_txl_itm_insts_pub.create_txl_itm_insts(
5667: p_api_version => p_api_version,
5668: p_init_msg_list => p_init_msg_list,
5669: x_return_status => x_return_status,
5670: x_msg_count => x_msg_count,

Line 5856: FROM okl_txl_itm_insts

5852: SELECT '!'
5853: FROM dual
5854: WHERE EXISTS
5855: (SELECT 1
5856: FROM okl_txl_itm_insts
5857: WHERE tal_id = p_tal_id
5858: AND tal_type = 'ALI');
5859:
5860: l_srl_exists VARCHAR2(1) DEFAULT '?';

Line 5866: FROM okl_txl_itm_insts

5862: --Bug #2723498 11.5.9 enhancement - Splitting assets by serial numbers
5863: --cursor to fetch all the serail numbers
5864: CURSOR get_srl_csr (p_tal_id IN NUMBER) IS
5865: SELECT id
5866: FROM okl_txl_itm_insts
5867: WHERE tal_id = p_tal_id
5868: AND tal_type = 'ALI';
5869:
5870: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

Line 5870: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

5866: FROM okl_txl_itm_insts
5867: WHERE tal_id = p_tal_id
5868: AND tal_type = 'ALI';
5869:
5870: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5871: l_iipv_count NUMBER;
5872: l_iipv_id NUMBER;
5873:
5874: l_ib_tbl ib_tbl_type;

Line 6630: okl_txl_itm_insts_pub.delete_txl_itm_insts(

6626: CLOSE get_srl_csr;
6627:
6628: IF l_iipv_tbl.COUNT > 0 THEN
6629: --delete the old records
6630: okl_txl_itm_insts_pub.delete_txl_itm_insts(
6631: p_api_version => p_api_version,
6632: p_init_msg_list => p_init_msg_list,
6633: x_return_status => x_return_status,
6634: x_msg_count => x_msg_count,

Line 13345: FROM OKL_TXL_ITM_INSTS iti

13341: --Bug # 2726870 11.5.9 enhancements - split asset into components
13342: --cursor to check if instance is to be split out in case of split asset by serial numbers
13343: CURSOR chk_instance_csr (PInstanceId IN NUMBER,PTalId IN NUMBER ) IS
13344: SELECT '!'
13345: FROM OKL_TXL_ITM_INSTS iti
13346: WHERE iti.instance_id = PInstanceId
13347: AND iti.tal_id = PTalId
13348: AND NVL(iti.selected_for_split_flag,'N') = 'Y'
13349: AND iti.tal_type = 'ALI';

Line 13424: FROM okl_txl_itm_insts

13420: --cursor to get the serial numbers for serialized split asset components
13421: CURSOR comp_srl_csr (p_asd_id IN NUMBER) IS
13422: SELECT serial_number,
13423: id
13424: FROM okl_txl_itm_insts
13425: WHERE asd_id = p_asd_id
13426: AND NVL(selected_for_split_flag,'N') = 'Y';
13427:
13428: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;

Line 13428: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;

13424: FROM okl_txl_itm_insts
13425: WHERE asd_id = p_asd_id
13426: AND NVL(selected_for_split_flag,'N') = 'Y';
13427:
13428: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;
13429:
13430: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13431: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13432:

Line 13430: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

13426: AND NVL(selected_for_split_flag,'N') = 'Y';
13427:
13428: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;
13429:
13430: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13431: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13432:
13433:
13434: BEGIN

Line 13431: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

13427:
13428: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;
13429:
13430: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13431: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13432:
13433:
13434: BEGIN
13435: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 13639: okl_txl_itm_insts_pub.update_txl_itm_insts

13635: l_iipv_rec.selected_for_split_flag := 'P';
13636: --dbms_output.put_line('before update of txl itm insts sts'||x_return_status);
13637: --dbms_output.put_line('before update of txl itm insts sts'||to_char(l_iipv_rec.id));
13638: --dbms_output.put_line('before update of txl itm insts sts'||to_char(l_iipv_rec.kle_id));
13639: okl_txl_itm_insts_pub.update_txl_itm_insts
13640: (p_api_version => p_api_version,
13641: p_init_msg_list => p_init_msg_list,
13642: x_return_status => x_return_status,
13643: x_msg_count => x_msg_count,

Line 16198: FROM okl_txl_itm_insts iti

16194:
16195: --Bug #2723498: 11.5.9 Split Asset by serial Number enhancement
16196: CURSOR srl_num_csr1 (PTalid IN NUMBER) IS
16197: SELECT COUNT(iti.serial_number)
16198: FROM okl_txl_itm_insts iti
16199: WHERE iti.tal_id = PTalid
16200: AND tal_type = 'ALI'
16201: AND NVL(selected_for_split_flag,'N') = 'Y';
16202:

Line 16207: FROM okl_txl_itm_insts iti

16203:
16204: CURSOR srl_num_csr2 (PTalId IN NUMBER,
16205: PTxdId IN NUMBER) IS
16206: SELECT COUNT(iti.serial_number)
16207: FROM okl_txl_itm_insts iti
16208: WHERE iti.tal_id = PTalId
16209: AND iti.asd_id = PTxdId
16210: AND tal_type = 'ALI'
16211: AND NVL(selected_for_split_flag,'N') = 'Y';

Line 16725: FROM okl_txl_itm_insts iti

16721: i NUMBER;
16722:
16723: CURSOR srl_num_csr1 (PTalid IN NUMBER) IS
16724: SELECT COUNT(iti.serial_number)
16725: FROM okl_txl_itm_insts iti
16726: WHERE iti.tal_id = PTalid
16727: AND tal_type = 'ALI'
16728: AND NVL(selected_for_split_flag,'N') = 'Y';
16729: