[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