DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on HR_PUMP_GET

Line 1: package body hr_pump_get as

1: package body hr_pump_get as
2: /* $Header: hrdpget.pkb 120.2 2010/03/18 12:32:49 pvelvano ship $ */
3: /*
4: NOTES
5: Please refer to the package header for documentation on these

Line 2136: --hr_data_pump.message('**bp** in hr_pump_get.get_cur_code: '|| p_name_or_code);

2132: p_effective_date in date
2133: ) return varchar2 is
2134: l_code fnd_currencies_vl.currency_code%type;
2135: begin
2136: --hr_data_pump.message('**bp** in hr_pump_get.get_cur_code: '|| p_name_or_code);
2137: --
2138: begin
2139: if p_name_or_code is null or p_name_or_code = hr_api.g_varchar2
2140: then

Line 2158: --hr_data_pump.message('**bp** out hr_pump_get.get_cur_code: '||l_code);

2154: and p_effective_date between
2155: nvl(start_date_active, START_OF_TIME) and nvl(end_date_active, END_OF_TIME);
2156: end if;
2157: --
2158: --hr_data_pump.message('**bp** out hr_pump_get.get_cur_code: '||l_code);
2159: return(l_code);
2160: exception
2161: when no_data_found then
2162: --

Line 2173: --hr_data_pump.message('**bp** out hr_pump_get.get_cur_code: '||l_code);

2169: and enabled_flag = 'Y'
2170: and p_effective_date between
2171: nvl(start_date_active, START_OF_TIME) and nvl(end_date_active, END_OF_TIME);
2172: --
2173: --hr_data_pump.message('**bp** out hr_pump_get.get_cur_code: '||l_code);
2174: return(l_code);
2175: when others then
2176: raise;
2177: end;

Line 5880: end hr_pump_get;

5876: begin
5877: -- Initialise the debugging information structure.
5878: null;
5879:
5880: end hr_pump_get;