[Home] [Help]
PACKAGE: APPS.OKL_EQUIPMENT_EXCHANGE_PVT
Source
1 package okl_equipment_exchange_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLREQXS.pls 115.2 2002/11/30 08:46:59 spillaip noship $ */
3 SUBTYPE thpv_tbl_type IS okl_trx_assets_pvt.tavv_tbl_type;
4 SUBTYPE tlpv_tbl_type IS okl_txl_assets_pvt.tlvv_tbl_type;
5 SUBTYPE talv_tbl_type IS okl_txl_assets_pvt.tlvv_tbl_type;
6 SUBTYPE iipv_tbl_type IS okl_txl_itm_insts_pvt.iivv_tbl_type;
7 SUBTYPE itiv_tbl_type IS okl_iti_pvt.itiv_tbl_type;
8
9 SUBTYPE cvmv_rec_type IS OKL_OKC_MIGRATION_PVT.CVMV_REC_TYPE;
10
11
12 FUNCTION GET_TAS_HDR_REC
13 (p_thpv_tbl IN thpv_tbl_type
14 ,p_no_data_found OUT NOCOPY BOOLEAN
15 ) RETURN thpv_tbl_type;
16 FUNCTION get_status
17 (p_status_code IN VARCHAR2)
18 RETURN VARCHAR2;
19 FUNCTION get_tal_rec
20 (p_talv_tbl IN talv_tbl_type,
21 x_no_data_found OUT NOCOPY BOOLEAN)
22 RETURN talv_tbl_type;
23 FUNCTION get_vendor_name
24 (p_vendor_id IN VARCHAR2)
25 RETURN VARCHAR2;
26
27 FUNCTION get_item_rec (
28 p_itiv_tbl IN itiv_tbl_type,
29 x_no_data_found OUT NOCOPY BOOLEAN) RETURN itiv_tbl_type;
30
31 FUNCTION get_exchange_type
32 (p_tas_id IN NUMBER)
33 RETURN VARCHAR2;
34
35 PROCEDURE update_serial_number(
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
38 p_instance_id IN NUMBER,
39 p_instance_name IN VARCHAR2,
40 p_serial_number IN VARCHAR2,
41 p_inventory_item_id IN NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2);
45
46 PROCEDURE store_exchange_details (
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
49 p_thpv_tbl IN thpv_tbl_type,
50 p_old_tlpv_tbl IN tlpv_tbl_type,
51 p_new_tlpv_tbl IN tlpv_tbl_type,
52 p_old_iipv_tbl IN iipv_tbl_type,
53 p_new_iipv_tbl IN iipv_tbl_type,
54 x_thpv_tbl OUT NOCOPY thpv_tbl_type,
55 x_old_tlpv_tbl OUT NOCOPY tlpv_tbl_type,
56 x_new_tlpv_tbl OUT NOCOPY tlpv_tbl_type,
57 x_old_iipv_tbl OUT NOCOPY iipv_tbl_type,
58 x_new_iipv_tbl OUT NOCOPY iipv_tbl_type,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2);
62
63 PROCEDURE exchange(
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 := OKL_API.G_FALSE,
66 p_tas_id IN NUMBER,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2);
70
71 END okl_equipment_exchange_pvt;