APPS.OKE_BILLING_METHODS_PKG dependencies on OKE_BILLING_METHODS_TL

Line 97: insert into OKE_BILLING_METHODS_TL (

93: , X_ATTRIBUTE14
94: , X_ATTRIBUTE15
95: );
96:
97: insert into OKE_BILLING_METHODS_TL (
98: BILLING_METHOD_CODE
99: , LANGUAGE
100: , CREATION_DATE
101: , CREATED_BY

Line 123: from OKE_BILLING_METHODS_TL T

119: from FND_LANGUAGES L
120: where L.INSTALLED_FLAG in ('I', 'B')
121: and not exists
122: (select NULL
123: from OKE_BILLING_METHODS_TL T
124: where T.BILLING_METHOD_CODE = X_BILLING_METHOD_CODE
125: and T.LANGUAGE = L.LANGUAGE_CODE)
126: ;
127:

Line 196: from OKE_BILLING_METHODS_TL

192: cursor c1 is select
193: BILLING_METHOD_NAME
194: ,DESCRIPTION
195: ,decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
196: from OKE_BILLING_METHODS_TL
197: where BILLING_METHOD_CODE= X_BILLING_METHOD_CODE
198: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
199: for update of BILLING_METHOD_CODE nowait;
200: tlinfo c1%rowtype;

Line 344: update OKE_BILLING_METHODS_TL set

340: if (sql%notfound) then
341: raise no_data_found;
342: end if;
343:
344: update OKE_BILLING_METHODS_TL set
345: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
346: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
347: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
348: , BILLING_METHOD_NAME = X_BILLING_METHOD_NAME

Line 364: delete from OKE_BILLING_METHODS_TL T

360:
361: procedure ADD_LANGUAGE
362: is
363: begin
364: delete from OKE_BILLING_METHODS_TL T
365: where not exists
366: (select NULL
367: from OKE_BILLING_METHODS_B B
368: where B.BILLING_METHOD_CODE = T.BILLING_METHOD_CODE

Line 371: update OKE_BILLING_METHODS_TL T set (

367: from OKE_BILLING_METHODS_B B
368: where B.BILLING_METHOD_CODE = T.BILLING_METHOD_CODE
369: );
370:
371: update OKE_BILLING_METHODS_TL T set (
372: BILLING_METHOD_NAME,
373: DESCRIPTION
374: ) = (select
375: B.BILLING_METHOD_NAME,

Line 377: from OKE_BILLING_METHODS_TL B

373: DESCRIPTION
374: ) = (select
375: B.BILLING_METHOD_NAME,
376: B.DESCRIPTION
377: from OKE_BILLING_METHODS_TL B
378: where B.BILLING_METHOD_CODE = T.BILLING_METHOD_CODE
379: and B.LANGUAGE = T.SOURCE_LANG)
380: where (
381: T.BILLING_METHOD_CODE,

Line 386: from OKE_BILLING_METHODS_TL SUBB, OKE_BILLING_METHODS_TL SUBT

382: T.LANGUAGE
383: ) in (select
384: SUBT.BILLING_METHOD_CODE,
385: SUBT.LANGUAGE
386: from OKE_BILLING_METHODS_TL SUBB, OKE_BILLING_METHODS_TL SUBT
387: where SUBB.BILLING_METHOD_CODE = SUBT.BILLING_METHOD_CODE
388: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
389: and (SUBB.BILLING_METHOD_NAME <> SUBT.BILLING_METHOD_NAME
390: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 395: insert into OKE_BILLING_METHODS_TL (

391: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
392: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
393: ));
394:
395: insert into OKE_BILLING_METHODS_TL (
396: DESCRIPTION,
397: BILLING_METHOD_CODE,
398: CREATION_DATE,
399: CREATED_BY,

Line 417: from OKE_BILLING_METHODS_TL B, FND_LANGUAGES L

413: B.LAST_UPDATE_LOGIN,
414: B.BILLING_METHOD_NAME,
415: L.LANGUAGE_CODE,
416: B.SOURCE_LANG
417: from OKE_BILLING_METHODS_TL B, FND_LANGUAGES L
418: where L.INSTALLED_FLAG in ('I', 'B')
419: and B.LANGUAGE = userenv('LANG')
420: and not exists
421: (select NULL

Line 422: from OKE_BILLING_METHODS_TL T

418: where L.INSTALLED_FLAG in ('I', 'B')
419: and B.LANGUAGE = userenv('LANG')
420: and not exists
421: (select NULL
422: from OKE_BILLING_METHODS_TL T
423: where T.BILLING_METHOD_CODE = B.BILLING_METHOD_CODE
424: and T.LANGUAGE = L.LANGUAGE_CODE);
425: end ADD_LANGUAGE;
426: