PACKAGE: APPS.OKL_AM_LOAD_CAT_BK_PUB

Source

1 PACKAGE OKL_AM_LOAD_CAT_BK_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPLCBS.pls 120.2 2005/10/30 04:25:34 appldev noship $ */
3 
4 
5    SUBTYPE amhv_tbl_type IS OKL_AM_LOAD_CAT_BK_PVT.amhv_tbl_type;
6 ---------------------------------------------------------------------------
7    --  GLOBAL CONSTANTS
8   ---------------------------------------------------------------------------
9 
10    G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_AM_LOAD_CAT_BK_PUB';
11    G_APP_NAME             CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
12    G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
13    G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLerrm';
14    G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLcode';
15 
16 
17 
18    --  The main body of OKL_AM_LOAD_CAT_BK_PUB
19    PROCEDURE create_hold_setup_trx( p_api_version           IN   NUMBER,
20                                   p_init_msg_list         IN   VARCHAR2 DEFAULT OKL_API.G_FALSE,
21                                   p_book_type_code        IN   fa_book_controls.book_type_code%type,
22                                   x_return_status         OUT  NOCOPY VARCHAR2,
23                                   x_msg_count             OUT  NOCOPY NUMBER,
24                                   x_msg_data              OUT  NOCOPY VARCHAR2,
25                                   x_amhv_tbl              OUT  NOCOPY amhv_tbl_type
26                                   );
27 
28 END OKL_AM_LOAD_CAT_BK_PUB;