310: l_ums_table_count := 0;
311:
312: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_BUGFIXES', g_rc.bugfixes);
313: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_BUGFIX_RELATIONSHIPS', g_rc.bugfix_relationships);
314: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_FILES', g_rc.files);
315: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_FILE_VERSIONS', g_rc.file_versions);
316: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_BUGFIX_FILE_VERSIONS', g_rc.bugfix_file_versions);
317:
318: if (g_debug_flag = DEBUG_STATS) then
1024: end up_fnd_ums_bugfix;
1025:
1026: --------------------------------------------------------------------------------
1027: function new_file_guid_at
1028: (p_application_short_name in fnd_ums_files.application_short_name%type,
1029: p_location in fnd_ums_files.location%type,
1030: p_name in fnd_ums_files.name%type)
1031: return raw
1032: is
1025:
1026: --------------------------------------------------------------------------------
1027: function new_file_guid_at
1028: (p_application_short_name in fnd_ums_files.application_short_name%type,
1029: p_location in fnd_ums_files.location%type,
1030: p_name in fnd_ums_files.name%type)
1031: return raw
1032: is
1033: pragma autonomous_transaction;
1026: --------------------------------------------------------------------------------
1027: function new_file_guid_at
1028: (p_application_short_name in fnd_ums_files.application_short_name%type,
1029: p_location in fnd_ums_files.location%type,
1030: p_name in fnd_ums_files.name%type)
1031: return raw
1032: is
1033: pragma autonomous_transaction;
1034: l_file_guid fnd_ums_files.file_guid%type;
1030: p_name in fnd_ums_files.name%type)
1031: return raw
1032: is
1033: pragma autonomous_transaction;
1034: l_file_guid fnd_ums_files.file_guid%type;
1035: begin
1036: -- lock the entity first
1037:
1038: lock_entity('FND_UMS_FILES', p_application_short_name, p_location, p_name);
1034: l_file_guid fnd_ums_files.file_guid%type;
1035: begin
1036: -- lock the entity first
1037:
1038: lock_entity('FND_UMS_FILES', p_application_short_name, p_location, p_name);
1039:
1040: -- check the existence again
1041:
1042: begin
1039:
1040: -- check the existence again
1041:
1042: begin
1043: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1044: into l_file_guid
1045: from fnd_ums_files
1046: where application_short_name = p_application_short_name
1047: and location = p_location
1041:
1042: begin
1043: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1044: into l_file_guid
1045: from fnd_ums_files
1046: where application_short_name = p_application_short_name
1047: and location = p_location
1048: and name = p_name;
1049: exception
1047: and location = p_location
1048: and name = p_name;
1049: exception
1050: when no_data_found then
1051: -- populate FND_UMS_FILES
1052:
1053: insert into fnd_ums_files
1054: (file_guid,
1055: application_short_name,
1049: exception
1050: when no_data_found then
1051: -- populate FND_UMS_FILES
1052:
1053: insert into fnd_ums_files
1054: (file_guid,
1055: application_short_name,
1056: location,
1057: name)
1077: end new_file_guid_at;
1078:
1079: --------------------------------------------------------------------------------
1080: function get_file_guid
1081: (p_application_short_name in fnd_ums_files.application_short_name%type,
1082: p_location in fnd_ums_files.location%type,
1083: p_name in fnd_ums_files.name%type)
1084: return raw
1085: is
1078:
1079: --------------------------------------------------------------------------------
1080: function get_file_guid
1081: (p_application_short_name in fnd_ums_files.application_short_name%type,
1082: p_location in fnd_ums_files.location%type,
1083: p_name in fnd_ums_files.name%type)
1084: return raw
1085: is
1086: l_file_guid fnd_ums_files.file_guid%type;
1079: --------------------------------------------------------------------------------
1080: function get_file_guid
1081: (p_application_short_name in fnd_ums_files.application_short_name%type,
1082: p_location in fnd_ums_files.location%type,
1083: p_name in fnd_ums_files.name%type)
1084: return raw
1085: is
1086: l_file_guid fnd_ums_files.file_guid%type;
1087: begin
1082: p_location in fnd_ums_files.location%type,
1083: p_name in fnd_ums_files.name%type)
1084: return raw
1085: is
1086: l_file_guid fnd_ums_files.file_guid%type;
1087: begin
1088: begin
1089: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1090: into l_file_guid
1085: is
1086: l_file_guid fnd_ums_files.file_guid%type;
1087: begin
1088: begin
1089: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1090: into l_file_guid
1091: from fnd_ums_files
1092: where application_short_name = p_application_short_name
1093: and location = p_location
1087: begin
1088: begin
1089: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1090: into l_file_guid
1091: from fnd_ums_files
1092: where application_short_name = p_application_short_name
1093: and location = p_location
1094: and name = p_name;
1095: exception