[Home] [Help]
PACKAGE: APPS.OKL_STREAMS_RECON_PVT
Source
1 PACKAGE OKL_STREAMS_RECON_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRSCRS.pls 120.3 2007/01/09 12:36:04 udhenuko noship $ */
3
4 SUBTYPE FILE_TYPE IS UTL_FILE.FILE_TYPE;
5 TYPE LOG_MSG_TBL IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
6
7 ---------------------------------------------------------------------------
8 -- GLOBAL VARIABLES
9 ---------------------------------------------------------------------------
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
13 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STREAMS_RECON_PVT';
15
16
17 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
18 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
19 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
20 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
21 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
22
23 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
26 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
27 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
28
29 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
30 G_EXCEPTION_ERROR EXCEPTION;
31 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
32
33 G_LOG_DIR CONSTANT VARCHAR2(30) := 'ECX_UTL_LOG_DIR';
34
35 -- Variables for XML Publisher Report input parameters
36 P_CONTRACT_NUMBER okc_k_headers_b.contract_number%TYPE;
37 P_END_DATE VARCHAR2(120);
38
39 --------------------------------------------------------------------------------
40 -- Start of Commnets
41 -- Suresh Gorantla
42 -- Procedure Name : recon_qry
43 -- Description : Generates the streams reconciliation report
44 -- Business Rules : we need to reconcile the streams amount
45 -- We reconcile the Total streams, Billed streams
46 -- cancled streams , Unbilled streams and
47 -- then get the differences
48 -- If the there is value for unbilled streams
49 -- Send we show the amount for each deal type and
50 -- associated products for the same.
51 -- If the there is value for difference streams
52 -- Send we show the amount for total billed amount
53 -- unbilled amounts, canceled amount and then difference
54 -- Difference amout = total_billed_amount - billed streams
55 -- - Canceled streams - Unbilled streams.
56 -- Parameters : p_contract_number, p_end_date
57 -- Version : 1.0
58 -- History : SGORANTL 20-jan-2004 - xxxxxxx created
59 -- End of Commnets
60 --------------------------------------------------------------------------------
61 PROCEDURE recon_qry (p_errbuf OUT NOCOPY VARCHAR2,
62 p_retcode OUT NOCOPY NUMBER,
63 p_contract_number IN okc_k_headers_b.contract_number%TYPE DEFAULT NULL,
64 p_end_date IN VARCHAR2 DEFAULT NULL);
65
66 -------------------------------------------------------------------------------
67 -- FUNCTION xml_recon_qry
68 -------------------------------------------------------------------------------
69 -- Start of comments
70 --
71 -- Procedure Name : xml_recon_qry
72 -- Description : Function for Billable Streams reconciliation Report Generation
73 -- in XML Publisher
74 -- Business Rules :
75 -- Parameters : p_contract_number, p_end_date
76 -- Version : 1.0
77 -- History : 03-Jan-2007 UDHENUKO created.
78 -- End of comments
79 -------------------------------------------------------------------------------
80 FUNCTION xml_recon_qry RETURN BOOLEAN;
81 END OKL_STREAMS_RECON_PVT;