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 4554: l_serial_number okl_txl_itm_insts.serial_number%TYPE;

4550: --End of comments
4551: --------------------------------------------------------------------------------
4552: PROCEDURE Validate_Serial_Number(x_return_status OUT nocopy VARCHAR2,
4553: p_serial_number IN VARCHAR2) IS
4554: l_serial_number okl_txl_itm_insts.serial_number%TYPE;
4555:
4556: --Cursor to find existence
4557: CURSOR srl_num_csr (Srl_Number IN VARCHAR2) IS
4558: SELECT serial_number

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

4593: WHEN OTHERS THEN
4594: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4595: END Validate_Serial_Number;
4596: ---------------------------------------------------------------------------------------------------------------
4597: FUNCTION generate_instance_number_ib(x_instance_number_ib OUT NOCOPY OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE)
4598: RETURN VARCHAR2 IS
4599: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
4600: -- cursor to get sequence number for asset number
4601: CURSOR c_instance_no_ib IS

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

4632: --------------------------------------------------------------------------------
4633: --Start of Comments
4634: --Bug # 2726870: 11.5.9 enhancement for splitting assets by serial number
4635: --API Name : create_split_comp_srl_num
4636: --Description : API will create serial_number records in OKL_TXL_ITM_INSTS_V
4637: -- If financial asset inventory item is serialized for a split asset
4638: -- component
4639: --History : 03-Nov-2002 avsingh Creation (for asset split by serial numbers)
4640: -- Bug# 7047938

Line 4761: l_party_site_use_id okl_txl_itm_insts.object_id1_new%TYPE;

4757:
4758: l_address VARCHAR2(80);
4759: --END BUG# 3569441
4760:
4761: l_party_site_use_id okl_txl_itm_insts.object_id1_new%TYPE;
4762: l_itiv_tbl itiv_tbl_type;
4763: l_itiv_rec itiv_rec_type;
4764: lx_itiv_rec itiv_rec_type;
4765: i NUMBER;

Line 4767: l_instance_number OKL_TXL_ITM_INSTS.instance_number_ib%TYPE;

4763: l_itiv_rec itiv_rec_type;
4764: lx_itiv_rec itiv_rec_type;
4765: i NUMBER;
4766: j NUMBER;
4767: l_instance_number OKL_TXL_ITM_INSTS.instance_number_ib%TYPE;
4768:
4769: --Bug # 7047938
4770: cursor l_tal_csr (p_asd_id in number) is
4771: select tal_id

Line 4930: okl_txl_itm_insts_pub.create_txl_itm_insts

