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 426: FROM qa_results qr

422: -- results been entered.
423:
424: CURSOR all_plan_cur IS
425: SELECT distinct qr.plan_id
426: FROM qa_results qr
427: WHERE qr.collection_id = p_collection_id AND
428: NOT EXISTS (SELECT 1 FROM qa_pc_results_relationship qprr
429: WHERE qprr.child_plan_id = qr.plan_id AND
430: qprr.child_collection_id = qr.collection_id AND

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

472: -- in case when an ERES is resubmitted the sequence
473: -- is not to be regenerated, yet the sequence array
474: -- needs to be populated with the values from the
475: -- Audit Hist table where the generated seq would reside
476: -- and this should be used while updating qa_results
477: -- Without this, in case of a resubmission, the sequence
478: -- value won't be copied to QA_RESULTS. This processing
479: -- has been moved to the proc generate_seq_for_pc
480: -- ntungare Thu Aug 17 03:40:02 PDT 2006

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

474: -- needs to be populated with the values from the
475: -- Audit Hist table where the generated seq would reside
476: -- and this should be used while updating qa_results
477: -- Without this, in case of a resubmission, the sequence
478: -- value won't be copied to QA_RESULTS. This processing
479: -- has been moved to the proc generate_seq_for_pc
480: -- ntungare Thu Aug 17 03:40:02 PDT 2006
481: --
482: /*

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

511: null);
512:
513: END LOOP;
514:
515: -- Now use bulk update to update all seq. values into qa_results for all the
516: -- records in the data collection
517:
518: update_record(l_row_count);
519:

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

594: generate_seq_for_pc(p_plan_id,
595: null,
596: p_txn_header_id);
597:
598: -- Now use bulk update to update all seq. values into qa_results for all the
599: -- records in the data collection
600:
601: update_record(l_row_count);
602:

Line 624: FROM qa_results

620: sequence4,sequence5,sequence6,
621: sequence7,sequence8,sequence9,
622: sequence10,sequence11,sequence12,
623: sequence13,sequence14,sequence15
624: FROM qa_results
625: WHERE collection_id = p_collection_id;
626:
627: CURSOR txn_cur IS
628: SELECT occurrence,collection_id,plan_id,txn_header_id,

Line 634: FROM qa_results

630: sequence4,sequence5,sequence6,
631: sequence7,sequence8,sequence9,
632: sequence10,sequence11,sequence12,
633: sequence13,sequence14,sequence15
634: FROM qa_results
635: WHERE txn_header_id = p_txn_header_id;
636:
637: l_row_count NUMBER := 0;
638:

Line 707: FROM qa_results qr

703: plan_id parent_plan_id,
704: collection_id parent_collection_id,
705: occurrence parent_occurrence,
706: 0 levels
707: FROM qa_results qr
708: WHERE qr.plan_id = p_plan_id AND
709: qr.collection_id = p_collection_id
710: UNION ALL
711: SELECT child_plan_id,

Line 744: FROM qa_results qr

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

Line 785: FROM qa_results qr

781: plan_id parent_plan_id,
782: collection_id parent_collection_id,
783: occurrence parent_occurrence,
784: 0 levels
785: FROM qa_results qr
786: WHERE qr.plan_id = p_plan_id AND
787: qr.txn_header_id = p_txn_header_id
788: UNION ALL
789: SELECT child_plan_id,

Line 799: FROM qa_results qr

795: level levels
796: FROM qa_pc_results_relationship r
797: WHERE p_txn_header_id =
798: (SELECT qr.txn_header_id
799: FROM qa_results qr
800: WHERE qr.plan_id = r.child_plan_id and
801: qr.collection_id = r.child_collection_id and
802: qr.occurrence = r.child_occurrence)
803: START WITH r.parent_plan_id = p_plan_id

Line 828: FROM qa_results qr

824: plan_id parent_plan_id,
825: collection_id parent_collection_id,
826: occurrence parent_occurrence,
827: 0 levels
828: FROM qa_results qr
829: WHERE qr.plan_id = p_plan_id AND
830: qr.txn_header_id = p_txn_header_id
831: UNION ALL
832: SELECT child_plan_id,

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

1012: PRAGMA AUTONOMOUS_TRANSACTION;
1013:
1014: -- Bug 3128040 rponnusa Thu Sep 4 05:52:20 PDT 2003
1015:
1016: -- In the ERES flow, we certainly don't want to commit the qa_results
1017: -- before the final commit. So the autonomous commit should be used
1018:
1019: -- 1. user tries to save record in the form
1020: -- 2. sequences generated (HERE each generation is itself an

Line 1022: -- 3. qa_results table updated

1018:
1019: -- 1. user tries to save record in the form
1020: -- 2. sequences generated (HERE each generation is itself an
1021: -- autonomous txn:lock table, gen-sequence, add-to-audit, commit.)
1022: -- 3. qa_results table updated
1023: -- 4. eSignature obtained
1024: -- 5. commit
1025:
1026: -- step 2 is accomblished in this procedure.

Line 1067: -- records in qa_results;

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

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

2086: Indicates the record postion in the plsql table that should be used to
2087: get or update the seq values from parent or child record respectively
2088:
2089: p_seq_position:
2090: Holds values from 1 to 15 to identify the result column name in qa_results
2091:
2092: p_seq_value inout variable:
2093: When p_action = 1 then parent seq value return back to calling procedure
2094: When p_action = 2 then parent seq value passed in

Line 2254: -- UPDATE qa_results

2250:
2251: -- Bulk update done once for all the records in collection
2252:
2253: -- FORALL k IN 1..p_total_rec_count
2254: -- UPDATE qa_results
2255: -- SET sequence1 = QLTTRAWB.g_seq_tab1(k),
2256: -- sequence2 = QLTTRAWB.g_seq_tab2(k),
2257: -- sequence3 = QLTTRAWB.g_seq_tab3(k),
2258: -- sequence4 = QLTTRAWB.g_seq_tab4(k),

Line 2281: UPDATE qa_results

2277: -- nutngare Sun Apr 9 23:43:06 PDT 2006
2278: --
2279: FOR k in 1..g_true_seq_gen_recids.COUNT
2280: LOOP
2281: UPDATE qa_results
2282: SET sequence1 = QLTTRAWB.g_seq_tab1(g_true_seq_gen_recids(k)),
2283: sequence2 = QLTTRAWB.g_seq_tab2(g_true_seq_gen_recids(k)),
2284: sequence3 = QLTTRAWB.g_seq_tab3(g_true_seq_gen_recids(k)),
2285: sequence4 = QLTTRAWB.g_seq_tab4(g_true_seq_gen_recids(k)),

Line 2513: FROM qa_results

2509: QLTTRAWB.g_seq_tab4(l_count), QLTTRAWB.g_seq_tab5(l_count), QLTTRAWB.g_seq_tab6(l_count),
2510: QLTTRAWB.g_seq_tab7(l_count), QLTTRAWB.g_seq_tab8(l_count), QLTTRAWB.g_seq_tab9(l_count),
2511: QLTTRAWB.g_seq_tab10(l_count), QLTTRAWB.g_seq_tab11(l_count), QLTTRAWB.g_seq_tab12(l_count),
2512: QLTTRAWB.g_seq_tab13(l_count), QLTTRAWB.g_seq_tab14(l_count), QLTTRAWB.g_seq_tab15(l_count)
2513: FROM qa_results
2514: WHERE plan_id = p_plan_ids(i) AND
2515: collection_id = p_collection_ids(i) AND
2516: occurrence = p_occurrences(i);
2517: i := p_occurrences.NEXT(i);

Line 2537: FROM qa_results qr

2533: level
2534: FROM qa_pc_results_relationship r
2535: WHERE EXISTS (
2536: SELECT 1
2537: FROM qa_results qr
2538: WHERE qr.plan_id = r.child_plan_id AND
2539: qr.collection_id = r.child_collection_id AND
2540: qr.occurrence = r.child_occurrence AND
2541: (qr.status IS NULL or qr.status=2) )

Line 2833: FROM qa_results qr

2829: x_message OUT nocopy VARCHAR2) IS
2830:
2831: CURSOR all_plan_cur IS
2832: SELECT DISTINCT qr.plan_id
2833: FROM qa_results qr
2834: WHERE qr.collection_id = p_collection_id
2835: AND NOT EXISTS
2836: (SELECT 1
2837: FROM qa_pc_results_relationship qprr

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

2909: fnd_log.string(fnd_log.level_statement, l_module,
2910: 'Sequence message for Applicable Plans Page ' || x_message);
2911: END IF;
2912:
2913: -- Now use bulk update to update all seq. values into qa_results for all the
2914: -- records in the data collection
2915: update_record(l_row_count);
2916:
2917: IF(fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN