1 Package OPIMPXWI AS
2 /*$Header: OPIMXWIS.pls 120.1 2005/06/08 18:31:09 appldev $ */
3
4 g_org_error BOOLEAN := FALSE;
5 -- -----------------------------------------------------------
6 -- PROCEDURE PUSH
7 -- ---------------------------------------------------------
8
9 Procedure OPI_EXTRACT_IDS(p_from_date IN DATE,
10 p_to_date IN DATE,
11 p_org_code IN VARCHAR2);
12
13
14 Procedure CALC_INV_BALANCE(p_from_date IN Date,
15 p_to_date IN Date,
16 Org_id IN Number,
17 status OUT nocopy NUMBER);
18
19 Procedure Calculate_Balance( p_trx_date IN DATE,
20 p_organization_id IN NUMBER,
21 p_item_id IN NUMBER,
22 p_cost_group_id IN NUMBER,
23 p_edw_start_date IN DATE,
24 p_revision IN VARCHAR2,
25 p_lot_number IN VARCHAR2,
26 p_subinventory IN VARCHAR2,
27 p_locator IN NUMBER,
28 p_item_status IN VARCHAR2,
29 p_item_type IN VARCHAR2,
30 p_base_uom IN VARCHAR2,
31 p_total_qty IN NUMBER,
32 status OUT nocopy NUMBER);
33
34 PROCEDURE purge_opi_ids_push_log(
35 i_org_id IN NUMBER,
36 o_errnum OUT nocopy NUMBER,
37 o_retcode OUT nocopy VARCHAR2,
38 o_errbuf OUT nocopy VARCHAR2);
39
40 PROCEDURE process_error(
41 i_stmt_num IN NUMBER,
42 i_errnum IN NUMBER,
43 i_retcode IN VARCHAR2,
44 i_errbuf IN VARCHAR2);
45
46 PROCEDURE process_warning(
47 i_stmt_num IN NUMBER,
48 i_errnum IN NUMBER,
49 i_retcode IN VARCHAR2,
50 i_errbuf IN VARCHAR2);
51
52 Procedure calc_begin_inv(p_from_date IN DATE,
53 Org_id IN Number,
54 status OUT nocopy Number);
55
56 PROCEDURE calc_intrst_balance(p_from_date IN Date,
57 p_to_date IN Date,
58 Org_id IN Number,
59 status OUT nocopy Number);
60
61 End OPIMPXWI;