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_OAM_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 618: lock_entity('FND_UMS_BUGFIXES', 'TOP_LEVEL', p_release_name, p_bug_number);

614: end if;
615: if (p_upload_phase = 'BEGIN') then
616: -- Lock the entity first
617:
618: lock_entity('FND_UMS_BUGFIXES', 'TOP_LEVEL', p_release_name, p_bug_number);
619:
620: -- Gather LDT file details
621:
622: l_file_dc := get_data_contents(p_download_mode,

Line 629: l_bugfix fnd_ums_bugfixes%ROWTYPE;

625:
626: -- Gather database details
627:
628: declare
629: l_bugfix fnd_ums_bugfixes%ROWTYPE;
630: begin
631: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ *
632: into l_bugfix
633: from fnd_ums_bugfixes

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

627:
628: declare
629: l_bugfix fnd_ums_bugfixes%ROWTYPE;
630: begin
631: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ *
632: into l_bugfix
633: from fnd_ums_bugfixes
634: where release_name = p_release_name
635: and bug_number = p_bug_number

Line 633: from fnd_ums_bugfixes

629: l_bugfix fnd_ums_bugfixes%ROWTYPE;
630: begin
631: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ *
632: into l_bugfix
633: from fnd_ums_bugfixes
634: where release_name = p_release_name
635: and bug_number = p_bug_number
636: and baseline = l_baseline;
637:

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

948: g_rc.bugfix_relationships := g_rc.bugfix_relationships + sql%rowcount;
949:
950: -- delete bugfix
951:
952: delete /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u1) */
953: from fnd_ums_bugfixes
954: where bugfix_guid = g_bugfix_guid;
955:
956: g_rc.bugfixes := g_rc.bugfixes + sql%rowcount;

Line 953: from fnd_ums_bugfixes

949:
950: -- delete bugfix
951:
952: delete /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u1) */
953: from fnd_ums_bugfixes
954: where bugfix_guid = g_bugfix_guid;
955:
956: g_rc.bugfixes := g_rc.bugfixes + sql%rowcount;
957:

Line 978: insert into fnd_ums_bugfixes

974: l_type := p_type;
975: l_abstract := p_abstract;
976: end if;
977:
978: insert into fnd_ums_bugfixes
979: (bugfix_guid,
980: release_name,
981: bug_number,
982: baseline,

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

1009: -- For Example: If database is RO, and ldt is LF, and dates are same
1010: -- then PIL and Files will be uploaded but bugfix and replacement
1011: -- data will not.
1012:
1013: update /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u1) */ fnd_ums_bugfixes
1014: set download_mode = l_final_dc.download_mode,
1015: last_definition_date = l_final_dc.last_definition_date
1016: where bugfix_guid = g_bugfix_guid;
1017:

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

1221: end up_fnd_ums_bugfix_file;
1222:
1223: --------------------------------------------------------------------------------
1224: function new_bugfix_guid_at
1225: (p_release_name in fnd_ums_bugfixes.release_name%type,
1226: p_bug_number in fnd_ums_bugfixes.bug_number%type)
1227: return raw
1228: is
1229: pragma autonomous_transaction;

Line 1226: p_bug_number in fnd_ums_bugfixes.bug_number%type)

1222:
1223: --------------------------------------------------------------------------------
1224: function new_bugfix_guid_at
1225: (p_release_name in fnd_ums_bugfixes.release_name%type,
1226: p_bug_number in fnd_ums_bugfixes.bug_number%type)
1227: return raw
1228: is
1229: pragma autonomous_transaction;
1230: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

Line 1230: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

1226: p_bug_number in fnd_ums_bugfixes.bug_number%type)
1227: return raw
1228: is
1229: pragma autonomous_transaction;
1230: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1231: begin
1232: -- lock the entity first
1233:
1234: lock_entity('FND_UMS_BUGFIXES', p_release_name, p_bug_number);

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

