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 2005/06/11 08:56:03 appldev $ */
3:
4: --
5: -- Modified the proc signature and implementation

Line 269: CURSOR C IS SELECT rowid FROM QA_RESULTS

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

Line 284: INSERT INTO QA_RESULTS(

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

Line 1026: FROM QA_RESULTS

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

Line 2011: UPDATE QA_RESULTS

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

Line 2257: DELETE FROM QA_RESULTS

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

Line 2266: END QA_RESULTS_PKG;

2262: end if;
2263: END Delete_Row;
2264:
2265:
2266: END QA_RESULTS_PKG;