[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;