DBA Data[Home] [Help]

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

1015: end up_fnd_ums_bugfix;
1016:
1017: --------------------------------------------------------------------------------
1018: function new_file_guid_at
1019: (p_application_short_name in fnd_ums_files.application_short_name%type,
1020: p_location in fnd_ums_files.location%type,
1021: p_name in fnd_ums_files.name%type)
1022: return raw
1023: is

Line 1020: p_location in fnd_ums_files.location%type,

1016:
1017: --------------------------------------------------------------------------------
1018: function new_file_guid_at
1019: (p_application_short_name in fnd_ums_files.application_short_name%type,
1020: p_location in fnd_ums_files.location%type,
1021: p_name in fnd_ums_files.name%type)
1022: return raw
1023: is
1024: pragma autonomous_transaction;

Line 1021: p_name in fnd_ums_files.name%type)

1017: --------------------------------------------------------------------------------
1018: function new_file_guid_at
1019: (p_application_short_name in fnd_ums_files.application_short_name%type,
1020: p_location in fnd_ums_files.location%type,
1021: p_name in fnd_ums_files.name%type)
1022: return raw
1023: is
1024: pragma autonomous_transaction;
1025: l_file_guid fnd_ums_files.file_guid%type;

Line 1025: l_file_guid fnd_ums_files.file_guid%type;

1021: p_name in fnd_ums_files.name%type)
1022: return raw
1023: is
1024: pragma autonomous_transaction;
1025: l_file_guid fnd_ums_files.file_guid%type;
1026: begin
1027: -- lock the entity first
1028:
1029: lock_entity('FND_UMS_FILES', p_application_short_name, p_location, p_name);

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

1025: l_file_guid fnd_ums_files.file_guid%type;
1026: begin
1027: -- lock the entity first
1028:
1029: lock_entity('FND_UMS_FILES', p_application_short_name, p_location, p_name);
1030:
1031: -- check the existence again
1032:
1033: begin

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

1030:
1031: -- check the existence again
1032:
1033: begin
1034: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1035: into l_file_guid
1036: from fnd_ums_files
1037: where application_short_name = p_application_short_name
1038: and location = p_location

Line 1036: from fnd_ums_files

1032:
1033: begin
1034: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1035: into l_file_guid
1036: from fnd_ums_files
1037: where application_short_name = p_application_short_name
1038: and location = p_location
1039: and name = p_name;
1040: exception

Line 1042: -- populate FND_UMS_FILES

1038: and location = p_location
1039: and name = p_name;
1040: exception
1041: when no_data_found then
1042: -- populate FND_UMS_FILES
1043:
1044: insert into fnd_ums_files
1045: (file_guid,
1046: application_short_name,

Line 1044: insert into fnd_ums_files

1040: exception
1041: when no_data_found then
1042: -- populate FND_UMS_FILES
1043:
1044: insert into fnd_ums_files
1045: (file_guid,
1046: application_short_name,
1047: location,
1048: name)

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

1068: end new_file_guid_at;
1069:
1070: --------------------------------------------------------------------------------
1071: function get_file_guid
1072: (p_application_short_name in fnd_ums_files.application_short_name%type,
1073: p_location in fnd_ums_files.location%type,
1074: p_name in fnd_ums_files.name%type)
1075: return raw
1076: is

Line 1073: p_location in fnd_ums_files.location%type,

1069:
1070: --------------------------------------------------------------------------------
1071: function get_file_guid
1072: (p_application_short_name in fnd_ums_files.application_short_name%type,
1073: p_location in fnd_ums_files.location%type,
1074: p_name in fnd_ums_files.name%type)
1075: return raw
1076: is
1077: l_file_guid fnd_ums_files.file_guid%type;

Line 1074: p_name in fnd_ums_files.name%type)

1070: --------------------------------------------------------------------------------
1071: function get_file_guid
1072: (p_application_short_name in fnd_ums_files.application_short_name%type,
1073: p_location in fnd_ums_files.location%type,
1074: p_name in fnd_ums_files.name%type)
1075: return raw
1076: is
1077: l_file_guid fnd_ums_files.file_guid%type;
1078: begin

Line 1077: l_file_guid fnd_ums_files.file_guid%type;

1073: p_location in fnd_ums_files.location%type,
1074: p_name in fnd_ums_files.name%type)
1075: return raw
1076: is
1077: l_file_guid fnd_ums_files.file_guid%type;
1078: begin
1079: begin
1080: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1081: into l_file_guid

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

1076: is
1077: l_file_guid fnd_ums_files.file_guid%type;
1078: begin
1079: begin
1080: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1081: into l_file_guid
1082: from fnd_ums_files
1083: where application_short_name = p_application_short_name
1084: and location = p_location

Line 1082: from fnd_ums_files

1078: begin
1079: begin
1080: select /*+ INDEX(fnd_ums_files fnd_ums_files_u2) */ file_guid
1081: into l_file_guid
1082: from fnd_ums_files
1083: where application_short_name = p_application_short_name
1084: and location = p_location
1085: and name = p_name;
1086: exception