APPS.PER_EMPDIR_SS dependencies on PER_EMPDIR_SS

Line 1: PACKAGE BODY PER_EMPDIR_SS AS

1: PACKAGE BODY PER_EMPDIR_SS AS
2: /* $Header: peredrcp.pkb 120.11.12010000.2 2009/02/03 13:22:46 pvelugul ship $ */
3:
4: -- Global Variables
5: TYPE cur_typ IS REF CURSOR;

Line 715: ' per_empdir_SS.get_timezone_code(postal_code, town_or_city,' ||

711: ' ,postal_code, inactive_date, office_site_flag, receiving_site_flag' ||
712: ' ,telephone_number_1, telephone_number_2, telephone_number_3' ||
713: ' ,null' ||
714: ' ,nvl(TIMEZONE_CODE,' ||
715: ' per_empdir_SS.get_timezone_code(postal_code, town_or_city,' ||
716: ' decode(country,''US'',region_2,region_1), country))' ||
717: ' ,object_version_number' ||
718: ' ,1 ' ||
719: ' FROM hr_locations_all l';

Line 3644: per_empdir_ss.write_log(1,

3640: value1 := value2;
3641: value2 := l_tmp;
3642:
3643: EXCEPTION WHEN OTHERS THEN
3644: per_empdir_ss.write_log(1,
3645: 'Error in swap: '||SQLCODE);
3646: per_empdir_ss.write_log(1,
3647: 'Error Msg: '||substr(SQLERRM,1,700));
3648: END swap;

Line 3646: per_empdir_ss.write_log(1,

3642:
3643: EXCEPTION WHEN OTHERS THEN
3644: per_empdir_ss.write_log(1,
3645: 'Error in swap: '||SQLCODE);
3646: per_empdir_ss.write_log(1,
3647: 'Error Msg: '||substr(SQLERRM,1,700));
3648: END swap;
3649:
3650: PROCEDURE main(

Line 3917: END PER_EMPDIR_SS;

3913: EXCEPTION WHEN OTHERS THEN
3914: RETURN NULL;
3915: END get_timezone_id;
3916:
3917: END PER_EMPDIR_SS;