[Home] [Help]
PACKAGE: APPS.IBY_DBCCARD_GRAPH_PVT
Source
1 PACKAGE IBY_DBCCARD_GRAPH_PVT AUTHID CURRENT_USER AS
2 /*$Header: ibyvgphs.pls 115.2 2002/11/20 01:07:19 jleybovi noship $*/
3
4 ------------------------------------------------------------------------
5 -- Constants Declaration
6 ------------------------------------------------------------------------
7
8 C_PERIOD_DAILY CONSTANT VARCHAR2(10) := 'DAILY';
9 C_PERIOD_WEEKLY CONSTANT VARCHAR2(10) := 'WEEKLY';
10 C_PERIOD_MONTHLY CONSTANT VARCHAR2(10) := 'MONTHLY';
11 C_PERIOD_YEARLY CONSTANT VARCHAR2(10) := 'YEARLY';
12
13 C_STATUS_SUCCESS CONSTANT VARCHAR2(10) := 'SUCCESS';
14 C_STATUS_FAILED CONSTANT VARCHAR2(10) := 'FAILED';
15 C_STATUS_PENDING CONSTANT VARCHAR2(10) := 'PENDING';
16 C_STATUS_UNKNOWN CONSTANT VARCHAR2(10) := 'UNKNOWN';
17
18 C_OUTPUTTYPE_TRXN CONSTANT VARCHAR2(10) := 'TRXN';
19 C_OUTPUTTYPE_AMOUNT CONSTANT VARCHAR2(10) := 'AMOUNT';
20
21 -------------------------------------------------------------------------
22 --**Defining all DataStructures required by the procedures**--
23 -- The following input and output PL/SQL record/table types are defined
24 -- to store the objects (entities) necessary for the Instrument Registration
25 -- PL/SQL APIs.
26 -------------------------------------------------------------------------
27
28 --INPUT and OUTPUT DataStructures
29 --1. Record Types
30
31 TYPE HourlyVol_rec_type IS RECORD (
32 columnId NUMBER(2) := 0,
33 totalTrxn NUMBER := 0,
34 time VARCHAR2(10)
35 );
36
37 TYPE TrxnTrends_rec_type IS RECORD (
38 month VARCHAR2(10),
39 value NUMBER := 0,
40 type VARCHAR2(100),
41 tdate DATE
42 );
43
44 --2. Table Types
45
46 TYPE HourlyVol_tbl_type IS TABLE OF HourlyVol_rec_type
47 INDEX BY BINARY_INTEGER;
48
49 TYPE TrxnTrends_tbl_type IS TABLE OF TrxnTrends_rec_type
50 INDEX BY BINARY_INTEGER;
51
52 TYPE Trends_tbl_type IS TABLE OF TrxnTrends_rec_type;
53
54 --------------------------------------------------------------------------------------
55 -- API Signatures--
56 --------------------------------------------------------------------------------------
57 -- 1. Get_Hourly_Volume
58 -- Start of comments
59 -- API name : Get_Hourly_Volume
60 -- Type : Private
61 -- Pre-reqs : None
62 -- Function : Fetches the information for hourly transaction.
63 -- Parameters :
64 -- IN : payee_id IN VARCHAR2
65 -- HourlyVol_tbl OUT HourlyVol_tbl_type
66 -- End of comments
67 --------------------------------------------------------------------------------------
68 Procedure Get_Hourly_Volume ( payee_id IN VARCHAR2,
69 HourlyVol_tbl OUT NOCOPY HourlyVol_tbl_type
70 );
71
72 --------------------------------------------------------------------------------------
73 -- 2. Get_Trxn_Trends
74 -- Start of comments
75 -- API name : Get_Trxn_Trends
76 -- Type : Private
77 -- Pre-reqs : None
78 -- Function : Fetches the information for Credit/Purchase Cards.
79 -- Parameters :
80 -- IN : payee_id IN VARCHAR2
81 -- output_type IN VARCHAR2
82 -- OUT : TrxnTrend_tbl OUT TrxnTrends_tbl_type
83 -- End of comments
84 --------------------------------------------------------------------------------------
85 Procedure Get_Trxn_Trends ( payee_id IN VARCHAR2,
86 output_type IN VARCHAR2,
87 TrxnTrend_tbl OUT NOCOPY TrxnTrends_tbl_type
88 );
89
90 --------------------------------------------------------------------------------------
91 -- 3. Get_Processor_Trends
92 -- Start of comments
93 -- API name : Get_Processor_Trends
94 -- Type : Private
95 -- Pre-reqs : None
96 -- Function : Fetches the information for Processors.
97 -- Parameters :
98 -- IN : payee_id IN VARCHAR2
99 -- output_type IN VARCHAR2
100 -- OUT : TrxnTrend_tbl OUT TrxnTrends_tbl_type
101 -- End of comments
102 --------------------------------------------------------------------------------------
103 Procedure Get_Processor_Trends ( payee_id IN VARCHAR2,
104 output_type IN VARCHAR2,
105 TrxnTrend_tbl OUT NOCOPY TrxnTrends_tbl_type
106 );
107
108 --------------------------------------------------------------------------------------
109 -- 4. Get_Subtype_Trends
110 -- Start of comments
111 -- API name : Get_Subtype_Trends
112 -- Type : Private
113 -- Pre-reqs : None
114 -- Function : Fetches the information for Credit/Purchase Subtypes.
115 -- Parameters :
116 -- IN : payee_id IN VARCHAR2
117 -- output_type IN VARCHAR2
118 -- TrxnTrend_tbl OUT TrxnTrends_tbl_type
119 -- End of comments
120 --------------------------------------------------------------------------------------
121 Procedure Get_Subtype_Trends ( payee_id IN VARCHAR2,
122 output_type IN VARCHAR2,
123 TrxnTrend_tbl OUT NOCOPY TrxnTrends_tbl_type
124 );
125
126 --------------------------------------------------------------------------------------
127 -- 5. Get_Failure_Trends
128 -- Start of comments
129 -- API name : Get_Failure_Trends
130 -- Type : Private
131 -- Pre-reqs : None
132 -- Function : Fetches the information for Authorization and Settlement failures.
133 -- Parameters :
134 -- IN : payee_id IN VARCHAR2
135 -- output_type IN VARCHAR2
136 -- TrxnTrend_tbl OUT NOCOPY TrxnTrends_tbl_type
137 -- End of comments
138 --------------------------------------------------------------------------------------
139 Procedure Get_Failure_Trends ( payee_id IN VARCHAR2,
140 output_type IN VARCHAR2,
141 TrxnTrend_tbl OUT NOCOPY TrxnTrends_tbl_type
142 );
143
144 END IBY_DBCCARD_GRAPH_PVT;