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_RESULTS

Line 403: -- qa_pc_results_realtionship table is synced up with the qa_results

399: END get_nextval_nocommit;
400:
401: -- bug 14134055
402: -- New procedure to ensure that the child_txn_header_id in the
403: -- qa_pc_results_realtionship table is synced up with the qa_results
404: -- table so that there is no error in sequence generation.
405: --
406: PROCEDURE sync_child_txn_hdr_id(p_txn_header_id IN NUMBER) IS
407: CURSOR results_cur IS

Line 412: FROM qa_results

408: SELECT plan_id,
409: collection_id,
410: occurrence,
411: txn_header_id
412: FROM qa_results
413: WHERE txn_header_id = p_txn_header_id;
414:
415: TYPE results_tab_typ IS TABLE OF results_cur%rowtype INDEX BY binary_integer;
416: results_tab results_tab_typ ;

Line 456: FROM qa_results qr

452: -- results been entered.
453:
454: CURSOR all_plan_cur IS
455: SELECT distinct qr.plan_id
456: FROM qa_results qr
457: WHERE qr.collection_id = p_collection_id AND
458: NOT EXISTS (SELECT 1 FROM qa_pc_results_relationship qprr
459: WHERE qprr.child_plan_id = qr.plan_id AND
460: qprr.child_collection_id = qr.collection_id AND

Line 506: -- and this should be used while updating qa_results

502: -- in case when an ERES is resubmitted the sequence
503: -- is not to be regenerated, yet the sequence array
504: -- needs to be populated with the values from the
505: -- Audit Hist table where the generated seq would reside
506: -- and this should be used while updating qa_results
507: -- Without this, in case of a resubmission, the sequence
508: -- value won't be copied to QA_RESULTS. This processing
509: -- has been moved to the proc generate_seq_for_pc
510: -- ntungare Thu Aug 17 03:40:02 PDT 2006

Line 508: -- value won't be copied to QA_RESULTS. This processing

504: -- needs to be populated with the values from the
505: -- Audit Hist table where the generated seq would reside
506: -- and this should be used while updating qa_results
507: -- Without this, in case of a resubmission, the sequence
508: -- value won't be copied to QA_RESULTS. This processing
509: -- has been moved to the proc generate_seq_for_pc
510: -- ntungare Thu Aug 17 03:40:02 PDT 2006
511: --
512: /*

Line 545: -- Now use bulk update to update all seq. values into qa_results for all the

541: null);
542:
543: END LOOP;
544:
545: -- Now use bulk update to update all seq. values into qa_results for all the
546: -- records in the data collection
547:
548: update_record(l_row_count);
549:

Line 634: -- Now use bulk update to update all seq. values into qa_results for all the

630: generate_seq_for_pc(p_plan_id,
631: null,
632: p_txn_header_id);
633:
634: -- Now use bulk update to update all seq. values into qa_results for all the
635: -- records in the data collection
636:
637: update_record(l_row_count);
638:

Line 660: FROM qa_results

656: sequence4,sequence5,sequence6,
657: sequence7,sequence8,sequence9,
658: sequence10,sequence11,sequence12,
659: sequence13,sequence14,sequence15
660: FROM qa_results
661: WHERE collection_id = p_collection_id;
662:
663: CURSOR txn_cur IS
664: SELECT occurrence,collection_id,plan_id,txn_header_id,

Line 670: FROM qa_results

666: sequence4,sequence5,sequence6,
667: sequence7,sequence8,sequence9,
668: sequence10,sequence11,sequence12,
669: sequence13,sequence14,sequence15
670: FROM qa_results
671: WHERE txn_header_id = p_txn_header_id;
672:
673: l_row_count NUMBER := 0;
674:

Line 743: FROM qa_results qr

739: plan_id parent_plan_id,
740: collection_id parent_collection_id,
741: occurrence parent_occurrence,
742: 0 levels
743: FROM qa_results qr
744: WHERE qr.plan_id = p_plan_id AND
745: qr.collection_id = p_collection_id
746: UNION ALL
747: SELECT child_plan_id,

Line 780: FROM qa_results qr

776: plan_id parent_plan_id,
777: collection_id parent_collection_id,
778: occurrence parent_occurrence,
779: 0 levels
780: FROM qa_results qr
781: WHERE qr.plan_id = p_plan_id AND
782: qr.txn_header_id = p_txn_header_id
783: UNION ALL
784: SELECT child_plan_id,

Line 821: FROM qa_results qr

817: plan_id parent_plan_id,
818: collection_id parent_collection_id,
819: occurrence parent_occurrence,
820: 0 levels
821: FROM qa_results qr
822: WHERE qr.plan_id = p_plan_id AND
823: qr.txn_header_id = p_txn_header_id
824: UNION ALL
825: SELECT child_plan_id,

Line 835: FROM qa_results qr

831: level levels
832: FROM qa_pc_results_relationship r
833: WHERE p_txn_header_id =
834: (SELECT qr.txn_header_id
835: FROM qa_results qr
836: WHERE qr.plan_id = r.child_plan_id and
837: qr.collection_id = r.child_collection_id and
838: qr.occurrence = r.child_occurrence)
839: START WITH r.parent_plan_id = p_plan_id

Line 864: FROM qa_results qr

860: plan_id parent_plan_id,
861: collection_id parent_collection_id,
862: occurrence parent_occurrence,
863: 0 levels
864: FROM qa_results qr
865: WHERE qr.plan_id = p_plan_id AND
866: qr.txn_header_id = p_txn_header_id
867: UNION ALL
868: --

Line 872: -- qa_results. So we can use the original form of the SQL that starts

868: --
869: -- bug 16037863
870: -- With the fix done for bug 14134055, the child txn header id in
871: -- qa_pc_results_relationhsip table will be in sync with that in
872: -- qa_results. So we can use the original form of the SQL that starts
873: -- from a parent plan id and gets all the rows in the hierarchy and
874: -- then picks the one with the specific txn_header_id
875: --
876: SELECT child_plan_id,

Line 1070: -- In the ERES flow, we certainly don't want to commit the qa_results

1066: PRAGMA AUTONOMOUS_TRANSACTION;
1067:
1068: -- Bug 3128040 rponnusa Thu Sep 4 05:52:20 PDT 2003
1069:
1070: -- In the ERES flow, we certainly don't want to commit the qa_results
1071: -- before the final commit. So the autonomous commit should be used
1072:
1073: -- 1. user tries to save record in the form
1074: -- 2. sequences generated (HERE each generation is itself an

Line 1076: -- 3. qa_results table updated

1072:
1073: -- 1. user tries to save record in the form
1074: -- 2. sequences generated (HERE each generation is itself an
1075: -- autonomous txn:lock table, gen-sequence, add-to-audit, commit.)
1076: -- 3. qa_results table updated
1077: -- 4. eSignature obtained
1078: -- 5. commit
1079:
1080: -- step 2 is accomblished in this procedure.

Line 1121: -- records in qa_results;

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:
1125: END gen_seq_for_currec_commit;

Line 2144: Holds values from 1 to 15 to identify the result column name in qa_results

2140: Indicates the record postion in the plsql table that should be used to
2141: get or update the seq values from parent or child record respectively
2142:
2143: p_seq_position:
2144: Holds values from 1 to 15 to identify the result column name in qa_results
2145:
2146: p_seq_value inout variable:
2147: When p_action = 1 then parent seq value return back to calling procedure
2148: When p_action = 2 then parent seq value passed in

Line 2308: -- UPDATE qa_results

2304:
2305: -- Bulk update done once for all the records in collection
2306:
2307: -- FORALL k IN 1..p_total_rec_count
2308: -- UPDATE qa_results
2309: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),
2310: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2311: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2312: -- sequence4 = QLTTRAWB.g_seq_tab4(k),

Line 2335: UPDATE qa_results

2331: -- nutngare Sun Apr 9 23:43:06 PDT 2006
2332: --
2333: FOR k in 1..g_true_seq_gen_recids.COUNT
2334: LOOP
2335: UPDATE qa_results
2336: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),
2337: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2338: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2339: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),

Line 2567: FROM qa_results

2563: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2564: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2565: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),
2566: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)
2567: FROM qa_results
2568: WHERE plan_id = p_plan_ids(i) AND
2569: collection_id = p_collection_ids(i) AND
2570: occurrence = p_occurrences(i);
2571: i := p_occurrences.NEXT(i);

Line 2591: FROM qa_results qr

2587: level
2588: FROM qa_pc_results_relationship r
2589: WHERE EXISTS (
2590: SELECT 1
2591: FROM qa_results qr
2592: WHERE qr.plan_id = r.child_plan_id AND
2593: qr.collection_id = r.child_collection_id AND
2594: qr.occurrence = r.child_occurrence AND
2595: (qr.status IS NULL or qr.status=2) )

Line 2887: FROM qa_results qr

2883: x_message OUT nocopy VARCHAR2) IS
2884:
2885: CURSOR all_plan_cur IS
2886: SELECT DISTINCT qr.plan_id
2887: FROM qa_results qr
2888: WHERE qr.collection_id = p_collection_id
2889: AND NOT EXISTS
2890: (SELECT 1
2891: FROM qa_pc_results_relationship qprr

Line 2967: -- Now use bulk update to update all seq. values into qa_results for all the

2963: fnd_log.string(fnd_log.level_statement, l_module,
2964: 'Sequence message for Applicable Plans Page ' || x_message);
2965: END IF;
2966:
2967: -- Now use bulk update to update all seq. values into qa_results for all the
2968: -- records in the data collection
2969: update_record(l_row_count);
2970:
2971: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN