APPS.HR_ABSUTIL_SS dependencies on HR_API_TRANSACTION_STEPS

Line 17: lv_startDate hr_api_transaction_steps.Information1%type;

13: p_absence_attendance_id in number) return date
14:
15: IS
16: c_proc constant varchar2(30) := 'getStartDate';
17: lv_startDate hr_api_transaction_steps.Information1%type;
18: begin
19: g_debug := hr_utility.debug_enabled;
20: if g_debug then
21: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 28: from hr_api_transaction_steps

24: if(p_transaction_id is not null) then
25: begin
26: select nvl(Information1,Information3)
27: into lv_startDate
28: from hr_api_transaction_steps
29: where transaction_id=p_transaction_id;
30:
31: exception
32: when others then

Line 59: lv_EndDate hr_api_transaction_steps.Information1%type;

55: p_absence_attendance_id in number) return date
56:
57: IS
58: c_proc constant varchar2(30) := 'getEndDate';
59: lv_EndDate hr_api_transaction_steps.Information1%type;
60: begin
61: g_debug := hr_utility.debug_enabled;
62: if g_debug then
63: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 69: from hr_api_transaction_steps

65: if(p_transaction_id is not null) then
66: begin
67: select nvl(Information2,Information4)
68: into lv_EndDate
69: from hr_api_transaction_steps
70: where transaction_id=p_transaction_id;
71:
72: exception
73: when others then

Line 113: from hr_api_transaction_steps

109: if(p_transaction_id is not null) then
110: begin
111: select Information5
112: into lv_AbsenceTypeId
113: from hr_api_transaction_steps
114: where transaction_id=p_transaction_id;
115:
116: exception
117: when others then

Line 155: lv_AbsenceCategory hr_api_transaction_steps.Information6%type;

151: p_absence_attendance_id in number) return varchar2
152:
153: IS
154: c_proc constant varchar2(30) := 'getAbsenceCategory';
155: lv_AbsenceCategory hr_api_transaction_steps.Information6%type;
156: begin
157: g_debug := hr_utility.debug_enabled;
158: if g_debug then
159: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 177: from hr_api_transaction_steps

173: if(p_transaction_id is not null) then
174: begin
175: select Information6
176: into lv_AbsenceCategory
177: from hr_api_transaction_steps
178: where transaction_id=p_transaction_id;
179: exception
180: when others then
181: lv_AbsenceCategory:=null;

Line 201: lv_AbsenceHoursDuration hr_api_transaction_steps.Information7%type;

197: p_absence_attendance_id in number) return number
198:
199: IS
200: c_proc constant varchar2(30) := 'getAbsenceHoursDuration';
201: lv_AbsenceHoursDuration hr_api_transaction_steps.Information7%type;
202: begin
203: g_debug := hr_utility.debug_enabled;
204: if g_debug then
205: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 211: from hr_api_transaction_steps

207: if(p_transaction_id is not null) then
208: begin
209: select Information7
210: into lv_AbsenceHoursDuration
211: from hr_api_transaction_steps
212: where transaction_id=p_transaction_id;
213: exception
214: when others then
215: lv_AbsenceHoursDuration:=null;

Line 237: lv_AbsenceDaysDuration hr_api_transaction_steps.Information8%type;

233: p_absence_attendance_id in number) return number
234:
235: IS
236: c_proc constant varchar2(30) := 'getAbsenceDaysDuration';
237: lv_AbsenceDaysDuration hr_api_transaction_steps.Information8%type;
238: begin
239: g_debug := hr_utility.debug_enabled;
240: if g_debug then
241: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 247: from hr_api_transaction_steps

243: if(p_transaction_id is not null) then
244: begin
245: select Information8
246: into lv_AbsenceDaysDuration
247: from hr_api_transaction_steps
248: where transaction_id=p_transaction_id;
249: exception
250: when others then
251: lv_AbsenceDaysDuration:=null;

Line 364: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;

360: p_absence_attendance_id in number) return varchar2
361:
362: IS
363: c_proc constant varchar2(30) := 'getAbsenceStatus';
364: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;
365: begin
366: g_debug := hr_utility.debug_enabled;
367: if g_debug then
368: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 379: from hr_api_transaction_steps

375: and fnd_lookup_values.lookup_code=Information9
376: and language = userenv('LANG')
377: )
378: into lv_AbsenceStatus
379: from hr_api_transaction_steps
380: where transaction_id=p_transaction_id;
381: exception
382: when others then
383: lv_AbsenceStatus:=null;

Line 743: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;

739: function getAbsenceStatusValue(p_transaction_id in Varchar2) return varchar2
740:
741: IS
742: c_proc constant varchar2(30) := 'getAbsenceStatusValue';
743: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;
744: begin
745: g_debug := hr_utility.debug_enabled;
746: if g_debug then
747: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 758: from hr_api_transaction_steps

754: and fnd_lookup_values.lookup_code=Information9
755: and language = userenv('LANG')
756: )
757: into lv_AbsenceStatus
758: from hr_api_transaction_steps
759: where transaction_id=p_transaction_id;
760: exception
761: when others then
762: lv_AbsenceStatus:=null;