1 PACKAGE CLN_SYNC_INVENTORY_PKG AUTHID CURRENT_USER AS
2 /* $Header: CLNSINVS.pls 115.3 2003/09/05 10:05:57 rkrishan noship $ */
3
4 -- Package
5 -- CLN_SYNC_INVENTORY_PKG
6 --
7 -- Purpose
8 -- Specs of package CLN_SYNC_INVENTORY_PKG.
9 --
10 -- History
11 -- April-17-2003 Rahul Krishan Created
12
13
14
15 -- Name
16 -- RAISE_REPORT_GEN_EVENT
17 -- Purpose
18 -- The main purpose ofthis API is to capture the parameters reqd. for the generation of the
19 -- inventory report as inputted by the user using concurrent program.
20 -- Arguments
21 --
22 -- Notes
23 -- No specific notes.
24
25 PROCEDURE RAISE_REPORT_GEN_EVENT(
26 x_errbuf OUT NOCOPY VARCHAR2,
27 x_retcode OUT NOCOPY NUMBER,
28 p_inv_user IN NUMBER,
29 p_inv_org IN NUMBER,
30 p_sub_inv IN VARCHAR2,
31 p_lot_number IN VARCHAR2,
32 p_item_category IN NUMBER,
33 p_item_number_from IN VARCHAR2,
34 p_item_number_to IN VARCHAR2,
35 p_item_revision_from IN VARCHAR2,
36 p_item_revision_to IN VARCHAR2,
37 p_diposition_available IN VARCHAR2,
38 p_diposition_blocked IN VARCHAR2,
39 p_diposition_allocated IN VARCHAR2 );
40
41
42 -- Name
43 -- GET_XML_TAG_VALUES
44 -- Purpose
45 -- The main purpose ofthis API is to call the inventory API - INVPQTTS.pls and
46 -- based on the user input through concurrent program and also using the profile
47 -- option calculate quantity on hand, avaliable to use , quantity blocked and allocated.
48 --
49 -- Arguments
50 --
51 -- Notes
52 -- No specific notes.
53
54 PROCEDURE GET_XML_TAG_VALUES(
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_inv_org IN NUMBER,
58 p_diposition_available IN VARCHAR2,
59 p_diposition_blocked IN VARCHAR2,
60 p_diposition_allocated IN VARCHAR2,
61 p_sub_inv IN VARCHAR2,
62 p_lot_number IN VARCHAR2,
63 p_item_number IN NUMBER,
64 p_item_revision IN VARCHAR2,
65 p_lot_ctrl_number IN NUMBER,
66 p_item_revision_ctrl_number IN NUMBER,
67 p_tp_type IN VARCHAR2,
68 p_tp_id IN NUMBER,
69 p_tp_site_id IN VARCHAR2,
70 p_xmlg_transaction_type IN VARCHAR2, --
71 p_xmlg_transaction_subtype IN VARCHAR2, --
72 p_xmlg_document_id IN VARCHAR2, --
73 p_xml_event_key IN VARCHAR2, --
74 p_xmlg_internal_control_number IN NUMBER, --
75 x_customer_item_number OUT NOCOPY VARCHAR2,
76 x_quantity_on_hand OUT NOCOPY NUMBER,
77 x_quantity_blocked OUT NOCOPY NUMBER,
78 x_quantity_allocated OUT NOCOPY NUMBER );
79
80 END CLN_SYNC_INVENTORY_PKG;