1 PACKAGE INV_MGD_MVT_CONC_PGM AUTHID CURRENT_USER AS
2 -- $Header: INVCPRGS.pls 120.1 2006/05/25 18:03:09 yawang noship $
3
4 --+=======================================================================+
5 --| Copyright (c) 1998 Oracle Corporation |
6 --| Redwood Shores, CA, USA |
7 --| All rights reserved. |
8 --+=======================================================================+
9 --| FILENAME |
10 --| INVCPRGS.pls |
11 --| |
12 --| DESCRIPTION |
13 --| Spec. of INV_MGD_MVT_CONC_PGM |
14 --| |
15 --| HISTORY |
16 --| 04/01/2000 pseshadr Created |
17 --| 10/15/2001 yawang Add procedure Run_Export_Data |
18 --| 11/09/2001 yawang Modify Run_Reset_Status |
19 --| 03/18/2002 yawang Add exchange rate to Run_Export_Data |
20 --| 11/22/2002 vma Add NOCOPY to OUT parameters |
21 --| 12/02/2004 vma Reverse the order of x_errbuf and |
22 --| x_retcode in API signatures to follow |
23 --| Concurrent Manager standard. |
24 --+======================================================================*/
25
26
27 --========================================================================
28 -- PROCEDURE : Run_Movement_Stats PUBLIC
29 -- PARAMETERS: x_errbuf error buffer
30 -- x_retcode 0 success, 1 warning, 2 error
31 -- p_legal_entity_id Legal Entity ID
32 -- p_start_date Transaction start date
33 -- p_end_date Transaction end date
34 -- p_source_type Document Source Type
35 -- COMMENT : This is the concurrent program for movement statistics.
36 -- It processes all the transaction for the specified legal
37 -- entity that have a transaction date within the specified
38 -- date range.
39 --========================================================================
40
41 PROCEDURE Run_Movement_Stats
42 ( x_errbuf OUT NOCOPY VARCHAR2
43 , x_retcode OUT NOCOPY VARCHAR2
44 , p_legal_entity_id IN NUMBER
45 , p_start_date IN VARCHAR2
46 , p_end_date IN VARCHAR2
47 , p_source_type IN VARCHAR2
48 );
49
50
51 --========================================================================
52 -- PROCEDURE : Run_Exception_Verification PUBLIC
53 -- PARAMETERS: x_errbuf error buffer
54 -- x_retcode 0 success, 1 warning, 2 error
55 -- p_legal_entity_id Legal Entity
56 -- p_economic_zone_code Economic Zone
57 -- p_usage_type Usage Type
58 -- p_stat_type Stat. Type
59 --- p_period_name Movement Statistics Period
60 -- p_document_source_type Document Source Type
61 -- (PO,SO,INV,RMA,RTV)
62 ---
63 -- COMMENT : This is the concurrent program specification for
64 -- Exception Verification Procedure/Report ,
65 -- which will validates and print
66 -- Exceptions for the Movement Statistics
67 -- transactions
68 ---
69 --=======================================================================--
70
71
72 PROCEDURE Run_Exception_verification
73 ( x_errbuf OUT NOCOPY VARCHAR2
74 , x_retcode OUT NOCOPY VARCHAR2
75 , p_legal_entity_id IN NUMBER
76 , p_economic_zone_code IN VARCHAR2
77 , p_usage_type IN VARCHAR2
78 , p_stat_type IN VARCHAR2
79 , p_period_name IN VARCHAR2
80 , p_document_source_type IN VARCHAR2
81 );
82
83
84 --========================================================================
85 -- PROCEDURE : Run_Reset_Status PUBLIC
86 -- PARAMETERS: x_errbuf error buffer
87 -- x_retcode 0 success, 1 warning, 2 error
88 -- p_legal_entity_id Legal Entity
89 -- p_economic_zone Econimic Zone
90 -- p_usage_type Usage Type
91 -- p_stat_type Status Type
92 -- p_period_name Period Name
93 -- p_document_source_type Document Source Type
94 -- (PO,SO,INV,RMA,RTV)
95 -- p_reset_option Reset Status Option
96 -- (All, Ignore only, Exclude Ignore)
97 --
98 -- COMMENT : This is the concurrent program specification
99 -- for Run_Reset_Status
100 --- enabling the movement statistics transaction
101 -- status to be updated or changed to Open(O)
102 -- and EDI_SENT_FLAG = 'N'
103 --
104 -- History: 11/09/2001 yawang Add parameter p_reset_option to
105 -- support ignore records
106 --=======================================================================--
107
108 PROCEDURE Run_Reset_Status
109 ( x_errbuf OUT NOCOPY VARCHAR2
110 , x_retcode OUT NOCOPY VARCHAR2
111 , p_legal_entity_id IN NUMBER
112 , p_economic_zone IN VARCHAR2
113 , p_usage_type IN VARCHAR2
114 , p_stat_type IN VARCHAR2
115 , p_period_name IN VARCHAR2
116 , p_document_source_type IN VARCHAR2
117 , p_reset_option IN VARCHAR2
118 )
119 ;
120
121
122 --========================================================================
123 -- PROCEDURE : Run_Purge_Movement_Stats PUBLIC
124 -- PARAMETERS: x_errbuf error buffer
125 -- x_retcode 0 success, 1 warning, 2 error
126 -- p_legal_entity_id Legal Entity
127 -- p_economic_zone Econimic Zone
128 -- p_usage_type Usage Type
129 -- p_stat_type Status Type
130 -- p_period_name Period Name
131 -- p_document_source_type Document Source Type
132 -- (PO,SO,INV,RMA,RTV)
133 -- COMMENT : This is the concurrent program for purging movement
134 -- statistics transactions.
135 -- It purges all the transaction for the specified legal
136 -- entity that have a transaction date within the specified
137 -- date range.
138 --========================================================================
139
140 PROCEDURE Run_Purge_Movement_Stats
141 ( x_errbuf OUT NOCOPY VARCHAR2
142 , x_retcode OUT NOCOPY VARCHAR2
143 , p_legal_entity_id IN NUMBER
144 , p_economic_zone IN VARCHAR2
145 , p_usage_type IN VARCHAR2
146 , p_stat_type IN VARCHAR2
147 , p_period_name IN VARCHAR2
148 , p_document_source_type IN VARCHAR2
149 );
150
151
152 --========================================================================
153 -- PROCEDURE : Run_Export_Data PUBLIC
154 -- PARAMETERS: x_errbuf error buffer
155 -- x_retcode 0 success, 1 warning, 2 error
156 -- p_legal_entity_id Legal Entity
157 -- p_zone_code Economic Zone
158 -- p_usage_type Usage Type
159 -- p_stat_type Statistical Type
160 -- p_movement_type Movement Type
161 -- p_period_name Period Name
162 -- p_currency_code Currency Code (support multi-currency)
163 -- p_exchange_rate Exchange Rate
164 -- p_inverse_rate Y - display inverse rate
165 -- N - display non-inverse rate
166 -- p_rate_type Exchange rate type
167 -- p_inverse_rate and p_rate_type are hidded
168 -- parameters in application, they are used to
169 -- determine list of value of exchange rate
170 -- p_amount_display display whole number or currency precision
171 --
172 -- COMMENT : This is the concurrent program specification for Run_Export_Data
173 -- used in IDEP declaration. It will generate a flat file in out
174 -- directory for specified movement type and report reference and
175 -- the records included in this file need to be in status of 'F'
176 --
177 --=======================================================================--
178
179 PROCEDURE Run_Export_Data
180 ( x_errbuf OUT NOCOPY VARCHAR2
181 , x_retcode OUT NOCOPY VARCHAR2
182 , p_legal_entity_id IN NUMBER
183 , p_zone_code IN VARCHAR2
184 , p_usage_type IN VARCHAR2
185 , p_stat_type IN VARCHAR2
186 , p_movement_type IN VARCHAR2
187 , p_period_name IN VARCHAR2
188 , p_amount_display IN VARCHAR2
189 , p_currency_code IN VARCHAR2
190 , p_inverse_rate IN VARCHAR2
191 , p_rate_type IN NUMBER
192 , p_exchange_rate_char IN VARCHAR2
193 )
194 ;
195
196 END INV_MGD_MVT_CONC_PGM;