Oracle apps EBS r12 Report for the HRMS and Payroll Report - Report Name - Time to Hire Report

Oracle apps EBS r12 Report for the HRMS and Payroll Report - Report Name - Time to Hire Report

Template File - RTF File Design :

Download the Format of the RTF File means Template File:

https://drive.google.com/file/d/1oCknbvMURjvbQ0TsSM3VHGVQ5vRGZY-p/view?usp=sharing

Format Like This.

Time to Hire Report

Sl.

MRF No.

Legal Entity

Department

Sub-Department

Designation

Grade

Type of Recruitment

MRF Generation Date

MRF Approval Date

Appointment Letter Issue Date

Time to Hire (in Days)

FEP

MRF

LE

DEPT

SUB

DESIG

GRD

TYPE

DATE

DATE

DATE

TOHE

-----------------------------------------------------------------------------------------------

---------------------------------- XXBEXTIMETOHIREREP.xml --------------------------

Data Definition File :

Download the Format of the Data Definition File :

https://drive.google.com/file/d/1PrT6TAmkDFh8qYK8YmGtUn7XafAboaPk/view?usp=sharing

<?xml version="1.0" encoding="UTF-8" ?>

          <dataTemplate name="XXBEXTIMETOHIREREP" version="1.0">

                   <properties>

                             <property name="xml_tag_case" value="upper" />

                   </properties>

                  

                   <parameters>

                             <parameter name="P_IN_CHR_LE" dataType = "VARCHAR2"></parameter>

                             <parameter name="P_IN_CHR_DEPT" dataType = "VARCHAR2"></parameter>

                             <parameter name="P_IN_CHR_GRADE" dataType = "VARCHAR2"></parameter>

                             <parameter name="P_IN_FROM_DATE" dataType = "VARCHAR2"></parameter>

                             <parameter name="P_IN_TO_DATE" dataType = "VARCHAR2"></parameter>

                   </parameters>

                   <dataQuery>

                             <sqlStatement name="Q_HIRETIME">

<![CDATA[

SELECT pr.attribute1 legal_entity,

  pr.attribute2 dept,

  pv.NAME mrf_num,

  TO_CHAR(pr.date_from,'DD-Mon-YYYY') mrf_generation_date,

  substr(pp.name,instr(pp.name,'|')+1,instr(pp.name,'|',1,2)-instr(pp.name,'|',1,1)-1) sub_dept,

  pj.NAME designation,

  SUBSTR(pg.NAME,instr(pg.NAME,'.')+1) grade,

  TO_CHAR(pv.date_from,'DD-Mon-YYYY') mrf_approval_date,

  TO_CHAR(to_date(pv.attribute8,'YYYY/MM/DD HH24:MI:SS'),'DD-Mon-YYYY') appoint_letter_issue_date,

  (SELECT lukp.meaning

  FROM hr_lookups lukp

  WHERE 1         =1

  AND lookup_type = 'VACANCY_CATEGORY'

  AND lookup_code = pv.vacancy_category

  ) vacancy_categ,

  to_date(pv.attribute8,'YYYY/MM/DD HH24:MI:SS')-pv.date_from time_to_hire

FROM per_vacancies pv,

  per_requisitions pr,

  per_grades pg,

  per_jobs pj,

  per_positions pp,

  hr_all_organization_units haou

WHERE pv.requisition_id =pr.requisition_id

AND pr.business_group_id=pv.business_group_id

AND pv.grade_id         = pg.grade_id(+)

AND pv.job_id           = pj.job_id(+)

AND pv.position_id      = pp.position_id(+)

AND pv.organization_id  = haou.organization_id(+)

AND pr.attribute1 = nvl(:P_IN_CHR_LE,pr.attribute1)

AND pr.attribute2 = nvl(:P_IN_CHR_DEPT,pr.attribute2)

AND nvl(SUBSTR(pg.NAME,instr(pg.NAME,'.')+1),'N') = nvl(:P_IN_CHR_GRADE,nvl(SUBSTR(pg.NAME,instr(pg.NAME,'.')+1),'N'))

AND pr.date_from between to_date(:P_IN_FROM_DATE,'YYYY/MM/DD HH24:MI:SS') and to_date(:P_IN_TO_DATE,'YYYY/MM/DD HH24:MI:SS')

  ]]>

                                      </sqlStatement>

                   </dataQuery>

                  

                   <dataStructure>

                             <group name="G_HIRETIME" dataType="varchar2" source="Q_HIRETIME">

                                 <element name="LEGAL_ENTITY" dataType="varchar2" value="LEGAL_ENTITY"/>

                                      <element name="DEPT" dataType="varchar2" value="DEPT"/>

                                      <element name="MRF_NUM" dataType="varchar2" value="MRF_NUM"/>

                                      <element name="MRF_GENERATION_DATE" dataType="varchar2" value="MRF_GENERATION_DATE"/>

                                      <element name="SUB_DEPT" dataType="varchar2" value="SUB_DEPT"/>

                                      <element name="DESIGNATION" dataType="varchar2" value="DESIGNATION"/>

                                      <element name="GRADE" dataType="varchar2" value="GRADE"/>

                                      <element name="MRF_APPROVAL_DATE" dataType="varchar2" value="MRF_APPROVAL_DATE"/>

                                      <element name="APPOINT_LETTER_ISSUE_DATE" dataType="varchar2" value="APPOINT_LETTER_ISSUE_DATE"/>

                                      <element name="VACANCY_CATEG" dataType="varchar2" value="VACANCY_CATEG"/>

                                      <element name="TIME_TO_HIRE" dataType="varchar2" value="TIME_TO_HIRE"/>

                             </group>

                   </dataStructure>

          </dataTemplate>

---------------------------------- End----------------

Download the Format of the XXBEXTIMETOHIREREP.rtf::

https://drive.google.com/file/d/1oCknbvMURjvbQ0TsSM3VHGVQ5vRGZY-p/view?usp=sharing

Download the Format of the XXBEXTIMETOHIREREP.xml ::

https://drive.google.com/file/d/1PrT6TAmkDFh8qYK8YmGtUn7XafAboaPk/view?usp=sharing

Download the Format of the 

XXBEXTIMETOHIREREP_CP.ldt::

https://drive.google.com/file/d/1q9QTGVnWSYu2l9av3QvhBp677Q-fvWJS/view?usp=sharing

Download the Format of the 

XXBEXTIMETOHIREREP_DD.ldt ::

https://drive.google.com/file/d/16CHbWIa7o1wVk1JyLm7Lg8LRrtOESdjx/view?usp=sharing

Download the Format of the 

XXBEXTIMETOHIREREP_REQ.ldt::

https://drive.google.com/file/d/1jHyBgRrerD0FhQVoYAudGePNp8mXI0Tn/view?usp=sharing