DBA Data[Home] [Help]

PACKAGE: APPS.INV_MGD_MVT_RESET_TRANS

Source


1 PACKAGE INV_MGD_MVT_RESET_TRANS AUTHID CURRENT_USER AS
2 -- $Header: INVRMVTS.pls 115.4 2002/12/03 19:38:38 yawang ship $
3 --+=======================================================================+
4 --|               Copyright (c) 1998 Oracle Corporation                   |
5 --|                       Redwood Shores, CA, USA                         |
6 --|                         All rights reserved.                          |
7 --+=======================================================================+
8 --| FILENAME                                                              |
9 --|     INVRMVTS.pls                                                      |
10 --|                                                                       |
11 --| DESCRIPTION                                                           |
12 --|    Spec of INV_MGD_MVT_RESET_TRANS                                    |
13 --|                                                                       |
14 --| HISTORY                                                               |
15 --|     06/12/2000 pseshadr        Created                                |
16 --|     11/09/2001 yawang          Add parameter p_reset_option           |
17 --|                                increased the version number to 2.0
18 --+======================================================================*/
19 
20 
21 --===================
22 -- PROCEDURES AND FUNCTIONS
23 --===================
24 
25 --========================================================================
26 -- PROCEDURE : Reset_Transaction_Status   PUBLIC
27 --
28 -- PARAMETERS: x_return_status      Procedure return status
29 --             x_msg_count          Number of messages in the list
30 --             x_msg_data           Message text
31 --             p_api_version_number Known Version Number
32 --             p_init_msg_list      Empty PL/SQL Table listfor
33 --                                  Initialization
34 --
35 --             p_legal_entity_id    Legal Entity
36 --             p_zone_code          Zonal Code
37 --             p_usage_type         Usage Type
38 --             p_stat_type          Stat Type
39 ----           p_period_name        Period Name for processing
40 --             p_document_source_type Document Source Type
41 --                                    (PO,SO,INV,RMA,RTV)
42 --             p_reset_option       Reset Status Option
43 --                                  (All, Ignore Only, Exclude Ignore)
44 --
45 -- VERSION   : current version         2.0
46 --             initial version         1.0
47 --
48 -- COMMENT   : Procedure specification
49 --             to Update the Movement Status to 'O-Open',
50 --             EDI_SENT_FLAG  = 'N' for the given Input parameters.
51 
52 -- Updated   :  09/Jul/2000
53 -- History   :  11/09/2001 yawang   Add parameter p_reset_option,current
54 --                                  version number increased to 2.0
55 --=======================================================================--
56 
57 PROCEDURE Reset_Transaction_Status
58 ( p_api_version_number   IN  NUMBER
59 , p_init_msg_list        IN  VARCHAR2 := FND_API.G_TRUE
60 , p_legal_entity_id      IN  NUMBER
61 , p_zone_code            IN  VARCHAR2
62 , p_usage_type           IN  VARCHAR2
63 , p_stat_type            IN  VARCHAR2
64 , p_period_name          IN  VARCHAR2
65 , p_document_source_type IN  VARCHAR2
66 , p_reset_option         IN  VARCHAR2
67 , x_return_status        OUT NOCOPY VARCHAR2
68 , x_msg_count            OUT NOCOPY NUMBER
69 , x_msg_data             OUT NOCOPY VARCHAR2
70 )
71 ;
72 
73 
74 END INV_MGD_MVT_RESET_TRANS;