36: X_LAST_UPDATE_DATE in DATE,
37: X_LAST_UPDATED_BY in NUMBER,
38: X_LAST_UPDATE_LOGIN in NUMBER
39: ) is
40: cursor C is select ROWID from SO_PRICE_LISTS_B
41: where PRICE_LIST_ID = X_PRICE_LIST_ID
42: ;
43: begin
44: insert into SO_PRICE_LISTS_B (
40: cursor C is select ROWID from SO_PRICE_LISTS_B
41: where PRICE_LIST_ID = X_PRICE_LIST_ID
42: ;
43: begin
44: insert into SO_PRICE_LISTS_B (
45: ATTRIBUTE9,
46: ATTRIBUTE10,
47: ATTRIBUTE11,
48: ATTRIBUTE12,
206: ATTRIBUTE5,
207: ATTRIBUTE6,
208: ATTRIBUTE7,
209: ATTRIBUTE8
210: from SO_PRICE_LISTS_B
211: where PRICE_LIST_ID = X_PRICE_LIST_ID
212: for update of PRICE_LIST_ID nowait;
213: recinfo c%rowtype;
214:
335: X_LAST_UPDATED_BY in NUMBER,
336: X_LAST_UPDATE_LOGIN in NUMBER
337: ) is
338: begin
339: update SO_PRICE_LISTS_B set
340: ATTRIBUTE9 = X_ATTRIBUTE9,
341: ATTRIBUTE10 = X_ATTRIBUTE10,
342: ATTRIBUTE11 = X_ATTRIBUTE11,
343: ATTRIBUTE12 = X_ATTRIBUTE12,
397: if (sql%notfound) then
398: raise no_data_found;
399: end if;
400:
401: delete from SO_PRICE_LISTS_B
402: where PRICE_LIST_ID = X_PRICE_LIST_ID;
403:
404: if (sql%notfound) then
405: raise no_data_found;
411: begin
412: delete from SO_PRICE_LISTS_TL T
413: where not exists
414: (select NULL
415: from SO_PRICE_LISTS_B B
416: where B.PRICE_LIST_ID = T.PRICE_LIST_ID
417: );
418:
419: update SO_PRICE_LISTS_TL T set (