PACKAGE: APPS.OKL_AM_CALC_QUOTE_STREAM_PVT

Source

1 PACKAGE      OKL_AM_CALC_QUOTE_STREAM_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRCQSS.pls 120.4 2007/04/10 10:14:54 akrangan noship $ */
3 
4   ---------------------------------------------------------------------------
5   -- GLOBAL DATASTRUCTURES
6   ---------------------------------------------------------------------------
7 
8   SUBTYPE qtev_rec_type	IS okl_trx_quotes_pub.qtev_rec_type;
9   SUBTYPE tqlv_rec_type	IS okl_txl_quote_lines_pub.tqlv_rec_type;
10   SUBTYPE tqlv_tbl_type	IS okl_txl_quote_lines_pub.tqlv_tbl_type;
11 
12   ---------------------------------------------------------------------------
13   -- GLOBAL VARIABLES
14   ---------------------------------------------------------------------------
15 
16   -- Line style from Lease Authoring APIs
17 
18   -- Sell Service Line Style
19   G_SERVICE_STYLE	CONSTANT VARCHAR2(30)	:= 'SOLD_SERVICE';
20   -- Link Service Asset Line Style
21   G_SERVICE_LINK_STYLE	CONSTANT VARCHAR2(30)	:= 'LINK_SERV_ASSET';
22   -- Fee Line Style
23   G_FEE_STYLE		CONSTANT VARCHAR2(30)	:= 'FEE';
24   -- Link Fee Asset Line Style
25   G_FEE_LINK_STYLE	CONSTANT VARCHAR2(30)	:= 'LINK_FEE_ASSET';
26 
27   -- Separator for the list of processed line styles
28   G_SEP			CONSTANT VARCHAR2(30)	:= ':';
29 
30   -- Default Formula for calculating Service and Fees
31   G_DEFAULT_FORMULA	CONSTANT VARCHAR2(30)	:= 'LINE_UNBILLED_STREAMS';
32 
33   -- A parameter to be passed to formula calculation API
34   G_FORMULA_PARAM_1	CONSTANT VARCHAR2(30)	:= 'STREAM TYPE';
35 
36   --SECHAWLA 21-APR-03 2925120 : Added this global constant to store the prorate ratio for Service and Fee lines
37   G_PRORATE_RATIO   CONSTANT NUMBER := 1;
38   --akrangan Bug 5495474 start
39   --similar to the above, for Contractual Fee, Unbilled Receivables
40   G_CONTRACTUAL_FEE_DONE VARCHAR2(3):='N';
41   G_UNBILLED_RECEIVABLES_DONE VARCHAR2(3):='N';
42   --akrangan Bug 5495474 end
43   -- Validation for missing fields
44   G_MISS_NUM		CONSTANT NUMBER		:= OKL_API.G_MISS_NUM;
45   G_MISS_CHAR		CONSTANT VARCHAR2(1)	:= OKL_API.G_MISS_CHAR;
46   G_MISS_DATE		CONSTANT DATE		:= OKL_API.G_MISS_DATE;
47 
48   ---------------------------------------------------------------------------
49   -- GLOBAL MESSAGE CONSTANTS FOR ERROR HANDLING
50   ---------------------------------------------------------------------------
51 
52   G_APP_NAME		CONSTANT VARCHAR2(3)	:=  OKL_API.G_APP_NAME;
53   G_API_VERSION		CONSTANT NUMBER		:= 1;
54   G_PKG_NAME		CONSTANT VARCHAR2(200)	:=
55 					'OKL_AM_CALC_QUOTE_STREAM_PVT';
56 
57   G_SQLCODE_TOKEN	CONSTANT VARCHAR2(200)	:= 'SQLCODE';
58   G_SQLERRM_TOKEN	CONSTANT VARCHAR2(200)	:= 'SQLERRM';
59   G_UNEXPECTED_ERROR	CONSTANT VARCHAR2(200)	:=
60 					 'OKL_CONTRACTS_UNEXPECTED_ERROR';
61 
62   -- rmunjulu 4996136 :
63   -- set in OKL_AM_CALCULATE_QUOTE_PVT.process_top_formula_new() and
64   -- checked in OKL_AM_CALC_QUOTE_STREAM_PVT.process_outstanding_balances( )
65   -- to prevent duplicate of OUTSTANDING_BALANCE
66   G_OUTSTANDING_BAL_DONE VARCHAR2(3):='N';
67 
68   -- rmunjulu 16-mar-06 5066471 : similar to the above, for SERVICE AND MAINTANCE
69   G_SERVICE_BAL_DONE VARCHAR2(3):='N';
70 
71   ---------------------------------------------------------------------------
72   -- Procedures and Functions
73   ---------------------------------------------------------------------------
74 
75   -- The main body of the calculate quote by stream type
76   PROCEDURE calc_stream_type_operand (
77 		p_operand	IN VARCHAR2,
78 		p_qtev_rec	IN qtev_rec_type,
79 		p_cle_id	IN NUMBER,
80 		p_formula_name	IN VARCHAR2 DEFAULT NULL,
81 		px_tqlv_tbl	IN OUT NOCOPY tqlv_tbl_type,
82 		x_operand_total	OUT NOCOPY NUMBER,
83 		x_return_status	OUT NOCOPY VARCHAR2);
84 
85 END OKL_AM_CALC_QUOTE_STREAM_PVT;