1 package pay_simulator_ss_pkg AUTHID CURRENT_USER AS
2 /* $Header: pysimss.pkh 120.0.12020000.3 2013/04/04 12:31:47 apudiped noship $
3 ------------------------------------------------------------------------------
4 +==============================================================================+
5 | Copyright (c) 2013 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +==============================================================================+
9 Name
10 Payroll Simulation Self Service Package
11 Purpose
12 This package handles the Payroll Simulation process requests from UI.
13 The Insertion of data into the PER_ASSIGNMENT_EXTRA_INFO and Submition
14 and completion of the Payroll Simulation Concurrent Program
15 History
16 02 Feb 2013 apudiped Initial Version Created
17 04 Feb 2013 apudiped Removed GSCC errors
18 28 Feb 2013 apudiped Created check_actions
19 04 Apr 2013 apudiped Added Validate Input Values
20 */
21
22 PROCEDURE clearpreviousdata
23 (p_assignment_id IN NUMBER);
24
25 PROCEDURE insert_row
26 (p_assignment_id IN varchar2
27 , p_info_category IN varchar2
28 , p_info_type IN varchar2
29 , p_val1 IN varchar2
30 , p_val2 IN varchar2
31 , p_val3 IN varchar2
32 , p_val4 IN varchar2
33 , p_val5 IN varchar2
34 , p_val6 IN varchar2
35 , p_val7 IN varchar2
36 , p_val8 IN varchar2
37 , p_val9 IN varchar2
38 , p_val10 IN varchar2
39 , p_val11 IN varchar2
40 , p_val12 IN varchar2
41 , p_val13 IN varchar2
42 , p_val14 IN varchar2
43 , p_val15 IN varchar2
44 , p_val16 IN varchar2
45 , p_val17 IN varchar2
46 , p_val18 IN varchar2
47 , p_val19 IN varchar2
48 , p_val20 IN varchar2
49 , p_val21 IN varchar2
50 , p_val22 IN varchar2
51 , p_val23 IN varchar2
52 , p_val24 IN varchar2
53 , p_val25 IN varchar2
54 , p_val26 IN varchar2
55 , p_val27 IN varchar2
56 , p_val28 IN varchar2
57 , p_val29 IN varchar2
58 , p_val30 IN varchar2
59 , p_del_flag IN varchar2);
60
61 FUNCTION get_employee_name
62 (p_person_id IN number) RETURN varchar2;
63
64 FUNCTION submit_request
65 (p_assignment_id IN number
66 , p_business_group_id IN number
67 , p_payroll_id IN number
68 , p_consolidation_set_id IN number
69 , p_run_date IN date) RETURN number;
70
71 PROCEDURE wait_request
72 (p_assignment_id in number,
73 p_request_id in number,
74 p_request_status out nocopy varchar2,
75 p_error_type out nocopy varchar2,
76 p_error_message out nocopy varchar2);
77
78 FUNCTION check_eligibility
79 (p_assignment_id in NUMBER) RETURN VARCHAR2;
80
81 FUNCTION check_actions
82 (p_assignment_id in NUMBER) RETURN VARCHAR2;
83
84 PROCEDURE validate_input_values
85 (p_assignment_id in number,
86 p_input_value_id in NUMBER,
87 p_screen_entry_value in out nocopy VARCHAR2,
88 p_internal_value out nocopy varchar2,
89 p_status out nocopy varchar2);
90
91 END pay_simulator_ss_pkg;