DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_RELOCATION_PVT dependencies on OKC_API

Line 4: TYPE falo_rec_type is RECORD( p_cle_id NUMBER DEFAULT OKC_API.G_MISS_NUM,

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,

Line 5: p_asset_id NUMBER DEFAULT OKC_API.G_MISS_NUM,

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,

Line 8: p_current_units NUMBER DEFAULT OKC_API.G_MISS_NUM,

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,

Line 9: p_distribution_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,

Line 10: p_units_assigned 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);

Line 11: p_assigned_to NUMBER DEFAULT OKC_API.G_MISS_NUM,

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:

Line 12: p_code_combination_id NUMBER DEFAULT OKC_API.G_MISS_NUM,

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;

Line 13: p_old_location_id 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:

Line 14: p_new_location_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:

Line 21: TYPE ialo_rec_type IS RECORD( p_instance_id NUMBER DEFAULT OKC_API.G_MISS_NUM,

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;

Line 22: p_location_id NUMBER DEFAULT OKC_API.G_MISS_NUM,

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:

Line 23: p_install_location_id NUMBER DEFAULT OKC_API.G_MISS_NUM );

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: ---------------------------------------------------------------------------

Line 33: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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';

Line 40: G_INVALID_VALUE CONSTANT VARCHAR2(200) := okc_api.G_INVALID_VALUE;

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

Line 41: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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

Line 46: , p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 55: , p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 65: , p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 76: , p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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