DBA Data[Home] [Help]

APPS.QP_MODIFIER_LIST_LINE_PVT dependencies on QP_LIST_LINES

Line 76: cursor C is select LIST_LINE_ID from QP_LIST_LINES

72: ) IS
73:
74:
75:
76: cursor C is select LIST_LINE_ID from QP_LIST_LINES
77: where LIST_LINE_ID = X_LIST_LINE_ID;
78:
79: BEGIN
80:

Line 82: insert into QP_LIST_LINES

78:
79: BEGIN
80:
81:
82: insert into QP_LIST_LINES
83: (LIST_LINE_ID
84: , CREATION_DATE
85: , CREATED_BY
86: , LAST_UPDATE_DATE

Line 308: cursor C is select * from QP_LIST_LINES

304: , X_GENERATE_USING_FORMULA_ID NUMBER
305: ) IS
306:
307:
308: cursor C is select * from QP_LIST_LINES
309: where LIST_LINE_ID = X_LIST_LINE_ID
310: for update of LIST_LINE_ID nowait;
311: Recinfo C%ROWTYPE;
312:

Line 680: UPDATE QP_LIST_LINES

676: ) IS
677:
678: begin
679:
680: UPDATE QP_LIST_LINES
681: SET
682: LIST_LINE_ID = X_LIST_LINE_ID
683: ,CREATION_DATE = X_CREATION_DATE
684: ,CREATED_BY = X_CREATED_BY

Line 766: delete from QP_LIST_LINES

762: ) IS
763:
764: begin
765:
766: delete from QP_LIST_LINES
767: where LIST_LINE_ID = X_LIST_LINE_ID;
768:
769: if (SQL%NOTFOUND) then
770: Raise NO_DATA_FOUND;