[Home] [Help]
PACKAGE: APPS.OTA_OM_UPD_API
Source
1 Package ota_om_upd_api AUTHID CURRENT_USER as
2 /* $Header: ottomupd.pkh 115.4 2002/11/29 13:21:04 jbharath noship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- |-------------------------------< cancel_order>----------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure will be used to cancel order line.
11 --
12 -- This procedure will only be used for OTA and OM integration.
13 --
14 -- Pre Conditions:
15 -- None.
16 --
17 -- In Arguments:
18 -- p_Line_id
19 -- p_org_id
20 --
21 -- Post Success:
22 -- Processing continues.
23 --
24 --
25 -- Post Failure:
26 -- None.
27 --
28 -- Access Status:
29 -- Public.
30 --
31 -- {End Of Comments}
32 ----------------------------------------------------------------------------
33 Procedure cancel_order(
34 p_Line_id IN NUMBER,
35 p_org_id IN NUMBER
36 );
37
38
39 -- ----------------------------------------------------------------------------
40 -- |---------------------------------< create_rma>----------------------------|
41 -- ----------------------------------------------------------------------------
42 -- {Start Of Comments}
43 --
44 -- Description:
45 -- This procedure will be used to create RMA.
46 --
47 -- This procedure will only be used for OTA and OM integration.
48 --
49 -- Pre Conditions:
50 -- None.
51 --
52 -- In Arguments:
53 -- p_Line_id
54 -- p_org_id
55 --
56 -- Post Success:
57 -- Processing continues.
58 --
59 --
60 -- Post Failure:
61 -- None.
62 --
63 -- Access Status:
64 -- Public.
65 --
66 -- {End Of Comments}
67 ----------------------------------------------------------------------------
68 Procedure create_rma(
69 p_Line_id IN NUMBER,
70 p_org_id IN NUMBER);
71
72 -- ----------------------------------------------------------------------------
73 -- |---------------------------------< create_order>----------------------------|
74 -- ----------------------------------------------------------------------------
75 -- {Start Of Comments}
76 --
77 -- Description:
78 -- This procedure will be used to create New Order and order line.
79 --
80 -- This procedure will only be used for OTA and OM integration.
81 --
82 -- Pre Conditions:
83 -- None.
84 --
85 -- In Arguments:
86 -- p_Line_id
87 -- p_inventory_item_id
88 -- p_customer_id
89 -- p_contact_id
90 --
91 -- out Argument
92 -- p_return_status
93 --
94 -- Post Success:
95 -- Processing continues.
96 --
97 --
98 -- Post Failure:
99 -- None.
100 --
101 -- Access Status:
102 -- Public.
103 --
104 -- {End Of Comments}
105 ----------------------------------------------------------------------------
106 Procedure create_order(
107 p_customer_id IN NUMBER,
108 p_contact_id IN NUMBER,
109 p_inventory_item_id IN NUMBER,
110 p_header_id OUT NOCOPY NUMBER,
111 p_line_id OUT NOCOPY NUMBER,
112 p_return_status OUT NOCOPY VARCHAR2);
113
114
115
116 -- ----------------------------------------------------------------------------
117 -- |--------------------------< retrieve_oe_messages>-------------------------|
118 -- ----------------------------------------------------------------------------
119 -- {Start Of Comments}
120 --
121 -- Description:
122 -- This procedure will be a retrieve Error message when calling OM Process
123 -- Order API.
124 --
125 --
126 -- Pre Conditions:
127 -- None.
128 --
129 -- In Arguments:
130 --
131 -- Post Success:
132 -- Processing continues.
133 --
134 --
135 -- Post Failure:
136 -- None.
137 --
138 -- Access Status:
139 -- Public.
140 --
141 -- {End Of Comments}
142 ----------------------------------------------------------------------------
143
144 PROCEDURE retrieve_oe_messages(p_msg_data out nocopy varchar2);
145
146
147 -- ----------------------------------------------------------------------------
148 -- |---------------------------------< create_enroll_from_om>------------------|
149 -- ----------------------------------------------------------------------------
150 -- {Start Of Comments}
151 --
152 -- Description:
153 -- This procedure will be used to create New enrollment and this procedure
154 -- will be called by OM Sales Order form.
155 --
156 -- This procedure will only be used for OTA and OM integration.
157 --
158 -- Pre Conditions:
159 -- None.
160 --
161 -- In Arguments:
162 -- p_Line_id
163 -- p_org_id
164 -- p_sold_to_org_id
165 -- p_ship_to_org_id
166 -- p_sold_to_contact_id
167 -- p_ship_to_contact_id
168 -- p_event_id
169 --
170 -- out Argument
171 -- p_return_status
172 --
173 -- Post Success:
174 -- Processing continues.
175 --
176 --
177 -- Post Failure:
178 -- None.
179 --
180 -- Access Status:
181 -- Public.
182 --
183 -- {End Of Comments}
184 ----------------------------------------------------------------------------
185 Procedure create_enroll_from_om(
186 p_Line_id IN NUMBER,
187 p_org_id IN NUMBER,
188 p_sold_to_org_id IN NUMBER,
189 p_ship_to_org_id IN NUMBER,
190 p_sold_to_contact_id IN NUMBER,
191 p_ship_to_contact_id IN NUMBER,
192 p_event_id IN NUMBER,
193 p_order_date IN DATE,
194 x_enrollment_id OUT NOCOPY NUMBER,
195 x_enrollment_status OUT NOCOPY VARCHAR2,
196 x_return_status OUT NOCOPY VARCHAR2);
197
198 end ota_om_upd_api;