DBA Data[Home] [Help]

PACKAGE: APPS.OKL_AM_REMARKET_ASSET_PUB

Source


1 PACKAGE OKL_AM_REMARKET_ASSET_PUB AS
2 /* $Header: OKLPRMKS.pls 120.3 2005/10/30 03:34:19 appldev noship $ */
3 
4 
5 ---------------------------------------------------------------------------
6    --  GLOBAL CONSTANTS
7   ---------------------------------------------------------------------------
8 
9    G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_AM_REMARKET_ASSET_PUB';
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 
17 
18   -- create item for remarketing
19 PROCEDURE create_rmk_item
20 (    p_api_version           IN  	NUMBER,
21      p_init_msg_list         IN  	VARCHAR2 DEFAULT OKL_API.G_FALSE,
22      p_item_number           IN     VARCHAR2, -- 04-OCT-04 SECHAWLA  3924244 : added new parameter
23      p_Item_Description      IN     VARCHAR2,
24      p_Item_Price            IN     NUMBER DEFAULT OKL_API.G_MISS_NUM,
25      p_quantity              IN     NUMBER DEFAULT 1,
26      x_return_status         OUT 	NOCOPY VARCHAR2,
27      x_msg_count             OUT 	NOCOPY NUMBER,
28      x_msg_data              OUT 	NOCOPY VARCHAR2,
29      x_new_item_number       OUT    NOCOPY VARCHAR2,
30      x_new_item_id           OUT    NOCOPY NUMBER
31 );
32 
33 
34 -- remove item
35 PROCEDURE remove_rmk_item
36 (    p_api_version           IN  	NUMBER,
37      p_init_msg_list         IN  	VARCHAR2 DEFAULT OKL_API.G_FALSE,
38      --  SECHAWLA 21-OCT-04 3924244   : changed p_order_header_id to p_order_line_id
39      p_order_line_Id         IN     NUMBER ,
40      x_return_status         OUT 	NOCOPY VARCHAR2,
41      x_msg_count             OUT 	NOCOPY NUMBER,
42      x_msg_data              OUT 	NOCOPY VARCHAR2
43 
44 );
45 
46 
47 
48 END OKL_AM_REMARKET_ASSET_PUB;