DBA Data[Home] [Help]

APPS.PAY_NL_SI_PKG dependencies on FF_FORMULAS_F

Line 8: g_ptp_formula_id ff_formulas_f.formula_id%TYPE;

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;

Line 9: g_ptp_formula_name ff_formulas_f.formula_name%TYPE;

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;

Line 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;

Line 14: g_std_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;
18: g_pse_ptp_formula_id ff_formulas_f.formula_id%TYPE;

Line 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;

Line 19: g_pse_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;
23: g_std_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;

Line 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;

Line 24: g_std_rep_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;
28: g_real_si_days_formula_id ff_formulas_f.formula_id%TYPE;

Line 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;

Line 29: g_real_si_days_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;
33: g_pse_rep_ptp_formula_id ff_formulas_f.formula_id%TYPE;

Line 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;

Line 34: g_pse_rep_ptp_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;
38: g_si_days_formula_id ff_formulas_f.formula_id%TYPE;

Line 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 Tax Proration Days */
42: g_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 39: g_si_days_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 Tax Proration Days */
42: g_assignment_id per_all_assignments_f.assignment_id%TYPE;
43: g_tax_proration_days NUMBER;

Line 542: l_formula_id ff_formulas_f.formula_id%TYPE;

538: l_inputs ff_exec.inputs_t;
539: l_outputs ff_exec.outputs_t;
540: l_formula_exists BOOLEAN := TRUE;
541: l_formula_cached BOOLEAN := FALSE;
542: l_formula_id ff_formulas_f.formula_id%TYPE;
543: BEGIN
544: g_ptp_formula_name := 'NL_PART_TIME_PERCENTAGE';
545: --
546: OPEN csr_get_pay_action_id(p_assignment_action_id);

Line 615: l_formula_id ff_formulas_f.formula_id%TYPE;

611: l_inputs ff_exec.inputs_t;
612: l_outputs ff_exec.outputs_t;
613: l_formula_exists BOOLEAN := TRUE;
614: l_formula_cached BOOLEAN := FALSE;
615: l_formula_id ff_formulas_f.formula_id%TYPE;
616: BEGIN
617: g_std_ptp_formula_name := 'NL_STANDARD_SI_PART_TIME_PERCENTAGE';
618: --
619: OPEN csr_get_pay_action_id(p_assignment_action_id);

Line 689: l_formula_id ff_formulas_f.formula_id%TYPE;

685: l_inputs ff_exec.inputs_t;
686: l_outputs ff_exec.outputs_t;
687: l_formula_exists BOOLEAN := TRUE;
688: l_formula_cached BOOLEAN := FALSE;
689: l_formula_id ff_formulas_f.formula_id%TYPE;
690: BEGIN
691: g_pse_ptp_formula_name := 'NL_PSEUDO_SI_PART_TIME_PERCENTAGE';
692: --
693: OPEN csr_get_pay_action_id(p_assignment_action_id);

Line 763: l_formula_id ff_formulas_f.formula_id%TYPE;

759: l_inputs ff_exec.inputs_t;
760: l_outputs ff_exec.outputs_t;
761: l_formula_exists BOOLEAN := TRUE;
762: l_formula_cached BOOLEAN := FALSE;
763: l_formula_id ff_formulas_f.formula_id%TYPE;
764: BEGIN
765: g_std_rep_ptp_formula_name := 'NL_STANDARD_SI_REPORTING_PART_TIME_PERCENTAGE';
766: --
767: OPEN csr_get_pay_action_id(p_assignment_action_id);

Line 836: l_formula_id ff_formulas_f.formula_id%TYPE;

832: l_inputs ff_exec.inputs_t;
833: l_outputs ff_exec.outputs_t;
834: l_formula_exists BOOLEAN := TRUE;
835: l_formula_cached BOOLEAN := FALSE;
836: l_formula_id ff_formulas_f.formula_id%TYPE;
837: BEGIN
838: g_pse_rep_ptp_formula_name := 'NL_PSEUDO_SI_REPORTING_PART_TIME_PERCENTAGE';
839: --
840: OPEN csr_get_pay_action_id(p_assignment_action_id);

Line 987: l_formula_id ff_formulas_f.formula_id%TYPE;

983: l_inputs ff_exec.inputs_t;
984: l_outputs ff_exec.outputs_t;
985: l_formula_exists BOOLEAN := TRUE;
986: l_formula_cached BOOLEAN := FALSE;
987: l_formula_id ff_formulas_f.formula_id%TYPE;
988: BEGIN
989: g_real_si_days_formula_name := 'NL_REAL_SOCIAL_INSURANCE_DAYS';
990: IF g_real_si_days_formula_exists = TRUE THEN
991: IF g_real_si_days_formula_cached = FALSE THEN

Line 1728: l_formula_id ff_formulas_f.formula_id%TYPE;

1724: l_inputs ff_exec.inputs_t;
1725: l_outputs ff_exec.outputs_t;
1726: l_formula_exists BOOLEAN := TRUE;
1727: l_formula_cached BOOLEAN := FALSE;
1728: l_formula_id ff_formulas_f.formula_id%TYPE;
1729: BEGIN
1730: g_si_days_formula_name := 'NL_OVERRIDE_SOCIAL_INSURANCE_DAYS';
1731: IF g_si_days_formula_exists = TRUE THEN
1732: IF g_si_days_formula_cached = FALSE THEN