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.15 2010/08/27 09:38:03 amaddula 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 197: insert_ap_income_tax_types;

193: end if;
194:
195: end loop ;
196:
197: insert_ap_income_tax_types;
198:
199: -- Call this procedure to reload ldts after fvdelapi.sql run
200: -- This ensure that all the dropped AOL objects are re-created
201: -- This design also avoids dummy checkin creation for loader files.

Line 230: PROCEDURE insert_ap_income_tax_types IS

226: END Run_Process ;
227:
228: -- Procedure to insert income tax types
229:
230: PROCEDURE insert_ap_income_tax_types IS
231: l_module_name varchar2(200);
232: l_errbuf varchar2(300);
233: BEGIN
234:

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

232: l_errbuf varchar2(300);
233: BEGIN
234:
235: g_module_name := 'fv.plsql.fv_install_extn.';
236: l_module_name := g_module_name || 'insert_ap_income_tax_types';
237:
238: INSERT INTO ap_income_tax_types
239: (income_tax_type,
240: description,

Line 238: INSERT INTO ap_income_tax_types

234:
235: g_module_name := 'fv.plsql.fv_install_extn.';
236: l_module_name := g_module_name || 'insert_ap_income_tax_types';
237:
238: INSERT INTO ap_income_tax_types
239: (income_tax_type,
240: description,
241: last_update_date,
242: last_updated_by,

Line 250: FROM ap_income_tax_types

246: (SELECT 'GOV 1','Unemployment compensation',sysdate,1,1,sysdate,1
247: FROM DUAL
248: WHERE NOT EXISTS
249: (SELECT 'x'
250: FROM ap_income_tax_types
251: WHERE income_tax_type = 'GOV 1'
252: AND description = 'Unemployment compensation'));
253:
254: INSERT INTO ap_income_tax_types

Line 254: INSERT INTO ap_income_tax_types

250: FROM ap_income_tax_types
251: WHERE income_tax_type = 'GOV 1'
252: AND description = 'Unemployment compensation'));
253:
254: INSERT INTO ap_income_tax_types
255: (income_tax_type,
256: description,
257: last_update_date,
258: last_updated_by,

Line 266: FROM ap_income_tax_types

262: (SELECT 'GOV 6','Taxable grants',sysdate,1,1,sysdate,1
263: FROM DUAL
264: WHERE NOT EXISTS
265: (SELECT 'x'
266: FROM ap_income_tax_types
267: WHERE income_tax_type = 'GOV 6'
268: AND description = 'Taxable grants'));
269:
270: INSERT INTO ap_income_tax_types

Line 270: INSERT INTO ap_income_tax_types

266: FROM ap_income_tax_types
267: WHERE income_tax_type = 'GOV 6'
268: AND description = 'Taxable grants'));
269:
270: INSERT INTO ap_income_tax_types
271: (income_tax_type,
272: description,
273: last_update_date,
274: last_updated_by,

Line 282: FROM ap_income_tax_types

278: (SELECT 'GOV 6A','Energy grants',sysdate,1,1,sysdate,1
279: FROM DUAL
280: WHERE NOT EXISTS
281: (SELECT 'x'
282: FROM ap_income_tax_types
283: WHERE income_tax_type = 'GOV 6A'
284: AND description = 'Energy grants'));
285:
286: INSERT INTO ap_income_tax_types

Line 286: INSERT INTO ap_income_tax_types

282: FROM ap_income_tax_types
283: WHERE income_tax_type = 'GOV 6A'
284: AND description = 'Energy grants'));
285:
286: INSERT INTO ap_income_tax_types
287: (income_tax_type,
288: description,
289: last_update_date,
290: last_updated_by,

Line 298: FROM ap_income_tax_types

294: (SELECT 'GOV 7','Agriculture payments',sysdate,1,1,sysdate,1
295: FROM DUAL
296: WHERE NOT EXISTS
297: (SELECT 'x'
298: FROM ap_income_tax_types
299: WHERE income_tax_type = 'GOV 7'
300: AND description = 'Agriculture payments'));
301:
302: INSERT INTO ap_income_tax_types

Line 302: INSERT INTO ap_income_tax_types

298: FROM ap_income_tax_types
299: WHERE income_tax_type = 'GOV 7'
300: AND description = 'Agriculture payments'));
301:
302: INSERT INTO ap_income_tax_types
303: (income_tax_type,
304: description,
305: last_update_date,
306: last_updated_by,

Line 314: FROM ap_income_tax_types

310: (SELECT 'INT 1','Interest income not included in box 3',sysdate,1,1,sysdate,1
311: FROM DUAL
312: WHERE NOT EXISTS
313: (SELECT 'x'
314: FROM ap_income_tax_types
315: WHERE income_tax_type = 'INT 1'
316: AND description = 'Interest income not included in box 3'));
317:
318: INSERT INTO ap_income_tax_types

Line 318: INSERT INTO ap_income_tax_types

314: FROM ap_income_tax_types
315: WHERE income_tax_type = 'INT 1'
316: AND description = 'Interest income not included in box 3'));
317:
318: INSERT INTO ap_income_tax_types
319: (income_tax_type,
320: description,
321: last_update_date,
322: last_updated_by,

Line 331: FROM ap_income_tax_types

327: sysdate,1,1,sysdate,1
328: FROM DUAL
329: WHERE NOT EXISTS
330: (SELECT 'x'
331: FROM ap_income_tax_types
332: WHERE income_tax_type = 'INT 1A'
333: AND description = 'Financial institution interest income not included in box
334: 3'));
335:

Line 336: INSERT INTO ap_income_tax_types

332: WHERE income_tax_type = 'INT 1A'
333: AND description = 'Financial institution interest income not included in box
334: 3'));
335:
336: INSERT INTO ap_income_tax_types
337: (income_tax_type,
338: description,
339: last_update_date,
340: last_updated_by,

Line 349: FROM ap_income_tax_types

345: sysdate,1,1,sysdate,1
346: FROM DUAL
347: WHERE NOT EXISTS
348: (SELECT 'x'
349: FROM ap_income_tax_types
350: WHERE income_tax_type = 'INT 3'
351: AND description = 'Interest on U.S. Savings Bonds and Treasury obligations'))
352: ;
353:

Line 359: END insert_ap_income_tax_types;

355: l_errbuf := sqlerrm;
356: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',l_errbuf);
357: NULL;
358:
359: END insert_ap_income_tax_types;
360:
361: -- Bug# 3578880
362: -- This procedure loads fvmenus.ldt, fvlkups.ldt, fvcprog.ldt, fvreqst.ldt
363: -- fvreqln.ldt and fvreqgr.ldt for all the langauges found in fnd_languages