[Home] [Help]
PACKAGE: APPS.OKL_SALES_QUOTE_QA_PVT
Source
1 PACKAGE OKL_SALES_QUOTE_QA_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRQQCS.pls 120.4 2006/04/12 11:20:02 ssdeshpa noship $ */
3
4 --------------------
5 -- PACKAGE CONSTANTS
6 --------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKLRQQCB.pls';
8 G_APP_NAME CONSTANT VARCHAR2(30) := OKL_API.G_APP_NAME;
9 G_API_VERSION CONSTANT NUMBER := 1;
10 G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
11 G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
12 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
13 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
14 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
15 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
16 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
17 G_DB_ERROR CONSTANT VARCHAR2(30) := 'OKL_DB_ERROR';
18 G_PKG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PKG_NAME';
19 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PROG_NAME';
20 G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := 'COL_NAME';
21 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLCODE';
22 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLERRM';
23 G_API_TYPE CONSTANT varchar2(4) := '_PVT';
24 G_FUNCTION_DATA_INVALID CONSTANT VARCHAR2(200) := 'OKL_FUNCTION_DATA_INVALID';
25 G_OPERAND_DATA_INVALID CONSTANT VARCHAR2(200) := 'OKL_OPERAND_DATA_INVALID';
26 G_FUNCTION_DOES_NOT_EXIST CONSTANT VARCHAR2(200) := 'OKL_FUNCTION_DOES_NOT_EXIST';
27 G_INVALID_FUNCTION CONSTANT VARCHAR2(200) := 'OKL_INVALID_FUNCTION';
28 -----------------------------------------------------------------------------
29 --Exception Delration
30
31 ------------------
32 -- DATA STRUCTURES
33 ------------------
34
35 TYPE qa_results_rec_type IS RECORD (
36 check_code VARCHAR2(30)
37 ,check_meaning VARCHAR2(80)
38 ,result_code VARCHAR2(30)
39 ,result_meaning VARCHAR2(80)
40 ,message_code VARCHAR2(30)
41 ,message_text VARCHAR2(2000)
42 );
43
44 TYPE qa_results_tbl_type IS TABLE OF qa_results_rec_type INDEX BY BINARY_INTEGER;
45 --------------------------------------------------------------------------------
46 --QA Checker Called By Quick Quote Validate API's
47 PROCEDURE run_qa_checker (
48 p_api_version IN NUMBER
49 ,p_init_msg_list IN VARCHAR2
50 ,p_object_type IN VARCHAR2
51 ,p_object_id IN NUMBER
52 ,x_return_status OUT NOCOPY VARCHAR2
53 ,x_msg_count OUT NOCOPY NUMBER
54 ,x_msg_data OUT NOCOPY VARCHAR2
55 ,x_qa_result OUT NOCOPY VARCHAR2
56 ,x_qa_result_tbl IN OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type);
57 --------------------------------------------------------------------------------
58 --QA Checker Called By the
59 --Lease Quote,Lease Application and Lease Opportunity Validate API's
60
61 PROCEDURE run_qa_checker (
62 p_api_version IN NUMBER
63 ,p_init_msg_list IN VARCHAR2
64 ,p_object_type IN VARCHAR2
65 ,p_object_id IN NUMBER
66 ,x_qa_result OUT NOCOPY VARCHAR2
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_msg_count OUT NOCOPY NUMBER
69 ,x_msg_data OUT NOCOPY VARCHAR2);
70 --------------------------------------------------------------------------------
71 ----------------
72 -- PROGRAM UNITS
73 ----------------
74 PROCEDURE run_qa_checker (
75 p_api_version IN NUMBER
76 ,p_init_msg_list IN VARCHAR2
77 ,p_object_type IN VARCHAR2
78 ,p_object_id IN NUMBER
79 ,x_return_status OUT NOCOPY VARCHAR2
80 ,x_msg_count OUT NOCOPY NUMBER
81 ,x_msg_data OUT NOCOPY VARCHAR2
82 ,x_qa_result_tbl OUT NOCOPY OKL_SALES_QUOTE_QA_PVT.qa_results_tbl_type);
83
84 ------------------------------------------------------------------------------
85 --Bug # 4688662 ssdeshpa start
86 FUNCTION are_all_lines_overriden(p_quote_id IN NUMBER
87 ,p_pricing_method IN VARCHAR2
88 ,p_line_level_pricing IN VARCHAR2
89 ,x_return_status OUT NOCOPY VARCHAR2)
90 RETURN VARCHAR2;
91 --Bug # 4688662 ssdeshpa end
92
93 END OKL_SALES_QUOTE_QA_PVT;