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_SEQUENCE_API dependencies on QA_SEQ_AUDIT_HISTORY

Line 74: -- in the qa_seq_audit_history table. This is important

70: --
71: -- bug 5228667
72: -- Added the parameters plan id and occurrence as
73: -- they would help in uniquely identifying a record
74: -- in the qa_seq_audit_history table. This is important
75: -- in case of a SR Txn wherein an EQR can be done while
76: -- updating an SR wherein the same Collection id is reused
77: -- This will ensure that the resubmission is not confused
78: -- with any audit recs already existing for a collection id

Line 439: -- source code = 'EDR' and audit_type = 'CREATED' in qa_seq_audit_history table.

435:
436: -- 1. Sequence will always be generated before the parent txn commited
437: -- in post-forms-commit for the FORM
438: -- 2. While generating sequence, audit information captured with
439: -- source code = 'EDR' and audit_type = 'CREATED' in qa_seq_audit_history table.
440: -- 3. When user Rejects the entry , update qa_seq_audit_history table
441: -- for audit_type = 'REJECTED' , source_id with eRes ID.
442: -- 4. When user Accepts the txn, delete audit information from
443: -- qa_seq_audit_history table

Line 440: -- 3. When user Rejects the entry , update qa_seq_audit_history table

436: -- 1. Sequence will always be generated before the parent txn commited
437: -- in post-forms-commit for the FORM
438: -- 2. While generating sequence, audit information captured with
439: -- source code = 'EDR' and audit_type = 'CREATED' in qa_seq_audit_history table.
440: -- 3. When user Rejects the entry , update qa_seq_audit_history table
441: -- for audit_type = 'REJECTED' , source_id with eRes ID.
442: -- 4. When user Accepts the txn, delete audit information from
443: -- qa_seq_audit_history table
444: -- 5. In case erecords are resubmitted, checking is done qa_seq_audit_history

Line 443: -- qa_seq_audit_history table

439: -- source code = 'EDR' and audit_type = 'CREATED' in qa_seq_audit_history table.
440: -- 3. When user Rejects the entry , update qa_seq_audit_history table
441: -- for audit_type = 'REJECTED' , source_id with eRes ID.
442: -- 4. When user Accepts the txn, delete audit information from
443: -- qa_seq_audit_history table
444: -- 5. In case erecords are resubmitted, checking is done qa_seq_audit_history
445: -- for the collection_id,occurrence. If record found, dont call sequence api.
446: -- 6. QA_RESULT_GRP.enable is called when parent txn commited(after eRes).
447: -- Api checks for eRes txn. If eRes then seq. api will not be called since

Line 444: -- 5. In case erecords are resubmitted, checking is done qa_seq_audit_history

440: -- 3. When user Rejects the entry , update qa_seq_audit_history table
441: -- for audit_type = 'REJECTED' , source_id with eRes ID.
442: -- 4. When user Accepts the txn, delete audit information from
443: -- qa_seq_audit_history table
444: -- 5. In case erecords are resubmitted, checking is done qa_seq_audit_history
445: -- for the collection_id,occurrence. If record found, dont call sequence api.
446: -- 6. QA_RESULT_GRP.enable is called when parent txn commited(after eRes).
447: -- Api checks for eRes txn. If eRes then seq. api will not be called since
448: -- seq. values generated already.

Line 1120: -- qa_seq_audit_history, qa_chars table. We should not commit

1116: p_parent_occurrence,
1117: p_oa_txnint);
1118:
1119: -- following commit statement will coming only the data in
1120: -- qa_seq_audit_history, qa_chars table. We should not commit
1121: -- records in qa_results;
1122:
1123: COMMIT;
1124:

Line 1145: FROM qa_seq_audit_history

1141: p_char_id NUMBER) RETURN VARCHAR2 AS
1142:
1143: CURSOR cur_seq_val IS
1144: SELECT sequence_value
1145: FROM qa_seq_audit_history
1146: WHERE plan_id = p_plan_id
1147: AND collection_id = p_collection_id
1148: AND occurrence = p_occurrence
1149: AND char_id = p_char_id;

Line 2414: SELECT 1 FROM qa_seq_audit_history

2410:
2411: l_count NUMBER;
2412:
2413: CURSOR dde_cursor IS
2414: SELECT 1 FROM qa_seq_audit_history
2415: WHERE txn_header_id = p_txn_header_id
2416: and (p_plan_id IS NULL OR plan_id = p_plan_id)
2417: and (p_occurrence IS NULL OR occurrence = p_occurrence);
2418:

Line 2420: SELECT 1 FROM qa_seq_audit_history

2416: and (p_plan_id IS NULL OR plan_id = p_plan_id)
2417: and (p_occurrence IS NULL OR occurrence = p_occurrence);
2418:
2419: CURSOR txn_cursor IS
2420: SELECT 1 FROM qa_seq_audit_history
2421: WHERE collection_id = p_collection_id
2422: and (p_plan_id IS NULL OR plan_id = p_plan_id)
2423: and (p_occurrence IS NULL OR occurrence = p_occurrence);
2424: BEGIN

Line 2776: DELETE FROM qa_seq_audit_history

2772: -- that got captured at generation. If eRecords rejected by user then
2773: -- leave the audit info. as it was.
2774: BEGIN
2775:
2776: DELETE FROM qa_seq_audit_history
2777: WHERE collection_id = p_collection_id;
2778: EXCEPTION
2779: WHEN OTHERS THEN raise;
2780:

Line 2790: DELETE FROM qa_seq_audit_history

2786: -- similar to delete_audit_for_Txn(see this proc. for details).
2787:
2788: BEGIN
2789:
2790: DELETE FROM qa_seq_audit_history
2791: WHERE txn_header_id = p_txn_header_id;
2792: EXCEPTION
2793: WHEN OTHERS THEN raise;
2794: