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_RESULT_GRP dependencies on QA_RESULTS

Line 51: DELETE qa_results

47: p_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49: IF p_collection_id is not null THEN
50:
51: DELETE qa_results
52: WHERE collection_id = p_collection_id;
53:
54: -- R12 ERES Support in Service Family. Bug 4345768
55: l_result_count := SQL%ROWCOUNT;

Line 178: UPDATE qa_results

174: -- Update the status of the records to 2(Enabled Status) only if it
175: -- is not already 2.
176: -- ntungare Thu Sep 8 07:24:20 PDT 2005
177: --
178: UPDATE qa_results
179: SET status = 2,
180: cs_incident_id = nvl(p_incident_id, cs_incident_id)
181: WHERE p_collection_id = collection_id
182: AND status <> 2;

Line 212: -- If the previous update statement had updated qa_results then

208: -- only actions that are performed in commit cycle are to be
209: -- launched here
210: --
211: -- Bug 4473407.
212: -- If the previous update statement had updated qa_results then
213: -- SQL%ROWCOUNT would be > 0 and only in that case we call do_actions
214: -- to fire the action. Before this fix qltdactb.do_actions was called
215: -- without any condition and because of this whenever the procedure
216: -- Enable is called the actions are also fired unnecessarily which is

Line 219: -- more than once, the updation of qa_results and action firing will

215: -- without any condition and because of this whenever the procedure
216: -- Enable is called the actions are also fired unnecessarily which is
217: -- not correct. The actions should fire only once for the enabled
218: -- records - even if the parent transaction calls QA_RESULT_GRP.ENABLE
219: -- more than once, the updation of qa_results and action firing will
220: -- happen only the first time and nothing would happen during the
221: -- consecutive calls.
222: -- ntungare Thu Sep 8 07:37:32 PDT 2005
223: --

