APPS.OKC_BUS_DOC_TYPES_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 36: cursor C is select ROWID from OKC_BUS_DOC_TYPES_B

32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is select ROWID from OKC_BUS_DOC_TYPES_B
37: where DOCUMENT_TYPE = X_DOCUMENT_TYPE
38: ;
39: begin
40: insert into OKC_BUS_DOC_TYPES_B (

Line 40: insert into OKC_BUS_DOC_TYPES_B (

36: cursor C is select ROWID from OKC_BUS_DOC_TYPES_B
37: where DOCUMENT_TYPE = X_DOCUMENT_TYPE
38: ;
39: begin
40: insert into OKC_BUS_DOC_TYPES_B (
41: CONTRACT_TERMS_FUNCTION,
42: ENABLE_DELIVERABLES_YN,
43: NOTIFICATION_HEADER_FUNCTION,
44: DOCUMENT_TYPE,

Line 191: from OKC_BUS_DOC_TYPES_B

187: ENABLE_ATTACHED_DOC_FLAG,
188: VARIABLE_RESOLUTION_AM,
189: APPLICATION_ID,
190: OBJECT_VERSION_NUMBER
191: from OKC_BUS_DOC_TYPES_B
192: where DOCUMENT_TYPE = X_DOCUMENT_TYPE
193: for update of DOCUMENT_TYPE nowait;
194: recinfo c%rowtype;
195:

Line 265: update OKC_BUS_DOC_TYPES_B set

261: X_LAST_UPDATED_BY in NUMBER,
262: X_LAST_UPDATE_LOGIN in NUMBER
263: ) is
264: begin
265: update OKC_BUS_DOC_TYPES_B set
266: CONTRACT_TERMS_FUNCTION = X_CONTRACT_TERMS_FUNCTION,
267: ENABLE_DELIVERABLES_YN = X_ENABLE_DELIVERABLES_YN,
268: NOTIFICATION_HEADER_FUNCTION = X_NOTIFICATION_HEADER_FUNCTION,
269: INTENT = X_INTENT,

Line 331: delete from OKC_BUS_DOC_TYPES_B

327: if (sql%notfound) then
328: raise no_data_found;
329: end if;
330:
331: delete from OKC_BUS_DOC_TYPES_B
332: where DOCUMENT_TYPE = X_DOCUMENT_TYPE;
333:
334: if (sql%notfound) then
335: raise no_data_found;

Line 345: from OKC_BUS_DOC_TYPES_B B

341: begin
342: delete from OKC_BUS_DOC_TYPES_TL T
343: where not exists
344: (select NULL
345: from OKC_BUS_DOC_TYPES_B B
346: where B.DOCUMENT_TYPE = T.DOCUMENT_TYPE
347: );
348:
349: update OKC_BUS_DOC_TYPES_TL T set (