PACKAGE: APPS.PAY_CA_ROE_EI_PKG

Source

1 PACKAGE pay_ca_roe_ei_pkg AUTHID CURRENT_USER AS
2 /* $Header: pycaroei.pkh 115.7 2004/03/09 18:46:47 pganguly noship $ */
3 
4 TYPE rec_element IS RECORD (element_id        NUMBER);
5 
6 TYPE element_table IS TABLE OF rec_element INDEX BY BINARY_INTEGER;
7 
8 dp_element_table     element_table;
9 de_element_table     element_table;
10 
11 TYPE t_small_number_table IS TABLE OF NUMBER(3) INDEX BY BINARY_INTEGER;
12 TYPE t_large_number_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
13 
14 l_days_from_start t_small_number_table;
15 l_period_number   t_small_number_table;
16 --
17 -- Functions/Procedures (see package body for detailed descriptions)
18 --
19 FUNCTION populate_date_lookup_table
20                     ( p_payroll_id             NUMBER,
21                       p_assignment_id          NUMBER,
22                       p_start_date             DATE,
23                       p_effective_date         DATE,
24                       p_last_period_start_date DATE)
25 RETURN VARCHAR2;
26 --
27 --PRAGMA RESTRICT_REFERENCES(populate_date_lookup_table, WNDS);
28 --
29 FUNCTION taxability_rule_exists
30                     ( p_classification_name   VARCHAR2,
31                       p_classification_id     NUMBER,
32                       p_tax_category          VARCHAR2,
33                       p_effective_date        DATE,
34                       p_tax_type              VARCHAR2)
35 RETURN VARCHAR2;
36 --
37 --PRAGMA RESTRICT_REFERENCES(taxability_rule_exists, WNDS, WNPS);
38 --
39 FUNCTION date_paid_or_date_earned
40                     ( p_element_type_id NUMBER,
41                       p_dp_or_de        VARCHAR2,
42                       p_ele_info3       VARCHAR2)
43 RETURN VARCHAR2;
44 --
45 --PRAGMA RESTRICT_REFERENCES(date_paid_or_date_earned, WNDS, WNPS);
46 --
47 FUNCTION get_pd_num
48                     ( p_current_date DATE,
49                       p_end_date     DATE)
50 RETURN NUMBER;
51 --PRAGMA RESTRICT_REFERENCES(get_pd_num, WNDS);
52 --
53 FUNCTION get_ei_amount_totals
54                     ( p_total_type      IN  VARCHAR2,
55                       p_assignment_id   IN  NUMBER,
56                       p_gre             IN  NUMBER,
57                       p_payroll_id      IN  NUMBER,
58                       p_start_date      IN  DATE,
59                       p_end_date        IN  DATE,
60                       p_period_type     OUT NOCOPY VARCHAR2,
61                       p_total_insurable OUT NOCOPY NUMBER,
62                       p_no_of_periods   OUT NOCOPY NUMBER,
63                       p_period_total    OUT NOCOPY t_large_number_table,
64                       p_term_or_abs_flag IN VARCHAR2)
65 RETURN VARCHAR2;
66 --
67 --PRAGMA RESTRICT_REFERENCES(get_ei_amount_totals, WNDS);
68 --
69 FUNCTION get_ei_amount_totals
70                     ( p_total_type      IN  VARCHAR2,
71                       p_assignment_id   IN  NUMBER,
72                       p_gre             IN  NUMBER,
73                       p_payroll_id      IN  NUMBER,
74                       p_end_date        IN  DATE,
75                       p_period_type     OUT NOCOPY VARCHAR2,
76                       p_total_insurable OUT NOCOPY NUMBER,
77                       p_no_of_periods   OUT NOCOPY NUMBER,
78                       p_period_total    OUT NOCOPY t_large_number_table,
79                       p_term_or_abs_flag IN VARCHAR2)
80 RETURN VARCHAR2;
81 --
82 --PRAGMA RESTRICT_REFERENCES(get_ei_amount_totals, WNDS);
83 --
84 PROCEDURE populate_element_table(p_bg_id number);
85 
86 END pay_ca_roe_ei_pkg;
87 --