[Home] [Help]
PACKAGE: APPS.OKL_AM_RESTRUCTURE_QUOTE_PVT
Source
1 PACKAGE OKL_AM_RESTRUCTURE_QUOTE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRRTQS.pls 115.2 2002/08/16 01:04:58 rdraguil noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_RESTRUCTURE_QUOTE_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12
13 G_YES CONSTANT VARCHAR2(1) := 'Y';
14 G_NO CONSTANT VARCHAR2(1) := 'N';
15
16 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
17
18 G_OKC_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
22
23 ---------------------------------------------------------------------------
24 -- GLOBAL DATASTRUCTURES
25 ---------------------------------------------------------------------------
26 SUBTYPE quot_rec_type IS OKL_TRX_QUOTES_PUB.qtev_rec_type;
27 SUBTYPE quot_tbl_type IS OKL_TRX_QUOTES_PUB.qtev_tbl_type;
28
29 ---------------------------------------------------------------------------
30 -- PROCEDURES
31 ---------------------------------------------------------------------------
32 PROCEDURE create_restructure_quote(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_quot_rec IN quot_rec_type,
39 x_quot_rec OUT NOCOPY quot_rec_type);
40
41 PROCEDURE create_restructure_quote(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 p_quot_tbl IN quot_tbl_type,
48 x_quot_tbl OUT NOCOPY quot_tbl_type);
49
50 PROCEDURE update_restructure_quote(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_quot_rec IN quot_rec_type,
57 x_quot_rec OUT NOCOPY quot_rec_type);
58
59 PROCEDURE update_restructure_quote(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_quot_tbl IN quot_tbl_type,
66 x_quot_tbl OUT NOCOPY quot_tbl_type);
67
68
69 END OKL_AM_RESTRUCTURE_QUOTE_PVT;