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 409: -- source code = 'EDR' and audit_type = 'CREATED' in qa_seq_audit_history table.

405:
406: -- 1. Sequence will always be generated before the parent txn commited
407: -- in post-forms-commit for the FORM
408: -- 2. While generating sequence, audit information captured with
409: -- source code = 'EDR' and audit_type = 'CREATED' in qa_seq_audit_history table.
410: -- 3. When user Rejects the entry , update qa_seq_audit_history table
411: -- for audit_type = 'REJECTED' , source_id with eRes ID.
412: -- 4. When user Accepts the txn, delete audit information from
413: -- qa_seq_audit_history table

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

406: -- 1. Sequence will always be generated before the parent txn commited
407: -- in post-forms-commit for the FORM
408: -- 2. While generating sequence, audit information captured with
409: -- source code = 'EDR' and audit_type = 'CREATED' in qa_seq_audit_history table.
410: -- 3. When user Rejects the entry , update qa_seq_audit_history table
411: -- for audit_type = 'REJECTED' , source_id with eRes ID.
412: -- 4. When user Accepts the txn, delete audit information from
413: -- qa_seq_audit_history table
414: -- 5. In case erecords are resubmitted, checking is done qa_seq_audit_history

Line 413: -- qa_seq_audit_history table

409: -- source code = 'EDR' and audit_type = 'CREATED' in qa_seq_audit_history table.
410: -- 3. When user Rejects the entry , update qa_seq_audit_history table
411: -- for audit_type = 'REJECTED' , source_id with eRes ID.
412: -- 4. When user Accepts the txn, delete audit information from
413: -- qa_seq_audit_history table
414: -- 5. In case erecords are resubmitted, checking is done qa_seq_audit_history
415: -- for the collection_id,occurrence. If record found, dont call sequence api.
416: -- 6. QA_RESULT_GRP.enable is called when parent txn commited(after eRes).
417: -- Api checks for eRes txn. If eRes then seq. api will not be called since

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

410: -- 3. When user Rejects the entry , update qa_seq_audit_history table
411: -- for audit_type = 'REJECTED' , source_id with eRes ID.
412: -- 4. When user Accepts the txn, delete audit information from
413: -- qa_seq_audit_history table
414: -- 5. In case erecords are resubmitted, checking is done qa_seq_audit_history
415: -- for the collection_id,occurrence. If record found, dont call sequence api.
416: -- 6. QA_RESULT_GRP.enable is called when parent txn commited(after eRes).
417: -- Api checks for eRes txn. If eRes then seq. api will not be called since
418: -- seq. values generated already.

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

1062: p_parent_occurrence,
1063: p_oa_txnint);
1064:
1065: -- following commit statement will coming only the data in
1066: -- qa_seq_audit_history, qa_chars table. We should not commit
1067: -- records in qa_results;
1068:
1069: COMMIT;
1070:

Line 1091: FROM qa_seq_audit_history

1087: p_char_id NUMBER) RETURN VARCHAR2 AS
1088:
1089: CURSOR cur_seq_val IS
1090: SELECT sequence_value
1091: FROM qa_seq_audit_history
1092: WHERE plan_id = p_plan_id
1093: AND collection_id = p_collection_id
1094: AND occurrence = p_occurrence
1095: AND char_id = p_char_id;

Line 2360: SELECT 1 FROM qa_seq_audit_history

2356:
2357: l_count NUMBER;
2358:
2359: CURSOR dde_cursor IS
2360: SELECT 1 FROM qa_seq_audit_history
2361: WHERE txn_header_id = p_txn_header_id
2362: and (p_plan_id IS NULL OR plan_id = p_plan_id)
2363: and (p_occurrence IS NULL OR occurrence = p_occurrence);
2364:

Line 2366: SELECT 1 FROM qa_seq_audit_history

2362: and (p_plan_id IS NULL OR plan_id = p_plan_id)
2363: and (p_occurrence IS NULL OR occurrence = p_occurrence);
2364:
2365: CURSOR txn_cursor IS
2366: SELECT 1 FROM qa_seq_audit_history
2367: WHERE collection_id = p_collection_id
2368: and (p_plan_id IS NULL OR plan_id = p_plan_id)
2369: and (p_occurrence IS NULL OR occurrence = p_occurrence);
2370: BEGIN

Line 2722: DELETE FROM qa_seq_audit_history

2718: -- that got captured at generation. If eRecords rejected by user then
2719: -- leave the audit info. as it was.
2720: BEGIN
2721:
2722: DELETE FROM qa_seq_audit_history
2723: WHERE collection_id = p_collection_id;
2724: EXCEPTION
2725: WHEN OTHERS THEN raise;
2726:

Line 2736: DELETE FROM qa_seq_audit_history

2732: -- similar to delete_audit_for_Txn(see this proc. for details).
2733:
2734: BEGIN
2735:
2736: DELETE FROM qa_seq_audit_history
2737: WHERE txn_header_id = p_txn_header_id;
2738: EXCEPTION
2739: WHEN OTHERS THEN raise;
2740: