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.

APPS.FND_UMS_LOADER dependencies on FND_UMS_BUGFIXES

Line 25: g_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

21: --
22: g_lock_lifetime integer := 1*24*60*60; -- one day
23: g_lock_waittime integer := 5*60; -- five minutes
24:
25: g_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
26:
27: -- Prereqs/Includes/Links data level
28:
29: PIL_LEVEL_NONE constant integer := 0;

Line 312: add_table_details(l_ums_tables, l_ums_table_count, 'FND_UMS_BUGFIXES', g_rc.bugfixes);

308: g_debug_flag := DEBUG_STATS;
309:
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);

Line 607: lock_entity('FND_UMS_BUGFIXES', 'TOP_LEVEL', p_release_name, p_bug_number);

603: begin
604: if (p_upload_phase = 'BEGIN') then
605: -- Lock the entity first
606:
607: lock_entity('FND_UMS_BUGFIXES', 'TOP_LEVEL', p_release_name, p_bug_number);
608:
609: -- Gather LDT file details
610:
611: l_file_dc := get_data_contents(p_download_mode,

Line 618: l_bugfix fnd_ums_bugfixes%ROWTYPE;

614:
615: -- Gather database details
616:
617: declare
618: l_bugfix fnd_ums_bugfixes%ROWTYPE;
619: begin
620: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ *
621: into l_bugfix
622: from fnd_ums_bugfixes

Line 620: select /+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) / *

616:
617: declare
618: l_bugfix fnd_ums_bugfixes%ROWTYPE;
619: begin
620: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ *
621: into l_bugfix
622: from fnd_ums_bugfixes
623: where release_name = p_release_name
624: and bug_number = p_bug_number;

Line 622: from fnd_ums_bugfixes

618: l_bugfix fnd_ums_bugfixes%ROWTYPE;
619: begin
620: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ *
621: into l_bugfix
622: from fnd_ums_bugfixes
623: where release_name = p_release_name
624: and bug_number = p_bug_number;
625:
626: g_bugfix_guid := l_bugfix.bugfix_guid;

Line 939: delete /+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u1) /

935: g_rc.bugfix_relationships := g_rc.bugfix_relationships + sql%rowcount;
936:
937: -- delete bugfix
938:
939: delete /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u1) */
940: from fnd_ums_bugfixes
941: where bugfix_guid = g_bugfix_guid;
942:
943: g_rc.bugfixes := g_rc.bugfixes + sql%rowcount;

Line 940: from fnd_ums_bugfixes

936:
937: -- delete bugfix
938:
939: delete /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u1) */
940: from fnd_ums_bugfixes
941: where bugfix_guid = g_bugfix_guid;
942:
943: g_rc.bugfixes := g_rc.bugfixes + sql%rowcount;
944:

Line 965: insert into fnd_ums_bugfixes

961: l_type := p_type;
962: l_abstract := p_abstract;
963: end if;
964:
965: insert into fnd_ums_bugfixes
966: (bugfix_guid,
967: release_name,
968: bug_number,
969: download_mode,

Line 998: update /+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u1) / fnd_ums_bugfixes

994: -- For Example: If database is RO, and ldt is LF, and dates are same
995: -- then PIL and Files will be uploaded but bugfix and replacement
996: -- data will not.
997:
998: update /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u1) */ fnd_ums_bugfixes
999: set download_mode = l_final_dc.download_mode,
1000: last_definition_date = l_final_dc.last_definition_date
1001: where bugfix_guid = g_bugfix_guid;
1002:

Line 1210: (p_release_name in fnd_ums_bugfixes.release_name%type,

1206: end up_fnd_ums_bugfix_file;
1207:
1208: --------------------------------------------------------------------------------
1209: function new_bugfix_guid_at
1210: (p_release_name in fnd_ums_bugfixes.release_name%type,
1211: p_bug_number in fnd_ums_bugfixes.bug_number%type)
1212: return raw
1213: is
1214: pragma autonomous_transaction;

Line 1211: p_bug_number in fnd_ums_bugfixes.bug_number%type)

1207:
1208: --------------------------------------------------------------------------------
1209: function new_bugfix_guid_at
1210: (p_release_name in fnd_ums_bugfixes.release_name%type,
1211: p_bug_number in fnd_ums_bugfixes.bug_number%type)
1212: return raw
1213: is
1214: pragma autonomous_transaction;
1215: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

Line 1215: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

