APPS.OKE_DELIVERABLES_PKG dependencies on OKE_DELIVERABLES_B

Line 45: cursor C is select ROWID from OKE_DELIVERABLES_B

41: X_LAST_UPDATE_DATE in DATE,
42: X_LAST_UPDATED_BY in NUMBER,
43: X_LAST_UPDATE_LOGIN in NUMBER
44: ) is
45: cursor C is select ROWID from OKE_DELIVERABLES_B
46: where DELIVERABLE_ID = X_DELIVERABLE_ID
47: ;
48: begin
49: insert into OKE_DELIVERABLES_B (

Line 49: insert into OKE_DELIVERABLES_B (

45: cursor C is select ROWID from OKE_DELIVERABLES_B
46: where DELIVERABLE_ID = X_DELIVERABLE_ID
47: ;
48: begin
49: insert into OKE_DELIVERABLES_B (
50: CURRENCY_CODE,
51: UNIT_PRICE,
52: UNIT_NUMBER,
53: UOM_CODE,

Line 231: from OKE_DELIVERABLES_B

227: ATTRIBUTE12,
228: ATTRIBUTE13,
229: ATTRIBUTE14,
230: ATTRIBUTE15
231: from OKE_DELIVERABLES_B
232: where DELIVERABLE_ID = X_DELIVERABLE_ID
233: for update of DELIVERABLE_ID nowait;
234: recinfo c%rowtype;
235:

Line 374: update OKE_DELIVERABLES_B

370: X_LAST_UPDATED_BY in NUMBER,
371: X_LAST_UPDATE_LOGIN in NUMBER
372: ) is
373: begin
374: update OKE_DELIVERABLES_B
375: set
376: CURRENCY_CODE = X_CURRENCY_CODE,
377: UNIT_PRICE = X_UNIT_PRICE,
378: UOM_CODE = X_UOM_CODE,

Line 441: delete from OKE_DELIVERABLES_B

437: if (sql%notfound) then
438: raise no_data_found;
439: end if;
440:
441: delete from OKE_DELIVERABLES_B
442: where DELIVERABLE_ID = X_DELIVERABLE_ID;
443:
444: if (sql%notfound) then
445: raise no_data_found;

Line 455: from OKE_DELIVERABLES_B B

451: begin
452: delete from OKE_DELIVERABLES_TL T
453: where not exists
454: (select NULL
455: from OKE_DELIVERABLES_B B
456: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
457: );
458:
459: update OKE_DELIVERABLES_TL T set (