PACKAGE: APPS.PAY_GB_P6EDI_PKG

Source

1 PACKAGE pay_gb_p6edi_pkg AS
2 /* $Header: pygbp6ei.pkh 120.2 2007/11/02 10:04:30 dchindar noship $ */
3 --
4 --
5 -- --------------- p6 upload process ---------------------
6 --
7 -- uploads p6 information from flat file into
8 -- pay_gb_tax_code_interface table
9 --
10 PROCEDURE upload_p6(errbuf OUT NOCOPY VARCHAR2,
11                     retcode OUT NOCOPY NUMBER,
12                     p_request_id in number default null,
13                     p_filename IN VARCHAR2,
14                     p_mode IN NUMBER,
15                     p_effective_date IN varchar2,
16                     p_business_group_id IN NUMBER,
17                     --p_payroll_id in number default null,
18                     -- p_authority  IN varchar2 default null, /*Change for soy 08-09*/
19 		    p_validate_only IN varchar2);
20 --
21 --
22 --
23 FUNCTION get_qualifier(line VARCHAR2)
24   return VARCHAR2;
25 --
26 --
27 --
28 FUNCTION get_name(line VARCHAR2)
29   return VARCHAR2;
30 --
31 --
32 --
33 FUNCTION process_att(line VARCHAR2, qualifier VARCHAR2)
34   return VARCHAR2;
35 --
36 --
37 --
38 FUNCTION process_date(line VARCHAR2)
39   return VARCHAR2;
40 --
41 --
42 --
43 FUNCTION process_tax(line VARCHAR2, process_type NUMBER)
44   return VARCHAR2;
45 --
46 --
47 --
48 PROCEDURE write_to_database(date_of_message_p VARCHAR2,
49                            form_type_p VARCHAR2,
50                            district_number_p VARCHAR2,
51                            employer_reference_p VARCHAR2,
52                            ni_number_p VARCHAR2,
53                            works_number_p VARCHAR2,
54                            total_pay_prev_emp_p VARCHAR2,
55                            total_tax_prev_emp_p VARCHAR2,
56                            tax_code_p VARCHAR2,
57                            week1_month1_indicator_p VARCHAR2,
58                            employee_name_p VARCHAR2,
59                            effective_date_p VARCHAR2,
60                            issue_date_p VARCHAR2,
61                            request_id_p number default null);
62 --
63 --
64 --
65 end pay_gb_p6edi_pkg;