eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.FND_OAM_UMS_LOADER dependencies on FND_UMS_FILE_VERSIONS

Line 315: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_FILE_VERSIONS', g_rc.file_versions);

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
319: debug(' ');

Line 1113: (p_file_guid in fnd_ums_file_versions.file_guid%type,

1109: end get_file_guid;
1110:
1111: --------------------------------------------------------------------------------
1112: function new_file_version_guid_at
1113: (p_file_guid in fnd_ums_file_versions.file_guid%type,
1114: p_version in fnd_ums_file_versions.version%type)
1115: return raw
1116: is
1117: pragma autonomous_transaction;

Line 1114: p_version in fnd_ums_file_versions.version%type)

1110:
1111: --------------------------------------------------------------------------------
1112: function new_file_version_guid_at
1113: (p_file_guid in fnd_ums_file_versions.file_guid%type,
1114: p_version in fnd_ums_file_versions.version%type)
1115: return raw
1116: is
1117: pragma autonomous_transaction;
1118: l_file_version_guid fnd_ums_file_versions.file_version_guid%type;

Line 1118: l_file_version_guid fnd_ums_file_versions.file_version_guid%type;

1114: p_version in fnd_ums_file_versions.version%type)
1115: return raw
1116: is
1117: pragma autonomous_transaction;
1118: l_file_version_guid fnd_ums_file_versions.file_version_guid%type;
1119: begin
1120: -- lock the entity first
1121:
1122: lock_entity('FND_UMS_FILE_VERSIONS', p_file_guid, p_version);

Line 1122: lock_entity('FND_UMS_FILE_VERSIONS', p_file_guid, p_version);

1118: l_file_version_guid fnd_ums_file_versions.file_version_guid%type;
1119: begin
1120: -- lock the entity first
1121:
1122: lock_entity('FND_UMS_FILE_VERSIONS', p_file_guid, p_version);
1123:
1124: -- check the existence again
1125:
1126: begin

Line 1127: select /+ INDEX(fnd_ums_file_versions fnd_ums_file_versions_u2) / file_version_guid

1123:
1124: -- check the existence again
1125:
1126: begin
1127: select /*+ INDEX(fnd_ums_file_versions fnd_ums_file_versions_u2) */ file_version_guid
1128: into l_file_version_guid
1129: from fnd_ums_file_versions
1130: where file_guid = p_file_guid
1131: and version = p_version;

Line 1129: from fnd_ums_file_versions

1125:
1126: begin
1127: select /*+ INDEX(fnd_ums_file_versions fnd_ums_file_versions_u2) */ file_version_guid
1128: into l_file_version_guid
1129: from fnd_ums_file_versions
1130: where file_guid = p_file_guid
1131: and version = p_version;
1132: exception
1133: when no_data_found then

Line 1134: -- populate FND_UMS_FILE_VERSIONS

1130: where file_guid = p_file_guid
1131: and version = p_version;
1132: exception
1133: when no_data_found then
1134: -- populate FND_UMS_FILE_VERSIONS
1135:
1136: insert into fnd_ums_file_versions
1137: (file_version_guid,
1138: file_guid,

Line 1136: insert into fnd_ums_file_versions

1132: exception
1133: when no_data_found then
1134: -- populate FND_UMS_FILE_VERSIONS
1135:
1136: insert into fnd_ums_file_versions
1137: (file_version_guid,
1138: file_guid,
1139: version)
1140: values

Line 1162: (p_file_guid in fnd_ums_file_versions.file_guid%type,

1158: end new_file_version_guid_at;
1159:
1160: --------------------------------------------------------------------------------
1161: function get_file_version_guid
1162: (p_file_guid in fnd_ums_file_versions.file_guid%type,
1163: p_version in fnd_ums_file_versions.version%type)
1164: return raw
1165: is
1166: l_file_version_guid fnd_ums_file_versions.file_version_guid%type;

Line 1163: p_version in fnd_ums_file_versions.version%type)

1159:
1160: --------------------------------------------------------------------------------
1161: function get_file_version_guid
1162: (p_file_guid in fnd_ums_file_versions.file_guid%type,
1163: p_version in fnd_ums_file_versions.version%type)
1164: return raw
1165: is
1166: l_file_version_guid fnd_ums_file_versions.file_version_guid%type;
1167: begin

Line 1166: l_file_version_guid fnd_ums_file_versions.file_version_guid%type;

1162: (p_file_guid in fnd_ums_file_versions.file_guid%type,
1163: p_version in fnd_ums_file_versions.version%type)
1164: return raw
1165: is
1166: l_file_version_guid fnd_ums_file_versions.file_version_guid%type;
1167: begin
1168: begin
1169: select /*+ INDEX(fnd_ums_file_versions fnd_ums_file_versions_u2) */ file_version_guid
1170: into l_file_version_guid

Line 1169: select /+ INDEX(fnd_ums_file_versions fnd_ums_file_versions_u2) / file_version_guid

1165: is
1166: l_file_version_guid fnd_ums_file_versions.file_version_guid%type;
1167: begin
1168: begin
1169: select /*+ INDEX(fnd_ums_file_versions fnd_ums_file_versions_u2) */ file_version_guid
1170: into l_file_version_guid
1171: from fnd_ums_file_versions
1172: where file_guid = p_file_guid
1173: and version = p_version;

Line 1171: from fnd_ums_file_versions

1167: begin
1168: begin
1169: select /*+ INDEX(fnd_ums_file_versions fnd_ums_file_versions_u2) */ file_version_guid
1170: into l_file_version_guid
1171: from fnd_ums_file_versions
1172: where file_guid = p_file_guid
1173: and version = p_version;
1174: exception
1175: when no_data_found then

Line 1190: l_file_guid fnd_ums_file_versions.file_guid%type;

1186: p_location in varchar2,
1187: p_name in varchar2,
1188: p_version in varchar2)
1189: is
1190: l_file_guid fnd_ums_file_versions.file_guid%type;
1191: l_file_version_guid fnd_ums_file_versions.file_version_guid%type;
1192: begin
1193: if (g_uc.upload_files) then
1194: -- File upload is allowed.

Line 1191: l_file_version_guid fnd_ums_file_versions.file_version_guid%type;

1187: p_name in varchar2,
1188: p_version in varchar2)
1189: is
1190: l_file_guid fnd_ums_file_versions.file_guid%type;
1191: l_file_version_guid fnd_ums_file_versions.file_version_guid%type;
1192: begin
1193: if (g_uc.upload_files) then
1194: -- File upload is allowed.
1195: