APPS.QP_PRICE_BOOK_HEADERS_PKG dependencies on QP_PRICE_BOOK_HEADERS_ALL_B

Line 28: cursor C is select ROWID from QP_PRICE_BOOK_HEADERS_ALL_B

24: X_LAST_UPDATE_DATE in DATE,
25: X_LAST_UPDATED_BY in NUMBER,
26: X_LAST_UPDATE_LOGIN in NUMBER
27: ) is
28: cursor C is select ROWID from QP_PRICE_BOOK_HEADERS_ALL_B
29: where PRICE_BOOK_HEADER_ID = X_PRICE_BOOK_HEADER_ID
30: ;
31: begin
32: insert into QP_PRICE_BOOK_HEADERS_ALL_B (

Line 32: insert into QP_PRICE_BOOK_HEADERS_ALL_B (

28: cursor C is select ROWID from QP_PRICE_BOOK_HEADERS_ALL_B
29: where PRICE_BOOK_HEADER_ID = X_PRICE_BOOK_HEADER_ID
30: ;
31: begin
32: insert into QP_PRICE_BOOK_HEADERS_ALL_B (
33: PRICE_BOOK_TYPE_CODE,
34: CURRENCY_CODE,
35: EFFECTIVE_DATE,
36: CUSTOMER_ID,

Line 147: from QP_PRICE_BOOK_HEADERS_ALL_B

143: ITEM_QUANTITY,
144: REQUEST_ID,
145: REQUEST_TYPE_CODE,
146: PB_INPUT_HEADER_ID
147: from QP_PRICE_BOOK_HEADERS_ALL_B
148: where PRICE_BOOK_HEADER_ID = X_PRICE_BOOK_HEADER_ID
149: for update of PRICE_BOOK_HEADER_ID nowait;
150: recinfo c%rowtype;
151:

Line 234: update QP_PRICE_BOOK_HEADERS_ALL_B set

230: X_LAST_UPDATED_BY in NUMBER,
231: X_LAST_UPDATE_LOGIN in NUMBER
232: ) is
233: begin
234: update QP_PRICE_BOOK_HEADERS_ALL_B set
235: PRICE_BOOK_TYPE_CODE = X_PRICE_BOOK_TYPE_CODE,
236: CURRENCY_CODE = X_CURRENCY_CODE,
237: EFFECTIVE_DATE = X_EFFECTIVE_DATE,
238: CUSTOMER_ID = X_CUSTOMER_ID,

Line 285: delete from QP_PRICE_BOOK_HEADERS_ALL_B

281: if (sql%notfound) then
282: raise no_data_found;
283: end if;
284:
285: delete from QP_PRICE_BOOK_HEADERS_ALL_B
286: where PRICE_BOOK_HEADER_ID = X_PRICE_BOOK_HEADER_ID;
287:
288: if (sql%notfound) then
289: raise no_data_found;

Line 299: from QP_PRICE_BOOK_HEADERS_ALL_B B

295: begin
296: delete from QP_PRICE_BOOK_HEADERS_TL T
297: where not exists
298: (select NULL
299: from QP_PRICE_BOOK_HEADERS_ALL_B B
300: where B.PRICE_BOOK_HEADER_ID = T.PRICE_BOOK_HEADER_ID
301: );
302:
303: update QP_PRICE_BOOK_HEADERS_TL T set (