APPS.QA_SEQ_AUDIT_PKG dependencies on QA_SEQ_AUDIT_HISTORY

Line 23: CURSOR C IS SELECT rowid FROM QA_SEQ_AUDIT_HISTORY

19: P_Created_By NUMBER,
20: P_Last_Update_Login NUMBER
21: ) IS
22:
23: CURSOR C IS SELECT rowid FROM QA_SEQ_AUDIT_HISTORY
24: WHERE char_id = P_Char_Id
25: AND plan_id = P_Plan_Id
26: AND collection_id = P_Collection_Id
27: AND occurrence = P_Occurrence;

Line 30: INSERT INTO QA_SEQ_AUDIT_HISTORY(

26: AND collection_id = P_Collection_Id
27: AND occurrence = P_Occurrence;
28:
29: BEGIN
30: INSERT INTO QA_SEQ_AUDIT_HISTORY(
31: plan_id,
32: collection_id,
33: occurrence,
34: char_id,

Line 98: FROM QA_SEQ_AUDIT_HISTORY

94: ) IS
95:
96: CURSOR C IS
97: SELECT *
98: FROM QA_SEQ_AUDIT_HISTORY
99: WHERE rowid = P_Rowid
100: FOR UPDATE of char_id NOWAIT;
101:
102: Recinfo C%ROWTYPE;

Line 166: UPDATE QA_SEQ_AUDIT_HISTORY

162: P_Created_By NUMBER,
163: P_Last_Update_Login NUMBER
164: )IS
165: BEGIN
166: UPDATE QA_SEQ_AUDIT_HISTORY
167: SET
168: plan_id = P_Plan_Id,
169: collection_id = P_Collection_Id,
170: occurrence = P_Occurrence,

Line 194: DELETE FROM QA_SEQ_AUDIT_HISTORY

190: END Update_Row;
191:
192: PROCEDURE Delete_Row(P_Rowid VARCHAR2) IS
193: BEGIN
194: DELETE FROM QA_SEQ_AUDIT_HISTORY
195: WHERE rowid = P_Rowid;
196:
197: IF (SQL%NOTFOUND) THEN
198: Raise NO_DATA_FOUND;