[Home] [Help]
PACKAGE: APPS.OKL_AM_CREATE_QUOTE_PUB
Source
1 PACKAGE OKL_AM_CREATE_QUOTE_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPCQTS.pls 120.6.12010000.2 2009/06/15 21:55:39 sechawla ship $ */
3 /*#
4 * Create Termination Quote API allows users to create a termination quote
5 * @rep:scope internal
6 * @rep:product OKL
7 * @rep:displayname Create Termination Quote API
8 * @rep:category BUSINESS_ENTITY OKL_TERMINATION_QUOTE
9 * @rep:businessevent oracle.apps.okl.am.sendquote
10 * @rep:businessevent oracle.apps.okl.am.manualquote
11 * @rep:lifecycle active
12 * @rep:compatibility S
13 */
14
15
16
17 ---------------------------------------------------------------------------
18 -- GLOBAL MESSAGE CONSTANTS
19 ---------------------------------------------------------------------------
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_CREATE_QUOTE_PUB';
21 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
22 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
23 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
24 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
25
26 ---------------------------------------------------------------------------
27 -- GLOBAL VARIABLES
28 ---------------------------------------------------------------------------
29 SUBTYPE assn_tbl_type IS OKL_AM_CREATE_QUOTE_PVT.assn_tbl_type;
30 SUBTYPE quot_rec_type IS OKL_AM_CREATE_QUOTE_PVT.quot_rec_type;
31 SUBTYPE tqlv_tbl_type IS OKL_AM_CREATE_QUOTE_PVT.tqlv_tbl_type;
32 SUBTYPE qpyv_tbl_type IS OKL_AM_CREATE_QUOTE_PVT.qpyv_tbl_type;
33
34 -- SECHAWLA 02-JAN-03 2699412 -- new declarations
35 SUBTYPE achr_rec_type IS OKL_AM_CREATE_QUOTE_PVT.achr_rec_type;
36 SUBTYPE achr_tbl_type IS OKL_AM_CREATE_QUOTE_PVT.achr_tbl_type;
37
38
39 G_EMPTY_QPYV_TBL qpyv_tbl_type;
40
41
42
43 ---------------------------------------------------------------------------
44 -- PROCEDURES
45 ---------------------------------------------------------------------------
46
47 -- SECHAWLA 02-JAN-03 2699412 new procedure call
48 -- To do the advance search for a given contract details.
49 PROCEDURE advance_contract_search(
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_achr_rec IN achr_rec_type,
56 x_achr_tbl OUT NOCOPY achr_tbl_type);
57
58
59 /*#
60 * Create Termination Quote API creates the termination quote.
61 * @param p_api_version API version
62 * @param p_init_msg_list Initialize message stack
63 * @param x_return_status Return status from the API
64 * @param x_msg_count Message count if error messages are encountered
65 * @param x_msg_data Message data error message
66 * @param p_quot_rec Record type of termination quote details
67 * @param p_assn_tbl Table of records of assets on termination quote
68 * @param p_qpyv_tbl Table of records of parties on termination quote
69 * @param x_quot_rec Record type of termination quote details
70 * @param x_tqlv_tbl Table of records of termination quote lines
71 * @param x_assn_tbl Table of records of assets on termination quote
72 * @param p_term_from_intf To identify whether the quote is to be auto approved or not from Termination Interface
73 * @rep:displayname Create Termination Quote
74 * @rep:scope internal
75 * @rep:lifecycle active
76 * @rep:category BUSINESS_ENTITY OKL_CONTRACT_LIFECYCLE
77 */
78 PROCEDURE create_terminate_quote(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_quot_rec IN quot_rec_type,
85 p_assn_tbl IN assn_tbl_type,
86 p_qpyv_tbl IN qpyv_tbl_type DEFAULT G_EMPTY_QPYV_TBL,
87 x_quot_rec OUT NOCOPY quot_rec_type,
88 x_tqlv_tbl OUT NOCOPY tqlv_tbl_type,
89 x_assn_tbl OUT NOCOPY assn_tbl_type,
90 p_term_from_intf IN VARCHAR2 DEFAULT 'N'); --Added parameter by sechawla for bug 7383445
91
92
93
94 END OKL_AM_CREATE_QUOTE_PUB;