DBA Data[Home] [Help]

APPS.PER_PERUSHRM_XMLP_PKG dependencies on FND_GLOBAL

Line 246: g_delimiter varchar2(1) := fnd_global.local_chr(10);

242: l_emp_country varchar2(10);
243: l_person_id number(15);
244: l_location_id number(15);
245: l_name varchar(60) := 'New_Hire_Record';
246: g_delimiter varchar2(1) := fnd_global.local_chr(10);
247: l_date_start varchar2(10);
248: l_date_of_birth varchar2(10);
249:
250:

Line 650: g_delimiter varchar2(1) := fnd_global.local_chr(10);

646: l_location_id number(15);
647: l_tax_unit_name varchar2(240);
648: l_name varchar2(60) := 'a01_header_record';
649: l_zip varchar2(10);
650: g_delimiter varchar2(1) := fnd_global.local_chr(10);
651:
652: CURSOR c_tax_unit_name IS
653: select hou.name
654: ,hou.location_id

Line 706: g_delimiter varchar2(1) := fnd_global.local_chr(10);

702: END;
703:
704: procedure a01_total_record(CS_NO_OF_NEW_HIRE in number) is
705: l_name varchar(60) := 'a01_total_record';
706: g_delimiter varchar2(1) := fnd_global.local_chr(10);
707: l_total_number number(10);
708:
709:
710: BEGIN

Line 872: g_delimiter varchar2(1) := fnd_global.local_chr(10);

868: v_first_name per_people_f.first_name%TYPE;
869: v_last_name per_people_f.last_name%TYPE;
870: v_state hr_locations_all.region_2%TYPE;
871: l_name varchar(60) := 'P_MAG_UPDATE_STATUS';
872: g_delimiter varchar2(1) := fnd_global.local_chr(10);
873:
874: BEGIN
875: hr_utility.set_location('Entered ......:' || l_name,10);
876: if c_person_id%ISOPEN then

Line 950: g_delimiter varchar2(1) := fnd_global.local_chr(10);

946:
947: function CF_GREFormula (FEDERAL_ID in varchar2,gre_location_id in number,TAX_UNIT_ID in number,TAX_UNIT_NAME in varchar2,SIT_COMPANY_STATE_ID in varchar2)return Number is
948: l_name varchar2(60) := 'CF_GREFormula';
949: l_buffer varchar2(1000);
950: g_delimiter varchar2(1) := fnd_global.local_chr(10);
951: begin
952:
953: hr_utility.set_location('Entering...' || l_name,0);
954: hr_utility.trace('p_audit_report = ' || p_audit_report);

Line 1142: g_delimiter varchar2(1) := fnd_global.local_chr(10);

1138: l_trans_state varchar2(50);
1139: l_trans_zip varchar2(10);
1140: l_trans_zip_extension varchar2(10);
1141: l_branch_code varchar2(3) := ' '; l_name varchar2(61) := 'GRE_RECORD';
1142: g_delimiter varchar2(1) := fnd_global.local_chr(10);
1143: l_tx_emp_num number := 0;
1144: l_tx_term_num number := 0;
1145:
1146: CURSOR c_transmitter IS