APPS.QA_PC_RESULTS_REL_PKG dependencies on QA_PC_RESULTS_RELATIONSHIP

Line 18: CURSOR C IS SELECT rowid FROM QA_PC_RESULTS_RELATIONSHIP

14: X_Created_By NUMBER,
15: X_Last_Update_Login NUMBER,
16: X_Child_Txn_Header_Id NUMBER
17: ) IS
18: CURSOR C IS SELECT rowid FROM QA_PC_RESULTS_RELATIONSHIP
19: WHERE parent_plan_id = X_Parent_Plan_Id
20: AND parent_collection_id = X_Parent_Collection_Id
21: AND parent_occurrence = X_Parent_Occurrence
22: AND child_plan_id = X_Child_Plan_Id

Line 32: -- the qa_pc_results_relationship table.

28: -- Bug 8273401
29: -- Checking if a record for this combination already exists.
30: -- If it does, then do not insert one more row and exit.
31: -- This would avoid duplicate entries from being entered into
32: -- the qa_pc_results_relationship table.
33: -- skolluku
34: --
35: OPEN C;
36: FETCH C INTO X_Rowid;

Line 43: INSERT INTO QA_PC_RESULTS_RELATIONSHIP(

39: return;
40: end if;
41: CLOSE C;
42:
43: INSERT INTO QA_PC_RESULTS_RELATIONSHIP(
44: parent_plan_id,
45: parent_collection_id,
46: parent_occurrence,
47: child_plan_id,

Line 99: FROM QA_PC_RESULTS_RELATIONSHIP

95:
96: ) IS
97: CURSOR C IS
98: SELECT *
99: FROM QA_PC_RESULTS_RELATIONSHIP
100: WHERE rowid = X_Rowid
101: FOR UPDATE of Child_Occurrence NOWAIT;
102: Recinfo C%ROWTYPE;
103:

Line 152: UPDATE QA_PC_RESULTS_RELATIONSHIP

148: X_Child_Txn_Header_Id NUMBER
149:
150: ) IS
151: BEGIN
152: UPDATE QA_PC_RESULTS_RELATIONSHIP
153: SET
154: parent_plan_id = X_Parent_Plan_Id,
155: parent_collection_id = X_Parent_Collection_Id,
156: parent_occurrence = X_Parent_Occurrence,

Line 176: DELETE FROM QA_PC_RESULTS_RELATIONSHIP

172: END Update_Row;
173:
174: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
175: BEGIN
176: DELETE FROM QA_PC_RESULTS_RELATIONSHIP
177: WHERE rowid = X_Rowid;
178:
179: if (SQL%NOTFOUND) then
180: Raise NO_DATA_FOUND;