1 PACKAGE pay_nl_wage_report_pkg AUTHID CURRENT_USER as
2 /* $Header: pynlwrar.pkh 120.7.12020000.2 2012/07/05 01:57:21 amnaraya ship $ */
3
4
5 TYPE XMLRec IS RECORD(
6 TagName VARCHAR2(240),
7 TagDesc VARCHAR2(240),
8 TagValue NUMBER,
9 Mandatory VARCHAR2(10));
10 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
11 collXMLTable tXMLTable;
12 --
13 TYPE t_interpretor_output_tab_rec IS RECORD(
14 dated_table_id pay_dated_tables.dated_table_id%TYPE ,
15 datetracked_event pay_datetracked_events.datetracked_event_id%TYPE ,
16 update_type pay_datetracked_events.update_type%TYPE ,
17 surrogate_key pay_process_events.surrogate_key%type ,
18 column_name pay_event_updates.column_name%TYPE ,
19 effective_date DATE,
20 old_value VARCHAR2(2000),
21 new_value VARCHAR2(2000),
22 change_values VARCHAR2(2000),
23 proration_type VARCHAR2(10),
24 change_mode pay_process_events.change_type%TYPE,--'DATE_PROCESSED' ETC
25 element_entry_id pay_element_entries_f.element_entry_id%TYPE,
26 next_ee NUMBER,
27 period_start_date DATE,
28 period_end_date DATE,
29 retro VARCHAR2(10),
30 assignment_action_id NUMBER);
31 TYPE Rec_Changes IS TABLE OF t_interpretor_output_tab_rec INDEX BY BINARY_INTEGER;
32 --
33 TYPE Balance_Rec IS RECORD (defined_balance_id pay_defined_balances.defined_balance_id%TYPE
34 ,balance_name pay_balance_types.balance_name%TYPE
35 ,database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE
36 ,context VARCHAR2(20)
37 ,context_val VARCHAR2(20));
38 TYPE Bal_Table IS TABLE OF Balance_Rec INDEX BY BINARY_INTEGER;
39 g_nom_bal_def_table Bal_Table;
40 --
41 TYPE Balance_Val IS RECORD ( balance_value NUMBER
42 ,database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE);
43 TYPE Bal_Value IS TABLE OF Balance_Val INDEX BY BINARY_INTEGER;
44 --
45 TYPE Retro_table IS RECORD (start_date DATE
46 ,end_date DATE
47 ,retro_type VARCHAR2(20));
48 TYPE Ret_Table IS TABLE OF Retro_table INDEX BY BINARY_INTEGER;
49 --
50 TYPE Balance_col_Rec IS RECORD (defined_balance_id pay_defined_balances.defined_balance_id%TYPE
51 ,defined_balance_id2 pay_defined_balances.defined_balance_id%TYPE
52 ,balance_name pay_balance_types.balance_name%TYPE
53 ,database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE
54 ,database_item_suffix2 pay_balance_dimensions.database_item_suffix%TYPE
55 ,context VARCHAR2(100)
56 ,context_val VARCHAR2(100)
57 ,balance_value NUMBER
58 ,balance_value2 NUMBER);
59 TYPE Bal_col_Table IS TABLE OF Balance_COL_Rec INDEX BY BINARY_INTEGER;
60 g_col_bal_def_table Bal_COL_Table;
61 --
62
63 FUNCTION get_parameters(p_payroll_action_id IN NUMBER,
64 p_token_name IN VARCHAR2) RETURN VARCHAR2;
65
66 --10100628
67 FUNCTION get_parameters1(p_payroll_action_id IN NUMBER,
68 p_token_name IN VARCHAR2) RETURN VARCHAR2;
69 --10100628
70 --
71 PROCEDURE get_all_parameters(p_payroll_action_id IN NUMBER
72 ,p_business_group_id OUT NOCOPY NUMBER
73 ,p_start_date OUT NOCOPY DATE
74 ,p_end_date OUT NOCOPY DATE
75 ,p_legal_employer OUT NOCOPY NUMBER
76 ,p_payroll_type OUT NOCOPY VARCHAR2
77 ,p_seq_no OUT NOCOPY VARCHAR2
78 ,p_prev_corr_year OUT NOCOPY VARCHAR2
79 ,p_er_only OUT NOCOPY VARCHAR2); --10100628
80 --
81 PROCEDURE archive_range_code(p_actid IN NUMBER
82 ,sqlstr OUT NOCOPY VARCHAR2);
83 --
84 PROCEDURE archive_init_code(p_actid IN NUMBER);
85 --
86 PROCEDURE archive_action_creation(p_actid IN NUMBER
87 ,stperson IN NUMBER
88 ,endperson IN NUMBER
89 ,chunk IN NUMBER);
90 --
91 PROCEDURE lock_action_creation (p_actid IN NUMBER
92 ,stperson IN NUMBER
93 ,endperson IN NUMBER
94 ,chunk IN NUMBER);
95 --
96 PROCEDURE archive_code(p_assactid in number
97 ,p_effective_date in date);
98
99 --
100 PROCEDURE archive_deinit_code(p_actid IN NUMBER);
101 --
102 FUNCTION get_archive_details(p_actid IN NUMBER) RETURN VARCHAR2;
103 --
104
105 FUNCTION get_archived_taxable_income(p_bg_id IN NUMBER
106 ,p_year IN NUMBER
107 ,p_tax_unit_id IN NUMBER)
108 RETURN NUMBER;
109
110 END pay_nl_wage_report_pkg;
[Home] [Help]