APPS.QP_RLTD_MODIFIER_PVT dependencies on QP_RLTD_MODIFIERS

Line 33: cursor C is select RLTD_MODIFIER_ID from QP_RLTD_MODIFIERS

29: , X_ATTRIBUTE14 VARCHAR2
30: , X_ATTRIBUTE15 VARCHAR2
31: ) IS
32:
33: cursor C is select RLTD_MODIFIER_ID from QP_RLTD_MODIFIERS
34: where RLTD_MODIFIER_ID = X_RLTD_MODIFIER_ID;
35:
36:
37:

Line 41: insert into QP_RLTD_MODIFIERS

37:
38: BEGIN
39:
40:
41: insert into QP_RLTD_MODIFIERS
42: (
43: RLTD_MODIFIER_ID
44: , CREATION_DATE
45: , CREATED_BY

Line 140: cursor C is select * from QP_RLTD_MODIFIERS

136: , X_ATTRIBUTE15 VARCHAR2
137: ) IS
138:
139:
140: cursor C is select * from QP_RLTD_MODIFIERS
141: where RLTD_MODIFIER_ID = X_RLTD_MODIFIER_ID
142: for update of RLTD_MODIFIER_ID nowait;
143: Recinfo C%ROWTYPE;
144:

Line 309: UPDATE QP_RLTD_MODIFIERS

305: , X_ATTRIBUTE15 VARCHAR2
306: ) IS
307: begin
308:
309: UPDATE QP_RLTD_MODIFIERS
310: SET
311: RLTD_MODIFIER_ID = X_RLTD_MODIFIER_ID
312: , CREATION_DATE = X_CREATION_DATE
313: , CREATED_BY = X_CREATED_BY

Line 350: delete from QP_RLTD_MODIFIERS

346: X_TO_RLTD_MODIFIER_ID NUMBER
347: ) IS
348: begin
349:
350: delete from QP_RLTD_MODIFIERS
351: where TO_RLTD_MODIFIER_ID= X_TO_RLTD_MODIFIER_ID;
352:
353: if (SQL%NOTFOUND) then
354: Raise NO_DATA_FOUND;