[Home] [Help]
PACKAGE: APPS.OKL_SPLIT_ASSET_COMP_PVT
Source
1 package OKL_SPLIT_ASSET_COMP_PVT AUTHID CURRENT_USER as
2 /* $Header: OKLRSACS.pls 115.1 2002/07/29 18:37:13 cklee noship $ */
3
4 subtype advv_rec_type is okl_asd_pvt.asdv_rec_type;
5 subtype advv_tbl_type is okl_asd_pvt.asdv_tbl_type;
6 ---------------------------------------------------------------------------
7 -- GLOBAL MESSAGE CONSTANTS , VARIABLES
8 ---------------------------------------------------------------------------
9 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SPLIT_ASSET_COMP_PVT';
10 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
14 G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
15 G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := 'COL_NAME';
16 G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
17
18 ----------------------------------------------------------------------------------
19 --Global Exception
20 ----------------------------------------------------------------------------------
21 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
22
23 ----------------------------------------------------------------------------------
24 --Public Procedures and Functions
25 ----------------------------------------------------------------------------------
26 -- PROCEDURE add_language;
27
28 PROCEDURE create_split_asset_comp(
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2,
34 p_asdv_tbl IN advv_tbl_type,
35 x_asdv_tbl OUT NOCOPY advv_tbl_type);
36
37 PROCEDURE update_split_asset_comp(
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_asdv_tbl IN advv_tbl_type,
44 x_asdv_tbl OUT NOCOPY advv_tbl_type);
45
46 PROCEDURE delete_split_asset_comp(
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_asdv_tbl IN advv_tbl_type);
53
54 PROCEDURE process_split_asset_comp(
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_tal_id IN NUMBER);
61
62
63 END OKL_SPLIT_ASSET_COMP_PVT;