[Home] [Help]
PACKAGE: APPS.OKL_AM_CONSOLIDATED_QTE_PVT
Source
1 PACKAGE OKL_AM_CONSOLIDATED_QTE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRCNQS.pls 115.1 2002/12/24 23:17:44 rmunjulu noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL CONSTANTS
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_CONSOLIDATED_QTE_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_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
13 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
14 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
15 G_YES CONSTANT VARCHAR2(1) := 'Y';
16 G_NO CONSTANT VARCHAR2(1) := 'N';
17
18 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19
20 SUBTYPE qtev_rec_type IS OKL_TRX_QUOTES_PUB.qtev_rec_type;
21 SUBTYPE qtev_tbl_type IS OKL_TRX_QUOTES_PUB.qtev_tbl_type;
22
23 PROCEDURE create_consolidate_quote (
24 p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 p_qtev_tbl IN qtev_tbl_type,
30 x_cons_rec OUT NOCOPY qtev_rec_type);
31
32 PROCEDURE update_consolidate_quote (
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_cons_rec IN qtev_rec_type,
39 x_cons_rec OUT NOCOPY qtev_rec_type,
40 x_qtev_tbl OUT NOCOPY qtev_tbl_type);
41
42
43 END OKL_AM_CONSOLIDATED_QTE_PVT;