APPS.OKC_DELIVERABLE_TYPES_PKG dependencies on OKC_DELIVERABLE_TYPES_TL

Line 40: insert into OKC_DELIVERABLE_TYPES_TL (

36: X_LAST_UPDATED_BY,
37: X_LAST_UPDATE_LOGIN
38: );
39:
40: insert into OKC_DELIVERABLE_TYPES_TL (
41: DELIVERABLE_TYPE_CODE,
42: NAME,
43: DESCRIPTION,
44: CREATED_BY,

Line 66: from OKC_DELIVERABLE_TYPES_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from OKC_DELIVERABLE_TYPES_TL T
67: where T.DELIVERABLE_TYPE_CODE = X_DELIVERABLE_TYPE_CODE
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from OKC_DELIVERABLE_TYPES_TL

95: cursor c1 is select
96: NAME,
97: DESCRIPTION,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from OKC_DELIVERABLE_TYPES_TL
100: where DELIVERABLE_TYPE_CODE = X_DELIVERABLE_TYPE_CODE
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of DELIVERABLE_TYPE_CODE nowait;
103: begin

Line 161: update OKC_DELIVERABLE_TYPES_TL set

157: if (sql%notfound) then
158: raise no_data_found;
159: end if;
160:
161: update OKC_DELIVERABLE_TYPES_TL set
162: NAME = X_NAME,
163: DESCRIPTION = X_DESCRIPTION,
164: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 180: delete from OKC_DELIVERABLE_TYPES_TL

176: procedure DELETE_ROW (
177: X_DELIVERABLE_TYPE_CODE in VARCHAR2
178: ) is
179: begin
180: delete from OKC_DELIVERABLE_TYPES_TL
181: where DELIVERABLE_TYPE_CODE = X_DELIVERABLE_TYPE_CODE;
182:
183: if (sql%notfound) then
184: raise no_data_found;

Line 198: delete from OKC_DELIVERABLE_TYPES_TL T

194:
195: procedure ADD_LANGUAGE
196: is
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

Line 205: update OKC_DELIVERABLE_TYPES_TL T set (

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 (
206: NAME,
207: DESCRIPTION
208: ) = (select
209: B.NAME,

Line 211: from OKC_DELIVERABLE_TYPES_TL B

207: DESCRIPTION
208: ) = (select
209: B.NAME,
210: B.DESCRIPTION
211: from OKC_DELIVERABLE_TYPES_TL B
212: where B.DELIVERABLE_TYPE_CODE = T.DELIVERABLE_TYPE_CODE
213: and B.LANGUAGE = T.SOURCE_LANG)
214: where (
215: T.DELIVERABLE_TYPE_CODE,

Line 220: from OKC_DELIVERABLE_TYPES_TL SUBB, OKC_DELIVERABLE_TYPES_TL SUBT

216: T.LANGUAGE
217: ) in (select
218: SUBT.DELIVERABLE_TYPE_CODE,
219: SUBT.LANGUAGE
220: from OKC_DELIVERABLE_TYPES_TL SUBB, OKC_DELIVERABLE_TYPES_TL SUBT
221: where SUBB.DELIVERABLE_TYPE_CODE = SUBT.DELIVERABLE_TYPE_CODE
222: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
223: and (SUBB.NAME <> SUBT.NAME
224: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 229: insert into OKC_DELIVERABLE_TYPES_TL (

225: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
226: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
227: ));
228:
229: insert into OKC_DELIVERABLE_TYPES_TL (
230: DELIVERABLE_TYPE_CODE,
231: NAME,
232: DESCRIPTION,
233: CREATED_BY,

Line 251: from OKC_DELIVERABLE_TYPES_TL B, FND_LANGUAGES L

247: B.LAST_UPDATE_DATE,
248: B.LAST_UPDATE_LOGIN,
249: L.LANGUAGE_CODE,
250: B.SOURCE_LANG
251: from OKC_DELIVERABLE_TYPES_TL B, FND_LANGUAGES L
252: where L.INSTALLED_FLAG in ('I', 'B')
253: and B.LANGUAGE = userenv('LANG')
254: and not exists
255: (select NULL

Line 256: from OKC_DELIVERABLE_TYPES_TL T

252: where L.INSTALLED_FLAG in ('I', 'B')
253: and B.LANGUAGE = userenv('LANG')
254: and not exists
255: (select NULL
256: from OKC_DELIVERABLE_TYPES_TL T
257: where T.DELIVERABLE_TYPE_CODE = B.DELIVERABLE_TYPE_CODE
258: and T.LANGUAGE = L.LANGUAGE_CODE);
259: end ADD_LANGUAGE;
260: