DBA Data[Home] [Help]

PACKAGE: APPS.ZX_JA_EXTRACT_PKG

Source


1 PACKAGE ZX_JA_EXTRACT_PKG AS
2 /* $Header: zxriextrajappvts.pls 120.1 2005/04/01 18:48:10 skorrapa noship $ */
3 
4 
5 --
6 -----------------------------------------
7 --Public Variable Declarations
8 -----------------------------------------
9 --
10 
11 -----------------------------------------
12 --Public Methods Declarations
13 -----------------------------------------
14 /*===========================================================================+
15  | PROCEDURE                                                                 |
16  |   FILTER_JA_AR_TAX_LINES                                                  |
17  |   Type       : Public                                                     |
18  |   Pre-req    : None                                                       |
19  |   Function   :                                                            |
20  |    This procedure is called to filter the records of transaction tables   |
21  |    by deleting all unnecessary rows in ZX_RE_TRX_DETAIL_T table           |
22  |                                                                           |
23  |    Called from ZX_EXTRACT_PKG                                             |
24  |                                                                           |
25  |   Parameters :                                                            |
26  |                                                                           |
27  |   MODIFICATION HISTORY                                                    |
28  |     27-Oct-03  Asako Takahashi   created                                  |
29  |                                                                           |
30  |                                                                           |
31  +===========================================================================*/
32 
33 
34 
35 PROCEDURE FILTER_JA_AR_TAX_LINES
36 (
37  P_TRL_GLOBAL_VARIABLES_REC	IN	ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
38 );
39 
40 /* Following parameters are removed since we now access global variables directly
41 (
42 P_REPORT_NAME            IN     varchar2,
43 P_REQUEST_ID             IN     number,
44 P_EXP_CERT_DATE_FROM     IN     date,
45 P_EXP_CERT_DATE_TO       IN     date,
46 P_EXP_METHOD             IN     varchar2,
47 P_TRX_SOURCE_ID          IN     number,
48 P_INCLUDE_REFERENCED_SOURCE IN  varchar2
49 );
50 */
51 
52 
53 /*===========================================================================+
54  | PROCEDURE                                                                 |
55  |   FILTER_JA_AP_TAX_LINES                                                  |
56  |   Type       : Public                                                     |
57  |   Pre-req    : None                                                       |
58  |   Function   :                                                            |
59  |    This procedure is called to filter the records of transaction tables   |
60  |    by deleting all unnecessary rows in ZX_RE_TRX_DETAIL_T table           |
61  |                                                                           |
62  |    Called from ZX_EXTRACT_PKG                                             |
63  |                                                                           |
64  |   Parameters :                                                            |
65  |                                                                           |
66  |   MODIFICATION HISTORY                                                    |
67  |     27-Oct-03  Asako Takahashi   created                                  |
68  |                                                                           |
69  |                                                                           |
70  +===========================================================================*/
71 
72 
73 PROCEDURE FILTER_JA_AP_TAX_LINES
74 (
75  P_TRL_GLOBAL_VARIABLES_REC	IN	ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
76 );
77 
78 /* Following parameters are removed since we now access global variables directly
79 (
80 P_REPORT_NAME            IN     varchar2,
81 P_REQUEST_ID             IN     number,
82 P_GUI_TYPE               IN     varchar2,
83 P_REPRINT                IN     varchar2,
84 -- P_APPLIED_TRX_NUMBER_LOW in     varchar2,
85 -- P_APPLIED_TRX_NUMBER_HIGH in    varchar2,
86 P_MRCSOBTYPE             in varchar2,
87 P_REPORTING_LEVEL        in varchar2,
88 P_REPORTING_CONTEXT      in number,
89 P_SET_OF_BOOKS_ID        in number
90 );
91 */
92 
93 /*===========================================================================+
94  | PROCEDURE                                                                 |
95  |   POPULATE_JA_AP(AR)                                                      |
96  |   Type       : Public                                                     |
97  |   Pre-req    : None                                                       |
98  |   Function   :                                                            |
99  |    This procedure calls the API to select the missing JA reports's        |
100  |    specific data                                                          |
101  |                                                                           |
102  |    Called from ZX_EXTRACT_PKG                                             |
103  |                                                                           |
104  |   Parameters :                                                            |
105  |                                                                           |
106  |   MODIFICATION HISTORY                                                    |
107  |     27-Oct-03  Asako Takahashi   created                                  |
108  |                                                                           |
109  |                                                                           |
110  +===========================================================================*/
111 PROCEDURE POPULATE_JA_AR
112 (
113  P_TRL_GLOBAL_VARIABLES_REC	IN	ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
114 );
115 
116 /* Following parameter is removed since we now access global variables directly
117 (P_REPORT_NAME in varchar2);
118 */
119 
120 PROCEDURE POPULATE_JA_AP
121 (
122  P_TRL_GLOBAL_VARIABLES_REC	IN	ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
123 );
124 
125 /* Following parameter is removed since we now access global variables directly
126 (P_REPORT_NAME in varchar2);
127 */
128 
129 END ZX_JA_EXTRACT_PKG;