1 PACKAGE INV_MGD_MVT_SETUP_MDTR AUTHID CURRENT_USER AS
2 /* $Header: INVUSGSS.pls 115.5 2002/11/22 19:32:28 yawang ship $ */
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVUSGSS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Spec. of INV_MGD_MVT_SETUP_MDTR |
13 --| |
14 --| HISTORY |
15 --| 06/16/00 ksaini Added Get_Movement_Stat_Usages Procedure |
16 --| 04/01/02 pseshadr Added Get_Reference_Context Procedure |
17 --+======================================================================*/
18
19
20 --========================================================================
21 -- PROCEDURE : Get_Reference_Context PRIVATE
22 -- PARAMETERS:
23 -- x_return_status return status
24 -- p_legal_entity_id Legal Entity ID
25 -- p_start_date Transaction start date
26 -- p_end_date Transaction end date
27 -- p_transaction type Transaction type (SO,PO etc)
28 -- COMMENT :
29 -- This processes all the parameters for the specified legal
30 -- entity .
31 --========================================================================
32
33
34 PROCEDURE Get_Reference_Context
35 ( p_legal_entity_id IN NUMBER
36 , p_start_date IN DATE
37 , p_end_date IN DATE
38 , p_transaction_type IN VARCHAR2
39 , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
40 , x_return_status OUT NOCOPY VARCHAR2
41 , ref_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
42 );
43
44 --========================================================================
45 -- PROCEDURE : Get_Setup_Context PRIVATE
46 -- PARAMETERS:
47 -- x_return_status return status
48 -- p_legal_entity_id Legal Entity ID
49 -- p_movement_transaction Movement Transaction Record
50 -- ref_crsr Cursor
51 -- COMMENT :
52 -- This processes all the transaction for the specified legal
53 -- entity that have a transaction date within the specified
54 -- date range.
55 --========================================================================
56
57 PROCEDURE Get_Setup_Context
58 ( p_legal_entity_id IN NUMBER
59 , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
60 , x_return_status OUT NOCOPY VARCHAR2
61 , setup_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
62 );
63
64 --========================================================================
65 -- PROCEDURE : Get_Invoice_Context PRIVATE
66 -- PARAMETERS:
67 -- x_return_status return status
68 -- p_legal_entity_id Legal Entity ID
69 -- p_start_date Transaction start date
70 -- p_end_date Transaction end date
71 -- p_transaction type Transaction type (SO,PO etc)
72 -- COMMENT : Processes the setup info when updating the Invoice
73 --========================================================================
74
75 PROCEDURE Get_Invoice_Context
76 ( p_legal_entity_id IN NUMBER
77 , p_start_date IN DATE
78 , p_end_date IN DATE
79 , p_transaction_type IN VARCHAR2
80 , p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
81 , x_return_status OUT NOCOPY VARCHAR2
82 , setup_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.setupCurTyp
83 );
84
85
86 --========================================================================
87 -- FUNCTION : Process_Setup_Context PRIVATE
88 -- PARAMETERS:
89 -- p_movement_transaction movement transaction record
90 -- COMMENT :
91 --========================================================================
92
93 FUNCTION Process_Setup_Context
94 ( p_movement_transaction IN INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type)
95 RETURN VARCHAR2;
96
97
98 --========================================================================
99 -- PROCEDURE : Get_Movement_Stat_Usages PRIVATE
100 -- PARAMETERS:
101 -- x_return_status OUT return status
102 -- x_msg_count OUT number of messages in the list
103 -- x_msg_data OUT message text
104 -- p_legal_entity_id IN legal_entity
105 -- p_economic_zone_code IN economic zone
106 -- p_usage_type IN usage type
107 -- p_stat_type IN stat_type
108 -- x_movement_stat_usages_rec OUT Stat type Usages record
109 -- VERSION : current version 1.0
110 -- initial version 1.0
111 -- COMMENT : Procedure that returns the category id for an item
112 --=======================================================================--
113 PROCEDURE Get_Movement_Stat_Usages
114 ( x_return_status OUT NOCOPY VARCHAR2
115 , x_msg_count OUT NOCOPY NUMBER
116 , x_msg_data OUT NOCOPY VARCHAR2
117 , p_legal_entity_id IN NUMBER
118 , p_economic_zone_code IN VARCHAR2
119 , p_usage_type IN VARCHAR2
120 , p_stat_type IN VARCHAR2
121 , x_movement_stat_usages_rec OUT NOCOPY
122 INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
123 );
124
125 END INV_MGD_MVT_SETUP_MDTR;