4: g_legislation_code varchar2(2) :='NL';
5: g_udt_name VARCHAR2(50) := 'PQP_COMPANY_WORK_PATTERNS';
6: g_ptp_formula_exists BOOLEAN := TRUE;
7: g_ptp_formula_cached BOOLEAN := FALSE;
8: g_ptp_formula_id ff_formulas_f.formula_id%TYPE;
9: g_ptp_formula_name ff_formulas_f.formula_name%TYPE;
10: /* Global Variables for Standard SI Part Time Percentage */
11: g_std_ptp_formula_exists BOOLEAN := TRUE;
12: g_std_ptp_formula_cached BOOLEAN := FALSE;
5: g_udt_name VARCHAR2(50) := 'PQP_COMPANY_WORK_PATTERNS';
6: g_ptp_formula_exists BOOLEAN := TRUE;
7: g_ptp_formula_cached BOOLEAN := FALSE;
8: g_ptp_formula_id ff_formulas_f.formula_id%TYPE;
9: g_ptp_formula_name ff_formulas_f.formula_name%TYPE;
10: /* Global Variables for Standard SI Part Time Percentage */
11: g_std_ptp_formula_exists BOOLEAN := TRUE;
12: g_std_ptp_formula_cached BOOLEAN := FALSE;
13: g_std_ptp_formula_id ff_formulas_f.formula_id%TYPE;
9: g_ptp_formula_name ff_formulas_f.formula_name%TYPE;
10: /* Global Variables for Standard SI Part Time Percentage */
11: g_std_ptp_formula_exists BOOLEAN := TRUE;
12: g_std_ptp_formula_cached BOOLEAN := FALSE;
13: g_std_ptp_formula_id ff_formulas_f.formula_id%TYPE;
14: g_std_ptp_formula_name ff_formulas_f.formula_name%TYPE;
15: /* Global Variables for Pseudo SI Part Time Percentage */
16: g_pse_ptp_formula_exists BOOLEAN := TRUE;
17: g_pse_ptp_formula_cached BOOLEAN := FALSE;
10: /* Global Variables for Standard SI Part Time Percentage */
11: g_std_ptp_formula_exists BOOLEAN := TRUE;
12: g_std_ptp_formula_cached BOOLEAN := FALSE;
13: g_std_ptp_formula_id ff_formulas_f.formula_id%TYPE;
14: g_std_ptp_formula_name ff_formulas_f.formula_name%TYPE;
15: /* Global Variables for Pseudo SI Part Time Percentage */
16: g_pse_ptp_formula_exists BOOLEAN := TRUE;
17: g_pse_ptp_formula_cached BOOLEAN := FALSE;
18: g_pse_ptp_formula_id ff_formulas_f.formula_id%TYPE;
14: g_std_ptp_formula_name ff_formulas_f.formula_name%TYPE;
15: /* Global Variables for Pseudo SI Part Time Percentage */
16: g_pse_ptp_formula_exists BOOLEAN := TRUE;
17: g_pse_ptp_formula_cached BOOLEAN := FALSE;
18: g_pse_ptp_formula_id ff_formulas_f.formula_id%TYPE;
19: g_pse_ptp_formula_name ff_formulas_f.formula_name%TYPE;
20: /* Global Variables for Standard SI Reporting Part Time Percentage */
21: g_std_rep_ptp_formula_exists BOOLEAN := TRUE;
22: g_std_rep_ptp_formula_cached BOOLEAN := FALSE;
15: /* Global Variables for Pseudo SI Part Time Percentage */
16: g_pse_ptp_formula_exists BOOLEAN := TRUE;
17: g_pse_ptp_formula_cached BOOLEAN := FALSE;
18: g_pse_ptp_formula_id ff_formulas_f.formula_id%TYPE;
19: g_pse_ptp_formula_name ff_formulas_f.formula_name%TYPE;
20: /* Global Variables for Standard SI Reporting Part Time Percentage */
21: g_std_rep_ptp_formula_exists BOOLEAN := TRUE;
22: g_std_rep_ptp_formula_cached BOOLEAN := FALSE;
23: g_std_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;
19: g_pse_ptp_formula_name ff_formulas_f.formula_name%TYPE;
20: /* Global Variables for Standard SI Reporting Part Time Percentage */
21: g_std_rep_ptp_formula_exists BOOLEAN := TRUE;
22: g_std_rep_ptp_formula_cached BOOLEAN := FALSE;
23: g_std_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;
24: g_std_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;
25: /* Global variables for Override Real SI Days */
26: g_real_si_days_formula_exists BOOLEAN := TRUE;
27: g_real_si_days_formula_cached BOOLEAN := FALSE;
20: /* Global Variables for Standard SI Reporting Part Time Percentage */
21: g_std_rep_ptp_formula_exists BOOLEAN := TRUE;
22: g_std_rep_ptp_formula_cached BOOLEAN := FALSE;
23: g_std_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;
24: g_std_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;
25: /* Global variables for Override Real SI Days */
26: g_real_si_days_formula_exists BOOLEAN := TRUE;
27: g_real_si_days_formula_cached BOOLEAN := FALSE;
28: g_real_si_days_formula_id ff_formulas_f.formula_id%TYPE;
24: g_std_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;
25: /* Global variables for Override Real SI Days */
26: g_real_si_days_formula_exists BOOLEAN := TRUE;
27: g_real_si_days_formula_cached BOOLEAN := FALSE;
28: g_real_si_days_formula_id ff_formulas_f.formula_id%TYPE;
29: g_real_si_days_formula_name ff_formulas_f.formula_name%TYPE;
30: /* Global Variables for Pseudo SI Reporting Part Time Percentage */
31: g_pse_rep_ptp_formula_exists BOOLEAN := TRUE;
32: g_pse_rep_ptp_formula_cached BOOLEAN := FALSE;
25: /* Global variables for Override Real SI Days */
26: g_real_si_days_formula_exists BOOLEAN := TRUE;
27: g_real_si_days_formula_cached BOOLEAN := FALSE;
28: g_real_si_days_formula_id ff_formulas_f.formula_id%TYPE;
29: g_real_si_days_formula_name ff_formulas_f.formula_name%TYPE;
30: /* Global Variables for Pseudo SI Reporting Part Time Percentage */
31: g_pse_rep_ptp_formula_exists BOOLEAN := TRUE;
32: g_pse_rep_ptp_formula_cached BOOLEAN := FALSE;
33: g_pse_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;
29: g_real_si_days_formula_name ff_formulas_f.formula_name%TYPE;
30: /* Global Variables for Pseudo SI Reporting Part Time Percentage */
31: g_pse_rep_ptp_formula_exists BOOLEAN := TRUE;
32: g_pse_rep_ptp_formula_cached BOOLEAN := FALSE;
33: g_pse_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;
34: g_pse_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;
35: /* Global Variables for Override SI Days */
36: g_si_days_formula_exists BOOLEAN := TRUE;
37: g_si_days_formula_cached BOOLEAN := FALSE;
30: /* Global Variables for Pseudo SI Reporting Part Time Percentage */
31: g_pse_rep_ptp_formula_exists BOOLEAN := TRUE;
32: g_pse_rep_ptp_formula_cached BOOLEAN := FALSE;
33: g_pse_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;
34: g_pse_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;
35: /* Global Variables for Override SI Days */
36: g_si_days_formula_exists BOOLEAN := TRUE;
37: g_si_days_formula_cached BOOLEAN := FALSE;
38: g_si_days_formula_id ff_formulas_f.formula_id%TYPE;
34: g_pse_rep_ptp_formula_name ff_formulas_f.formula_name%TYPE;
35: /* Global Variables for Override SI Days */
36: g_si_days_formula_exists BOOLEAN := TRUE;
37: g_si_days_formula_cached BOOLEAN := FALSE;
38: g_si_days_formula_id ff_formulas_f.formula_id%TYPE;
39: g_si_days_formula_name ff_formulas_f.formula_name%TYPE;
40: g_si_days NUMBER;
41: /* Global Variables for Override SI Days ZVW */
42: g_si_days_zvw NUMBER;
35: /* Global Variables for Override SI Days */
36: g_si_days_formula_exists BOOLEAN := TRUE;
37: g_si_days_formula_cached BOOLEAN := FALSE;
38: g_si_days_formula_id ff_formulas_f.formula_id%TYPE;
39: g_si_days_formula_name ff_formulas_f.formula_name%TYPE;
40: g_si_days NUMBER;
41: /* Global Variables for Override SI Days ZVW */
42: g_si_days_zvw NUMBER;
43: /* Global Variables for Tax Proration Days */
555: l_inputs ff_exec.inputs_t;
556: l_outputs ff_exec.outputs_t;
557: l_formula_exists BOOLEAN := TRUE;
558: l_formula_cached BOOLEAN := FALSE;
559: l_formula_id ff_formulas_f.formula_id%TYPE;
560: BEGIN
561: g_ptp_formula_name := 'NL_PART_TIME_PERCENTAGE';
562: --
563: OPEN csr_get_pay_action_id(p_assignment_action_id);
628: l_inputs ff_exec.inputs_t;
629: l_outputs ff_exec.outputs_t;
630: l_formula_exists BOOLEAN := TRUE;
631: l_formula_cached BOOLEAN := FALSE;
632: l_formula_id ff_formulas_f.formula_id%TYPE;
633: BEGIN
634: g_std_ptp_formula_name := 'NL_STANDARD_SI_PART_TIME_PERCENTAGE';
635: --
636: OPEN csr_get_pay_action_id(p_assignment_action_id);
702: l_inputs ff_exec.inputs_t;
703: l_outputs ff_exec.outputs_t;
704: l_formula_exists BOOLEAN := TRUE;
705: l_formula_cached BOOLEAN := FALSE;
706: l_formula_id ff_formulas_f.formula_id%TYPE;
707: BEGIN
708: g_pse_ptp_formula_name := 'NL_PSEUDO_SI_PART_TIME_PERCENTAGE';
709: --
710: OPEN csr_get_pay_action_id(p_assignment_action_id);
776: l_inputs ff_exec.inputs_t;
777: l_outputs ff_exec.outputs_t;
778: l_formula_exists BOOLEAN := TRUE;
779: l_formula_cached BOOLEAN := FALSE;
780: l_formula_id ff_formulas_f.formula_id%TYPE;
781: BEGIN
782: g_std_rep_ptp_formula_name := 'NL_STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';
783: --
784: OPEN csr_get_pay_action_id(p_assignment_action_id);
849: l_inputs ff_exec.inputs_t;
850: l_outputs ff_exec.outputs_t;
851: l_formula_exists BOOLEAN := TRUE;
852: l_formula_cached BOOLEAN := FALSE;
853: l_formula_id ff_formulas_f.formula_id%TYPE;
854: BEGIN
855: g_pse_rep_ptp_formula_name := 'NL_PSEUDO_SI_REPORTING_PART_TIME_PERCENTAGE';
856: --
857: OPEN csr_get_pay_action_id(p_assignment_action_id);
1000: l_inputs ff_exec.inputs_t;
1001: l_outputs ff_exec.outputs_t;
1002: l_formula_exists BOOLEAN := TRUE;
1003: l_formula_cached BOOLEAN := FALSE;
1004: l_formula_id ff_formulas_f.formula_id%TYPE;
1005: BEGIN
1006: g_real_si_days_formula_name := 'NL_REAL_SOCIAL_INSURANCE_DAYS';
1007: IF g_real_si_days_formula_exists = TRUE THEN
1008: IF g_real_si_days_formula_cached = FALSE THEN
1741: l_inputs ff_exec.inputs_t;
1742: l_outputs ff_exec.outputs_t;
1743: l_formula_exists BOOLEAN := TRUE;
1744: l_formula_cached BOOLEAN := FALSE;
1745: l_formula_id ff_formulas_f.formula_id%TYPE;
1746: BEGIN
1747: g_si_days_formula_name := 'NL_OVERRIDE_SOCIAL_INSURANCE_DAYS';
1748: IF g_si_days_formula_exists = TRUE THEN
1749: IF g_si_days_formula_cached = FALSE THEN