APPS.FND_DOC_CATEGORIES_PKG dependencies on FND_APPLICATION

Line 556: -- Get application id from fnd_application

552: if (X_OWNER = 'SEED') then
553: l_user_id := 1;
554: end if;
555:
556: -- Get application id from fnd_application
557: if (X_APP_SHORT_NAME IS NOT NULL) then
558: select application_id
559: into l_application_id
560: from fnd_application

Line 560: from fnd_application

556: -- Get application id from fnd_application
557: if (X_APP_SHORT_NAME IS NOT NULL) then
558: select application_id
559: into l_application_id
560: from fnd_application
561: where application_short_name = X_APP_SHORT_NAME;
562: else
563: l_application_id := NULL ;
564: end if;

Line 689: -- Get application id from fnd_application

685:
686: -- Translate char last_update_date to date
687: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
688:
689: -- Get application id from fnd_application
690: if (X_APP_SHORT_NAME IS NOT NULL) then
691: select application_id
692: into l_application_id
693: from fnd_application

Line 693: from fnd_application

689: -- Get application id from fnd_application
690: if (X_APP_SHORT_NAME IS NOT NULL) then
691: select application_id
692: into l_application_id
693: from fnd_application
694: where application_short_name = X_APP_SHORT_NAME;
695: else
696: l_application_id := NULL ;
697: end if;