APPS.QA_PC_PLAN_REL_PKG dependencies on QA_PC_PLAN_RELATIONSHIP

Line 19: CURSOR C IS SELECT rowid FROM QA_PC_PLAN_RELATIONSHIP

15: X_Creation_Date DATE,
16: X_Created_By NUMBER,
17: X_Last_Update_Login NUMBER
18: ) IS
19: CURSOR C IS SELECT rowid FROM QA_PC_PLAN_RELATIONSHIP
20: WHERE plan_relationship_id = X_Plan_Relationship_Id;
21: CURSOR C2 IS SELECT qa_pc_plan_relationship_s.nextval FROM dual;
22:
23: BEGIN

Line 21: CURSOR C2 IS SELECT qa_pc_plan_relationship_s.nextval FROM dual;

17: X_Last_Update_Login NUMBER
18: ) IS
19: CURSOR C IS SELECT rowid FROM QA_PC_PLAN_RELATIONSHIP
20: WHERE plan_relationship_id = X_Plan_Relationship_Id;
21: CURSOR C2 IS SELECT qa_pc_plan_relationship_s.nextval FROM dual;
22:
23: BEGIN
24: if (X_Plan_Relationship_Id is NULL) then
25: OPEN C2;

Line 30: INSERT INTO QA_PC_PLAN_RELATIONSHIP(

26: FETCH C2 INTO X_Plan_Relationship_Id;
27: CLOSE C2;
28: end if;
29:
30: INSERT INTO QA_PC_PLAN_RELATIONSHIP(
31: plan_relationship_id,
32: parent_plan_id,
33: child_plan_id,
34: plan_relationship_type,

Line 85: FROM QA_PC_PLAN_RELATIONSHIP

81: X_Created_By NUMBER
82: ) IS
83: CURSOR C IS
84: SELECT *
85: FROM QA_PC_PLAN_RELATIONSHIP
86: WHERE rowid = X_Rowid
87: FOR UPDATE of plan_relationship_id NOWAIT;
88: Recinfo C%ROWTYPE;
89:

Line 139: UPDATE QA_PC_PLAN_RELATIONSHIP

135: X_Created_By NUMBER,
136: X_Last_Update_Login NUMBER
137: ) IS
138: BEGIN
139: UPDATE QA_PC_PLAN_RELATIONSHIP
140: SET
141: plan_relationship_id = X_Plan_Relationship_Id,
142: parent_plan_id = X_Parent_Plan_Id,
143: child_plan_id = X_Child_Plan_id,

Line 164: DELETE FROM QA_PC_PLAN_RELATIONSHIP

160: END Update_Row;
161:
162: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
163: BEGIN
164: DELETE FROM QA_PC_PLAN_RELATIONSHIP
165: WHERE rowid = X_Rowid;
166:
167: if (SQL%NOTFOUND) then
168: Raise NO_DATA_FOUND;