DBA Data[Home] [Help]

APPS.QP_PRICING_ATTRIBUTE_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 45: cursor C is select PRICING_ATTRIBUTE_ID from QP_PRICING_ATTRIBUTES

41: , X_ATTRIBUTE14 VARCHAR2
42: , X_ATTRIBUTE15 VARCHAR2
43: ) IS
44:
45: cursor C is select PRICING_ATTRIBUTE_ID from QP_PRICING_ATTRIBUTES
46: where PRICING_ATTRIBUTE_ID = X_PRICING_ATTRIBUTE_ID;
47:
48:
49: BEGIN

Line 52: insert into QP_PRICING_ATTRIBUTES

48:
49: BEGIN
50:
51:
52: insert into QP_PRICING_ATTRIBUTES
53: (
54: PRICING_ATTRIBUTE_ID
55: , CREATION_DATE
56: , CREATED_BY

Line 187: cursor C is select * from QP_PRICING_ATTRIBUTES

183: , X_ATTRIBUTE15 VARCHAR2
184: ) IS
185:
186:
187: cursor C is select * from QP_PRICING_ATTRIBUTES
188: where PRICING_ATTRIBUTE_ID = X_PRICING_ATTRIBUTE_ID
189: for update of PRICING_ATTRIBUTE_ID nowait;
190: Recinfo C%ROWTYPE;
191:

Line 413: UPDATE QP_PRICING_ATTRIBUTES

409: , X_ATTRIBUTE15 VARCHAR2
410: ) IS
411: begin
412:
413: UPDATE QP_PRICING_ATTRIBUTES
414: SET
415: PRICING_ATTRIBUTE_ID = X_PRICING_ATTRIBUTE_ID
416: , CREATION_DATE = X_CREATION_DATE
417: , CREATED_BY = X_CREATED_BY

Line 469: delete from QP_PRICING_ATTRIBUTES

465: X_LIST_LINE_ID NUMBER
466: ) IS
467: begin
468:
469: delete from QP_PRICING_ATTRIBUTES
470: where LIST_LINE_ID = LIST_LINE_ID;
471:
472: if (SQL%NOTFOUND) then
473: Raise NO_DATA_FOUND;