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
48:
49: BEGIN
50:
51:
52: insert into QP_PRICING_ATTRIBUTES
53: (
54: PRICING_ATTRIBUTE_ID
55: , CREATION_DATE
56: , CREATED_BY
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:
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
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;