DBA Data[Home] [Help]

PACKAGE: APPS.OKL_AM_PROCESS_ASSET_TRX_PUB

Source


1 PACKAGE OKL_AM_PROCESS_ASSET_TRX_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPAMAS.pls 115.7 2002/05/02 20:59:06 sechawla noship $ */
3 
4 ---------------------------------------------------------------------------
5    --  GLOBAL CONSTANTS
6   ---------------------------------------------------------------------------
7 
8    G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_AM_PROCESS_ASSET_TRX_PUB';
9    G_APP_NAME             CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
10    G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11    G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLerrm';
12    G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLcode';
13 
14 
15 
16    -- wrapper for executing OKL_AM_PROCESS_ASSET_TRX_PVT as a concurrent program
17    PROCEDURE process_transactions_wrap(	ERRBUF                  OUT 	NOCOPY VARCHAR2,
18                                         RETCODE                 OUT     NOCOPY VARCHAR2 ,
19                                         p_api_version           IN  	NUMBER,
20            			                    p_init_msg_list         IN  	VARCHAR2 DEFAULT OKC_API.G_FALSE,
21                                         p_contract_id           IN      NUMBER   DEFAULT NULL,
22                                         p_asset_id              IN      NUMBER   DEFAULT NULL,
23                                         p_kle_id                IN      VARCHAR2 DEFAULT NULL,
24                                         p_salvage_writedown_yn  IN      VARCHAR2 DEFAULT 'N'
25 
26                                      )   ;
27 
28 
29    --  The main body of OKL_AM_PROCESS_ASSET_TRX_PUB
30    PROCEDURE process_transactions( p_api_version           IN   NUMBER,
31                               p_init_msg_list         IN   VARCHAR2 DEFAULT OKC_API.G_FALSE,
32                               x_return_status         OUT  NOCOPY VARCHAR2,
33                               x_msg_count             OUT  NOCOPY NUMBER,
34                               x_msg_data              OUT  NOCOPY VARCHAR2,
35                               p_contract_id    	      IN   NUMBER DEFAULT NULL,
36                               p_asset_id              IN   NUMBER DEFAULT NULL,
37                               p_kle_id                IN   NUMBER DEFAULT NULL,
38                               p_salvage_writedown_yn  IN   VARCHAR2 DEFAULT 'N',
39                               x_total_count           OUT     NOCOPY NUMBER,
40                               x_processed_count       OUT     NOCOPY NUMBER,
41                               x_error_count           OUT     NOCOPY NUMBER);
42 
43 END OKL_AM_PROCESS_ASSET_TRX_PUB;