739: C_CREATED CONSTANT BOOLEAN := TRUE;
740: --
741: g_Max_line CONSTANT NUMBER := 225;
742: g_chr_quote CONSTANT VARCHAR2(10):='''';
743: g_chr_newline CONSTANT VARCHAR2(10):= fa_cmp_string_pkg.g_chr_newline;
744:
745: g_log_level_rec fa_api_types.log_level_rec_type;
746:
747: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
771: G_MODULE_NAME||l_procedure_name||'.begin',
772: 'Beginning of procedure');
773: END IF;
774:
775: l_array_body := fa_cmp_string_pkg.g_null_varchar2s;
776: l_array_pkg := fa_cmp_string_pkg.g_null_varchar2s;
777:
778: -- deferred does not use locking - exit returning nothing
779: l_bodypkg := C_PRIVATE_API_1;
772: 'Beginning of procedure');
773: END IF;
774:
775: l_array_body := fa_cmp_string_pkg.g_null_varchar2s;
776: l_array_pkg := fa_cmp_string_pkg.g_null_varchar2s;
777:
778: -- deferred does not use locking - exit returning nothing
779: l_bodypkg := C_PRIVATE_API_1;
780:
777:
778: -- deferred does not use locking - exit returning nothing
779: l_bodypkg := C_PRIVATE_API_1;
780:
781: fa_cmp_string_pkg.CreateString
782: (p_package_text => l_BodyPkg
783: ,p_array_string => l_array_pkg);
784:
785: if (p_extract_type = 'DEPRN') then
797: else
798: null; -- unkown type
799: end if;
800:
801: fa_cmp_string_pkg.CreateString
802: (p_package_text => l_BodyPkg
803: ,p_array_string => l_array_body);
804:
805: l_array_pkg :=
802: (p_package_text => l_BodyPkg
803: ,p_array_string => l_array_body);
804:
805: l_array_pkg :=
806: fa_cmp_string_pkg.ConcatTwoStrings
807: (p_array_string_1 => l_array_pkg
808: ,p_array_string_2 => l_array_body);
809:
810:
809:
810:
811: l_bodypkg := C_PRIVATE_API_3;
812:
813: fa_cmp_string_pkg.CreateString
814: (p_package_text => l_BodyPkg
815: ,p_array_string => l_array_body);
816:
817: l_array_pkg :=
814: (p_package_text => l_BodyPkg
815: ,p_array_string => l_array_body);
816:
817: l_array_pkg :=
818: fa_cmp_string_pkg.ConcatTwoStrings
819: (p_array_string_1 => l_array_pkg
820: ,p_array_string_2 => l_array_body);
821:
822: p_package_body := l_array_pkg;