1 PACKAGE PO_OTM_INTEGRATION_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVOTMS.pls 120.1 2010/11/01 22:07:24 yawang ship $ */
3
4 -------------------------------------------------------------------------------
5 --Start of Comments
6 --Name:
7 -- is_otm_installed
8 --Pre-reqs:
9 -- None.
10 --Modifies:
11 -- None.
12 --Locks:
13 -- None.
14 --Function:
15 -- Returns true if Oracle OTM is installed.
16 --Parameters:
17 -- None
18 --Retrurns
19 -- TRUE if OTM is installed, FALSE if it is not.
20 --End of Comments
21 -------------------------------------------------------------------------------
22 FUNCTION is_otm_installed RETURN BOOLEAN;
23
24 -------------------------------------------------------------------------------
25 --Start of Comments
26 --Name:
27 -- is_inbound_logistics_enabled
28 --Pre-reqs:
29 -- None.
30 --Modifies:
31 -- None.
32 --Locks:
33 -- None.
34 --Function:
35 -- Returns true if either Oracle OTM or FTE integration is enabled for PO.
36 --Parameters:
37 -- None
38 --Retrurns
39 -- TRUE if OTM is installed, FALSE if it is not.
40 --End of Comments
41 -------------------------------------------------------------------------------
42 FUNCTION is_inbound_logistics_enabled RETURN BOOLEAN;
43
44
45 -------------------------------------------------------------------------------
46 --Start of Comments
47 --Name:
48 -- handle_doc_update
49 --Pre-reqs:
50 -- None.
51 --Modifies:
52 -- None.
53 --Locks:
54 -- None.
55 --Function:
56 -- Called when OTM is installed and a document control action has been
57 -- performed. If the action is one tracked by Oracle OTM, raises
58 -- oracle.apps.po.event.document_action_event, which will trigger
59 -- the OTM integration BPEL process.
60 --Parameters:
61 --IN:
62 --p_doc_type
63 -- The PO Document Type (PO or RELEASE)
64 --p_doc_id
65 -- The document's ID (po_header_id for POs, po_release_id for Releases).
66 --p_action
67 -- The action performend on the document, as passed from Document Control or
68 -- Document Manager.
69 --p_line_id
70 -- In the case of an action that was performed just on a PO line, such as close
71 -- or cancel, the ID of the line on which the action was performed.
72 --p_line_loc_id
73 -- In the case of an action that was performed on just a PO line location,
74 -- the ID of the line location on which the action was performed.
75 --OUT:
76 -- None
77 --End of Comments
78 -------------------------------------------------------------------------------
79 PROCEDURE handle_doc_update (
80 p_doc_type IN VARCHAR2
81 , p_doc_id IN NUMBER
82 , p_action IN VARCHAR2
83 , p_line_id IN NUMBER
84 , p_line_loc_id IN NUMBER
85 );
86
87 -------------------------------------------------------------------------------
88 --Start of Comments
89 --Name:
90 -- get_otm_document
91 --Pre-reqs:
92 -- None.
93 --Modifies:
94 -- None.
95 --Locks:
96 -- None.
97 --Function:
98 -- Called by the OTM integration BPEL process to extract information about
99 -- a PO document. Information returned depends upon the action performed.
100 --Parameters:
101 --IN:
102 --p_doc_type
103 -- The PO Document Type (PO or RELEASE)
104 --p_doc_id
105 -- The document's ID (po_header_id for POs, po_release_id for Releases).
106 --p_doc_revision
107 -- The revision of the document on which the action was performed.
108 --p_blanket_revision
109 -- When the document is a Release, the revision number of the BPA against
110 -- which the release was created.
111 --p_action
112 -- The action performend on the document, as passed from Document Control or
113 -- Document Manager.
114 --p_line_id
115 -- In the case of an action that was performed just on a PO line, such as close
116 -- or cancel, the ID of the line on which the action was performed.
117 --p_line_loc_id
118 -- In the case of an action that was performed on just a PO line location,
119 -- the ID of the line location on which the action was performed.
120 --OUT:
121 --x_otm_doc
122 -- PO_OTM_ORDER_TYPE containing the appropriate document information. In the
123 -- case of a PO approval, should contain full document info. In the case of
124 -- hold, cancel, or close, will only contain ID info.
125 --End of Comments
126 -------------------------------------------------------------------------------
127 PROCEDURE get_otm_document (
128 p_doc_type IN VARCHAR2
129 , p_doc_id IN NUMBER
130 , p_doc_revision IN NUMBER
131 , p_blanket_revision IN NUMBER DEFAULT NULL
132 , p_action IN VARCHAR2
133 , p_line_id IN NUMBER DEFAULT NULL
134 , p_line_loc_id IN NUMBER DEFAULT NULL
135 , x_otm_doc OUT NOCOPY PO_OTM_ORDER_TYPE
136 );
137
138 -- OTM Recovery START
139 PROCEDURE recover_failed_docs
140 ( errbuf OUT NOCOPY VARCHAR2,
141 retcode OUT NOCOPY VARCHAR2
142 );
143
144 PROCEDURE update_order_otm_status
145 ( p_doc_id IN NUMBER,
146 p_doc_type IN VARCHAR2,
147 p_order_otm_status IN VARCHAR2,
148 p_otm_recovery_flag IN VARCHAR2
149 );
150 -- OTM Recovery END
151
152 END;