[Home] [Help]
PACKAGE: APPS.OTA_LEARNER_ENROLL_REVIEW_SS
Source
1 PACKAGE OTA_LEARNER_ENROLL_REVIEW_SS AUTHID CURRENT_USER AS
2 /* $Header: otlnrrev.pkh 120.2 2011/03/25 04:42:51 smahanka ship $*/
3
4
5 CURSOR csr_get_booking_justification(p_booking_justification_id NUMBER) IS
6 SELECT justification_text
7 FROM ota_bkng_justifications_tl
8 WHERE language = USERENV('LANG')
9 AND booking_justification_id = p_booking_justification_id;
10
11 procedure save_add_enroll_detail(
12 p_login_person_id NUMBER default null
13 , p_item_type in varchar2
14 , p_item_key in varchar2
15 , p_activity_id in number
16 , p_save_mode in varchar2 default null
17 , p_error_message out nocopy varchar2
18 , p_eventid in VARCHAR2
19 , p_activityversionid in VARCHAR2
20 , p_specialInstruction in VARCHAR2
21 , p_keyflexId in VARCHAR2
22 , p_businessGroupId in VARCHAR2
23 , p_assignmentId in VARCHAR2
24 , p_organizationId in VARCHAR2
25 , p_from in VARCHAR2
26 , p_tdb_information_category in varchar2 default null
27 , p_tdb_information1 in varchar2 default null
28 , p_tdb_information2 in varchar2 default null
29 , p_tdb_information3 in varchar2 default null
30 , p_tdb_information4 in varchar2 default null
31 , p_tdb_information5 in varchar2 default null
32 , p_tdb_information6 in varchar2 default null
33 , p_tdb_information7 in varchar2 default null
34 , p_tdb_information8 in varchar2 default null
35 , p_tdb_information9 in varchar2 default null
36 , p_tdb_information10 in varchar2 default null
37 , p_tdb_information11 in varchar2 default null
38 , p_tdb_information12 in varchar2 default null
39 , p_tdb_information13 in varchar2 default null
40 , p_tdb_information14 in varchar2 default null
41 , p_tdb_information15 in varchar2 default null
42 , p_tdb_information16 in varchar2 default null
43 , p_tdb_information17 in varchar2 default null
44 , p_tdb_information18 in varchar2 default null
45 , p_tdb_information19 in varchar2 default null
46 , p_tdb_information20 in varchar2 default null
47 , p_delegate_person_id in NUMBER default null
48 , p_ccselectiontext in varchar2 default null
49 , p_offering_id in VARCHAR2
50 ,p_booking_justification_id in VARCHAR2 default null
51 );
52
53
54
55
56
57 PROCEDURE get_add_enr_dtl_data_from_tt
58 (p_item_type in varchar2
59 ,p_item_key in varchar2
60 ,p_activity_id in varchar2
61 ,p_trans_rec_count out nocopy number
62 ,p_person_id out nocopy number
63 ,p_add_enroll_detail_data out nocopy varchar2
64 );
65
66
67
68 procedure get_add_enr_dtl_data_from_tt
69 (p_transaction_step_id in number
70 ,p_add_enroll_detail_data out nocopy varchar2
71 );
72
73 PROCEDURE get_review_data_from_tt
74 (p_item_type in varchar2
75 ,p_item_key in varchar2
76 ,p_activity_id in varchar2
77 ,p_person_id out nocopy number
78 ,p_review_data out nocopy varchar2
79 );
80
81 procedure get_review_data_from_tt
82 (p_transaction_step_id in number
83 ,p_review_data out nocopy varchar2
84 );
85
86 procedure process_api
87 (p_validate IN BOOLEAN DEFAULT FALSE
88 ,p_transaction_step_id IN NUMBER DEFAULT NULL
89 );
90
91 procedure process_api2
92 (p_validate IN BOOLEAN DEFAULT FALSE
93 ,p_transaction_step_id IN NUMBER DEFAULT NULL
94 ,p_effective_date in varchar2 DEFAULT NULL
95 );
96
97 procedure create_enrollment
98 (itemtype in varchar2,
99 itemkey in varchar2,
100 actid in number,
101 funmode in varchar2,
102 result out nocopy varchar2 );
103
104 procedure cancel_enrollment
105 (itemtype in varchar2,
106 itemkey in varchar2,
107 actid in number,
108 funmode in varchar2,
109 result out nocopy varchar2 );
110
111 procedure validate_enrollment
112 (p_item_type in varchar2,
113 p_item_key in varchar2,
114 p_message out nocopy varchar2) ;
115
116
117 Procedure create_segment
118 (p_assignment_id in number
119 ,p_business_group_id_from in number
120 ,p_business_group_id_to in number
121 ,p_organization_id in number
122 ,p_sponsor_organization_id in number
123 ,p_event_id in number
124 ,p_person_id in number
125 ,p_currency_code in varchar2
126 ,p_cost_allocation_keyflex_id in number
127 ,p_user_id in number
128 ,p_finance_header_id out nocopy number
129 ,p_object_version_number out nocopy number
130 ,p_result out nocopy varchar2
131 ,p_from_result out nocopy varchar2
132 ,p_to_result out nocopy varchar2
133 ,p_auto_transfer in varchar2);
134
135
136 --
137 -- ----------------------------------------
138 -- Workflow Cross Charges Notifications
139 -- ----------------------------------------
140 --
141 Procedure Cross_Charges_Notifications ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
142 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
143 actid IN NUMBER,
144 funcmode IN VARCHAR2,
145 resultout OUT nocopy VARCHAR2 );
146
147 -- ----------------------------------------
148 -- Workflow Delivery Mode based Notifications
149 -- ----------------------------------------
150
151 Procedure Delivery_Mode_Notifications ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
152 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
153 actid IN NUMBER,
154 funcmode IN VARCHAR2,
155 resultout OUT nocopy VARCHAR2 );
156
157 Procedure APPROVED ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
158 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
159 actid IN NUMBER,
160 funcmode IN VARCHAR2,
161 resultout OUT nocopy VARCHAR2 );
162
163 Function is_class_pending_for_approval
164 (p_event_id in varchar2,
165 p_person_id in number,
166 p_process_name in varchar2)
167 RETURN VARCHAR2;
168
169 -- ---------------------------------------------------------------------------
170 -- |----------------------< get_approval_req >--------------------------|
171 -- ---------------------------------------------------------------------------
172 --
173 PROCEDURE get_approval_req ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
174 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
175 actid IN NUMBER,
176 funcmode IN VARCHAR2,
177 resultout OUT nocopy VARCHAR2 );
178
179 -- ---------------------------------------------------------------------------
180 -- |----------------------< ntf_details_to_lrnr >--------------------------|
181 -- ---------------------------------------------------------------------------
182 --
183
184 PROCEDURE ntf_details_to_lrnr ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
185 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
186 actid IN NUMBER,
187 funcmode IN VARCHAR2,
188 resultout OUT nocopy VARCHAR2 );
189
190 end ota_learner_enroll_review_ss;