DBA Data[Home] [Help]

PACKAGE: APPS.OKL_AM_ASSET_DISPOSE_PVT

Source


1 PACKAGE OKL_AM_ASSET_DISPOSE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRADPS.pls 120.4 2006/11/22 18:40:55 rravikir noship $ */
3 
4 
5   ---------------------------------------------------------------------------
6    --  GLOBAL CONSTANTS
7   ---------------------------------------------------------------------------
8 
9    G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_AM_ASSET_DISPOSE_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    G_REQUIRED_VALUE       CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15    G_INVALID_VALUE	      CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16    G_COL_NAME_TOKEN	      CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17 
18 
19 
20 
21 
22 
23 -- retire an asset
24   PROCEDURE dispose_asset (	p_api_version           IN  	NUMBER,
25            			p_init_msg_list         IN  	VARCHAR2 DEFAULT OKC_API.G_FALSE,
26                                 x_return_status         OUT 	NOCOPY VARCHAR2,
27                                 x_msg_count             OUT 	NOCOPY NUMBER,
28            			x_msg_data              OUT 	NOCOPY VARCHAR2,
29 				p_financial_asset_id    IN      NUMBER,
30                                 p_quantity              IN      NUMBER,
31                                 p_proceeds_of_sale      IN      NUMBER,
32                                 p_quote_eff_date        IN      DATE DEFAULT NULL, -- rmunjulu EDAT
33                                 p_quote_accpt_date      IN      DATE DEFAULT NULL, -- rmunjulu EDAT
34                                 p_legal_entity_id       IN      NUMBER); -- RRAVIKIR Legal Entity Changes
35 
36   -- retire an asset
37   --  SECHAWLA 21-OCT-04 3924244   : changed p_order_header_id to p_order_line_id
38   PROCEDURE dispose_asset (	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_order_line_id         IN      NUMBER) ;
44 
45    -- undo retirement
46    PROCEDURE undo_retirement(	p_api_version           IN  	NUMBER,
47            			p_init_msg_list         IN  	VARCHAR2 DEFAULT OKC_API.G_FALSE,
48                                 x_return_status         OUT 	NOCOPY VARCHAR2,
49                                 x_msg_count             OUT 	NOCOPY NUMBER,
50            			x_msg_data              OUT 	NOCOPY VARCHAR2,
51 				p_retirement_id         IN      NUMBER);
52 
53    -- Expire an existing installed base item instance
54    PROCEDURE expire_item (
55 		p_api_version		IN  NUMBER,
56 		p_init_msg_list		IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
57 		x_msg_count	    	OUT NOCOPY NUMBER,
58 		x_msg_data		    OUT NOCOPY VARCHAR2,
59 		x_return_status		OUT NOCOPY VARCHAR2,
60 		p_instance_id		IN  NUMBER,
61 		p_end_date		    IN  DATE);
62 
63 
64 
65 END; -- Package spec