[Home] [Help]
Skip to content
PACKAGE BODY: APPS.PY_SQWL_FORMULAS
Source
1 package body py_sqwl_formulas as
2 /* $Header: pysqwl.pkb 115.9 1999/11/23 21:56:12 pkm ship $ */
3
4 PROCEDURE insert_formula
5 ( p_formula_name VARCHAR2 )
6 IS
7 p_formula_type_id number(9);
8 l_exists varchar2(1);
9
10 BEGIN
11
12 SELECT formula_type_id
13 INTO p_formula_type_id
14 FROM ff_formula_types
15 WHERE FORMULA_TYPE_NAME = 'Oracle Payroll';
16
17 BEGIN
18
19 SELECT 'y'
20 INTO l_exists
21 FROM ff_formulas_f
22 WHERE formula_name = p_formula_name;
23
24 EXCEPTION WHEN NO_DATA_FOUND THEN
25
26 INSERT INTO ff_formulas_f
27 (formula_id,
28 effective_start_date,
29 effective_end_date,
30 business_group_id,
31 legislation_code,
32 formula_type_id,
33 formula_name,
34 description,
35 formula_text,
36 sticky_flag)
37 VALUES
38 (ff_formulas_s.nextval,
39 fnd_date.canonical_to_date('0001/01/01 00:00:00'),
40 fnd_date.canonical_to_date('4712/12/31 23:59:59'),
41 NULL,
42 'US',
43 p_formula_type_id,
44 p_formula_name,
45 NULL,
46 NULL,
47 NULL);
48
49 END;
50
51 END insert_formula;
52
53 PROCEDURE load_formulas IS
54
55 BEGIN
56
57 insert_formula('ICESA_TRANSMITTER');
58 insert_formula('ICESA_BINFO');
59 insert_formula('ICESA_EMPLOYER');
60 insert_formula('ICESA_SUPPLEMENTAL');
61 insert_formula('ICESA_TOTAL');
62 insert_formula('ICESA_TOTAL2');
63 insert_formula('ICESA_FINAL');
64 insert_formula('SSA_SQWL_TRANSMITTER');
65 insert_formula('SSA_SQWL_BINFO');
66 insert_formula('SSA_SQWL_EMPLOYER');
67 insert_formula('SSA_SQWL_SUPPLEMENTAL');
68 insert_formula('SSA_SQWL_TOTAL');
69 insert_formula('SSA_SQWL_FINAL');
70 insert_formula('GASQWL_SUPPLEMENTAL');
71 insert_formula('INSQWL_SUPPLEMENTAL');
72 insert_formula('INSQWL_FINAL');
73 insert_formula('NJSQWL_TRANSMITTER');
74 insert_formula('NJSQWL_EMPLOYER');
75 insert_formula('NJSQWL_SUPPLEMENTAL');
76 insert_formula('NMSQWL_EMPLOYER');
77 insert_formula('NMSQWL_SUPPLEMENTAL');
78 insert_formula('NYSQWL_TRANSMITTER');
79 insert_formula('NYSQWL_EMPLOYER');
80 insert_formula('NYSQWL_EMPLOYEE');
81 insert_formula('NYSQWL_TOTAL');
82 insert_formula('NYSQWL_FINAL');
83 /***** Bug 976472 **********/
84 insert_formula('NYSQWL_EMPLOYEE_JURISDICTION');
85 insert_formula('NYSQWL_EMPLOYEE_TOTAL');
86 /*****End Bug 976472 **********/
87 insert_formula('OHSQWL_EMPLOYER');
88 insert_formula('OHSQWL_EMPLOYEE');
89 insert_formula('DUMMY_SQWL_EMPLOYER');
90 insert_formula('DUMMY_SQWL_TRANSMITTER');
91 insert_formula('DCSQWL_SUPPLEMENTAL');
92 insert_formula('IDSQWL_SUPPLEMENTAL');
93 insert_formula('PRSQWL_SUPPLEMENTAL');
94 insert_formula('AKSQWL_EMPLOYEE');
95 insert_formula('AKSQWL_TOTAL');
96 insert_formula('IASQWL_EMPLOYER');
97 insert_formula('IASQWL_SUPPLEMENTAL');
98 insert_formula('IASQWL_TOTAL');
99 insert_formula('IASQWL_FINAL');
100 insert_formula('IASQWL_INTERMEDIATE_TOTAL');
101 insert_formula('DUMMY_TIB4_TOTAL');
102 insert_formula('DUMMY_TIB4_FINAL');
103 insert_formula('DUMMY_TIB4_TRANSMITTER');
104 insert_formula('NCTIB4_SUPPLEMENTAL');
105 insert_formula('TIB4_SUPPLEMENTAL');
106 insert_formula('NJTIB4_SUPPLEMENTAL');
107 insert_formula('DUMMY_SQWL_TOTAL');
108 insert_formula('DUMMY_SQWL_FINAL');
109 insert_formula('FLSQWL_TRANSMITTER');
110 insert_formula('FLSQWL_EMPLOYER');
111 insert_formula('FLSQWL_SUPPLEMENTAL');
112 insert_formula('FLSQWL_INTERMEDIATE_TOTAL');
113 insert_formula('FLSQWL_TOTAL');
114 insert_formula('FLSQWL_FINAL');
115 insert_formula('SDSQWLD_EMPLOYER');
116 insert_formula('SDSQWLD_SUPPLEMENTAL');
117 insert_formula('WASQWL_EMPLOYER');
118 insert_formula('WASQWL_SUPPLEMENTAL');
119 insert_formula('WASQWL_FINAL');
120 insert_formula('TIB4_DUMMY');
121 insert_formula('TIB4_TRANSMITTER');
122 insert_formula('TIB4_EMPLOYER');
123 insert_formula('TIB4_EMPLOYEE');
124 insert_formula('TIB4_BINFO');
125 insert_formula('TIB4_TOTAL');
126 insert_formula('TIB4_FINAL');
127 insert_formula('TIB4_INTERMEDIATE_TOTAL');
128 insert_formula('W2_TIB4_SUPPLEMENTAL');
129 insert_formula('W2_HIGH_COMP');
130 insert_formula('MDSQWLD_FINAL');
131 insert_formula('MDSQWLD_SUPPLEMENTAL');
132 insert_formula('CTSQWL_TOTAL');
133 insert_formula('CT_SQWL_TOTAL_NP');
134 insert_formula('CT_SQWL_SUPPLEMENTAL_NP');
135 insert_formula('KY_DK_TRANSMITTER1');
136 insert_formula('KY_DK_TRANSMITTER2');
137 insert_formula('KY_DK_EMPLOYER1');
138 insert_formula('KY_DK_EMPLOYER2');
139 insert_formula('KY_DK_BINFO1');
140 insert_formula('KY_DK_BINFO2');
141 insert_formula('KY_DK_SUPPLEMENTAL1');
142 insert_formula('KY_DK_SUPPLEMENTAL2');
143 insert_formula('KY_DK_TOTAL1');
144 insert_formula('GATIB4_TRANSMITTER');
145 insert_formula('GATIB4_EMPLOYER');
146 insert_formula('GATIB4_SUPPLEMENTAL');
147 insert_formula('GATIB4_TOTAL');
148 insert_formula('GATIB4_FINAL');
149 insert_formula('NDSQWL_TRANSMITTER');
150
151
152 END load_formulas;
153
154 END py_sqwl_formulas;
155