DBA Data[Home] [Help]

APPS.HR_PERSON_ABSENCE_SWI dependencies on HR_API_TRANSACTION_STEPS

Line 14: lv_EndDate hr_api_transaction_steps.Information1%type;

10:
11: function getEndDate(p_transaction_id in number) return date
12: IS
13: c_proc constant varchar2(30) := 'getEndDate';
14: lv_EndDate hr_api_transaction_steps.Information1%type;
15: begin
16:
17: if(p_transaction_id is not null) then
18: begin

Line 21: from hr_api_transaction_steps

17: if(p_transaction_id is not null) then
18: begin
19: select nvl(Information2,Information4)
20: into lv_EndDate
21: from hr_api_transaction_steps
22: where transaction_id=p_transaction_id;
23:
24: exception
25: when others then

Line 50: lv_startDate hr_api_transaction_steps.Information1%type;

46: function getStartDate(p_transaction_id in number) return date
47:
48: IS
49: c_proc constant varchar2(30) := 'getStartDate';
50: lv_startDate hr_api_transaction_steps.Information1%type;
51: begin
52:
53: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
54:

Line 60: from hr_api_transaction_steps

56: if(p_transaction_id is not null) then
57: begin
58: select nvl(Information1,Information3)
59: into lv_startDate
60: from hr_api_transaction_steps
61: where transaction_id=p_transaction_id;
62:
63: exception
64: when others then