1 Package ota_cancel_api AUTHID CURRENT_USER as
2 /* $Header: ottomint.pkh 120.30 2010/05/25 05:37:48 shwnayak ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< delete_cancel_line>-------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start Of Comments}
7 --
8 -- Description:
9 -- This procedure will be used to update delegate booking and event table.
10 --
11 -- This procedure will only be used for OTA and OM integration. The prurpose
12 -- of this procedure is only be called by OM Process Order API when the order
13 -- line got canceled or deleted. This procedure being created because Order
14 -- Management doesnot support workflow for Cancel or delete Order Line.
15 --
16 -- Pre Conditions:
17 -- None.
18 --
19 -- In Arguments:
20 -- p_line_id,
21 -- p_org_id
22 -- p_uom
23 -- p_daemon_type
24 --
25 -- Post Success:
26 -- Processing continues.
27 --
28 --
29 -- Post Failure:
30 -- None.
31 --
32 -- Access Status:
33 -- Public.
34 --
35 -- {End Of Comments}
36 ----------------------------------------------------------------------------
37 Procedure delete_cancel_line
38 (
39 p_line_id IN Number,
40 p_org_id IN Number,
41 p_UOM IN Varchar2,
42 P_daemon_type IN varchar2,
43 x_return_status OUT NOCOPY varchar2);
44
45
46 -- ----------------------------------------------------------------------------
47 -- |-----------------------------< cancel_enrollment>-------------------------|
48 -- ----------------------------------------------------------------------------
49 -- {Start Of Comments}
50 --
51 -- Description:
52 -- This procedure will be a concurrent process which run in the background.
53 --
54 -- This procedure will only be used for OTA and OM integration. Basically this
55 -- procedure will select all delegate booking data that has daemon_flag='Y' and
56 -- Daemon_type is not nul. If the enrollment got canceled and there is a
57 -- waitlisted student then the automatic waitlist processing will be called.
58 --
59 -- Pre Conditions:
60 -- None.
61 --
62 -- In Arguments:
63 -- p_user_id,
64 -- p_login_id
65 --
66 -- Post Success:
67 -- Processing continues.
68 --
69 --
70 -- Post Failure:
71 -- None.
72 --
73 -- Access Status:
74 -- Public.
75 --
76 -- {End Of Comments}
77 ----------------------------------------------------------------------------
78
79 Procedure cancel_enrollment
80 (p_user_id in number,
81 p_login_id in number);
82
83 --
84 -- ----------------------------------------------------------------------------
85 -- |----------------------< initial_cancel_enrollment>-------------------------|
86 -- ----------------------------------------------------------------------------
87 -- {Start Of Comments}
88 --
89 -- Description:
90 -- This procedure will be a concurrent process which run in the background.
91 --
92 --
93 -- Pre Conditions:
94 -- None.
95 --
96 -- Out Arguments:
97 -- errbuf
98 -- retcode
99 --
100 -- Post Success:
101 -- Processing continues.
102 --
103 --
104 -- Post Failure:
105 -- None.
106 --
107 -- Access Status:
108 -- Public.
109 --
110 -- {End Of Comments}
111 ----------------------------------------------------------------------------
112
113 Procedure initial_cancel_enrollment
114 (ERRBUF OUT NOCOPY VARCHAR2,
115 RETCODE OUT NOCOPY VARCHAR2);
116
117 --
118 -- ----------------------------------------------------------------------------
119 -- |------------------------------------< upd_max_attendee >------------------|
120 -- ----------------------------------------------------------------------------
121 -- {Start Of Comments}
122 --
123 -- Description:
124 -- This procedure will be used to update event maximum atenddee .
125 --
126 --
127 -- Pre Conditions:
128 -- None.
129 --
130 -- In Arguments:
131 -- p_line_id,
132 -- p_org_id,
133 -- p_max_attendee
134 -- p_uom
135 -- p_operation
136 --
137 -- Out Arguments:
138 -- x_return_status
139 -- x_msg_data
140 --
141 -- Post Success:
142 -- Processing continues.
143 --
144 --
145 -- Post Failure:
146 -- None.
147 --
148 -- Access Status:
149 -- Public.
150 --
151 -- {End Of Comments}
152 ----------------------------------------------------------------------------
153
154 Procedure upd_max_attendee
155 (p_line_id in number,
156 p_org_id in number,
157 p_max_attendee in number,
158 p_uom in varchar2,
159 p_operation in varchar2,
160 x_return_status out nocopy varchar2,
161 x_msg_data out nocopy varchar2
162 );
163
164 end ota_cancel_api ;
165
[Home] [Help]