[Home] [Help]
1: package body PAY_NL_GENERAL as
2: /* $Header: pynlgenr.pkb 120.19.12020000.2 2012/11/29 14:12:27 mkuppuch ship $ */
3: --
4: g_package varchar2(30) := 'pay_nl_general';
5: hr_formula_error EXCEPTION;
1: package body PAY_NL_GENERAL as
2: /* $Header: pynlgenr.pkb 120.19.12020000.2 2012/11/29 14:12:27 mkuppuch ship $ */
3: --
4: g_package varchar2(30) := 'pay_nl_general';
5: hr_formula_error EXCEPTION;
6:
7: -- +********************************************************************+
8: -- | PUBLIC FUNCTIONS |
562: l_rule_found varchar2(10):='N';
563:
564: begin
565: retcode := 0;
566: fnd_file.put_line(FND_FILE.LOG,'Entering Procedure pay_nl_general.insert_leg_rule');
567:
568: OPEN c_leg_rule('RETRO_COMP_DFLT_OVERRIDE');
569: FETCH c_leg_rule INTO l_rule_found;
570:
587: and rule_type='RETRO_COMP_DFLT_OVERRIDE';
588: fnd_file.put_line(FND_FILE.LOG,'Legislation Rule Removed,Retropay method is now STANDARD');
589: END if;
590: end if;
591: fnd_file.put_line(FND_FILE.LOG,'Leaving Procedure pay_nl_general.insert_leg_rule');
592: END insert_leg_rule;
593:
594:
595: ---------------------------------------------------------------------------
1374: and paa.SOURCE_ACTION_ID is not null
1375: -- and ppa.payroll_action_id = paa.payroll_action_id
1376: and paa.action_status='C'
1377: and prr.ASSIGNMENT_ACTION_ID=paa.assignment_action_id
1378: and pay_nl_general.get_retro_period(prr.source_id,ppa.effective_date) = p_retro_period
1379: and prr.run_result_id=prv.run_result_id
1380: and pet.element_type_id = prr.element_type_id
1381: and pec.classification_id=pet.classification_id
1382: and pec.legislation_code = 'NL'
1420: and paa.SOURCE_ACTION_ID is not null
1421: and ppa.payroll_action_id = paa.payroll_action_id
1422: and paa.action_status='C'
1423: and prr.ASSIGNMENT_ACTION_ID=paa.assignment_action_id
1424: and pay_nl_general.get_retro_period(prr.source_id,ppa.effective_date) = p_retro_period
1425: and prr.run_result_id=prv.run_result_id
1426: and pet.element_type_id = prr.element_type_id
1427: and pec.legislation_code = 'NL'
1428: and pecs.classification_id=pec.classification_id
1476: and ppa.payroll_action_id = paa.payroll_action_id
1477: and paa.action_status='C'
1478: and prr.ASSIGNMENT_ACTION_ID=paa.assignment_action_id
1479: and paa.assignment_action_id = pac.assignment_action_id
1480: and pay_nl_general.get_retro_period(prr.source_id,ppa.effective_date) = p_retro_period
1481: and prr.run_result_id=prv.run_result_id
1482: and prv.input_value_id = P_input_value_id
1483: -- and ppa.payroll_action_id=nvl(p_pact_id,ppa.payroll_action_id)
1484: and prr.run_result_id=prv1.run_result_id
1505: and paa.SOURCE_ACTION_ID is not null
1506: and ppa.payroll_action_id = paa.payroll_action_id
1507: and paa.action_status='C'
1508: and prr.ASSIGNMENT_ACTION_ID=paa.assignment_action_id
1509: and pay_nl_general.get_retro_period(prr.source_id,ppa.effective_date) = p_retro_period
1510: and prr.run_result_id=prv.run_result_id
1511: and prr.element_type_id = p_element_type_id
1512: and piv.element_type_id = p_element_type_id
1513: and piv.name ='Pay Value'
1557: -- and ppa.payroll_action_id = paa.payroll_action_id
1558: and paa.action_status='C'
1559: and prr.ASSIGNMENT_ACTION_ID=paa.assignment_action_id
1560: and ppa.effective_date = p_effective_date
1561: -- and pay_nl_general.get_retro_period(prr.source_id,ppa.effective_date) = p_retro_period
1562: and prr.run_result_id=prv.run_result_id
1563: and pet.element_type_id = prr.element_type_id
1564: and pet.element_type_id = piv.element_type_id
1565: and piv.name ='Pay Value'
1640: --
1641: CURSOR get_file_no_per_day IS
1642: SELECT count(*)
1643: FROM pay_payroll_actions ppa
1644: WHERE TRIM(PAY_NL_GENERAL.get_parameter(ppa.legislative_parameters
1645: ,'MAGTAPE_REPORT_ID'))= 'NL_PAYFILE'
1646: AND action_type = 'M'
1647: AND action_status = 'C'
1648: AND effective_date = p_effective_date;
2991:
2992: END get_run_type;
2993:
2994:
2995: END PAY_NL_GENERAL;