4926: RAISE OKL_API.G_EXCEPTION_ERROR;
4927: END IF;
4928: l_itiv_rec.instance_number_ib := l_instance_number;
4929: --create record
4930: okl_txl_itm_insts_pub.create_txl_itm_insts
4931: (p_api_version => p_api_version,
4932: p_init_msg_list => p_init_msg_list,
4933: x_return_status => x_return_status,
4934: x_msg_count => x_msg_count,

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

5216: --------------------------------------------------------------------------------
5217: --Start of Comments
5218: --Bug #2723498 : 11.5.9 enhancement for splitting assets by serial number
5219: --API Name : create_srl_num_trx
5220: --Description : Local API will create serial_number records in OKL_TXL_ITM_INSTS_V
5221: -- If financial asset inventory item is serialized
5222: --History : 03-Nov-2002 avsingh Creation (for asset split by serial numbers)
5223: --End of comments
5224: --------------------------------------------------------------------------------

Line 5327: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

5323: --Bug# 5946411: ER -- End
5324:
5325: srl_num_rec2 srl_num_csr2%ROWTYPE;
5326:
5327: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5328: i NUMBER DEFAULT 0;
5329: lx_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5330:
5331: --Cursor to get install site use id

Line 5329: lx_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

5325: srl_num_rec2 srl_num_csr2%ROWTYPE;
5326:
5327: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5328: i NUMBER DEFAULT 0;
5329: lx_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5330:
5331: --Cursor to get install site use id
5332: CURSOR inst_site_csr (pty_site_id IN NUMBER) IS
5333: SELECT TO_CHAR(Party_site_use_id) party_site_use_id

Line 5362: l_pty_site_use_id okl_txl_itm_insts.object_id1_new%TYPE;

5358:
5359: l_address VARCHAR2(80);
5360: --END BUG# 3569441
5361:
5362: l_pty_site_use_id okl_txl_itm_insts.object_id1_new%TYPE;
5363: l_error_condition EXCEPTION;
5364:
5365: l_ib_tbl ib_tbl_type;
5366: l_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

Line 5638: okl_txl_itm_insts_pub.create_txl_itm_insts(

5634: CLOSE srl_num_csr;
5635: END IF; --srl_tbl count is = 0
5636: IF l_iipv_tbl.COUNT > 0 THEN
5637: --call api to create records for srl num trx
5638: okl_txl_itm_insts_pub.create_txl_itm_insts(
5639: p_api_version => p_api_version,
5640: p_init_msg_list => p_init_msg_list,
5641: x_return_status => x_return_status,
5642: x_msg_count => x_msg_count,

Line 5828: FROM okl_txl_itm_insts

5824: SELECT '!'
5825: FROM dual
5826: WHERE EXISTS
5827: (SELECT 1
5828: FROM okl_txl_itm_insts
5829: WHERE tal_id = p_tal_id
5830: AND tal_type = 'ALI');
5831:
5832: l_srl_exists VARCHAR2(1) DEFAULT '?';

Line 5838: FROM okl_txl_itm_insts

5834: --Bug #2723498 11.5.9 enhancement - Splitting assets by serial numbers
5835: --cursor to fetch all the serail numbers
5836: CURSOR get_srl_csr (p_tal_id IN NUMBER) IS
5837: SELECT id
5838: FROM okl_txl_itm_insts
5839: WHERE tal_id = p_tal_id
5840: AND tal_type = 'ALI';
5841:
5842: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

Line 5842: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

5838: FROM okl_txl_itm_insts
5839: WHERE tal_id = p_tal_id
5840: AND tal_type = 'ALI';
5841:
5842: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5843: l_iipv_count NUMBER;
5844: l_iipv_id NUMBER;
5845:
5846: l_ib_tbl ib_tbl_type;

Line 6577: okl_txl_itm_insts_pub.delete_txl_itm_insts(

6573: CLOSE get_srl_csr;
6574:
6575: IF l_iipv_tbl.COUNT > 0 THEN
6576: --delete the old records
6577: okl_txl_itm_insts_pub.delete_txl_itm_insts(
6578: p_api_version => p_api_version,
6579: p_init_msg_list => p_init_msg_list,
6580: x_return_status => x_return_status,
6581: x_msg_count => x_msg_count,

Line 13292: FROM OKL_TXL_ITM_INSTS iti

13288: --Bug # 2726870 11.5.9 enhancements - split asset into components
13289: --cursor to check if instance is to be split out in case of split asset by serial numbers
13290: CURSOR chk_instance_csr (PInstanceId IN NUMBER,PTalId IN NUMBER ) IS
13291: SELECT '!'
13292: FROM OKL_TXL_ITM_INSTS iti
13293: WHERE iti.instance_id = PInstanceId
13294: AND iti.tal_id = PTalId
13295: AND NVL(iti.selected_for_split_flag,'N') = 'Y'
13296: AND iti.tal_type = 'ALI';

Line 13371: FROM okl_txl_itm_insts

13367: --cursor to get the serial numbers for serialized split asset components
13368: CURSOR comp_srl_csr (p_asd_id IN NUMBER) IS
13369: SELECT serial_number,
13370: id
13371: FROM okl_txl_itm_insts
13372: WHERE asd_id = p_asd_id
13373: AND NVL(selected_for_split_flag,'N') = 'Y';
13374:
13375: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;

Line 13375: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;

13371: FROM okl_txl_itm_insts
13372: WHERE asd_id = p_asd_id
13373: AND NVL(selected_for_split_flag,'N') = 'Y';
13374:
13375: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;
13376:
13377: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13378: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13379:

Line 13377: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

13373: AND NVL(selected_for_split_flag,'N') = 'Y';
13374:
13375: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;
13376:
13377: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13378: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13379:
13380:
13381: BEGIN

Line 13378: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

13374:
13375: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;
13376:
13377: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13378: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13379:
13380:
13381: BEGIN
13382: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 13586: okl_txl_itm_insts_pub.update_txl_itm_insts

13582: l_iipv_rec.selected_for_split_flag := 'P';
13583: --dbms_output.put_line('before update of txl itm insts sts'||x_return_status);
13584: --dbms_output.put_line('before update of txl itm insts sts'||to_char(l_iipv_rec.id));
13585: --dbms_output.put_line('before update of txl itm insts sts'||to_char(l_iipv_rec.kle_id));
13586: okl_txl_itm_insts_pub.update_txl_itm_insts
13587: (p_api_version => p_api_version,
13588: p_init_msg_list => p_init_msg_list,
13589: x_return_status => x_return_status,
13590: x_msg_count => x_msg_count,

Line 16106: FROM okl_txl_itm_insts iti

16102:
16103: --Bug #2723498: 11.5.9 Split Asset by serial Number enhancement
16104: CURSOR srl_num_csr1 (PTalid IN NUMBER) IS
16105: SELECT COUNT(iti.serial_number)
16106: FROM okl_txl_itm_insts iti
16107: WHERE iti.tal_id = PTalid
16108: AND tal_type = 'ALI'
16109: AND NVL(selected_for_split_flag,'N') = 'Y';
16110:

Line 16115: FROM okl_txl_itm_insts iti

16111:
16112: CURSOR srl_num_csr2 (PTalId IN NUMBER,
16113: PTxdId IN NUMBER) IS
16114: SELECT COUNT(iti.serial_number)
16115: FROM okl_txl_itm_insts iti
16116: WHERE iti.tal_id = PTalId
16117: AND iti.asd_id = PTxdId
16118: AND tal_type = 'ALI'
16119: AND NVL(selected_for_split_flag,'N') = 'Y';

Line 16633: FROM okl_txl_itm_insts iti

16629: i NUMBER;
16630:
16631: CURSOR srl_num_csr1 (PTalid IN NUMBER) IS
16632: SELECT COUNT(iti.serial_number)
16633: FROM okl_txl_itm_insts iti
16634: WHERE iti.tal_id = PTalid
16635: AND tal_type = 'ALI'
16636: AND NVL(selected_for_split_flag,'N') = 'Y';
16637: