Oracle apps EBS r12 Report for the HRMS and Payroll Report - Report Name - Confirmation Proposal Form

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

To: MR. NAME_OF_DEP_HEAD                                      Department: DEPARTMENT

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 :

Download the Format of the Data Definition File ::
https://drive.google.com/file/d/1ecNfrD2vapqdnESUKkF4hhWgn8bAXgiT/view?usp=sharing

<?xml version="1.0" encoding="UTF-8" ?>
<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

Download the Format of the XXBEX_CONF_PROPOSAL_CP.ldt::
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

Download the Format of the XXBEX_CONF_PROPOSAL_REQ.ldt::
https://drive.google.com/file/d/1tTjKVCKGkM2rA14PG7o-zq81gORomX2k/view?usp=sharing