DBA Data[Home] [Help]

APPS.HR_ABSUTIL_SS dependencies on HR_GENERAL

Line 108: -- hr_general.decode_lookup('ABSENCE_CATEGORY',hats.Information4)

104: g_debug := hr_utility.debug_enabled;
105: if g_debug then
106: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
107: end if;
108: -- hr_general.decode_lookup('ABSENCE_CATEGORY',hats.Information4)
109: if(p_transaction_id is not null) then
110: begin
111: select Information5
112: into lv_AbsenceTypeId

Line 280: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),

276: g_debug := hr_utility.debug_enabled;
277: if g_debug then
278: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
279: end if;
280: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
281: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
282: hrl.meaning)*/
283: if(p_transaction_id is not null) then
284: begin

Line 281: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),

277: if g_debug then
278: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
279: end if;
280: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
281: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
282: hrl.meaning)*/
283: if(p_transaction_id is not null) then
284: begin
285: select hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS',

Line 285: select hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS',

281: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
282: hrl.meaning)*/
283: if(p_transaction_id is not null) then
284: begin
285: select hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS',
286: decode(status,'RI','C',
287: 'RIS','S',
288: 'RO','Y',
289: 'ROS','Y',

Line 325: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),

321: g_debug := hr_utility.debug_enabled;
322: if g_debug then
323: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
324: end if;
325: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
326: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
327: hrl.meaning)*/
328: if(p_transaction_id is not null) then
329: begin

Line 326: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),

322: if g_debug then
323: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
324: end if;
325: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
326: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
327: hrl.meaning)*/
328: if(p_transaction_id is not null) then
329: begin
330: select decode(status,'RI','C',