[Home] [Help]
PACKAGE: APPS.OKL_SPLIT_ASSET_COMP_PUB
Source
1 package OKL_SPLIT_ASSET_COMP_PUB AUTHID CURRENT_USER as
2 /* $Header: OKLPSACS.pls 115.1 2002/07/29 18:37:18 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_PUB';
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
15 ----------------------------------------------------------------------------------
16 --Global Exception
17 ----------------------------------------------------------------------------------
18 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19 ----------------------------------------------------------------------------------
20 --Public Procedures and Functions
21 ----------------------------------------------------------------------------------
22 -- PROCEDURE add_language;
23
24 PROCEDURE create_split_asset_comp(
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_asdv_tbl IN advv_tbl_type,
31 x_asdv_tbl OUT NOCOPY advv_tbl_type);
32
33 PROCEDURE update_split_asset_comp(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_asdv_tbl IN advv_tbl_type,
40 x_asdv_tbl OUT NOCOPY advv_tbl_type);
41
42 PROCEDURE delete_split_asset_comp(
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_asdv_tbl IN advv_tbl_type);
49
50 PROCEDURE process_split_asset_comp(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_tal_id IN NUMBER);
57
58
59 END OKL_SPLIT_ASSET_COMP_PUB;