1 Package OPIMPXIN AS
2 /*$Header: OPIMXINS.pls 120.1 2005/06/08 18:29:57 appldev $ */
3
4 Procedure calc_wip_completion(Errbuf out nocopy Varchar2,
5 Retcode out nocopy Varchar2,
6 p_from_date IN Date,
7 p_to_date IN Date,
8 Org_id IN Number);
9
10
11 Procedure calc_wip_issue(Errbuf out nocopy Varchar2,
12 Retcode out nocopy Varchar2,
13 p_from_date IN Date,
14 p_to_date IN Date,
15 Org_id IN Number);
16
17 Procedure calc_assembly_return(Errbuf out nocopy Varchar2,
18 Retcode out nocopy Varchar2,
19 p_from_date IN Date,
20 p_to_date IN Date,
21 Org_id IN Number);
22
23 Procedure calc_po_deliveries(Errbuf out nocopy Varchar2,
24 Retcode out nocopy Varchar2,
25 p_from_date IN Date,
26 p_to_date IN Date,
27 Org_id IN Number);
28
29 Procedure calc_value_to_orgs(Errbuf out nocopy Varchar2,
30 Retcode out nocopy Varchar2,
31 p_from_date IN Date,
32 p_to_date IN Date,
33 Org_id IN Number);
34
35 Procedure calc_value_from_orgs(Errbuf out nocopy Varchar2,
36 Retcode out nocopy Varchar2,
37 p_from_date IN Date,
38 p_to_date IN Date,
39 Org_id IN Number);
40
41 Procedure calc_customer_shipment(Errbuf out nocopy Varchar2,
42 Retcode out nocopy Varchar2,
43 p_from_date IN Date,
44 p_to_date IN Date,
45 Org_id IN Number);
46
47 Procedure calc_inv_adjustment(Errbuf out nocopy Varchar2,
48 Retcode out nocopy Varchar2,
49 p_from_date IN Date,
50 p_to_date IN Date,
51 Org_id IN Number);
52
53 Procedure calc_total_issue(Errbuf out nocopy Varchar2,
54 Retcode out nocopy Varchar2,
55 p_from_date IN Date,
56 p_to_date IN Date,
57 Org_id IN Number);
58
59 Procedure calc_total_receipt(Errbuf out nocopy Varchar2,
60 Retcode out nocopy Varchar2,
61 p_from_date IN Date,
62 p_to_date IN Date,
63 Org_id IN Number);
64
65 Procedure Insert_update_push_log(
66 p_trx_date IN Date,
67 p_organization_id IN Number,
68 p_item_id IN Number default NULL,
69 p_cost_group_id IN Number default NULL,
70 p_revision IN Varchar2 default NULL,
71 p_lot_number IN Varchar2 default NULL,
72 p_subinventory IN Varchar2 default NULL,
73 p_locator IN Number default NULL,
74 p_item_status IN Varchar2 default NULL,
75 p_item_type IN Varchar2 default NULL,
76 p_base_uom IN Varchar2 default NULL,
77 p_col_name1 IN Varchar2 default NULL,
78 p_total1 IN Number default NULL,
79 p_col_name2 IN Varchar2 default NULL,
80 p_total2 IN Number default NULL,
81 p_col_name3 IN Varchar2 default NULL,
82 p_total3 IN Number default NULL,
83 p_col_name4 IN Varchar2 default NULL,
84 p_total4 IN Number default NULL,
85 p_col_name5 IN Varchar2 default NULL,
86 p_total5 IN Number default NULL,
87 p_col_name6 IN Varchar2 default NULL,
88 p_total6 IN Number default NULL,
89 selector IN Number default NULL,
90 success OUT nocopy Number);
91
92 Procedure Initialize(
93 p_trx_date OUT nocopy Date,
94 p_organization_id OUT nocopy Number,
95 p_item_id OUT nocopy Number,
96 p_cost_group_id OUT nocopy Number,
97 p_revision OUT nocopy Varchar2,
98 p_lot_number OUT nocopy Varchar2,
99 p_subinventory OUT nocopy Varchar2,
100 p_locator OUT nocopy Number,
101 total_qty OUT nocopy Number,
102 total_value OUT nocopy Number);
103
104 End OPIMPXIN;