DBA Data[Home] [Help]

PACKAGE: APPS.OKL_AM_PROCESS_ASSET_TRX_PVT

Source


1 PACKAGE OKL_AM_PROCESS_ASSET_TRX_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRAMAS.pls 115.15 2002/08/14 00:54:19 sechawla noship $ */
3 
4 
5   ---------------------------------------------------------------------------
6    --  GLOBAL CONSTANTS
7   ---------------------------------------------------------------------------
8 
9    G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_AM_PROCESS_ASSET_TRX_PVT';
10    G_APP_NAME             CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
11    G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
12    G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLerrm';
13    G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLcode';
14 
15 
16    G_TRANS_SUBTYPE	      CONSTANT FA_TRANSACTION_HEADERS.TRANSACTION_SUBTYPE%TYPE  := 'AMORTIZED';
17 
18 
19    -- wrapper for executing OKL_AM_PROCESS_ASSET_TRX_PVT as a concurrent program
20    PROCEDURE process_transactions_wrap(	ERRBUF                  OUT 	NOCOPY   VARCHAR2,
21                                         RETCODE                 OUT     NOCOPY   VARCHAR2 ,
22                                         p_api_version           IN  	NUMBER,
23            			                    p_init_msg_list         IN  	VARCHAR2 DEFAULT OKC_API.G_FALSE,
24                                         p_contract_id           IN      NUMBER   DEFAULT NULL,
25                                         p_asset_id              IN      NUMBER   DEFAULT NULL,
26                                         p_kle_id                IN      VARCHAR2 DEFAULT NULL,
27                                         p_salvage_writedown_yn  IN      VARCHAR2 DEFAULT 'N'
28 
29                                      )   ;
30 
31 
32 -- main body of OKL_AM_PROCESS_ASSET_TRX_PVT
33 
34    PROCEDURE process_transactions(	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_contract_id    	    IN 	    NUMBER DEFAULT NULL,
40                                 p_asset_id              IN      NUMBER DEFAULT NULL,
41                                 p_kle_id                IN      NUMBER DEFAULT NULL,
42                                 p_salvage_writedown_yn  IN      VARCHAR2 DEFAULT 'N',
43                                 x_total_count           OUT     NOCOPY NUMBER,
44                                 x_processed_count       OUT     NOCOPY NUMBER,
45                                 x_error_count           OUT     NOCOPY NUMBER  )   ;
46 
47 
48 
49 
50 
51 END; -- Package spec