1 PACKAGE pay_us_geo_upd_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyusgeou.pkh 120.4.12020000.2 2012/07/15 11:25:22 emunisek 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 FUNCTION get_city(p_person_id number,
26 p_location_id number,
27 p_state_code varchar2,
28 p_county_code varchar2,
29 p_city_code varchar2,
30 p_city_name varchar2,
31 p_patch_name varchar2,
32 p_process_type varchar2
33 )
34 RETURN varchar2;
35
36 PROCEDURE range_cursor(pactid in number
37 ,sqlstr out nocopy varchar2);
38
39
40
41 PROCEDURE action_creation (pactid in number
42 ,stperson in number
43 ,endperson in number
44 ,chunk in number);
45
46 PROCEDURE sort_action(payactid in varchar2
47 ,sqlstr in out nocopy varchar2
48 ,len out nocopy number);
49
50 PROCEDURE archive_code (p_xfr_action_id in number
51 , p_effective_date in date);
52
53 PROCEDURE archive_deinit(p_payroll_action_id in number);
54
55
56 FUNCTION get_parameter(name in varchar2,
57 parameter_list varchar2) RETURN VARCHAR2;
58
59 PROCEDURE upgrade_geocodes(
60 p_assign_start IN NUMBER,
61 p_assign_end IN NUMBER,
62 p_geo_phase_id IN NUMBER,
63 p_mode IN VARCHAR2,
64 p_patch_name IN VARCHAR2,
65 p_city_name IN VARCHAR2 DEFAULT NULL,
66 p_api_mode IN VARCHAR2 DEFAULT 'N');
67
68
69 PROCEDURE upgrade_geo_api(P_ASSIGN_ID NUMBER,
70 P_PATCH_NAME VARCHAR2,
71 P_MODE VARCHAR2,
72 P_CITY_NAME VARCHAR2);
73
74
75 g_geo_phase_id number;
76
77 g_mode varchar2(10);
78
79 g_process_type varchar2(2);
80
81
82 PROCEDURE update_taxability_rules(P_GEO_PHASE_ID IN NUMBER,
83 P_MODE IN VARCHAR2,
84 P_PATCH_NAME IN VARCHAR2);
85
86 --Added for Annual GEO 2010 Bug#9541247.
87 --This procedure will be used to update the County Name stored in
88 --Person's Address table PER_ADDRESSES and Location Details table
89 --HR_LOCATIONS_ALL when there is a change to a County Name
90
91 --Added parameter p_call for Bug#10060041
92 PROCEDURE update_county_name(P_GEO_PHASE_ID IN NUMBER,
93 P_MODE IN VARCHAR2,
94 P_PATCH_NAME IN VARCHAR2,
95 P_CALL IN VARCHAR2);
96 --End Bug#9541247
97
98 /* Added Procedure for Bug#14314081 */
99
100 PROCEDURE update_city_name(P_GEO_PHASE_ID IN NUMBER,
101 P_MODE IN VARCHAR2,
102 P_PATCH_NAME IN VARCHAR2,
103 P_CALL IN VARCHAR2);
104
105 /* End of changes for Bug#14314081 */
106
107 PROCEDURE update_org_info(P_GEO_PHASE_ID IN NUMBER,
108 P_MODE IN VARCHAR2,
109 P_PATCH_NAME IN VARCHAR2);
110
111 Function IS_US_OR_CA_LEGISLATION
112 (p_input_value_id in pay_input_values_f.input_value_id%TYPE)
113 Return pay_input_values_f.input_value_id%TYPE;
114
115 PROCEDURE update_ca_emp_info(P_GEO_PHASE_ID IN NUMBER,
116 P_MODE IN VARCHAR2,
117 P_PATCH_NAME IN VARCHAR2);
118
119
120 PROCEDURE group_level_balance (P_START_PAYROLL_ACTION IN NUMBER,
121 P_END_PAYROLL_ACTION IN NUMBER,
122 P_GEO_PHASE_ID IN NUMBER,
123 P_MODE IN VARCHAR2,
124 P_PATCH_NAME IN VARCHAR2) ;
125
126
127
128 end pay_us_geo_upd_pkg;