[Home] [Help]
PACKAGE: APPS.OTA_EL_TRAINING_SS
Source
1 package OTA_EL_TRAINING_SS AUTHID CURRENT_USER AS
2 /* $Header: oteltwrs.pkh 115.1 2003/04/09 11:42:59 pgupta noship $*/
3
4 gv_wf_review_region_item constant wf_item_attributes.name%type
5 := 'HR_REVIEW_REGION_ITEM';
6 /*
7 ||===========================================================================
8 || PROCEDURE: save_adv_search
9 ||---------------------------------------------------------------------------
10 ||
11 || Description:
12 || Description:
13 || This procedure will save Advance Search items in Transaction table
14 ||
15 ||
16 || Pre Conditions:
17 ||
18 || In Arguments:
19 ||
20 ||
21 ||
22 || Out Arguments:
23 ||
24 || In Out Arguments:
25 ||
26 || Post Success:
27 ||
28 ||
29 || Post Failure:
30 || Raises an exception
31 ||
32 || Access Status:
33 || Public.
34 ||
35 ||===========================================================================
36 */
37
38 procedure save_adv_search(
39 p_login_person_id NUMBER default null
40 , p_item_type in varchar2
41 , p_item_key in varchar2
42 , p_activity_id in number
43 , p_save_mode in varchar2 default null
44 , p_error_message out nocopy varchar2
45 , p_language in VARCHAR2
46 , p_trndates in VARCHAR2
47 , p_trnorgids in VARCHAR2
48 , p_trnorgnames in VARCHAR2
49 );
50
51
52
53 procedure save_add_enroll_detail(
54 p_login_person_id NUMBER default null
55 , p_item_type in varchar2
56 , p_item_key in varchar2
57 , p_activity_id in number
58 , p_save_mode in varchar2 default null
59 , p_error_message out nocopy varchar2
60 , p_eventid in VARCHAR2
61 , p_activityversionid in VARCHAR2
62 , p_specialInstruction in VARCHAR2
63 , p_keyflexId in VARCHAR2
64 , p_businessGroupId in VARCHAR2
65 , p_assignmentId in VARCHAR2
66 , p_organizationId in VARCHAR2
67 , p_from in VARCHAR2
68 , p_tdb_information_category in varchar2 default null
69 , p_tdb_information1 in varchar2 default null
70 , p_tdb_information2 in varchar2 default null
71 , p_tdb_information3 in varchar2 default null
72 , p_tdb_information4 in varchar2 default null
73 , p_tdb_information5 in varchar2 default null
74 , p_tdb_information6 in varchar2 default null
75 , p_tdb_information7 in varchar2 default null
76 , p_tdb_information8 in varchar2 default null
77 , p_tdb_information9 in varchar2 default null
78 , p_tdb_information10 in varchar2 default null
79 , p_tdb_information11 in varchar2 default null
80 , p_tdb_information12 in varchar2 default null
81 , p_tdb_information13 in varchar2 default null
82 , p_tdb_information14 in varchar2 default null
83 , p_tdb_information15 in varchar2 default null
84 , p_tdb_information16 in varchar2 default null
85 , p_tdb_information17 in varchar2 default null
86 , p_tdb_information18 in varchar2 default null
87 , p_tdb_information19 in varchar2 default null
88 , p_tdb_information20 in varchar2 default null
89 , p_delegate_person_id in NUMBER default null
90 , p_ccselectiontext in varchar2 default null
91 , p_oafunc in varchar2 default null
92 , p_processname in varchar2 default null
93 , p_calledfrom in varchar2 default null
94 , p_frommenu in varchar2 default null
95 );
96
97
98
99
100
101
102 PROCEDURE get_add_enr_dtl_data_from_tt
103 (p_item_type in varchar2
104 ,p_item_key in varchar2
105 ,p_activity_id in varchar2
106 ,p_trans_rec_count out nocopy number
107 ,p_person_id out nocopy number
108 ,p_add_enroll_detail_data out nocopy varchar2
109 );
110
111
112
113 procedure get_add_enr_dtl_data_from_tt
114 (p_transaction_step_id in number
115 ,p_add_enroll_detail_data out nocopy varchar2
116 );
117
118 PROCEDURE get_review_data_from_tt
119 (p_item_type in varchar2
120 ,p_item_key in varchar2
121 ,p_activity_id in varchar2
122 ,p_person_id out nocopy number
123 ,p_review_data out nocopy varchar2
124 );
125
126 procedure get_review_data_from_tt
127 (p_transaction_step_id in number
128 ,p_review_data out nocopy varchar2
129 );
130
131 procedure process_api
132 (p_validate IN BOOLEAN DEFAULT FALSE
133 ,p_transaction_step_id IN NUMBER DEFAULT NULL
134 );
135
136 procedure process_api2
137 (p_validate IN BOOLEAN DEFAULT FALSE
138 ,p_transaction_step_id IN NUMBER DEFAULT NULL
139 );
140
141 procedure create_enrollment
142 (itemtype in varchar2,
143 itemkey in varchar2,
144 actid in number,
145 funmode in varchar2,
146 result out nocopy varchar2 );
147
148
149
150 procedure validate_enrollment
151 (p_item_type in varchar2,
152 p_item_key in varchar2);
153
154
155 Procedure create_segment
156 (p_assignment_id in number
157 ,p_business_group_id_from in number
158 ,p_business_group_id_to in number
159 ,p_organization_id in number
160 ,p_sponsor_organization_id in number
161 ,p_event_id in number
162 ,p_person_id in number
163 ,p_currency_code in varchar2
164 ,p_cost_allocation_keyflex_id in number
165 ,p_user_id in number
166 ,p_finance_header_id out nocopy number
167 ,p_object_version_number out nocopy number
168 ,p_result out nocopy varchar2
169 ,p_from_result out nocopy varchar2
170 ,p_to_result out nocopy varchar2
171 ,p_auto_transfer in varchar2);
172
173
174
175 end OTA_EL_TRAINING_SS;
176