1 PACKAGE pay_us_geo_upd_pkg AS
2 /* $Header: pyusgeou.pkh 120.1.12010000.1 2008/07/27 23:51:54 appldev ship $ */
3
4
5 /* DESCRIPTION OF THE LOCAL PROCEDURES:
6 write_message => inserts rows into PAY_US_GEO_UPDATE for each iteration
7 upgrade_geocodes => driving procedure calls all the local procedures
8 balance_batch_lines => updates pay balance batch lines
9 city_tax_records => updates city tax records
10 run_results => updates run results
11 archive_item_contexts => updates archive items
12 element_entries => updates element entries
13 balance_contexts => updates balance contexts for person and assignment level
14 duplicate_vertex_ee => deletes duplicate element entries and adds percentages togethor
15 insert_ele_entries => creates element entries for assignments that have new geocodes
16 check_time => checks the percent time for element entries
17 update_taxability_rules => updates the taxability rules
18 update_org_info => updates org_information1 column
19 in hr_organization_information
20 pay_run_balances => updates jurisdiction code and jurisdiction comp3
21 (jurisdiction comp3 is new city code)
22 pay_action_contexts => updates context_value
23 */
24
25 PROCEDURE range_cursor(pactid in number
26 ,sqlstr out nocopy varchar2);
27
28
29
30 PROCEDURE action_creation (pactid in number
31 ,stperson in number
32 ,endperson in number
33 ,chunk in number);
34
35 PROCEDURE sort_action(payactid in varchar2
36 ,sqlstr in out nocopy varchar2
37 ,len out nocopy number);
38
39 PROCEDURE archive_code (p_xfr_action_id in number
40 , p_effective_date in date);
41
42 PROCEDURE archive_deinit(p_payroll_action_id in number);
43
44
45 FUNCTION get_parameter(name in varchar2,
46 parameter_list varchar2) RETURN VARCHAR2;
47
48 PROCEDURE upgrade_geocodes(
49 p_assign_start IN NUMBER,
50 p_assign_end IN NUMBER,
51 p_geo_phase_id IN NUMBER,
52 p_mode IN VARCHAR2,
53 p_patch_name IN VARCHAR2,
54 p_city_name IN VARCHAR2 DEFAULT NULL,
55 p_api_mode IN VARCHAR2 DEFAULT 'N');
56
57
58 PROCEDURE upgrade_geo_api(P_ASSIGN_ID NUMBER,
59 P_PATCH_NAME VARCHAR2,
60 P_MODE VARCHAR2,
61 P_CITY_NAME VARCHAR2);
62
63
64 g_geo_phase_id number;
65
66 g_mode varchar2(10);
67
68 g_process_type varchar2(2);
69
70
71 PROCEDURE update_taxability_rules(P_GEO_PHASE_ID IN NUMBER,
72 P_MODE IN VARCHAR2,
73 P_PATCH_NAME IN VARCHAR2);
74
75 PROCEDURE update_org_info(P_GEO_PHASE_ID IN NUMBER,
76 P_MODE IN VARCHAR2,
77 P_PATCH_NAME IN VARCHAR2);
78
79 Function IS_US_OR_CA_LEGISLATION
80 (p_input_value_id in pay_input_values_f.input_value_id%TYPE)
81 Return pay_input_values_f.input_value_id%TYPE;
82
83 PROCEDURE update_ca_emp_info(P_GEO_PHASE_ID IN NUMBER,
84 P_MODE IN VARCHAR2,
85 P_PATCH_NAME IN VARCHAR2);
86
87
88 PROCEDURE group_level_balance (P_START_PAYROLL_ACTION IN NUMBER,
89 P_END_PAYROLL_ACTION IN NUMBER,
90 P_GEO_PHASE_ID IN NUMBER,
91 P_MODE IN VARCHAR2,
92 P_PATCH_NAME IN VARCHAR2) ;
93
94
95
96 end pay_us_geo_upd_pkg;