1211: p_bug_number in fnd_ums_bugfixes.bug_number%type)
1212: return raw
1213: is
1214: pragma autonomous_transaction;
1215: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1216: begin
1217: -- lock the entity first
1218:
1219: lock_entity('FND_UMS_BUGFIXES', p_release_name, p_bug_number);

Line 1219: lock_entity('FND_UMS_BUGFIXES', p_release_name, p_bug_number);

1215: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1216: begin
1217: -- lock the entity first
1218:
1219: lock_entity('FND_UMS_BUGFIXES', p_release_name, p_bug_number);
1220:
1221: -- check the existence again
1222:
1223: begin

Line 1224: select /+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) / bugfix_guid

1220:
1221: -- check the existence again
1222:
1223: begin
1224: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ bugfix_guid
1225: into l_bugfix_guid
1226: from fnd_ums_bugfixes
1227: where release_name = p_release_name
1228: and bug_number = p_bug_number;

Line 1226: from fnd_ums_bugfixes

1222:
1223: begin
1224: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ bugfix_guid
1225: into l_bugfix_guid
1226: from fnd_ums_bugfixes
1227: where release_name = p_release_name
1228: and bug_number = p_bug_number;
1229: exception
1230: when no_data_found then

Line 1244: -- populate FND_UMS_BUGFIXES

1240: -- be created to get the bugfix_guid. This bugfix is marked
1241: -- as DL_MODE_NONE so that its definition will be replaced
1242: -- with the real definition.
1243:
1244: -- populate FND_UMS_BUGFIXES
1245:
1246: insert into fnd_ums_bugfixes
1247: (bugfix_guid,
1248: release_name,

Line 1246: insert into fnd_ums_bugfixes

1242: -- with the real definition.
1243:
1244: -- populate FND_UMS_BUGFIXES
1245:
1246: insert into fnd_ums_bugfixes
1247: (bugfix_guid,
1248: release_name,
1249: bug_number,
1250: download_mode,

Line 1286: (p_release_name in fnd_ums_bugfixes.release_name%type,

1282: end new_bugfix_guid_at;
1283:
1284: --------------------------------------------------------------------------------
1285: function get_bugfix_guid
1286: (p_release_name in fnd_ums_bugfixes.release_name%type,
1287: p_bug_number in fnd_ums_bugfixes.bug_number%type)
1288: return raw
1289: is
1290: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

Line 1287: p_bug_number in fnd_ums_bugfixes.bug_number%type)

1283:
1284: --------------------------------------------------------------------------------
1285: function get_bugfix_guid
1286: (p_release_name in fnd_ums_bugfixes.release_name%type,
1287: p_bug_number in fnd_ums_bugfixes.bug_number%type)
1288: return raw
1289: is
1290: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1291: begin

Line 1290: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

1286: (p_release_name in fnd_ums_bugfixes.release_name%type,
1287: p_bug_number in fnd_ums_bugfixes.bug_number%type)
1288: return raw
1289: is
1290: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1291: begin
1292: begin
1293: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ bugfix_guid
1294: into l_bugfix_guid

Line 1293: select /+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) / bugfix_guid

1289: is
1290: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1291: begin
1292: begin
1293: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ bugfix_guid
1294: into l_bugfix_guid
1295: from fnd_ums_bugfixes
1296: where release_name = p_release_name
1297: and bug_number = p_bug_number;

Line 1295: from fnd_ums_bugfixes

1291: begin
1292: begin
1293: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ bugfix_guid
1294: into l_bugfix_guid
1295: from fnd_ums_bugfixes
1296: where release_name = p_release_name
1297: and bug_number = p_bug_number;
1298: exception
1299: when no_data_found then

Line 1369: procedure up_fnd_ums_bugfixes

1365: end if;
1366: end up_fnd_ums_one_bugfix;
1367:
1368: --------------------------------------------------------------------------------
1369: procedure up_fnd_ums_bugfixes
1370: (p_upload_phase in varchar2,
1371: p_entity_download_mode in varchar2,
1372: p_release_name in varchar2,
1373: p_bug_number in varchar2,

Line 1388: end up_fnd_ums_bugfixes;

1384: else
1385: raise_application_error(ERROR_UNKNOWN_UPLOAD_PHASE,
1386: 'Unknown UPLOAD_PHASE: ' || p_upload_phase);
1387: end if;
1388: end up_fnd_ums_bugfixes;
1389:
1390: --------------------------------------------------------------------------------
1391: function newline
1392: return varchar2