[Home] [Help]
PACKAGE: APPS.OTA_CANCEL_TRAINING_SS
Source
1 PACKAGE ota_cancel_training_ss AUTHID CURRENT_USER AS
2 /* $Header: otssctrn.pkh 115.5 2002/11/29 06:48:37 dbatra noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------<create_enroll_wf_process>-------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure will be used to set the item attributes in workflow.
11 --
12 -- Pre Conditions:
13 -- None.
14 --
15 -- In Arguments:
16 -- p_item_key
17 -- p_item_type
18 -- p_person_id
19 -- p_event_title
20 -- p_course_start_date
21 -- p_course_end_date
22 -- Out Arguments:
23 -- x_return_status
24 -- x_msg_data
25 --
26 -- Post Success:
27 -- Processing continues.
28 --
29 -- Post Failure:
30 -- None.
31 --
32 -- Access Status:
33 -- Public.
34 --
35 -- {End Of Comments}
36 ----------------------------------------------------------------------------
37 PROCEDURE create_enroll_wf_process
38 (x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_item_key IN wf_items.item_key%TYPE,
41 p_item_type IN wf_items.item_type%TYPE,
42 p_person_id IN number default NULL,
43 p_event_title IN ota_events.title%TYPE,
44 p_course_start_date IN ota_events.course_start_date%TYPE,
45 p_course_end_date IN ota_events.course_end_date%TYPE,
46 p_version_name IN ota_activity_versions.Version_name%TYPE );
47 --
48 -- ----------------------------------------------------------------------------
49 -- |-----------------------------< cancel_enrollment>-------------------------|
50 -- ----------------------------------------------------------------------------
51 -- {Start Of Comments}
52 --
53 -- Description:
54 -- This procedure will be called from the View Enrollment Details Screen on pressing 'Submit'.
55 --
56 -- This procedure will be used to call the cancel the enrollment Id passed in and
57 -- update the Enrollment with the Cancellation details.
58 --
59 -- Pre Conditions:
60 -- None.
61 --
62 -- In Arguments:
63 -- p_init_msg_list
64 -- p_booking_id
65 -- p_event_id
66 -- p_person_id
67 -- p_booking_status_type_id
68 -- p_cancel_reason
69 -- p_username
70 -- p_waitlist_size
71 -- p_item_key
72 -- p_item_type
73 --
74 -- Out Arguments:
75 -- x_return_status
76 -- x_msg_count
77 -- x_msg_data
78 --
79 -- Post Success:
80 -- Processing continues.
81 --
82 --
83 -- Post Failure:
84 -- None.
85 --
86 -- Access Status:
87 -- Public.
88 --
89 -- {End Of Comments}
90 ----------------------------------------------------------------------------
91 PROCEDURE cancel_enrollment
92 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_booking_id IN NUMBER,
97 p_event_id IN NUMBER,
98 p_person_id IN NUMBER,
99 p_booking_status_type_id IN NUMBER,
100 p_cancel_reason IN VARCHAR2,
101 p_username IN VARCHAR2,
102 p_waitlist_size IN NUMBER,
103 p_item_key IN VARCHAR2 DEFAULT NULL,
104 p_item_type IN VARCHAR2 DEFAULT NULL,
105 p_tdb_information_category IN VARCHAR2 DEFAULT NULL,
106 p_tdb_information1 IN VARCHAR2 DEFAULT NULL,
107 p_tdb_information2 IN VARCHAR2 DEFAULT NULL,
108 p_tdb_information3 IN VARCHAR2 DEFAULT NULL,
109 p_tdb_information4 IN VARCHAR2 DEFAULT NULL,
110 p_tdb_information5 IN VARCHAR2 DEFAULT NULL,
111 p_tdb_information6 IN VARCHAR2 DEFAULT NULL,
112 p_tdb_information7 IN VARCHAR2 DEFAULT NULL,
113 p_tdb_information8 IN VARCHAR2 DEFAULT NULL,
114 p_tdb_information9 IN VARCHAR2 DEFAULT NULL,
115 p_tdb_information10 IN VARCHAR2 DEFAULT NULL,
116 p_tdb_information11 IN VARCHAR2 DEFAULT NULL,
117 p_tdb_information12 IN VARCHAR2 DEFAULT NULL,
118 p_tdb_information13 IN VARCHAR2 DEFAULT NULL,
119 p_tdb_information14 IN VARCHAR2 DEFAULT NULL,
120 p_tdb_information15 IN VARCHAR2 DEFAULT NULL,
121 p_tdb_information16 IN VARCHAR2 DEFAULT NULL,
122 p_tdb_information17 IN VARCHAR2 DEFAULT NULL,
123 p_tdb_information18 IN VARCHAR2 DEFAULT NULL,
124 p_tdb_information19 IN VARCHAR2 DEFAULT NULL,
125 p_tdb_information20 IN VARCHAR2 DEFAULT NULL
126 );
127 --
128 -- ----------------------------------------------------------------------------
129 -- |-------------------------< get_booking_status_comments >----------------------------|
130 -- ----------------------------------------------------------------------------
131 --
132 -- Description: get the comments from the booking history table for the
133 -- booking_id and booking_status_type_id passed in as parameters.
134 --
135 --
136
137 FUNCTION get_booking_status_comments(p_booking_id IN NUMBER,
138 p_booking_status_type_id IN NUMBER) RETURN VARCHAR2;
139 --
140
141 END ota_cancel_training_ss;