Oracle apps EBS r12 Report for the HRMS and Payroll Report -
Report Name - Confirmation Proposal Form
Template File - RTF File Design :
Download the Format of the RTF File means Template File:
https://docs.google.com/document/d/1WWcheI528cWkGVyH84GJWFC09fhr_xfOlOJYqh-sRv8/edit?usp=sharing
Format Like This.
XX Chemical Division
CONFIRMATION PROPOSAL FORM
Designation: DESIG_OF_DEP_HEAD Legal Entity: LEGAL_ENTITY
Subject:
Employee Confirmation from Probation to Permanent Status
Name of the Employee:
NAME_OF_EMP Employee No.: EMP_NUM
Designation: DESIG_OF_EMP Joining
Date: JOINING_DTE
Normal Probation Period: PROBATION Months Grade:
GRADE
Normal Date of Confirmation: CONF_DATE
Educational Qualifications
|
||||
S.No
|
Qualification
|
Year of
Passing
|
Board/University
|
Results
|
FSN
|
QUAL
|
YEAR
|
UNIV
|
RSLTE
|
Under normal conditions the above employee should be
confirmed as a regular employee on the date indicated above. Before doing so
you are requested to carefully evaluate his/her job performance as per our Performance Appraisal System and enter
your recommendations in the spaces provided below.
Please complete this form and return it to
HRD by DATE
HOD_DESG: Date: ______/_____/_______
Recommendations: Please
mark with "X" in the box.
Confirmation to Regular employee with effect from
normal due date shown above.
|
|
Extension of probation period by _____ months.
|
|
Termination of services. Reasons:
|
.
|
||||||||||||
Performance Feedback (1-10 Scales)
|
1 2
|
3 4
|
5 6
|
7 8
|
9 10
|
|||||||
(Please tick)
|
Poor
|
Below Average
|
Average
|
Good
|
Outstanding
|
|||||||
.
|
||||||||||||
a.
|
Present Basic: Tk. BASIC
|
b. Present Gross Salary: Tk. GROSS
|
||||||||||
c.
|
No. of Increment (@Tk. INC):______
|
d. Special Allowance (if considered): Tk. ALL
|
||||||||||
e.
|
Total Increase: Tk. TTL
|
f. New Gross Salary: Tk. NET
|
||||||||||
g.
|
Promotion (Y/N): PROM
|
h. New Designation: NEW_DESG
|
||||||||||
þ
HR Recommended Increase: Tk. INC Gross Salary: Tk. GROSS
Signed by
|
Signed by
|
Checked by
|
Approved by
|
Supervisor / Sub-Dept. Head / Dept.
Head
|
Function /
Dept.
Head
|
HOD_DESG
|
Managing Director
|
---------------------------------- XXBEX_CONF_PROPOSAL.xml --------------------------
Data Definition File :
https://drive.google.com/file/d/1ecNfrD2vapqdnESUKkF4hhWgn8bAXgiT/view?usp=sharing
<dataTemplate name="XXBEX_CONF_PROPOSAL" version="1.0">
<properties>
<property name="xml_tag_case" value="upper" />
</properties>
<parameters>
<parameter name="P_EFFECTIVE_DATE" dataType = "VARCHAR2"></parameter>
<parameter name="P_DEPT_HEAD" dataType = "VARCHAR2"></parameter>
<parameter name="P_EMP_NUM" dataType = "varchar2"></parameter>
<parameter name="P_HOD_HR" dataType = "varchar2"></parameter>
<parameter name="P_INC_RATE" dataType = "varchar2"></parameter>
<parameter name="P_SPCL_ALLOWNC" dataType = "varchar2"></parameter>
<parameter name="P_TOTAL_INC" dataType = "varchar2"></parameter>
<parameter name="P_NET_GROSS" dataType = "varchar2"></parameter>
<parameter name="P_PROMOTION" dataType = "varchar2"></parameter>
<parameter name="P_NEW_DES" dataType = "varchar2"></parameter>
<parameter name="P_HR_REC_INC" dataType = "varchar2"></parameter>
<parameter name="P_HR_REC_GROSS_SAL" dataType = "varchar2"></parameter>
</parameters>
<dataQuery>
<sqlStatement name="Q_EMPL">
<![CDATA[
SELECT
(SELECT initcap(peop.title) title
FROM per_all_people_f peop
WHERE 1 =1
AND peop.person_id=:P_DEPT_HEAD
AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN peop.effective_start_date AND peop.effective_end_date
) title_dep_head,
(SELECT trim(initcap(peop.first_name
||' '
||peop.middle_names
||DECODE(peop.middle_names,NULL,'',' ')
||peop.last_name)) full_name
FROM per_all_people_f peop
WHERE 1 =1
AND person_id=:P_DEPT_HEAD
AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN peop.effective_start_date AND peop.effective_end_date
) name_of_dep_head,
(SELECT SUBSTR(pp.NAME,instr(pp.NAME,'|',1,2)+1)
FROM per_all_positions pp,
per_all_assignments_f asgn
WHERE 1 =1
AND asgn.position_id =pp.position_id(+)
AND asgn.business_group_id=pp.business_group_id
AND asgn.person_id =:P_DEPT_HEAD
AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN asgn.effective_start_date AND asgn.effective_end_date
) dep_head_dep,
(SELECT pj.NAME
FROM per_jobs pj,
per_all_assignments_f asgn
WHERE 1 =1
AND asgn.job_id =pj.job_id(+)
AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN asgn.effective_start_date AND asgn.effective_end_date
AND asgn.person_id=:P_DEPT_HEAD
) designation_of_dept_head,
(SELECT DECODE(pgd.segment1,'BAIL','Bangladesh Antibiotic Industries Limited', 'BPL','Beximco Pharmaceuticals Limited','IIS','I'
||'&'
||'I Services Limited','PCL','Pharmatek Chemicals Limited','SPL','Shuktara Printers Limited')
FROM per_grade_definitions pgd,
per_grades pg,
per_all_assignments_f asgn
WHERE 1 =1
AND pgd.grade_definition_id=pg.grade_definition_id
AND asgn.grade_id =pg.grade_id(+)
AND asgn.person_id =:P_DEPT_HEAD
AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN asgn.effective_start_date AND asgn.effective_end_date
) legal_entity,
papf.person_id person_id,
trim(initcap(papf.first_name
||' '
||papf.middle_names
||DECODE(papf.middle_names,NULL,'',' ')
||papf.last_name)) name_of_non_confirmed_emp,
papf.employee_number employee_number,
pj.NAME des_of_non_confirmed_emp,
TO_CHAR(ppos.date_start,'DD-Mon-YYYY') joining_date,
paaf.probation_period normal_probation_period,
substr(pg.name,instr(pg.name,'.')+1) grade_of_non_confirmed_emp,
TO_CHAR(paaf.date_probation_end+1,'DD-Mon-YYYY') normal_date_of_confirmation,
TO_CHAR(to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss'),'DD-Mon-YYYY') "DATE",
(SELECT
NVL(PJ.NAME,'No Job Assigned') HOD_POSITION
FROM per_people_extra_info pei,
per_all_people_f ppf,
per_all_assignments_f paaf,
per_jobs pj,
per_all_positions pos,
per_position_definitions ppd,
fnd_user usr,
pqh_roles rls
WHERE information_type = 'PQH_ROLE_USERS'
AND pei.person_id = ppf.person_id
AND usr.employee_id = ppf.person_id
and ppf.PERSON_ID=paaf.PERSON_ID
and paaf.JOB_ID=pj.JOB_ID(+)
and trunc(sysdate) between paaf.EFFECTIVE_START_DATE and paaf.EFFECTIVE_END_DATE
and paaf.BUSINESS_GROUP_ID=ppf.BUSINESS_GROUP_ID
and paaf.position_id=pos.position_id(+)
and pos.POSITION_DEFINITION_ID=ppd.POSITION_DEFINITION_ID(+)
AND rls.role_id = TO_NUMBER (pei.pei_information3)
AND NVL (pei.pei_information5, 'Y') = 'Y'
and rls.role_name ='HR Letters Signatory') designation_of_hr_hod,
ppp.proposed_salary_n present_basic_salary,
ppp.attribute14 present_gross_salary,
:P_HOD_HR hod_hr,
:P_INC_RATE inc_rate,
:P_SPCL_ALLOWNC spcl_allowance,
:P_TOTAL_INC total_inc,
:P_NET_GROSS net_gross,
decode(:P_PROMOTION,'N','No','Y','Yes') promotion,
:P_NEW_DES new_desg,
:P_HR_REC_INC hr_rec_inc,
:P_HR_REC_GROSS_SAL hr_rec_gross_sal
FROM per_all_people_f papf,
per_all_assignments_f paaf,
per_jobs pj,
per_grades pg,
per_pay_proposals ppp,
per_periods_of_service ppos
WHERE 1 =1
AND papf.person_id =paaf.person_id
AND paaf.job_id =pj.job_id
AND paaf.grade_id =pg.grade_id
AND paaf.assignment_id=ppp.assignment_id
AND ppos.person_id =papf.person_id
AND paaf.period_of_service_id=ppos.period_of_service_id
AND ppos.actual_termination_date is null
AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN paaf.effective_start_date AND paaf.effective_end_date
AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN papf.effective_start_date AND papf.effective_end_date
AND to_date(:P_EFFECTIVE_DATE,'YYYY/MM/DD hh24:mi:ss') BETWEEN ppp.change_date AND ppp.date_to +1
AND papf.person_id=NVL(:P_EMP_NUM,papf.person_id)
]]>
</sqlStatement>
<sqlStatement name="Q_EDUCT">
<![CDATA[
SELECT pei_information1 edu_qual_name,
pei_information6 year_of_passing,
pei_information2 board_university,
pei_information3 results
FROM per_people_extra_info
WHERE 1 =1
AND information_type='BEX_QUAL_DETAILS'
AND person_id =:P_EMP_NUM
ORDER BY pei_information6 DESC
]]>
</sqlStatement>
</dataQuery>
<dataStructure>
<group name="G_EMPL" dataType="varchar2" source="Q_EMPL">
<element name="TITLE_DEP_HEAD" dataType="varchar2" value="TITLE_DEP_HEAD"/>
<element name="NAME_OF_DEP_HEAD" dataType="varchar2" value="NAME_OF_DEP_HEAD"/>
<element name="DEP_HEAD_DEP" dataType="varchar2" value="DEP_HEAD_DEP"/>
<element name="DESIGNATION_OF_DEPT_HEAD" dataType="varchar2" value="DESIGNATION_OF_DEPT_HEAD"/>
<element name="LEGAL_ENTITY" dataType="varchar2" value="LEGAL_ENTITY"/>
<element name="NAME_OF_NON_CONFIRMED_EMP" dataType="varchar2" value="NAME_OF_NON_CONFIRMED_EMP"/>
<element name="EMPLOYEE_NUMBER" dataType="varchar2" value="EMPLOYEE_NUMBER"/>
<element name="DES_OF_NON_CONFIRMED_EMP" dataType="varchar2" value="DES_OF_NON_CONFIRMED_EMP" />
<element name="JOINING_DATE" dataType="varchar2" value="JOINING_DATE" />
<element name="NORMAL_PROBATION_PERIOD" dataType="varchar2" value="NORMAL_PROBATION_PERIOD"/>
<element name="GRADE_OF_NON_CONFIRMED_EMP" dataType="varchar2" value="GRADE_OF_NON_CONFIRMED_EMP"/>
<element name="NORMAL_DATE_OF_CONFIRMATION" dataType="varchar2" value="NORMAL_DATE_OF_CONFIRMATION"/>
<element name="DATE" dataType="varchar2" value="DATE"/>
<element name="DESIGNATION_OF_HR_HOD" dataType="varchar2" value="DESIGNATION_OF_HR_HOD"/>
<element name="PRESENT_BASIC_SALARY" dataType="varchar2" value="PRESENT_BASIC_SALARY"/>
<element name="PRESENT_GROSS_SALARY" dataType="varchar2" value="PRESENT_GROSS_SALARY"/>
<element name="HOD_HR" dataType="varchar2" value="HOD_HR"/>
<element name="INC_RATE" dataType="varchar2" value="INC_RATE"/>
<element name="SPCL_ALLOWANCE" dataType="varchar2" value="SPCL_ALLOWANCE"/>
<element name="TOTAL_INC" dataType="varchar2" value="TOTAL_INC"/>
<element name="NET_GROSS" dataType="varchar2" value="NET_GROSS"/>
<element name="PROMOTION" dataType="varchar2" value="PROMOTION"/>
<element name="NEW_DESG" dataType="varchar2" value="NEW_DESG"/>
<element name="HR_REC_INC" dataType="varchar2" value="HR_REC_INC"/>
<element name="HR_REC_GROSS_SAL" dataType="varchar2" value="HR_REC_GROSS_SAL"/>
</group>
<group name="G_EDUCT" dataType="varchar2" source="Q_EDUCT">
<element name="EDU_QUAL_NAME" dataType="varchar2" value="EDU_QUAL_NAME"/>
<element name="YEAR_OF_PASSING" dataType="varchar2" value="YEAR_OF_PASSING"/>
<element name="BOARD_UNIVERSITY" dataType="varchar2" value="BOARD_UNIVERSITY"/>
<element name="RESULTS" dataType="varchar2" value="RESULTS"/>
</group>
</dataStructure>
</dataTemplate>
---------------------------------- End----------------
Download the Format of the XXBEX_CONF_PROPOSAL.rtf::
https://docs.google.com/document/d/1WWcheI528cWkGVyH84GJWFC09fhr_xfOlOJYqh-sRv8/edit?usp=sharing
Download the Format of the XXBEX_CONF_PROPOSAL.xml ::
https://drive.google.com/file/d/1ecNfrD2vapqdnESUKkF4hhWgn8bAXgiT/view?usp=sharing
https://drive.google.com/file/d/1ecNfrD2vapqdnESUKkF4hhWgn8bAXgiT/view?usp=sharing
Download the Format of the XXBEX_CONF_PROPOSAL_CP.ldt::
https://drive.google.com/file/d/1g8p8YCIUI1wZByOA-5IiPNWlQgGW35-y/view?usp=sharing
https://drive.google.com/file/d/1g8p8YCIUI1wZByOA-5IiPNWlQgGW35-y/view?usp=sharing
Download the Format of the XXBEX_CONF_PROPOSAL_DD.ldt ::
https://drive.google.com/file/d/1V6mRbw1Q5tcYqZjqW-uHQivUpJ8VJZ2q/view?usp=sharing
https://drive.google.com/file/d/1V6mRbw1Q5tcYqZjqW-uHQivUpJ8VJZ2q/view?usp=sharing
Download the Format of the XXBEX_CONF_PROPOSAL_REQ.ldt::
https://drive.google.com/file/d/1tTjKVCKGkM2rA14PG7o-zq81gORomX2k/view?usp=sharing
https://drive.google.com/file/d/1tTjKVCKGkM2rA14PG7o-zq81gORomX2k/view?usp=sharing
No comments:
Post a Comment