1 PACKAGE pay_ins_custom_template AUTHID CURRENT_USER AS
2 /* $Header: payinscstmplt.pkh 120.0.12010000.2 2008/10/15 10:19:11 kagangul noship $*/
3 /*===========================================================================+
4 | Copyright (c) 2001 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +============================================================================+
8 Name PAY_INS_CUSTOM_TEMPLATE
9
10 File payinscstmplt.pkh
11
12 Purpose The purpose of this package is to register the user defined custom
13 Templates into Payroll Tables i.e. PAY_REPORT_CATEGORUES,
14 PAY_REPORT_CATEGORY_COMPONENTS AND PAY_REPORT_VARIABLES.
15
16 Notes Currently this procedure supports the following concurrent programs
17 for which user defined custom templates can be registered :
18 1. Local Year End Interface Extract
19 2. Employee W-2 PDF
20 3. 1099R Information Return - PDF
21 4. Check Writer (XML)
22 5. Deposit Advice (XML)
23 6. RL1 PDF
24 7. RL2 PDF
25 Whenever any new concurrent programs is required to be added in this
26 category i.e if any new conc programs is decided to have the flexibility
27 of registering custom template, please edit the function GET_NAME.
28 If the Concurrent program's short name differs from the corresponding
29 data_source_code in table xdo_templates_b, this function needs one
30 'elsif' clause to be added for that new concurrent program.
31
32 History
33
34 Date User Id Version Description
35 ============================================================================
36 01-Sep-08 kagangul 115.0 Initial Version Created
37 ============================================================================*/
38
39 PROCEDURE insert_custom_template(errbuf OUT NOCOPY VARCHAR2,
40 retcode OUT NOCOPY NUMBER,
41 p_conc_prog VARCHAR2,
42 p_lookup_type_name VARCHAR2,
43 p_business_group_id NUMBER);
44
45 FUNCTION get_definition_id(pn_report_group_id NUMBER,
46 pv_template_type_code VARCHAR2,
47 pv_template_code VARCHAR2)
48 RETURN NUMBER;
49
50 FUNCTION get_legislation_code(p_business_group_id NUMBER)
51 RETURN VARCHAR2;
52
53 PROCEDURE insert_report_variable(p_report_definition_id NUMBER,
54 p_definition_type VARCHAR2,
55 p_name VARCHAR2,
56 p_value VARCHAR2,
57 p_business_group_id NUMBER,
58 p_report_variable_id OUT NOCOPY NUMBER);
59
60 PROCEDURE insert_report_catg_comp(p_report_category_id NUMBER,
61 p_report_definition_id NUMBER,
62 p_breakout_variable_id NUMBER,
63 p_order_by_variable_id NUMBER,
64 p_style_sheet_variable_id NUMBER,
65 p_business_group_id NUMBER,
66 p_report_category_comp_id OUT NOCOPY NUMBER);
67
68 PROCEDURE insert_report_category(p_report_group_id NUMBER,
69 p_category_name VARCHAR2,
70 p_short_name VARCHAR2,
71 p_legislation_code VARCHAR2,
72 p_business_group_id NUMBER,
73 p_report_category_id NUMBER);
74
75 FUNCTION get_name(p_conc_prog VARCHAR2)
76 RETURN VARCHAR2;
77
78 END pay_ins_custom_template;