APPS.OZF_WORKSHEET_HEADERS_PKG dependencies on OZF_WORKSHEET_HEADERS_B

Line 32: cursor C is select ROWID from OZF_WORKSHEET_HEADERS_B

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from OZF_WORKSHEET_HEADERS_B
33: where WORKSHEET_HEADER_ID = X_WORKSHEET_HEADER_ID
34: ;
35: begin
36: insert into OZF_WORKSHEET_HEADERS_B (

Line 36: insert into OZF_WORKSHEET_HEADERS_B (

32: cursor C is select ROWID from OZF_WORKSHEET_HEADERS_B
33: where WORKSHEET_HEADER_ID = X_WORKSHEET_HEADER_ID
34: ;
35: begin
36: insert into OZF_WORKSHEET_HEADERS_B (
37: FORECAST_START_DATE,
38: FORECAST_END_DATE,
39: CURRENCY_CODE,
40: FORECAST_GENERATED,

Line 169: from OZF_WORKSHEET_HEADERS_B

165: PRICE_LIST_ID,
166: FORECAST_UOM_CODE,
167: INCREMENT_QUOTA,
168: OFFER_TYPE
169: from OZF_WORKSHEET_HEADERS_B
170: where WORKSHEET_HEADER_ID = X_WORKSHEET_HEADER_ID
171: for update of WORKSHEET_HEADER_ID nowait;
172: recinfo c%rowtype;
173:

Line 276: update OZF_WORKSHEET_HEADERS_B set

272: X_LAST_UPDATED_BY in NUMBER,
273: X_LAST_UPDATE_LOGIN in NUMBER
274: ) is
275: begin
276: update OZF_WORKSHEET_HEADERS_B set
277: FORECAST_START_DATE = X_FORECAST_START_DATE,
278: FORECAST_END_DATE = X_FORECAST_END_DATE,
279: CURRENCY_CODE = X_CURRENCY_CODE,
280: FORECAST_GENERATED = X_FORECAST_GENERATED,

Line 330: delete from OZF_WORKSHEET_HEADERS_B

326: if (sql%notfound) then
327: raise no_data_found;
328: end if;
329:
330: delete from OZF_WORKSHEET_HEADERS_B
331: where WORKSHEET_HEADER_ID = X_WORKSHEET_HEADER_ID;
332:
333: if (sql%notfound) then
334: raise no_data_found;

Line 344: from OZF_WORKSHEET_HEADERS_B B

340: begin
341: delete from OZF_WORKSHEET_HEADERS_TL T
342: where not exists
343: (select NULL
344: from OZF_WORKSHEET_HEADERS_B B
345: where B.WORKSHEET_HEADER_ID = T.WORKSHEET_HEADER_ID
346: );
347:
348: update OZF_WORKSHEET_HEADERS_TL T set (