Oracle apps EBS r12 Report for the HRMS and
Payroll Report - Report Name - Condolence Letter
Template
File - RTF File Design :
Format Like This.
XX CHEMICAL DIVISION
CONDOLENCE
The Management and Staff of XX Chemical
Division have been deeply shocked at the sad demise of the REL of NAME,
POS,
DEPT Department
on DATE.
We shall pray for the salvation of the
departed soul and may the Almighty give patience to the bereaved family to bear
this great loss.
On behalf of the Management and Staff
(HOD)
HOD_DESIG
-----------------------------------------------------------------------------------------------
------------------------- XXBEXCONDOLENCELETTR.xml
--------------------------
Data
Definition File :
<?xml
version="1.0" encoding="UTF-8" ?>
<dataTemplate name="XXBEXCONDOLENCELETTR"
version="1.0">
<properties>
<property
name="xml_tag_case" value="upper" />
</properties>
<parameters>
<parameter name="P_IN_PERSON_ID"
dataType = "VARCHAR2"></parameter>
<parameter
name="P_IN_EFFECTIVE_DATE" dataType =
"VARCHAR2"></parameter>
<parameter
name="P_RELATION" dataType =
"VARCHAR2"></parameter>
</parameters>
<dataQuery>
<sqlStatement name="Q_CONDOLENCE">
<![CDATA[
SELECT
TO_CHAR(SYSDATE,'DD-Mon-YYYY') server_date,
trim(initcap(papf.title
||' '
||papf.first_name
||' '
||papf.middle_names
||DECODE(papf.middle_names,NULL,'',' ')
||papf.last_name)) employee_name,
pjd.segment2 designation,
ppd.segment3 department,
:P_RELATION relation,
TO_CHAR(to_date(:P_IN_EFFECTIVE_DATE,'YYYY/MM/DD
HH24:MI:SS'),'DD-Mon-YYYY') effect_date,
(SELECT trim(initcap(ppf.first_name
||' '
||ppf.middle_names
||DECODE(ppf.middle_names,NULL,'',' ')
||ppf.last_name)) person_name
FROM per_people_extra_info pei ,
per_all_people_f ppf ,
fnd_user usr ,
pqh_roles rls
WHERE information_type = 'PQH_ROLE_USERS'
AND pei.person_id = ppf.person_id
AND TRUNC(sysdate) BETWEEN
ppf.effective_start_date AND ppf.effective_end_date
AND usr.employee_id = ppf.person_id
AND rls.role_name = 'HR Letters Signatory'
AND rls.role_id = to_number(pei.pei_information3)
AND rownum =1
) hr_head,
(SELECT jobd.segment2
FROM per_people_extra_info pei ,
per_all_people_f ppf ,
fnd_user usr ,
pqh_roles rls,
per_all_assignments_f paf,
per_jobs pjob,
per_job_definitions jobd
WHERE information_type = 'PQH_ROLE_USERS'
AND pei.person_id = ppf.person_id
AND usr.employee_id = ppf.person_id
AND paf.person_id =ppf.person_id
AND rls.role_name ='HR Letters Signatory'
AND paf.job_id = pjob.job_id(+)
AND pjob.job_definition_id =
jobd.job_definition_id(+)
AND rls.role_id = to_number(pei.pei_information3)
AND TRUNC(sysdate) BETWEEN
ppf.effective_start_date AND ppf.effective_end_date
AND TRUNC(sysdate) BETWEEN
paf.effective_start_date AND paf.effective_end_date
AND rownum=1
) hr_head_desig
FROM per_all_people_f
papf,
per_all_assignments_f paaf,
per_jobs pj,
per_job_definitions pjd,
per_positions pp,
per_position_definitions ppd
WHERE 1 =1
AND papf.person_id = paaf.person_id
AND paaf.job_id = pj.job_id(+)
AND
pj.job_definition_id =
pjd.job_definition_id(+)
AND
paaf.position_id =
pp.position_id (+)
AND
pp.position_definition_id = ppd.position_definition_id(+)
AND TRUNC(sysdate)
BETWEEN papf.effective_start_date AND papf.effective_end_date
AND TRUNC(sysdate)
BETWEEN paaf.effective_start_date AND paaf.effective_end_date
AND papf.person_id
=NVL(:P_IN_PERSON_ID,papf.person_id)
]]>
</sqlStatement>
</dataQuery>
<dataStructure>
<group name="G_CONDOLENCE"
dataType="varchar2" source="Q_CONDOLENCE">
<element name="SERVER_DATE" dataType="varchar2"
value="SERVER_DATE"/>
<element
name="EMPLOYEE_NAME" dataType="varchar2"
value="EMPLOYEE_NAME"/>
<element
name="DESIGNATION" dataType="varchar2"
value="DESIGNATION"/>
<element
name="DEPARTMENT" dataType="varchar2"
value="DEPARTMENT"/>
<element
name="EFFECT_DATE" dataType="varchar2"
value="EFFECT_DATE"/>
<element
name="RELATION" dataType="varchar2"
value="RELATION" />
<element
name="HR_HEAD" dataType="varchar2"
value="HR_HEAD" />
<element
name="HR_HEAD_DESIG" dataType="varchar2"
value="HR_HEAD_DESIG"/>
</group>
</dataStructure>
</dataTemplate>
----------------------------------
End----------------
Download the Format of
the XXBEXCONDOLENCELETTR.rtf::
https://drive.google.com/file/d/1iCNLf7zAhut2PLvjTQbt7QKAtiF4lMkl/view?usp=sharing
Download the Format of
the XXBEXCONDOLENCELETTR.xml ::
https://drive.google.com/file/d/1iY8D8rBcgx5JbjzwI5v8OnwdGkOHaid7/view?usp=sharing
Download the Format of
the
XXBEXCONDOLENCELETTR_CP.ldt::
https://drive.google.com/file/d/1hl2pc_xJPlWer4elicux_dZmuwNaihHy/view?usp=sharing
Download the Format of
the
XXBEXCONDOLENCELETTR_DD.ldt ::
https://drive.google.com/file/d/1POHQu_rxRiZX7wgcZ-CzogYkTNaS-w3Y/view?usp=sharing
Download the Format of
the
XXBEXCONDOLENCELETTR_REQ.ldt::
https://drive.google.com/file/d/13QxyaTtOnkoeh_EyCDUxknJBpocrAzL7/view?usp=sharing
No comments:
Post a Comment