APPS.OKC_DELIVERABLE_TYPES_PKG dependencies on OKC_DELIVERABLE_TYPES_B

Line 16: cursor C is select ROWID from OKC_DELIVERABLE_TYPES_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from OKC_DELIVERABLE_TYPES_B
17: where DELIVERABLE_TYPE_CODE = X_DELIVERABLE_TYPE_CODE
18: ;
19: begin
20: insert into OKC_DELIVERABLE_TYPES_B (

Line 20: insert into OKC_DELIVERABLE_TYPES_B (

16: cursor C is select ROWID from OKC_DELIVERABLE_TYPES_B
17: where DELIVERABLE_TYPE_CODE = X_DELIVERABLE_TYPE_CODE
18: ;
19: begin
20: insert into OKC_DELIVERABLE_TYPES_B (
21: DELIVERABLE_TYPE_CODE,
22: INTERNAL_FLAG,
23: OBJECT_VERSION_NUMBER,
24: CREATION_DATE,

Line 90: from OKC_DELIVERABLE_TYPES_B

86: ) is
87: cursor c is select
88: INTERNAL_FLAG,
89: OBJECT_VERSION_NUMBER
90: from OKC_DELIVERABLE_TYPES_B
91: where DELIVERABLE_TYPE_CODE = X_DELIVERABLE_TYPE_CODE
92: for update of DELIVERABLE_TYPE_CODE nowait;
93: recinfo c%rowtype;
94:

Line 149: update OKC_DELIVERABLE_TYPES_B set

145: X_LAST_UPDATED_BY in NUMBER,
146: X_LAST_UPDATE_LOGIN in NUMBER
147: ) is
148: begin
149: update OKC_DELIVERABLE_TYPES_B set
150: INTERNAL_FLAG = X_INTERNAL_FLAG,
151: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
152: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
153: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 187: delete from OKC_DELIVERABLE_TYPES_B

183: if (sql%notfound) then
184: raise no_data_found;
185: end if;
186:
187: delete from OKC_DELIVERABLE_TYPES_B
188: where DELIVERABLE_TYPE_CODE = X_DELIVERABLE_TYPE_CODE;
189:
190: if (sql%notfound) then
191: raise no_data_found;

Line 201: from OKC_DELIVERABLE_TYPES_B B

197: begin
198: delete from OKC_DELIVERABLE_TYPES_TL T
199: where not exists
200: (select NULL
201: from OKC_DELIVERABLE_TYPES_B B
202: where B.DELIVERABLE_TYPE_CODE = T.DELIVERABLE_TYPE_CODE
203: );
204:
205: update OKC_DELIVERABLE_TYPES_TL T set (