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.15.12020000.2 2012/07/05 04:30:42 amnaraya ship $ */
3:
4: -- Global Variables
5: TYPE cur_typ IS REF CURSOR;

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

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

Line 3650: per_empdir_ss.write_log(1,

3646: value1 := value2;
3647: value2 := l_tmp;
3648:
3649: EXCEPTION WHEN OTHERS THEN
3650: per_empdir_ss.write_log(1,
3651: 'Error in swap: '||SQLCODE);
3652: per_empdir_ss.write_log(1,
3653: 'Error Msg: '||substr(SQLERRM,1,700));
3654: END swap;

Line 3652: per_empdir_ss.write_log(1,

3648:
3649: EXCEPTION WHEN OTHERS THEN
3650: per_empdir_ss.write_log(1,
3651: 'Error in swap: '||SQLCODE);
3652: per_empdir_ss.write_log(1,
3653: 'Error Msg: '||substr(SQLERRM,1,700));
3654: END swap;
3655:
3656: PROCEDURE main(

Line 3923: END PER_EMPDIR_SS;

3919: EXCEPTION WHEN OTHERS THEN
3920: RETURN NULL;
3921: END get_timezone_id;
3922:
3923: END PER_EMPDIR_SS;