DBA Data[Home] [Help]

APPS.FND_OAM_UMS_LOADER dependencies on FND_UMS_FILES

Line 314: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_FILES', g_rc.files);

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

Line 1028: (p_application_short_name in fnd_ums_files.application_short_name%type,

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

Line 1029: p_location in fnd_ums_files.location%type,

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;

Line 1030: p_name in fnd_ums_files.name%type)

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;

Line 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);

Line 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

Line 1043: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid

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

Line 1045: from fnd_ums_files

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

Line 1051: -- populate FND_UMS_FILES

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,

Line 1053: insert into fnd_ums_files

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)

Line 1081: (p_application_short_name in fnd_ums_files.application_short_name%type,

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

Line 1082: p_location in fnd_ums_files.location%type,

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;

Line 1083: p_name in fnd_ums_files.name%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

Line 1086: l_file_guid fnd_ums_files.file_guid%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
1088: begin
1089: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1090: into l_file_guid

Line 1089: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ 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

Line 1091: from fnd_ums_files

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