DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on USER_SOURCE

Line 4425: select substr(text,5,70) into l_version_info from user_source

4421:
4422: IF (g_level_procedure >= g_current_runtime_level ) THEN
4423:
4424: l_version_info := NULL;
4425: select substr(text,5,70) into l_version_info from user_source
4426: where name = 'ZX_EXTRACT_PKG'
4427: and text like '%Header:%'
4428: and type = 'PACKAGE BODY'
4429: and line < 10;

Line 4442: select substr(text,5,70) into l_version_info from user_source

4438: END IF;
4439:
4440: IF (g_level_procedure >= g_current_runtime_level ) THEN
4441: l_version_info := NULL;
4442: select substr(text,5,70) into l_version_info from user_source
4443: where name = 'ZX_AR_EXTRACT_PKG'
4444: and text like '%Header:%'
4445: and type = 'PACKAGE BODY'
4446: and line < 10;

Line 4454: select substr(text,5,70) into l_version_info from user_source

4450: END IF;
4451:
4452: IF (g_level_procedure >= g_current_runtime_level ) THEN
4453: l_version_info := NULL;
4454: select substr(text,5,70) into l_version_info from user_source
4455: where name = 'ZX_AP_EXTRACT_PKG'
4456: and text like '%Header:%'
4457: and type = 'PACKAGE BODY'
4458: and line < 10;

Line 4465: select substr(text,5,70) into l_version_info from user_source

4461: END IF;
4462:
4463: IF (g_level_procedure >= g_current_runtime_level ) THEN
4464: l_version_info := NULL;
4465: select substr(text,5,70) into l_version_info from user_source
4466: where name = 'ZX_AR_POPULATE_PKG'
4467: and text like '%Header:%'
4468: and type = 'PACKAGE BODY'
4469: and line < 10;

Line 4476: select substr(text,5,70) into l_version_info from user_source

4472: END IF;
4473:
4474: IF (g_level_procedure >= g_current_runtime_level ) THEN
4475: l_version_info := NULL;
4476: select substr(text,5,70) into l_version_info from user_source
4477: where name = 'ZX_AP_POPULATE_PKG'
4478: and text like '%Header:%'
4479: and type = 'PACKAGE BODY'
4480: and line < 10;

Line 4487: select substr(text,5,70) into l_version_info from user_source

4483: END IF;
4484:
4485: IF (g_level_procedure >= g_current_runtime_level ) THEN
4486: l_version_info := NULL;
4487: select substr(text,5,70) into l_version_info from user_source
4488: where name = 'ZX_GL_EXTRACT_PKG'
4489: and text like '%Header:%'
4490: and type = 'PACKAGE BODY'
4491: and line < 10;