APPS.OKC_BUS_DOC_EVENTS_PVT dependencies on OKC_BUS_DOC_EVENTS_B

Line 18: cursor C is select ROWID from OKC_BUS_DOC_EVENTS_B

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from OKC_BUS_DOC_EVENTS_B
19: where BUS_DOC_EVENT_ID = X_BUS_DOC_EVENT_ID
20: ;
21: begin
22: insert into OKC_BUS_DOC_EVENTS_B (

Line 22: insert into OKC_BUS_DOC_EVENTS_B (

18: cursor C is select ROWID from OKC_BUS_DOC_EVENTS_B
19: where BUS_DOC_EVENT_ID = X_BUS_DOC_EVENT_ID
20: ;
21: begin
22: insert into OKC_BUS_DOC_EVENTS_B (
23: BUS_DOC_EVENT_ID,
24: BUSINESS_EVENT_CODE,
25: BUS_DOC_TYPE,
26: BEFORE_AFTER,

Line 101: from OKC_BUS_DOC_EVENTS_B

97: BUS_DOC_TYPE,
98: BEFORE_AFTER,
99: START_END_QUALIFIER
100: --OBJECT_VERSION_NUMBER
101: from OKC_BUS_DOC_EVENTS_B
102: where BUS_DOC_EVENT_ID = X_BUS_DOC_EVENT_ID
103: for update of BUS_DOC_EVENT_ID nowait;
104: recinfo c%rowtype;
105:

Line 159: update OKC_BUS_DOC_EVENTS_B set

155: X_LAST_UPDATED_BY in NUMBER,
156: X_LAST_UPDATE_LOGIN in NUMBER
157: ) is
158: begin
159: update OKC_BUS_DOC_EVENTS_B set
160: BUS_DOC_EVENT_ID = X_BUS_DOC_EVENT_ID,
161: BUSINESS_EVENT_CODE = X_BUSINESS_EVENT_CODE,
162: BUS_DOC_TYPE = X_BUS_DOC_TYPE,
163: BEFORE_AFTER = X_BEFORE_AFTER,

Line 201: delete from OKC_BUS_DOC_EVENTS_B

197: if (sql%notfound) then
198: raise no_data_found;
199: end if;
200:
201: delete from OKC_BUS_DOC_EVENTS_B
202: where BUS_DOC_EVENT_ID = X_BUS_DOC_EVENT_ID;
203:
204: if (sql%notfound) then
205: raise no_data_found;

Line 215: from OKC_BUS_DOC_EVENTS_B B

211: begin
212: delete from OKC_BUS_DOC_EVENTS_TL T
213: where not exists
214: (select NULL
215: from OKC_BUS_DOC_EVENTS_B B
216: where B.BUS_DOC_EVENT_ID = T.BUS_DOC_EVENT_ID
217: );
218:
219: update OKC_BUS_DOC_EVENTS_TL T set (