APPS.FV_INSTALL_EXTN dependencies on AP_INCOME_TAX_TYPES

Line 4: PROCEDURE insert_ap_income_tax_types;

1: PACKAGE BODY FV_Install_Extn AS
2: -- $Header: FVXPIXTB.pls 120.14 2007/01/10 16:05:51 agovil ship $
3:
4: PROCEDURE insert_ap_income_tax_types;
5: PROCEDURE Load_FV_Ldts;
6:
7: g_module_name varchar2(100);
8: vp_retcode NUMBER;

Line 174: insert_ap_income_tax_types;

170: end if;
171:
172: end loop ;
173:
174: insert_ap_income_tax_types;
175:
176: -- Call this procedure to reload ldts after fvdelapi.sql run
177: -- This ensure that all the dropped AOL objects are re-created
178: -- This design also avoids dummy checkin creation for loader files.

Line 207: PROCEDURE insert_ap_income_tax_types IS

203: END Run_Process ;
204:
205: -- Procedure to insert income tax types
206:
207: PROCEDURE insert_ap_income_tax_types IS
208: l_module_name varchar2(200);
209: l_errbuf varchar2(300);
210: BEGIN
211:

Line 213: l_module_name := g_module_name || 'insert_ap_income_tax_types';

209: l_errbuf varchar2(300);
210: BEGIN
211:
212: g_module_name := 'fv.plsql.fv_install_extn.';
213: l_module_name := g_module_name || 'insert_ap_income_tax_types';
214:
215: INSERT INTO ap_income_tax_types
216: (income_tax_type,
217: description,

Line 215: INSERT INTO ap_income_tax_types

211:
212: g_module_name := 'fv.plsql.fv_install_extn.';
213: l_module_name := g_module_name || 'insert_ap_income_tax_types';
214:
215: INSERT INTO ap_income_tax_types
216: (income_tax_type,
217: description,
218: last_update_date,
219: last_updated_by,

Line 227: FROM ap_income_tax_types

223: (SELECT 'GOV 1','Unemployment compensation',sysdate,1,1,sysdate,1
224: FROM DUAL
225: WHERE NOT EXISTS
226: (SELECT 'x'
227: FROM ap_income_tax_types
228: WHERE income_tax_type = 'GOV 1'
229: AND description = 'Unemployment compensation'));
230:
231: INSERT INTO ap_income_tax_types

Line 231: INSERT INTO ap_income_tax_types

227: FROM ap_income_tax_types
228: WHERE income_tax_type = 'GOV 1'
229: AND description = 'Unemployment compensation'));
230:
231: INSERT INTO ap_income_tax_types
232: (income_tax_type,
233: description,
234: last_update_date,
235: last_updated_by,

Line 243: FROM ap_income_tax_types

239: (SELECT 'GOV 6','Taxable grants',sysdate,1,1,sysdate,1
240: FROM DUAL
241: WHERE NOT EXISTS
242: (SELECT 'x'
243: FROM ap_income_tax_types
244: WHERE income_tax_type = 'GOV 6'
245: AND description = 'Taxable grants'));
246:
247: INSERT INTO ap_income_tax_types

Line 247: INSERT INTO ap_income_tax_types

243: FROM ap_income_tax_types
244: WHERE income_tax_type = 'GOV 6'
245: AND description = 'Taxable grants'));
246:
247: INSERT INTO ap_income_tax_types
248: (income_tax_type,
249: description,
250: last_update_date,
251: last_updated_by,

Line 259: FROM ap_income_tax_types

255: (SELECT 'GOV 6A','Energy grants',sysdate,1,1,sysdate,1
256: FROM DUAL
257: WHERE NOT EXISTS
258: (SELECT 'x'
259: FROM ap_income_tax_types
260: WHERE income_tax_type = 'GOV 6A'
261: AND description = 'Energy grants'));
262:
263: INSERT INTO ap_income_tax_types

Line 263: INSERT INTO ap_income_tax_types

259: FROM ap_income_tax_types
260: WHERE income_tax_type = 'GOV 6A'
261: AND description = 'Energy grants'));
262:
263: INSERT INTO ap_income_tax_types
264: (income_tax_type,
265: description,
266: last_update_date,
267: last_updated_by,

Line 275: FROM ap_income_tax_types

271: (SELECT 'GOV 7','Agriculture payments',sysdate,1,1,sysdate,1
272: FROM DUAL
273: WHERE NOT EXISTS
274: (SELECT 'x'
275: FROM ap_income_tax_types
276: WHERE income_tax_type = 'GOV 7'
277: AND description = 'Agriculture payments'));
278:
279: INSERT INTO ap_income_tax_types

Line 279: INSERT INTO ap_income_tax_types

275: FROM ap_income_tax_types
276: WHERE income_tax_type = 'GOV 7'
277: AND description = 'Agriculture payments'));
278:
279: INSERT INTO ap_income_tax_types
280: (income_tax_type,
281: description,
282: last_update_date,
283: last_updated_by,

Line 291: FROM ap_income_tax_types

287: (SELECT 'INT 1','Interest income not included in box 3',sysdate,1,1,sysdate,1
288: FROM DUAL
289: WHERE NOT EXISTS
290: (SELECT 'x'
291: FROM ap_income_tax_types
292: WHERE income_tax_type = 'INT 1'
293: AND description = 'Interest income not included in box 3'));
294:
295: INSERT INTO ap_income_tax_types

Line 295: INSERT INTO ap_income_tax_types

291: FROM ap_income_tax_types
292: WHERE income_tax_type = 'INT 1'
293: AND description = 'Interest income not included in box 3'));
294:
295: INSERT INTO ap_income_tax_types
296: (income_tax_type,
297: description,
298: last_update_date,
299: last_updated_by,

Line 308: FROM ap_income_tax_types

304: sysdate,1,1,sysdate,1
305: FROM DUAL
306: WHERE NOT EXISTS
307: (SELECT 'x'
308: FROM ap_income_tax_types
309: WHERE income_tax_type = 'INT 1A'
310: AND description = 'Financial institution interest income not included in box
311: 3'));
312:

Line 313: INSERT INTO ap_income_tax_types

309: WHERE income_tax_type = 'INT 1A'
310: AND description = 'Financial institution interest income not included in box
311: 3'));
312:
313: INSERT INTO ap_income_tax_types
314: (income_tax_type,
315: description,
316: last_update_date,
317: last_updated_by,

Line 326: FROM ap_income_tax_types

322: sysdate,1,1,sysdate,1
323: FROM DUAL
324: WHERE NOT EXISTS
325: (SELECT 'x'
326: FROM ap_income_tax_types
327: WHERE income_tax_type = 'INT 3'
328: AND description = 'Interest on U.S. Savings Bonds and Treasury obligations'))
329: ;
330:

Line 336: END insert_ap_income_tax_types;

332: l_errbuf := sqlerrm;
333: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',l_errbuf);
334: NULL;
335:
336: END insert_ap_income_tax_types;
337:
338: -- Bug# 3578880
339: -- This procedure loads fvmenus.ldt, fvlkups.ldt, fvcprog.ldt, fvreqst.ldt
340: -- fvreqln.ldt and fvreqgr.ldt for all the langauges found in fnd_languages