1 PACKAGE INV_MGD_MVT_EXPORT_DATA AUTHID CURRENT_USER AS
2 -- $Header: INVIDEPS.pls 120.1 2006/05/25 18:07:15 yawang noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVIDEPS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Spec of INV_MGD_MVT_EXPORT_DATA |
13 --| |
14 --| HISTORY |
15 --| 10/12/01 yawang Created |
16 --| 10/23/01 yawang Modified,add parameter legal entity, zone|
17 --| code,usage type,stat type and period name|
18 --| 03/15/02 yawang Add parameter currency code and exchange |
19 --| rate |
20 --| 12/03/02 vma Add NOCOPY to OUT parameters to comply |
21 --| with new PL/SQL standards for better |
22 --| performance. |
23 --+======================================================================*/
24
25
26 --===================
27 -- PROCEDURES AND FUNCTIONS
28 --===================
29
30 --========================================================================
31 -- PROCEDURE : Generate_Export_Data PUBLIC
32 --
33 -- PARAMETERS: x_return_status Procedure return status
34 -- x_msg_count Number of messages in the list
35 -- x_msg_data Message text
36 -- p_api_version_number Known Version Number
37 -- p_init_msg_list Empty PL/SQL Table list for
38 -- Initialization
39 --
40 -- p_legal_entity_id Legal Entity
41 -- p_zone_code Economic Zone
42 -- p_usage_type Usage Type
43 -- p_stat_type Statistical Type
44 -- p_period_name Period Name
45 -- p_movement_type Movement Type
46 -- p_currency_code The currency in which user want to see
47 -- the statistic value
48 -- p_exchange_rate The exchange rate for the currency code
49 -- user selected
50 -- p_amount_display Display whole number or of currency precision
51 --
52 -- VERSION : current version 1.0
53 -- initial version 1.0
54 --
55 -- COMMENT : Procedure specification
56 -- to generate flat data file used in IDEP
57 --
58 -- Updated : 15/Mar/2002
59 --=======================================================================--
60
61 PROCEDURE Generate_Export_Data
62 ( p_api_version_number IN NUMBER
63 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
64 , p_legal_entity_id IN NUMBER
65 , p_zone_code IN VARCHAR2
66 , p_usage_type IN VARCHAR2
67 , p_stat_type IN VARCHAR2
68 , p_movement_type IN VARCHAR2
69 , p_period_name IN VARCHAR2
70 , p_amount_display IN VARCHAR2
71 , p_currency_code IN VARCHAR2
72 , p_exchange_rate_char IN VARCHAR2
73 , x_return_status OUT NOCOPY VARCHAR2
74 , x_msg_count OUT NOCOPY NUMBER
75 , x_msg_data OUT NOCOPY VARCHAR2
76 )
77 ;
78
79 END INV_MGD_MVT_EXPORT_DATA;