1 PACKAGE inv_xml_reports AUTHID CURRENT_USER AS
2 /* $Header: INVXREPS.pls 120.2 2011/02/04 10:59:45 ksivasa ship $ */
3 PROCEDURE lot_inventory_report (
4 errbuf OUT NOCOPY VARCHAR2
5 , retcode OUT NOCOPY VARCHAR2
6 , p_organization_id IN NUMBER
7 , p_from_item IN VARCHAR2
8 , p_to_item IN VARCHAR2
9 , p_from_subinv IN VARCHAR2
10 , p_to_subinv IN VARCHAR2);
11
12 PROCEDURE lot_master_report (
13 errbuf OUT NOCOPY VARCHAR2
14 , retcode OUT NOCOPY VARCHAR2
15 , p_organization_id IN NUMBER
16 , p_from_item IN VARCHAR2
17 , p_to_item IN VARCHAR2);
18
19 PROCEDURE mat_status_def_report (
20 errbuf OUT NOCOPY VARCHAR2
21 , retcode OUT NOCOPY VARCHAR2
22 , p_from_status IN VARCHAR2
23 , p_to_status IN VARCHAR2
24 , p_sort_order IN NUMBER);
25
26 PROCEDURE grade_change_history_report (
27 errbuf OUT NOCOPY VARCHAR2
28 , retcode OUT NOCOPY VARCHAR2
29 , p_organization_id IN NUMBER
30 , p_item_id IN NUMBER
31 , p_from_lot IN VARCHAR2
32 , p_to_lot IN VARCHAR2
33 , p_from_date IN VARCHAR2
34 , p_to_date IN VARCHAR2);
35
36 PROCEDURE xml_transfer (
37 p_xml_clob IN CLOB);
38
39 --#11703502 Character date international calendar support Added calendar_aware in date function arguments
40 FUNCTION C_CALENDAR_VALUE RETURN NUMBER;
41
42 END inv_xml_reports;