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 1034: (p_application_short_name in fnd_ums_files.application_short_name%type,

1030: end up_fnd_ums_bugfix;
1031:
1032: --------------------------------------------------------------------------------
1033: function new_file_guid_at
1034: (p_application_short_name in fnd_ums_files.application_short_name%type,
1035: p_location in fnd_ums_files.location%type,
1036: p_name in fnd_ums_files.name%type)
1037: return raw
1038: is

Line 1035: p_location in fnd_ums_files.location%type,

1031:
1032: --------------------------------------------------------------------------------
1033: function new_file_guid_at
1034: (p_application_short_name in fnd_ums_files.application_short_name%type,
1035: p_location in fnd_ums_files.location%type,
1036: p_name in fnd_ums_files.name%type)
1037: return raw
1038: is
1039: pragma autonomous_transaction;

Line 1036: p_name in fnd_ums_files.name%type)

1032: --------------------------------------------------------------------------------
1033: function new_file_guid_at
1034: (p_application_short_name in fnd_ums_files.application_short_name%type,
1035: p_location in fnd_ums_files.location%type,
1036: p_name in fnd_ums_files.name%type)
1037: return raw
1038: is
1039: pragma autonomous_transaction;
1040: l_file_guid fnd_ums_files.file_guid%type;

Line 1040: l_file_guid fnd_ums_files.file_guid%type;

1036: p_name in fnd_ums_files.name%type)
1037: return raw
1038: is
1039: pragma autonomous_transaction;
1040: l_file_guid fnd_ums_files.file_guid%type;
1041: begin
1042: -- lock the entity first
1043:
1044: lock_entity('FND_UMS_FILES', p_application_short_name, p_location, p_name);

Line 1044: lock_entity('FND_UMS_FILES', p_application_short_name, p_location, p_name);

1040: l_file_guid fnd_ums_files.file_guid%type;
1041: begin
1042: -- lock the entity first
1043:
1044: lock_entity('FND_UMS_FILES', p_application_short_name, p_location, p_name);
1045:
1046: -- check the existence again
1047:
1048: begin

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

1045:
1046: -- check the existence again
1047:
1048: begin
1049: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1050: into l_file_guid
1051: from fnd_ums_files
1052: where application_short_name = p_application_short_name
1053: and location = p_location

Line 1051: from fnd_ums_files

1047:
1048: begin
1049: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1050: into l_file_guid
1051: from fnd_ums_files
1052: where application_short_name = p_application_short_name
1053: and location = p_location
1054: and name = p_name;
1055: exception

Line 1057: -- populate FND_UMS_FILES

1053: and location = p_location
1054: and name = p_name;
1055: exception
1056: when no_data_found then
1057: -- populate FND_UMS_FILES
1058:
1059: insert into fnd_ums_files
1060: (file_guid,
1061: application_short_name,

Line 1059: insert into fnd_ums_files

1055: exception
1056: when no_data_found then
1057: -- populate FND_UMS_FILES
1058:
1059: insert into fnd_ums_files
1060: (file_guid,
1061: application_short_name,
1062: location,
1063: name)

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

1083: end new_file_guid_at;
1084:
1085: --------------------------------------------------------------------------------
1086: function get_file_guid
1087: (p_application_short_name in fnd_ums_files.application_short_name%type,
1088: p_location in fnd_ums_files.location%type,
1089: p_name in fnd_ums_files.name%type)
1090: return raw
1091: is

Line 1088: p_location in fnd_ums_files.location%type,

1084:
1085: --------------------------------------------------------------------------------
1086: function get_file_guid
1087: (p_application_short_name in fnd_ums_files.application_short_name%type,
1088: p_location in fnd_ums_files.location%type,
1089: p_name in fnd_ums_files.name%type)
1090: return raw
1091: is
1092: l_file_guid fnd_ums_files.file_guid%type;

Line 1089: p_name in fnd_ums_files.name%type)

1085: --------------------------------------------------------------------------------
1086: function get_file_guid
1087: (p_application_short_name in fnd_ums_files.application_short_name%type,
1088: p_location in fnd_ums_files.location%type,
1089: p_name in fnd_ums_files.name%type)
1090: return raw
1091: is
1092: l_file_guid fnd_ums_files.file_guid%type;
1093: begin

Line 1092: l_file_guid fnd_ums_files.file_guid%type;

1088: p_location in fnd_ums_files.location%type,
1089: p_name in fnd_ums_files.name%type)
1090: return raw
1091: is
1092: l_file_guid fnd_ums_files.file_guid%type;
1093: begin
1094: begin
1095: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1096: into l_file_guid

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

1091: is
1092: l_file_guid fnd_ums_files.file_guid%type;
1093: begin
1094: begin
1095: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1096: into l_file_guid
1097: from fnd_ums_files
1098: where application_short_name = p_application_short_name
1099: and location = p_location

Line 1097: from fnd_ums_files

1093: begin
1094: begin
1095: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1096: into l_file_guid
1097: from fnd_ums_files
1098: where application_short_name = p_application_short_name
1099: and location = p_location
1100: and name = p_name;
1101: exception