APPS.QA_PC_ELEMENT_REL_PKG dependencies on QA_PC_ELEMENT_RELATIONSHIP

Line 16: CURSOR C IS SELECT rowid FROM QA_PC_ELEMENT_RELATIONSHIP

12: X_Creation_Date DATE,
13: X_Created_By NUMBER,
14: X_Last_Update_Login NUMBER
15: ) IS
16: CURSOR C IS SELECT rowid FROM QA_PC_ELEMENT_RELATIONSHIP
17: WHERE element_relationship_id = X_Element_Relationship_Id;
18: CURSOR C2 IS SELECT qa_pc_element_relationship_s.nextval FROM dual;
19:
20: BEGIN

Line 18: CURSOR C2 IS SELECT qa_pc_element_relationship_s.nextval FROM dual;

14: X_Last_Update_Login NUMBER
15: ) IS
16: CURSOR C IS SELECT rowid FROM QA_PC_ELEMENT_RELATIONSHIP
17: WHERE element_relationship_id = X_Element_Relationship_Id;
18: CURSOR C2 IS SELECT qa_pc_element_relationship_s.nextval FROM dual;
19:
20: BEGIN
21: if (X_Element_Relationship_Id is NULL) then
22: OPEN C2;

Line 26: INSERT INTO QA_PC_ELEMENT_RELATIONSHIP(

22: OPEN C2;
23: FETCH C2 INTO X_Element_Relationship_Id;
24: CLOSE C2;
25: end if;
26: INSERT INTO QA_PC_ELEMENT_RELATIONSHIP(
27: element_relationship_id,
28: plan_relationship_id,
29: parent_char_id,
30: child_char_id,

Line 74: FROM QA_PC_ELEMENT_RELATIONSHIP

70: X_Created_By NUMBER
71: ) IS
72: CURSOR C IS
73: SELECT *
74: FROM QA_PC_ELEMENT_RELATIONSHIP
75: WHERE rowid = X_Rowid
76: FOR UPDATE of element_relationship_id NOWAIT;
77: Recinfo C%ROWTYPE;
78:

Line 123: UPDATE QA_PC_ELEMENT_RELATIONSHIP

119: X_Last_Update_Login NUMBER
120: ) IS
121:
122: BEGIN
123: UPDATE QA_PC_ELEMENT_RELATIONSHIP
124: SET
125: element_relationship_id = X_Element_Relationship_Id,
126: plan_relationship_id = X_Plan_Relationship_Id,
127: parent_char_id = X_Parent_Char_id,

Line 146: DELETE FROM QA_PC_ELEMENT_RELATIONSHIP

142: END Update_Row;
143:
144: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
145: BEGIN
146: DELETE FROM QA_PC_ELEMENT_RELATIONSHIP
147: WHERE rowid = X_Rowid;
148:
149: if (SQL%NOTFOUND) then
150: Raise NO_DATA_FOUND;