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 203: lv_AbsenceCategory hr_api_transaction_steps.Information6%type;

199: p_absence_attendance_id in number) return varchar2
200:
201: IS
202: c_proc constant varchar2(30) := 'getAbsenceCategoryCode';
203: lv_AbsenceCategory hr_api_transaction_steps.Information6%type;
204: l_lookup_code_val varchar2(10);
205:
206: Cursor c_lookup_code(AbsenceCat varchar2) is select LOOKUP_CODE from fnd_lookup_values flv
207: where flv.MEANING = AbsenceCat and flv.lookup_type = 'ABSENCE_CATEGORY';

Line 218: from hr_api_transaction_steps

214: if(p_transaction_id is not null) then
215: begin
216: select Information6
217: into lv_AbsenceCategory
218: from hr_api_transaction_steps
219: where transaction_id=p_transaction_id;
220: exception
221: when others then
222: lv_AbsenceCategory:=null;

Line 247: lv_AbsenceHoursDuration hr_api_transaction_steps.Information7%type;

243: p_absence_attendance_id in number) return number
244:
245: IS
246: c_proc constant varchar2(30) := 'getAbsenceHoursDuration';
247: lv_AbsenceHoursDuration hr_api_transaction_steps.Information7%type;
248: begin
249: g_debug := hr_utility.debug_enabled;
250: if g_debug then
251: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 257: from hr_api_transaction_steps

253: if(p_transaction_id is not null) then
254: begin
255: select Information7
256: into lv_AbsenceHoursDuration
257: from hr_api_transaction_steps
258: where transaction_id=p_transaction_id;
259: exception
260: when others then
261: lv_AbsenceHoursDuration:=null;

Line 284: lv_AbsenceDaysDuration hr_api_transaction_steps.Information8%type;

280: p_absence_attendance_id in number) return number
281:
282: IS
283: c_proc constant varchar2(30) := 'getAbsenceDaysDuration';
284: lv_AbsenceDaysDuration hr_api_transaction_steps.Information8%type;
285: begin
286: g_debug := hr_utility.debug_enabled;
287: if g_debug then
288: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 294: from hr_api_transaction_steps

290: if(p_transaction_id is not null) then
291: begin
292: select Information8
293: into lv_AbsenceDaysDuration
294: from hr_api_transaction_steps
295: where transaction_id=p_transaction_id;
296: exception
297: when others then
298: lv_AbsenceDaysDuration:=null;

Line 413: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;

409: p_absence_attendance_id in number) return varchar2
410:
411: IS
412: c_proc constant varchar2(30) := 'getAbsenceStatus';
413: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;
414: begin
415: g_debug := hr_utility.debug_enabled;
416: if g_debug then
417: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 428: from hr_api_transaction_steps

424: and fnd_lookup_values.lookup_code=Information9
425: and language = userenv('LANG')
426: )
427: into lv_AbsenceStatus
428: from hr_api_transaction_steps
429: where transaction_id=p_transaction_id;
430: exception
431: when others then
432: lv_AbsenceStatus:=null;

Line 792: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;

788: function getAbsenceStatusValue(p_transaction_id in Varchar2) return varchar2
789:
790: IS
791: c_proc constant varchar2(30) := 'getAbsenceStatusValue';
792: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;
793: begin
794: g_debug := hr_utility.debug_enabled;
795: if g_debug then
796: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 807: from hr_api_transaction_steps

803: and fnd_lookup_values.lookup_code=Information9
804: and language = userenv('LANG')
805: )
806: into lv_AbsenceStatus
807: from hr_api_transaction_steps
808: where transaction_id=p_transaction_id;
809: exception
810: when others then
811: lv_AbsenceStatus:=null;