[Home] [Help]
11: arcsing in file to generate
12: Checkfile Equivalence
13: 05-FEB-2013 emunisek 120.2 Replaced sequence related to
14: PAY_ACTION_INFORMATION_S with
15: PAY_SIMULATION_INFORMATION_S
16: 06-FEB-2013 emunisek 120.3 Resolved issues in update_asg_data
17: Procedure
18: 07-FEB-2013 emunisek 120.4 Resolved issues with display of Tax
19: Deductions and Tax Withholding Details.
3470:
3471: CURSOR c_get_tax_unit_id(cp_assignment_id NUMBER)
3472: IS
3473: SELECT NVL(psi.tax_unit_id,-1)
3474: FROM pay_simulation_information psi
3475: WHERE psi.action_information_category = 'EMPLOYEE DETAILS'
3476: AND psi.action_context_type = 'AAP'
3477: AND psi.assignment_id = cp_assignment_id
3478: ORDER BY psi.action_context_id DESC;
3547: END archive_payroll_level_data;
3548:
3549: /* Procedure : archive_data
3550: Purpose : This procedure captures the results of Payroll Simulator
3551: Run to the table PAY_SIMULATION_INFORMATION. This
3552: procedure is similar to the Payroll Archiver procedure
3553: PAY_US_ACTION_ARCH.ACTION_ARCHIVE_DATA. The regular
3554: Payroll Archiver procedure is based on Prepayments where
3555: as the current procedure is based on actual Payroll Run
3557: Important : The Data archival process is similar to the regular
3558: Payroll Archiver except the Payment related data will be
3559: skipped here as there are no Prepayments executed as part
3560: of Payroll Simulation. All the data gathered during this
3561: procedure is inserted into PAY_SIMULATION_INFORMATION
3562: table autonomously so that the data can be used to
3563: generate the Output, post Database level rollback. Any
3564: information required for generating Output, that will not
3565: be available due to rollback should be captured through
4463: Database level rollback of changes made during Payroll
4464: Simulation run. Hence any information required for
4465: generating Output, that will not be available due to
4466: rollback should be captured through archive_data procedure
4467: and saved autonomously to PAY_SIMULATION_INFORMATION table
4468: Parameter p_xml_code is to allow the Customers the ability
4469: to use Custom XML Code. This is hidden from Customers as
4470: of now and will be enabled if required in future. The
4471: entire code to support Custom XML Code is already in
4483:
4484: CURSOR get_asg_action(cp_assignment_id NUMBER)
4485: IS
4486: SELECT psi.action_information2
4487: FROM pay_simulation_information psi
4488: WHERE psi.assignment_id = cp_assignment_id
4489: AND psi.action_information_category = 'SIMULATION_ACTION_INFORMATION'
4490: AND psi.action_context_type = 'ACTION INFO'
4491: ORDER BY psi.action_information1 DESC,psi.action_information2 DESC;
4519: available to the user. For US Localization, we are using
4520: this procedure to determine all those "Element Name -
4521: Input Value" combinations applicable to the current
4522: Assignment. These combinations are stored to table
4523: PAY_SIMULATION_INFORMATION with ACTION_CONTEXT_TYPE as
4524: "INPUTSLOV". This data is used by the LOV Queries related
4525: to Earnings and Deductions regions of Payroll Simulator.
4526: Important : This procedure is initiated from Payroll Simulator Page
4527: and the data gathered by this procedure will not be
4712: OPEN get_gross_pay_ytd(ln_archive_action_id);
4713: FETCH get_gross_pay_ytd INTO ln_gross_salary_ytd;
4714: CLOSE get_gross_pay_ytd;
4715:
4716: DELETE FROM pay_simulation_information
4717: WHERE assignment_id = p_assignment_id
4718: AND action_context_type IN ('INPUTSLOV','SIMDISPLAY')
4719: AND action_context_id = p_assignment_id;
4720:
4717: WHERE assignment_id = p_assignment_id
4718: AND action_context_type IN ('INPUTSLOV','SIMDISPLAY')
4719: AND action_context_id = p_assignment_id;
4720:
4721: INSERT INTO pay_simulation_information
4722: (action_information_id,
4723: action_context_id,
4724: action_context_type,
4725: action_information_category,
4727: effective_date,
4728: assignment_id
4729: )
4730: VALUES
4731: (pay_simulation_information_s.NEXTVAL,
4732: p_assignment_id,
4733: 'INPUTSLOV',
4734: 'LAST_PAYSLIP_DATE',
4735: TO_CHAR(ld_last_payslip_date,'DD/MM/YYYY'),
4736: ld_effective_date,
4737: p_assignment_id
4738: );
4739:
4740: INSERT INTO pay_simulation_information
4741: (action_information_id,
4742: action_context_id,
4743: action_context_type,
4744: action_information_category,
4749: effective_date,
4750: assignment_id
4751: )
4752: VALUES
4753: (pay_simulation_information_s.NEXTVAL,
4754: p_assignment_id,
4755: 'SIMDISPLAY',
4756: 'US_SIMULATION_DISPLAY',
4757: lv_pay_basis,
4765: OPEN get_exclusion_set_id(ln_business_group_id);
4766: FETCH get_exclusion_set_id INTO ln_exclusion_set_id;
4767: CLOSE get_exclusion_set_id;
4768:
4769: INSERT INTO pay_simulation_information
4770: (action_information_id,
4771: action_context_id,
4772: action_context_type,
4773: action_information_category,
4780: action_information7,
4781: effective_date,
4782: assignment_id
4783: )
4784: SELECT pay_simulation_information_s.NEXTVAL,
4785: p_assignment_id,
4786: 'INPUTSLOV',
4787: DECODE(pec.classification_name,
4788: 'Earnings','EARNINGS INPUT VALUES',