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.QA_BIS dependencies on QA_BIS_UPDATE_HISTORY

Line 17: -- A last refresh time is kept in the table QA_BIS_UPDATE_HISTORY.

13: -- deleted and truncated. Then the results are transferred.
14: -- Another is by incremental refresh, where only the recently
15: -- inserted or updated records are transferred.
16: --
17: -- A last refresh time is kept in the table QA_BIS_UPDATE_HISTORY.
18: -- It is updated in both complete rebuild and incremental refresh.
19: --
20: -- **OBSOLETE**
21: -- The incremental refresh method does not take care of deletion.

Line 39: -- QA_BIS_UPDATE_HISTORY as delete log. When a record is deleted

35: -- valid row to invalid (status=1) will also delete the row from
36: -- the summary table in the next refresh (complete or incremental).
37: --
38: -- Incremental refresh now takes care of deletion by using
39: -- QA_BIS_UPDATE_HISTORY as delete log. When a record is deleted
40: -- from QA_RESUTLS, qa_bis.delete_log is called to record an audit
41: -- trail.
42: --
43: -- Author: Bryan So (bso)

Line 137: FROM qa_bis_update_history

133: -- by complete rebuild or by procedure delete_purged_rows.
134: --
135: BEGIN
136: DELETE
137: FROM qa_bis_update_history
138: WHERE occurrence >= 0 AND
139: last_update_date < g_current_datetime;
140: commit;
141: END delete_update_history;

Line 153: FROM qa_bis_update_history h

149: DELETE
150: FROM qa_bis_results qbr
151: WHERE qbr.occurrence IN
152: (SELECT h.occurrence
153: FROM qa_bis_update_history h
154: WHERE h.occurrence >= 0 AND
155: h.last_update_date < g_current_datetime);
156: commit;
157: delete_update_history;

Line 351: -- Write a refresh time to the QA_BIS_UPDATE_HISTORY table.

347:
348:
349: PROCEDURE write_last_refresh_datetime(x_last_refresh_time date) IS
350: --
351: -- Write a refresh time to the QA_BIS_UPDATE_HISTORY table.
352: --
353: BEGIN
354: UPDATE qa_bis_update_history SET
355: request_id = who_request_id,

Line 354: UPDATE qa_bis_update_history SET

350: --
351: -- Write a refresh time to the QA_BIS_UPDATE_HISTORY table.
352: --
353: BEGIN
354: UPDATE qa_bis_update_history SET
355: request_id = who_request_id,
356: program_application_id = who_program_application_id,
357: program_id = who_program_id,
358: program_update_date = sysdate,

Line 370: -- Initialize the QA_BIS_UPDATE_HISTORY table.

366:
367:
368: PROCEDURE init_last_refresh_datetime IS
369: --
370: -- Initialize the QA_BIS_UPDATE_HISTORY table.
371: --
372: BEGIN
373: INSERT INTO qa_bis_update_history(
374: request_id,

Line 373: INSERT INTO qa_bis_update_history(

369: --
370: -- Initialize the QA_BIS_UPDATE_HISTORY table.
371: --
372: BEGIN
373: INSERT INTO qa_bis_update_history(
374: request_id,
375: program_application_id,
376: program_id,
377: program_update_date,

Line 404: -- Get last refresh time from the QA_BIS_UPDATE_HISTORY table

400:
401:
402: FUNCTION get_last_refresh_datetime RETURN date IS
403: --
404: -- Get last refresh time from the QA_BIS_UPDATE_HISTORY table
405: --
406: d date;
407: CURSOR c IS
408: SELECT last_refresh_time

Line 409: FROM qa_bis_update_history

405: --
406: d date;
407: CURSOR c IS
408: SELECT last_refresh_time
409: FROM qa_bis_update_history
410: WHERE occurrence = -1;
411: -- special flag that indicates this is the record
412: -- to look for refresh time
413: BEGIN

Line 629: -- Insert a row into QA_BIS_UPDATE_HISTORY to log the deletion.

625: -- Called by QLTRES.Q_RES_PRIVATE.delete_row.
626: --
627: BEGIN
628: --
629: -- Insert a row into QA_BIS_UPDATE_HISTORY to log the deletion.
630: --
631:
632: INSERT INTO qa_bis_update_history(
633: created_by,

Line 632: INSERT INTO qa_bis_update_history(

628: --
629: -- Insert a row into QA_BIS_UPDATE_HISTORY to log the deletion.
630: --
631:
632: INSERT INTO qa_bis_update_history(
633: created_by,
634: creation_date,
635: last_update_login,
636: last_updated_by,

Line 689: -- current_date to the QA_BIS_UPDATE_HISTORY table as last

685: -- qr.qa_creation_date <= last_refresh <= qr.qa_last_update_date
686: -- and qr.qa_last_update_date < current_date
687: --
688: -- The last condition is needed because we will be writing
689: -- current_date to the QA_BIS_UPDATE_HISTORY table as last
690: -- refresh time. All rows updated at or after current_date
691: -- will be excluded in this rebuild. They will be mirrored
692: -- in the next rebulid.
693: --