APPS.CCT_UPGRADE_PKG dependencies on FND_LOOKUPS

Line 424: PROCEDURE delete_fnd_lookups( lookupType IN VARCHAR2

420:
421:
422: END COPY_ALL_ROWS;
423:
424: PROCEDURE delete_fnd_lookups( lookupType IN VARCHAR2
425: ,lookupCode IN VARCHAR2
426: )
427: IS
428: CURSOR csr_installed_langs IS

Line 433: l_string VARCHAR2(20) := 'DELETE_FND_LOOKUPS';

429: SELECT distinct language FROM fnd_lookup_values
430: WHERE lookup_type=lookupType;
431:
432: lang fnd_languages.language_code%TYPE;
433: l_string VARCHAR2(20) := 'DELETE_FND_LOOKUPS';
434:
435: BEGIN
436:
437: OPEN csr_installed_langs;

Line 443: delete_fnd_lookups( lookupType,lookupCode, lang);

439: LOOP
440: FETCH csr_installed_langs into lang;
441: EXIT WHEN csr_installed_langs%NOTFOUND;
442:
443: delete_fnd_lookups( lookupType,lookupCode, lang);
444:
445: END LOOP;
446:
447: CLOSE csr_installed_langs;

Line 455: PROCEDURE delete_fnd_lookups( lookupType IN VARCHAR2

451: CLOSE csr_installed_langs;
452: raise_application_error(-20000, sqlerrm || '.' || l_string) ;
453: END;
454:
455: PROCEDURE delete_fnd_lookups( lookupType IN VARCHAR2
456: , lookupCode IN VARCHAR2
457: , lang IN VARCHAR2)
458: IS
459: l_string VARCHAR2(25) := 'DELETE_FND_LOOKUPS-LANG';

Line 459: l_string VARCHAR2(25) := 'DELETE_FND_LOOKUPS-LANG';

455: PROCEDURE delete_fnd_lookups( lookupType IN VARCHAR2
456: , lookupCode IN VARCHAR2
457: , lang IN VARCHAR2)
458: IS
459: l_string VARCHAR2(25) := 'DELETE_FND_LOOKUPS-LANG';
460: BEGIN
461:
462: if lookupCode is null then
463:

Line 469: DELETE FND_LOOKUPS

465: WHERE lookup_type=lookupType
466: AND language = lang;
467:
468: -- Also deleting the lookup type as we have deleted all the values
469: DELETE FND_LOOKUPS
470: WHERE lookup_type=lookupType;
471:
472: else
473:

Line 480: DELETE FND_LOOKUPS

476: AND lookup_code = lookupCode
477: AND language = lang;
478:
479: -- Also deleting the lookup type as we have deleted all the values
480: DELETE FND_LOOKUPS
481: WHERE lookup_type=lookupType
482: AND lookup_code = lookupCode;
483:
484: end if;