DBA Data[Home] [Help]

APPS.OKL_TXL_ITM_INSTS_PVT dependencies on OKL_TXL_ITM_INSTS_PVT

Line 1: package body OKL_TXL_ITM_INSTS_PVT as

1: package body OKL_TXL_ITM_INSTS_PVT as
2: /* $Header: OKLCITIB.pls 120.6 2005/10/30 04:03:39 appldev noship $ */
3:
4: /*
5: * sjalasut: aug 18, 04 added constants used in raising business event. BEGIN

Line 1007: l_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;

1003: AND inststyle.lty_code = 'INST_ITEM'
1004: AND txl.kle_id = inst.id
1005: AND ff2.cle_id = p_asset_id;
1006:
1007: l_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1008: x_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1009:
1010: l_iti_rec okl_iti_pvt.iti_rec_type;
1011: l_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;

Line 1008: x_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;

1004: AND txl.kle_id = inst.id
1005: AND ff2.cle_id = p_asset_id;
1006:
1007: l_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1008: x_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1009:
1010: l_iti_rec okl_iti_pvt.iti_rec_type;
1011: l_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1012: x_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;

Line 1011: l_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;

1007: l_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1008: x_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1009:
1010: l_iti_rec okl_iti_pvt.iti_rec_type;
1011: l_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1012: x_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1013:
1014: l_itiv_rec okl_iti_pvt.itiv_rec_type;
1015:

Line 1012: x_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;

1008: x_iivv_tbl okl_txl_itm_insts_pvt.iivv_tbl_type;
1009:
1010: l_iti_rec okl_iti_pvt.iti_rec_type;
1011: l_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1012: x_iivv_rec okl_txl_itm_insts_pvt.iivv_rec_type;
1013:
1014: l_itiv_rec okl_iti_pvt.itiv_rec_type;
1015:
1016: x_no_data_found BOOLEAN;

Line 1230: okl_txl_itm_insts_pvt.update_txl_itm_insts(

1226:
1227: --dbms_output.put_line('ID: '||l_iivv_rec.id);
1228: --dbms_output.put_line('SRL No: '||l_iivv_rec.serial_number);
1229:
1230: okl_txl_itm_insts_pvt.update_txl_itm_insts(
1231: p_api_version => 1.0,
1232: p_init_msg_list => p_init_msg_list,
1233: x_return_status => x_return_status,
1234: x_msg_count => x_msg_count,

Line 1284: END OKL_TXL_ITM_INSTS_PVT;

1280: x_msg_data,
1281: '_PVT');
1282: END reset_item_srl_number;
1283:
1284: END OKL_TXL_ITM_INSTS_PVT;