Line 309: PROCEDURE Enable_QA_Results ( X_Txn_Header_ID Number,

305: Called From: WIP COMPLETION TXN COMMIT LOGIC
306: Parameter: X_txn_header_id ( identifier for a group of material txns )
307:
308: ***********************************************************************/
309: PROCEDURE Enable_QA_Results ( X_Txn_Header_ID Number,
310: P_MSG_COUNT IN OUT NOCOPY NUMBER ) IS
311:
312: Cursor C_Collection_id is
313: Select qa_collection_id

Line 349: END Enable_QA_Results ;

345: CLOSE C_COLLECTION_ID ;
346:
347: Exception When Others Then
348: return ;
349: END Enable_QA_Results ;
350:
351: -- Start R12 EAM Integration. Bug 4345492
352: PROCEDURE enable_and_fire_action (
353: p_api_version IN NUMBER,

Line 387: qa_results_api.enable(p_collection_id);

383:
384: -- Initialize API return status to error
385: x_return_status := FND_API.G_RET_STS_ERROR;
386:
387: qa_results_api.enable(p_collection_id);
388: actions_request_id := fnd_request.submit_request('QA', 'QLTACTWB', NULL,
389: NULL, FALSE, to_char(-p_collection_id));
390:
391: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 439: PROCEDURE get_qa_results_erecords

435: -- API to retrieve the Quality Results E-Records captured as
436: -- part of a Transaction session ( collection )
437: -- The E-Record IDs are returned as part of the x_qa_erecord_tbl
438: -- output parameter.
439: PROCEDURE get_qa_results_erecords
440: (
441: p_api_version IN NUMBER,
442: p_init_msg_list IN VARCHAR2 := NULL ,
443: p_commit IN VARCHAR2 := NULL ,

Line 452: l_api_name CONSTANT VARCHAR2(30) := 'get_qa_results_erecords';

448: x_msg_count OUT NOCOPY NUMBER ,
449: x_msg_data OUT NOCOPY VARCHAR2
450: )
451: IS
452: l_api_name CONSTANT VARCHAR2(30) := 'get_qa_results_erecords';
453: l_api_version CONSTANT NUMBER := 1.0;
454:
455: ctr NUMBER := 1;
456: l_prev_plan_id NUMBER := -1;

Line 469: FROM QA_RESULTS

465: IS
466: SELECT plan_id,
467: txn_header_id,
468: occurrence
469: FROM QA_RESULTS
470: WHERE collection_id = c_collection_id
471: AND status <> 2
472: ORDER BY txn_header_id DESC, plan_id;
473:

Line 711: END get_qa_results_erecords;

707: 'Exiting Procedure: Error'
708: );
709: END IF;
710:
711: END get_qa_results_erecords;
712:
713: -- Bug 5508639. SHKALYAN 13-Sep-2006.
714: -- new API to delete the old invalid results For a collection_id
715: -- This is needed because the Per Collection E-Records show

Line 728: FROM qa_results

724: l_plans dbms_sql.number_table;
725:
726: CURSOR C IS
727: SELECT occurrence, plan_id
728: FROM qa_results
729: WHERE collection_id = p_collection_id
730: AND status <> 2;
731:
732: BEGIN

Line 740: DELETE QA_RESULTS

736: CLOSE C;
737:
738: -- Delete all old invaild records for collection_id
739: FORALL i IN l_occurrences.FIRST..l_occurrences.LAST
740: DELETE QA_RESULTS
741: WHERE plan_id = l_plans(i)
742: AND occurrence = l_occurrences(i);
743:
744: -- Delete Child relationships

Line 793: FROM QA_RESULTS

789: -- Also Process only Results which are in disabled status.
790: CURSOR get_txn_header_id( c_collection_id NUMBER )
791: IS
792: SELECT MAX( txn_header_id )
793: FROM QA_RESULTS
794: WHERE collection_id = c_collection_id
795: AND status <> 2;
796:
797: -- Bug 5508639. SHKALYAN 13-Sep-2006.

Line 801: -- Arrays for holding the return values of qa results

797: -- Bug 5508639. SHKALYAN 13-Sep-2006.
798: l_txn_header_id NUMBER;
799:
800: -- Bug 5656202. SHKALYAN 11-NOV-2006.
801: -- Arrays for holding the return values of qa results
802: -- enabled in the current session
803: Type num_tab_typ is table of number index by binary_integer;
804: plan_id_tab num_tab_typ;
805: collection_id_tab num_tab_typ;

Line 853: -- Get all the QA Results E-Records for the given collection

849: 'Before Getting QA Result ERecords'
850: );
851: END IF;
852:
853: -- Get all the QA Results E-Records for the given collection
854: get_qa_results_erecords
855: (
856: p_api_version => 1.0,
857: p_init_msg_list => FND_API.G_FALSE,

Line 854: get_qa_results_erecords

850: );
851: END IF;
852:
853: -- Get all the QA Results E-Records for the given collection
854: get_qa_results_erecords
855: (
856: p_api_version => 1.0,
857: p_init_msg_list => FND_API.G_FALSE,
858: p_commit => FND_API.G_FALSE,

Line 914: 'Before Enabling QA Results and firing Actions'

910: FND_LOG.string
911: (
912: FND_LOG.level_statement,
913: g_pkg_name || '.' || l_api_name,
914: 'Before Enabling QA Results and firing Actions'
915: );
916: END IF;
917:
918: -- Bug 5508639. SHKALYAN 13-Sep-2006.

Line 920: -- include the logic for updating qa_results and calling do_actions

916: END IF;
917:
918: -- Bug 5508639. SHKALYAN 13-Sep-2006.
919: -- We were calling the enable API here. Modified to directly
920: -- include the logic for updating qa_results and calling do_actions
921: -- This is because we want to process based on txn_header_id
922: -- instead of collection_id and the old enable api cannot be used.
923:
924: -- Get the most recent txn_header_id

Line 938: UPDATE qa_results

934: -- background results. Also, since subsequent action processing
935: -- cannot be based on just txn_header_id, collecting all the
936: -- occurrences updated in this session, so that, actions can be fired
937: -- for only these records
938: UPDATE qa_results
939: SET status = 2,
940: cs_incident_id = nvl(p_incident_id, cs_incident_id)
941: WHERE p_collection_id = collection_id
942: AND (txn_header_id = l_txn_header_id OR txn_header_id IS NULL)

Line 1159: -- Get all the QA Results E-Records for the given collection

1155: 'Before Getting QA Result ERecords'
1156: );
1157: END IF;
1158:
1159: -- Get all the QA Results E-Records for the given collection
1160: get_qa_results_erecords
1161: (
1162: p_api_version => 1.0,
1163: p_init_msg_list => FND_API.G_FALSE,

Line 1160: get_qa_results_erecords

1156: );
1157: END IF;
1158:
1159: -- Get all the QA Results E-Records for the given collection
1160: get_qa_results_erecords
1161: (
1162: p_api_version => 1.0,
1163: p_init_msg_list => FND_API.G_FALSE,
1164: p_commit => FND_API.G_FALSE,

Line 1220: 'Before Purging QA Results'

1216: FND_LOG.string
1217: (
1218: FND_LOG.level_statement,
1219: g_pkg_name || '.' || l_api_name,
1220: 'Before Purging QA Results'
1221: );
1222: END IF;
1223:
1224: -- Purge the Quality Results for the Collection