1 PACKAGE pay_nl_wage_report_pkg as
2 /* $Header: pynlwrar.pkh 120.1.12010000.4 2008/09/30 07:27:02 rsahai 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 PROCEDURE get_all_parameters(p_payroll_action_id IN NUMBER
67 ,p_business_group_id OUT NOCOPY NUMBER
68 ,p_start_date OUT NOCOPY DATE
69 ,p_end_date OUT NOCOPY DATE
70 ,p_legal_employer OUT NOCOPY NUMBER
71 ,p_payroll_type OUT NOCOPY VARCHAR2
72 ,p_seq_no OUT NOCOPY VARCHAR2);
73 --
74 PROCEDURE archive_range_code(p_actid IN NUMBER
75 ,sqlstr OUT NOCOPY VARCHAR2);
76 --
77 PROCEDURE archive_init_code(p_actid IN NUMBER);
78 --
79 PROCEDURE archive_action_creation(p_actid IN NUMBER
80 ,stperson IN NUMBER
81 ,endperson IN NUMBER
82 ,chunk IN NUMBER);
83 --
84 PROCEDURE lock_action_creation (p_actid IN NUMBER
85 ,stperson IN NUMBER
86 ,endperson IN NUMBER
87 ,chunk IN NUMBER);
88 --
89 PROCEDURE archive_code(p_assactid in number
90 ,p_effective_date in date);
91
92 --
93 PROCEDURE archive_deinit_code(p_actid IN NUMBER);
94 --
95 FUNCTION get_archive_details(p_actid IN NUMBER) RETURN VARCHAR2;
96 --
97 END pay_nl_wage_report_pkg;