1230: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1231: begin
1232: -- lock the entity first
1233:
1234: lock_entity('FND_UMS_BUGFIXES', p_release_name, p_bug_number);
1235:
1236: -- check the existence again
1237:
1238: begin

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

1235:
1236: -- check the existence again
1237:
1238: begin
1239: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ bugfix_guid
1240: into l_bugfix_guid
1241: from fnd_ums_bugfixes
1242: where release_name = p_release_name
1243: and bug_number = p_bug_number;

Line 1241: from fnd_ums_bugfixes

1237:
1238: begin
1239: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ bugfix_guid
1240: into l_bugfix_guid
1241: from fnd_ums_bugfixes
1242: where release_name = p_release_name
1243: and bug_number = p_bug_number;
1244: exception
1245: when no_data_found then

Line 1259: -- populate FND_UMS_BUGFIXES

1255: -- be created to get the bugfix_guid. This bugfix is marked
1256: -- as DL_MODE_NONE so that its definition will be replaced
1257: -- with the real definition.
1258:
1259: -- populate FND_UMS_BUGFIXES
1260:
1261: insert into fnd_ums_bugfixes
1262: (bugfix_guid,
1263: release_name,

Line 1261: insert into fnd_ums_bugfixes

1257: -- with the real definition.
1258:
1259: -- populate FND_UMS_BUGFIXES
1260:
1261: insert into fnd_ums_bugfixes
1262: (bugfix_guid,
1263: release_name,
1264: bug_number,
1265: download_mode,

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

1297: end new_bugfix_guid_at;
1298:
1299: --------------------------------------------------------------------------------
1300: function get_bugfix_guid
1301: (p_release_name in fnd_ums_bugfixes.release_name%type,
1302: p_bug_number in fnd_ums_bugfixes.bug_number%type)
1303: return raw
1304: is
1305: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

Line 1302: p_bug_number in fnd_ums_bugfixes.bug_number%type)

1298:
1299: --------------------------------------------------------------------------------
1300: function get_bugfix_guid
1301: (p_release_name in fnd_ums_bugfixes.release_name%type,
1302: p_bug_number in fnd_ums_bugfixes.bug_number%type)
1303: return raw
1304: is
1305: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1306: begin

Line 1305: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;

1301: (p_release_name in fnd_ums_bugfixes.release_name%type,
1302: p_bug_number in fnd_ums_bugfixes.bug_number%type)
1303: return raw
1304: is
1305: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1306: begin
1307: begin
1308: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ bugfix_guid
1309: into l_bugfix_guid

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

1304: is
1305: l_bugfix_guid fnd_ums_bugfixes.bugfix_guid%type;
1306: begin
1307: begin
1308: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ bugfix_guid
1309: into l_bugfix_guid
1310: from fnd_ums_bugfixes
1311: where release_name = p_release_name
1312: and bug_number = p_bug_number;

Line 1310: from fnd_ums_bugfixes

1306: begin
1307: begin
1308: select /*+ INDEX(fnd_ums_bugfixes fnd_ums_bugfixes_u2) */ bugfix_guid
1309: into l_bugfix_guid
1310: from fnd_ums_bugfixes
1311: where release_name = p_release_name
1312: and bug_number = p_bug_number;
1313: exception
1314: when no_data_found then

Line 1385: procedure up_fnd_ums_bugfixes

1381: end if;
1382: end up_fnd_ums_one_bugfix;
1383:
1384: --------------------------------------------------------------------------------
1385: procedure up_fnd_ums_bugfixes
1386: (p_upload_phase in varchar2,
1387: p_entity_download_mode in varchar2,
1388: p_release_name in varchar2,
1389: p_bug_number in varchar2,

Line 1404: end up_fnd_ums_bugfixes;

1400: else
1401: raise_application_error(ERROR_UNKNOWN_UPLOAD_PHASE,
1402: 'Unknown UPLOAD_PHASE: ' || p_upload_phase);
1403: end if;
1404: end up_fnd_ums_bugfixes;
1405:
1406: --------------------------------------------------------------------------------
1407: function newline
1408: return varchar2