APPS.QA_RESULTS_PKG dependencies on QA_RESULTS

Line 1: PACKAGE BODY QA_RESULTS_PKG as

1: PACKAGE BODY QA_RESULTS_PKG as
2: /* $Header: qltrestb.plb 120.3.12010000.2 2010/04/26 17:16:38 ntungare ship $ */
3:
4: --
5: -- Modified the proc signature and implementation

Line 270: CURSOR C IS SELECT rowid FROM QA_RESULTS

266: -- R12 OPM Deviations. Bug 4345503 End
267:
268:
269: ) IS
270: CURSOR C IS SELECT rowid FROM QA_RESULTS
271: WHERE plan_id = x_plan_id
272: AND collection_id = X_Collection_Id
273: and occurrence = X_Occurrence;
274: CURSOR C2 IS SELECT qa_occurrence_s.nextval FROM dual;

Line 285: INSERT INTO QA_RESULTS(

281:
282: -- Modified the signature to include new hardcoded element followup activity, transfer license plate number
283: -- saugupta
284:
285: INSERT INTO QA_RESULTS(
286: collection_id,
287: occurrence,
288: last_update_date,
289: qa_last_update_date,

Line 1028: FROM QA_RESULTS

1024: -- R12 OPM Deviations. Bug 4345503 End
1025: ) IS
1026: CURSOR C IS
1027: SELECT *
1028: FROM QA_RESULTS
1029: WHERE rowid = X_Rowid
1030: FOR UPDATE of Occurrence NOWAIT;
1031: Recinfo C%ROWTYPE;
1032:

Line 2014: UPDATE QA_RESULTS

2010: X_PROCESS_PARAMETER_ID NUMBER
2011: -- R12 OPM Deviations. Bug 4345503 End
2012: ) IS
2013: BEGIN
2014: UPDATE QA_RESULTS
2015: SET
2016: collection_id = X_Collection_Id,
2017: occurrence = X_Occurrence,
2018: last_update_date = X_Last_Update_Date,

Line 2260: DELETE FROM QA_RESULTS

2256: END Update_Row;
2257:
2258: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
2259: BEGIN
2260: DELETE FROM QA_RESULTS
2261: WHERE rowid = X_Rowid;
2262:
2263: if (SQL%NOTFOUND) then
2264: Raise NO_DATA_FOUND;

Line 2269: END QA_RESULTS_PKG;

2265: end if;
2266: END Delete_Row;
2267:
2268:
2269: END QA_RESULTS_PKG;