[Home] [Help]
PACKAGE: APPS.OKL_AM_ASSET_RELOCATION_PVT
Source
1 PACKAGE OKL_AM_ASSET_RELOCATION_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRARES.pls 115.4 2002/04/16 19:34:07 pkm ship $ */
3
4 TYPE falo_rec_type is RECORD( p_cle_id NUMBER DEFAULT OKC_API.G_MISS_NUM,
5 p_asset_id NUMBER DEFAULT OKC_API.G_MISS_NUM,
6 p_asset_number VARCHAR2(15),
7 p_corporate_book VARCHAR2(15),
8 p_current_units NUMBER DEFAULT OKC_API.G_MISS_NUM,
9 p_distribution_id NUMBER DEFAULT OKC_API.G_MISS_NUM,
10 p_units_assigned NUMBER DEFAULT OKC_API.G_MISS_NUM,
11 p_assigned_to NUMBER DEFAULT OKC_API.G_MISS_NUM,
12 p_code_combination_id NUMBER DEFAULT OKC_API.G_MISS_NUM,
13 p_old_location_id NUMBER DEFAULT OKC_API.G_MISS_NUM,
14 p_new_location_id NUMBER DEFAULT OKC_API.G_MISS_NUM);
15
16 TYPE falo_tbl_type IS TABLE OF falo_rec_type INDEX BY BINARY_INTEGER;
17
18
19
20
21 TYPE ialo_rec_type IS RECORD( p_instance_id NUMBER DEFAULT OKC_API.G_MISS_NUM,
22 p_location_id NUMBER DEFAULT OKC_API.G_MISS_NUM,
23 p_install_location_id NUMBER DEFAULT OKC_API.G_MISS_NUM );
24
25 TYPE ialo_tbl_type IS TABLE OF ialo_rec_type INDEX BY BINARY_INTEGER;
26
27 ---------------------------------------------------------------------------
28 -- GLOBAL CONSTANTS
29 ---------------------------------------------------------------------------
30 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_ASSET_RELOCATION_PVT';
31 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_api.G_APP_NAME;
32 G_API_VERSION CONSTANT NUMBER := 1;
33 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
34 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
35 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
36 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
37 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
38 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
39 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
40 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okc_api.G_INVALID_VALUE;
41 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
42 G_EXCEPTION_HALT_PROCESS EXCEPTION;
43
44 PROCEDURE Relocate_Installed_Item
45 ( p_api_version IN NUMBER
46 , p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
47 , x_return_status OUT NOCOPY VARCHAR2
48 , x_msg_count OUT NOCOPY NUMBER
49 , x_msg_data OUT NOCOPY VARCHAR2
50 , p_ialo_tbl IN ialo_tbl_type
51 ) ;
52
53 PROCEDURE Relocate_Fixed_Asset
54 ( p_api_version IN NUMBER
55 , p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
56 , x_return_status OUT NOCOPY VARCHAR2
57 , x_msg_count OUT NOCOPY NUMBER
58 , x_msg_data OUT NOCOPY VARCHAR2
59 , p_falo_tbl IN falo_tbl_type
60 ) ;
61
62 -- Change location of installed base item instance
63 PROCEDURE Change_Item_Location
64 ( p_api_version IN NUMBER
65 , p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
66 , x_msg_count OUT NOCOPY NUMBER
67 , x_msg_data OUT NOCOPY VARCHAR2
68 , x_return_status OUT NOCOPY VARCHAR2
69 , p_instance_id IN NUMBER
70 , p_location_id IN NUMBER
71 , p_install_location_id IN NUMBER DEFAULT NULL
72 );
73
74 PROCEDURE Change_FA_Location
75 ( p_api_version IN NUMBER
76 , p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
77 , x_return_status OUT NOCOPY VARCHAR2
78 , x_msg_count OUT NOCOPY NUMBER
79 , x_msg_data OUT NOCOPY VARCHAR2
80 , p_assets_tbl IN falo_tbl_type
81
82 );
83
84 END OKL_AM_ASSET_RELOCATION_PVT;