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 642: g_delimiter varchar2(1) := fnd_global.local_chr(10);

638: l_location_id number(15);
639: l_tax_unit_name varchar2(240);
640: l_name varchar2(60) := 'a01_header_record';
641: l_zip varchar2(10);
642: g_delimiter varchar2(1) := fnd_global.local_chr(10);
643:
644: CURSOR c_tax_unit_name IS
645: select hou.name
646: ,hou.location_id

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

694: END;
695:
696: procedure a01_total_record(CS_NO_OF_NEW_HIRE in number) is
697: l_name varchar(60) := 'a01_total_record';
698: g_delimiter varchar2(1) := fnd_global.local_chr(10);
699: l_total_number number(10);
700:
701:
702: BEGIN

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

860: v_first_name per_people_f.first_name%TYPE;
861: v_last_name per_people_f.last_name%TYPE;
862: v_state hr_locations_all.region_2%TYPE;
863: l_name varchar(60) := 'P_MAG_UPDATE_STATUS';
864: g_delimiter varchar2(1) := fnd_global.local_chr(10);
865:
866: BEGIN
867: hr_utility.set_location('Entered ......:' || l_name,10);
868: if c_person_id%ISOPEN then

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

938:
939: 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
940: l_name varchar2(60) := 'CF_GREFormula';
941: l_buffer varchar2(1000);
942: g_delimiter varchar2(1) := fnd_global.local_chr(10);
943: begin
944:
945: hr_utility.set_location('Entering...' || l_name,0);
946: hr_utility.trace('p_audit_report = ' || p_audit_report);

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

1130: l_trans_state varchar2(50);
1131: l_trans_zip varchar2(10);
1132: l_trans_zip_extension varchar2(10);
1133: l_branch_code varchar2(3) := ' '; l_name varchar2(61) := 'GRE_RECORD';
1134: g_delimiter varchar2(1) := fnd_global.local_chr(10);
1135: l_tx_emp_num number := 0;
1136: l_tx_term_num number := 0;
1137:
1138: CURSOR c_transmitter IS