APPS.OKC_BUSINESS_VARIABLES_PVT dependencies on OKC_BUS_VARIABLES_TL

Line 175: insert into OKC_BUS_VARIABLES_TL (

171: X_VARIABLE_SOURCE
172:
173: );
174:
175: insert into OKC_BUS_VARIABLES_TL (
176: VARIABLE_CODE,
177: VARIABLE_NAME,
178: DESCRIPTION,
179: CREATED_BY,

Line 201: from OKC_BUS_VARIABLES_TL T

197: from FND_LANGUAGES L
198: where L.INSTALLED_FLAG in ('I', 'B')
199: and not exists
200: (select NULL
201: from OKC_BUS_VARIABLES_TL T
202: where T.VARIABLE_CODE = X_VARIABLE_CODE
203: and T.LANGUAGE = L.LANGUAGE_CODE);
204:
205: open c;

Line 298: from OKC_BUS_VARIABLES_TL

294: cursor c1 is select
295: VARIABLE_NAME,
296: DESCRIPTION,
297: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
298: from OKC_BUS_VARIABLES_TL
299: where VARIABLE_CODE = X_VARIABLE_CODE
300: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
301: for update of VARIABLE_CODE nowait;
302: begin

Line 486: update OKC_BUS_VARIABLES_TL set

482: if (sql%notfound) then
483: raise no_data_found;
484: end if;
485:
486: update OKC_BUS_VARIABLES_TL set
487: VARIABLE_NAME = X_VARIABLE_NAME,
488: DESCRIPTION = X_DESCRIPTION,
489: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
490: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 510: delete from OKC_BUS_VARIABLES_TL

506: CURSOR variable_doc_assoc_csr (cp_variable_code IN VARCHAR) IS
507: SELECT VARIABLE_CODE FROM OKC_VARIABLE_DOC_TYPES
508: WHERE VARIABLE_CODE = cp_variable_code;
509: begin
510: delete from OKC_BUS_VARIABLES_TL
511: where VARIABLE_CODE = X_VARIABLE_CODE;
512:
513: if (sql%notfound) then
514: raise no_data_found;

Line 559: delete from OKC_BUS_VARIABLES_TL T

555:
556: procedure ADD_LANGUAGE
557: is
558: begin
559: delete from OKC_BUS_VARIABLES_TL T
560: where not exists
561: (select NULL
562: from OKC_BUS_VARIABLES_B B
563: where B.VARIABLE_CODE = T.VARIABLE_CODE

Line 566: update OKC_BUS_VARIABLES_TL T set (

562: from OKC_BUS_VARIABLES_B B
563: where B.VARIABLE_CODE = T.VARIABLE_CODE
564: );
565:
566: update OKC_BUS_VARIABLES_TL T set (
567: VARIABLE_NAME,
568: DESCRIPTION
569: ) = (select
570: B.VARIABLE_NAME,

Line 572: from OKC_BUS_VARIABLES_TL B

568: DESCRIPTION
569: ) = (select
570: B.VARIABLE_NAME,
571: B.DESCRIPTION
572: from OKC_BUS_VARIABLES_TL B
573: where B.VARIABLE_CODE = T.VARIABLE_CODE
574: and B.LANGUAGE = T.SOURCE_LANG)
575: where (
576: T.VARIABLE_CODE,

Line 581: from OKC_BUS_VARIABLES_TL SUBB, OKC_BUS_VARIABLES_TL SUBT

577: T.LANGUAGE
578: ) in (select
579: SUBT.VARIABLE_CODE,
580: SUBT.LANGUAGE
581: from OKC_BUS_VARIABLES_TL SUBB, OKC_BUS_VARIABLES_TL SUBT
582: where SUBB.VARIABLE_CODE = SUBT.VARIABLE_CODE
583: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
584: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
585: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 590: insert into OKC_BUS_VARIABLES_TL (

586: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
587: or SUBB.VARIABLE_NAME <> SUBT.VARIABLE_NAME
588: ));
589:
590: insert into OKC_BUS_VARIABLES_TL (
591: VARIABLE_CODE,
592: VARIABLE_NAME,
593: DESCRIPTION,
594: CREATED_BY,

Line 612: from OKC_BUS_VARIABLES_TL B, FND_LANGUAGES L

608: B.LAST_UPDATED_BY,
609: B.LAST_UPDATE_LOGIN,
610: L.LANGUAGE_CODE,
611: B.SOURCE_LANG
612: from OKC_BUS_VARIABLES_TL B, FND_LANGUAGES L
613: where L.INSTALLED_FLAG in ('I', 'B')
614: and B.LANGUAGE = userenv('LANG')
615: and not exists
616: (select NULL

Line 617: from OKC_BUS_VARIABLES_TL T

613: where L.INSTALLED_FLAG in ('I', 'B')
614: and B.LANGUAGE = userenv('LANG')
615: and not exists
616: (select NULL
617: from OKC_BUS_VARIABLES_TL T
618: where T.VARIABLE_CODE = B.VARIABLE_CODE
619: and T.LANGUAGE = L.LANGUAGE_CODE);
620: end ADD_LANGUAGE;
621: