[Home] [Help]
PACKAGE: APPS.OZF_SALES_TRANSACTIONS_PVT
Source
1 PACKAGE OZF_SALES_TRANSACTIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvstns.pls 120.3.12000000.2 2007/02/24 05:18:39 kdass ship $ */
3
4 TYPE SALES_TRANSACTION_REC_TYPE IS RECORD (
5 sales_transaction_id NUMBER,
6 object_version_number NUMBER,
7 last_update_date DATE ,
8 last_updated_by NUMBER,
9 creation_date DATE,
10 request_id NUMBER,
11 created_by NUMBER,
12 created_from VARCHAR2(30),
13 last_update_login NUMBER(15),
14 program_application_id NUMBER,
15 program_update_date DATE,
16 program_id NUMBER,
17 transfer_type VARCHAR2(30),
18 sold_from_cust_account_id NUMBER,
19 sold_from_party_id NUMBER,
20 sold_from_party_site_id NUMBER,
21 sold_to_cust_account_id NUMBER,
22 sold_to_party_id NUMBER,
23 sold_to_party_site_id NUMBER,
24 bill_to_site_use_id NUMBER,
25 ship_to_site_use_id NUMBER,
26 transaction_date DATE,
27 quantity NUMBER,
28 uom_code VARCHAR2(30),
29 amount NUMBER,
30 currency_code VARCHAR2(30),
31 inventory_item_id NUMBER,
32 primary_quantity NUMBER,
33 primary_uom_code VARCHAR2(30),
34 common_quantity NUMBER,
35 common_uom_code VARCHAR2(30),
36 common_currency_code VARCHAR2(30),
37 common_amount NUMBER,
38 header_id NUMBER,
39 line_id NUMBER,
40 reason_code VARCHAR2(30),
41 source_code VARCHAR2(30),
42 error_flag VARCHAR2(1),
43 attribute_category VARCHAR2 (40),
44 attribute1 VARCHAR2 (240),
45 attribute2 VARCHAR2 (240),
46 attribute3 VARCHAR2 (240),
47 attribute4 VARCHAR2 (240),
48 attribute5 VARCHAR2 (240),
49 attribute6 VARCHAR2 (240),
50 attribute7 VARCHAR2 (240),
51 attribute8 VARCHAR2 (240),
52 attribute9 VARCHAR2 (240),
53 attribute10 VARCHAR2 (240),
54 attribute11 VARCHAR2 (240),
55 attribute12 VARCHAR2 (240),
56 attribute13 VARCHAR2 (240),
57 attribute14 VARCHAR2 (240),
58 attribute15 VARCHAR2 (240),
59 org_id NUMBER,
60 qp_list_header_id VARCHAR2 (240)
61 );
62
63 TYPE SALES_TRANS_TBL IS TABLE OF SALES_TRANSACTION_REC_TYPE INDEX BY BINARY_INTEGER;
64
65 -- Default number of records fetch per call
66 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
67
68 ---------------------------------------------------------------------
69 -- PROCEDURE
70 -- Validate_transaction
71 --
72 -- PURPOSE
73 -- Validate a transaction record.
74 --
75 -- PARAMETERS
76 -- p_transaction : the transaction code record to be validated
77 --
78 -- NOTES
79 --
80 ----------------------------------------------------------------------
81 PROCEDURE Validate_Transaction (
82 p_api_version IN NUMBER
83 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
84 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
85 ,x_return_status OUT NOCOPY VARCHAR2
86 ,x_msg_count OUT NOCOPY NUMBER
87 ,x_msg_data OUT NOCOPY VARCHAR2
88 ,p_transaction IN SALES_TRANSACTION_REC_TYPE
89 );
90
91 ---------------------------------------------------------------------
92 -- PROCEDURE
93 -- create_transaction
94 --
95 -- PURPOSE
96 -- This procedure creates an transaction
97 --
98 -- PARAMETERS
99 --
100 --
101 -- NOTES
102 ---------------------------------------------------------------------
103 PROCEDURE create_transaction (
104 p_api_version IN NUMBER
105 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
106 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
107 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
108 ,p_transaction_rec IN SALES_TRANSACTION_REC_TYPE
109 ,x_sales_transaction_id OUT NOCOPY NUMBER
110 ,x_return_status OUT NOCOPY VARCHAR2
111 ,x_msg_data OUT NOCOPY VARCHAR2
112 ,x_msg_count OUT NOCOPY NUMBER
113 );
114
115 ---------------------------------------------------------------------
116 -- PROCEDURE
117 -- Initiate_Inventory_tmp
118 --
119 -- PURPOSE
120 -- Populate the inventory temporary table
121 --
122 -- PARAMETERS
123 -- p_party_id: Id of the party that we want to have a look of its inventory
124 -- p_start_date : The date when we want to take a snapshot of inventory
125 --
126 -- NOTES
127 --
128 ----------------------------------------------------------------------
129 PROCEDURE Initiate_Inventory_tmp (
130 p_api_version IN NUMBER
131 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
132 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
133 ,p_resale_batch_id IN NUMBER
134 ,p_start_date IN DATE
135 ,p_end_date IN DATE
136 ,x_return_status OUT NOCOPY VARCHAR2
137 ,x_msg_count OUT NOCOPY NUMBER
138 ,x_msg_data OUT NOCOPY VARCHAR2
139 );
140
141 ---------------------------------------------------------------------
142 -- PROCEDURE
143 -- update_Inventory_tmp
144 --
145 -- PURPOSE
146 -- update the inventory temporary table
147 --
148 -- PARAMETERS
149 -- p_sales_transaction_id: the id of the salse_transaction record to update
150 --
151 -- NOTES
152 --
153 ----------------------------------------------------------------------
154 PROCEDURE update_Inventory_tmp (
155 p_api_version IN NUMBER
156 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
157 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
158 ,p_sales_transaction_id IN NUMBER
159 ,x_return_status OUT NOCOPY VARCHAR2
160 ,x_msg_count OUT NOCOPY NUMBER
161 ,x_msg_data OUT NOCOPY VARCHAR2
162 );
163
164 ---------------------------------------------------------------------
165 -- PROCEDURE
166 -- Validate_Inventory_Level
167 --
168 -- PURPOSE
169 -- Validate a line against the inventory levle.
170 --
171 -- PARAMETERS
172 -- p_line_int_rec: interface rece.
173 -- x_valid: boolean
174 --
175 -- NOTES
176 --
177 ----------------------------------------------------------------------
178 PROCEDURE Validate_Inventory_Level (
179 p_api_version IN NUMBER
180 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
181 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
182 ,p_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%ROWTYPE
183 ,x_valid OUT NOCOPY BOOLEAN
184 ,x_return_status OUT NOCOPY VARCHAR2
185 ,x_msg_count OUT NOCOPY NUMBER
186 ,x_msg_data OUT NOCOPY VARCHAR2
187 );
188
189 ---------------------------------------------------------------------
190 -- PROCEDURE
191 -- Get_Purchase_Price
192 --
193 -- PURPOSE
194 -- Calculate the purchase price of a line based on the order management data.
195 --
196 -- PARAMETERS
197 -- p_line_int_rec: interface rece.
198 -- x_purchase_price: NUMBER
199 --
200 -- NOTES
201 --
202 ----------------------------------------------------------------------
203 PROCEDURE Get_Purchase_Price (
204 p_api_version IN NUMBER
205 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
206 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
207 ,p_order_date IN DATE
208 ,p_sold_from_cust_account_id IN NUMBER
209 ,p_sold_from_site_id IN NUMBER
210 ,p_inventory_item_id IN NUMBER
211 ,p_uom_code IN VARCHAR2
212 ,p_quantity IN NUMBER
213 ,p_currency_code IN VARCHAR2
214 ,p_x_purchase_uom_code IN OUT NOCOPY VARCHAR2
215 ,x_purchase_price OUT NOCOPY NUMBER
216 ,x_return_status OUT NOCOPY VARCHAR2
217 ,x_msg_count OUT NOCOPY NUMBER
218 ,x_msg_data OUT NOCOPY VARCHAR2
219 );
220
221 END OZF_SALES_TRANSACTIONS_PVT;