DBA Data[Home] [Help]

PACKAGE: APPS.INVTTMTX

Source


1 PACKAGE INVTTMTX as
2 /* $Header: INVTTMTS.pls 120.2 2006/05/03 22:14:19 ajohnson ship $ */
3 
4   G_TRANSACTION_PERIOD_ID 	NUMBER;
5   G_ORG_ID			NUMBER;
6   G_TRANSACTION_DATE		DATE;
7   G_CURRENT_DATE		DATE;
8   G_CURRENT_PERIOD_ID		NUMBER;
9   G_PERIOD_STATUS               NUMBER := 0; -- ( 0 - CLOSED ; 1 - OPEN )
10 
11   PROCEDURE tdatechk(org_id               IN      INTEGER,
12                      transaction_date     IN      DATE,
13                      period_id            OUT     nocopy INTEGER,
14                      open_past_period     IN OUT  nocopy BOOLEAN);
15 
16   FUNCTION ship_number_validation(shipment_number IN VARCHAR2) RETURN NUMBER;
17 
18   procedure post_query(
19     p_org_id                in  number,
20     p_inventory_item_id     in  number,
21     p_subinv                in  varchar2,
22     p_to_subinv             in  varchar2,
23     p_reason_id             in  number,
24     p_trx_type              in  varchar2,
25     p_transaction_action_id in  number,
26     p_from_uom              in  varchar2,
27     p_to_uom                in  varchar2,
28     p_sub_qty_tracked       out nocopy number,
29     p_sub_asset_inv         out nocopy number,
30     p_sub_locator_type      out nocopy number,
31     p_sub_material_acct     out nocopy number,
32     p_to_sub_qty_tracked    out nocopy number,
33     p_to_sub_asset_inv      out nocopy number,
34     p_to_sub_locator_type   out nocopy number,
35     p_to_sub_material_acct  out nocopy number,
36     p_reason_name           out nocopy varchar2,
37     p_transaction_type      out nocopy varchar2,
38     p_conversion_rate       out nocopy number);
39 
40 Procedure RPC_FAILURE_ROLLBACK(trx_header_id number,
41 			       cleanup_success in out nocopy boolean);
42 
43 Procedure lot_handling(hdr_id NUMBER,
44 		      lot_success IN OUT nocopy VARCHAR2);
45 
46 END INVTTMTX;
47