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 329: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),

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

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

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

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

330: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
331: hrl.meaning)*/
332: if(p_transaction_id is not null) then
333: begin
334: select hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS',
335: decode(status,'RI','C',
336: 'RIS','S',
337: 'RO','Y',
338: 'ROS','Y',

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

370: g_debug := hr_utility.debug_enabled;
371: if g_debug then
372: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
373: end if;
374: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
375: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
376: hrl.meaning)*/
377: if(p_transaction_id is not null) then
378: begin

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

371: if g_debug then
372: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
373: end if;
374: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
375: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
376: hrl.meaning)*/
377: if(p_transaction_id is not null) then
378: begin
379: select decode(status,'RI','C',