[Home] [Help]
PACKAGE: APPS.OKL_AM_REPURCHASE_ASSET_PVT
Source
1 PACKAGE OKL_AM_REPURCHASE_ASSET_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRRQUS.pls 115.2 2002/08/21 18:17:28 rmunjulu noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_REPURCHASE_ASSET_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
13 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
14 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
15 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
16 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
17 G_MAX_DATE_TOKEN CONSTANT VARCHAR2(200) := 'DATE_EFF_TO_MAX';
18 G_QUOTE_NUMBER_TOKEN CONSTANT VARCHAR2(200) := 'QUOTE_NUMBER';
19 G_YES CONSTANT VARCHAR2(1) := 'Y';
20 G_NO CONSTANT VARCHAR2(1) := 'N';
21
22 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
23
24 ---------------------------------------------------------------------------
25 -- GLOBAL DATASTRUCTURES
26 ---------------------------------------------------------------------------
27
28 SUBTYPE qtev_rec_type IS okl_trx_quotes_pub.qtev_rec_type;
29 SUBTYPE tqlv_tbl_type IS okl_txl_quote_lines_pub.tqlv_tbl_type;
30
31 ---------------------------------------------------------------------------
32 -- PROCEDURES
33 ---------------------------------------------------------------------------
34
35 PROCEDURE create_repurchase_quote(
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 p_qtev_rec IN qtev_rec_type,
42 p_tqlv_tbl IN tqlv_tbl_type,
43 x_qtev_rec OUT NOCOPY qtev_rec_type,
44 x_tqlv_tbl OUT NOCOPY tqlv_tbl_type);
45
46 PROCEDURE update_repurchase_quote(
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_qtev_rec IN qtev_rec_type,
53 p_tqlv_tbl IN tqlv_tbl_type,
54 x_qtev_rec OUT NOCOPY qtev_rec_type,
55 x_tqlv_tbl OUT NOCOPY tqlv_tbl_type);
56
57 END OKL_AM_REPURCHASE_ASSET_PVT;