[Home] [Help]
PACKAGE: APPS.PAY_DB_PAY_US_GROSS
Source
1 package pay_db_pay_us_gross AUTHID CURRENT_USER as
2 /* $Header: pypusgrs.pkh 115.0 99/07/17 06:27:10 porting ship $ */
3 /*
4 rem Change History
5 rem
6 rem Date Name Description
7 rem ---- ---- -----------
8 rem 30-JUL-1996 J. ALLOUN Added error handling.
9 rem
10 */
11 --
12 g_default_start_date date := to_date('01-01-0001','DD-MM-YYYY');
13 g_todays_date constant date := trunc(sysdate);
14 g_max_end_date constant date := to_date('31/12/4712','DD/MM/YYYY');
15 g_max_elnum constant BINARY_INTEGER := 8;
16 --
17 TYPE ElemTabType IS TABLE OF
18 PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE
19 INDEX BY BINARY_INTEGER;
20 --
21 TYPE InputTabType IS TABLE OF
22 PAY_INPUT_VALUES_F.NAME%TYPE
23 INDEX BY BINARY_INTEGER;
24 --
25 TYPE ResultTabType IS TABLE OF
26 PAY_FORMULA_RESULT_RULES_F.RESULT_NAME%TYPE
27 INDEX BY BINARY_INTEGER;
28 --
29 TYPE UOMTabType IS TABLE OF
30 PAY_INPUT_VALUES_F.UOM%TYPE
31 INDEX BY BINARY_INTEGER;
32 --
33 TYPE RsltPrefixType IS TABLE OF
34 VARCHAR(10)
35 INDEX BY BINARY_INTEGER;
36 --
37 g_business_group_ID NUMBER := NULL; -- business group ID
38 g_vtx_elem_tab ElemTabType; -- VERTEX grossup elements
39 g_vtx_input_value InputTabType; -- Input value/result rule names
40 g_vtx_result_name ResultTabType; -- result rule names
41 g_vtx_uom UOMTabType; -- Unit of Measure
42 --
43 --
44 procedure create_vertex_element_names;
45 --
46 function create_gross_up (
47 p_business_group_name IN VARCHAR2 DEFAULT NULL,
48 p_element_name IN VARCHAR2,
49 p_classification IN VARCHAR2,
50 p_reporting_name IN VARCHAR2,
51 p_formula_name IN VARCHAR2,
52 p_priority IN NUMBER,
53 p_effective_start_date IN DATE DEFAULT NULL,
54 p_effective_end_date IN DATE DEFAULT NULL
55 ) RETURN NUMBER;
56 --
57 procedure delete_gross_up (
58 p_business_group_id IN NUMBER,
59 p_element_name IN VARCHAR2
60 );
61 --
62 function create_linked_elements (
63 p_mode VARCHAR2 DEFAULT 'Grossup',
64 p_element_name VARCHAR2,
65 p_element_type_id NUMBER,
66 p_formula_id NUMBER,
67 p_priority NUMBER,
68 p_business_group_name VARCHAR2 DEFAULT NULL,
69 p_start_date DATE DEFAULT NULL,
70 p_end_date DATE DEFAULT NULL
71 ) RETURN NUMBER;
72 --
73 procedure create_indirect_link (
74 p_element_name VARCHAR2,
75 p_uom VARCHAR2,
76 p_name VARCHAR2,
77 p_display_sequence NUMBER,
78 p_stat_proc_id NUMBER,
79 p_business_group_name VARCHAR2 DEFAULT NULL,
80 p_effective_start_date DATE DEFAULT NULL,
81 p_effective_end_date DATE DEFAULT NULL
82 );
83 --
84 function create_status_proc_rule(
85 p_effective_start_date IN DATE,
86 p_effective_end_date IN DATE,
87 p_formula_ID IN NUMBER DEFAULT NULL,
88 p_element_type_ID IN NUMBER
89 ) RETURN NUMBER;
90 --
91 function create_result_rule(
92 p_legislation_code VARCHAR2 DEFAULT 'US',
93 p_result_name VARCHAR2,
94 p_result_type VARCHAR2 DEFAULT 'I',
95 p_severity VARCHAR2 DEFAULT NULL,
96 p_stat_proc_ID NUMBER,
97 p_input_value_ID NUMBER DEFAULT NULL,
98 p_effective_start_date DATE,
99 p_effective_end_date DATE
100 ) RETURN NUMBER;
101 --
102 end pay_db_pay_us_gross;