APPS.OKC_BUSINESS_VARIABLES_PVT dependencies on OKC_BUS_VARIABLES_TL

Line 199: insert into OKC_BUS_VARIABLES_TL (

195: X_MRV_FLAG, -- MRV Changes
196: X_MRV_TMPL_CODE -- MRV Changes
197: );
198:
199: insert into OKC_BUS_VARIABLES_TL (
200: VARIABLE_CODE,
201: VARIABLE_NAME,
202: DESCRIPTION,
203: CREATED_BY,

Line 225: from OKC_BUS_VARIABLES_TL T

221: from FND_LANGUAGES L
222: where L.INSTALLED_FLAG in ('I', 'B')
223: and not exists
224: (select NULL
225: from OKC_BUS_VARIABLES_TL T
226: where T.VARIABLE_CODE = X_VARIABLE_CODE
227: and T.LANGUAGE = L.LANGUAGE_CODE);
228:
229: open c;

Line 338: from OKC_BUS_VARIABLES_TL

334: cursor c1 is select
335: VARIABLE_NAME,
336: DESCRIPTION,
337: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
338: from OKC_BUS_VARIABLES_TL
339: where VARIABLE_CODE = X_VARIABLE_CODE
340: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
341: for update of VARIABLE_CODE nowait;
342: begin

Line 563: update OKC_BUS_VARIABLES_TL set

559: if (sql%notfound) then
560: raise no_data_found;
561: end if;
562:
563: update OKC_BUS_VARIABLES_TL set
564: VARIABLE_NAME = X_VARIABLE_NAME,
565: DESCRIPTION = X_DESCRIPTION,
566: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
567: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 587: delete from OKC_BUS_VARIABLES_TL

583: CURSOR variable_doc_assoc_csr (cp_variable_code IN VARCHAR) IS
584: SELECT VARIABLE_CODE FROM OKC_VARIABLE_DOC_TYPES
585: WHERE VARIABLE_CODE = cp_variable_code;
586: begin
587: delete from OKC_BUS_VARIABLES_TL
588: where VARIABLE_CODE = X_VARIABLE_CODE;
589:
590: if (sql%notfound) then
591: raise no_data_found;

Line 636: delete from OKC_BUS_VARIABLES_TL T

632:
633: procedure ADD_LANGUAGE
634: is
635: begin
636: delete from OKC_BUS_VARIABLES_TL T
637: where not exists
638: (select NULL
639: from OKC_BUS_VARIABLES_B B
640: where B.VARIABLE_CODE = T.VARIABLE_CODE

Line 643: update OKC_BUS_VARIABLES_TL T set (

639: from OKC_BUS_VARIABLES_B B
640: where B.VARIABLE_CODE = T.VARIABLE_CODE
641: );
642:
643: update OKC_BUS_VARIABLES_TL T set (
644: VARIABLE_NAME,
645: DESCRIPTION
646: ) = (select
647: B.VARIABLE_NAME,

Line 649: from OKC_BUS_VARIABLES_TL B

645: DESCRIPTION
646: ) = (select
647: B.VARIABLE_NAME,
648: B.DESCRIPTION
649: from OKC_BUS_VARIABLES_TL B
650: where B.VARIABLE_CODE = T.VARIABLE_CODE
651: and B.LANGUAGE = T.SOURCE_LANG)
652: where (
653: T.VARIABLE_CODE,

Line 658: from OKC_BUS_VARIABLES_TL SUBB, OKC_BUS_VARIABLES_TL SUBT

654: T.LANGUAGE
655: ) in (select
656: SUBT.VARIABLE_CODE,
657: SUBT.LANGUAGE
658: from OKC_BUS_VARIABLES_TL SUBB, OKC_BUS_VARIABLES_TL SUBT
659: where SUBB.VARIABLE_CODE = SUBT.VARIABLE_CODE
660: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
661: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
662: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 667: insert into OKC_BUS_VARIABLES_TL (

663: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
664: or SUBB.VARIABLE_NAME <> SUBT.VARIABLE_NAME
665: ));
666:
667: insert into OKC_BUS_VARIABLES_TL (
668: VARIABLE_CODE,
669: VARIABLE_NAME,
670: DESCRIPTION,
671: CREATED_BY,

Line 689: from OKC_BUS_VARIABLES_TL B, FND_LANGUAGES L

685: B.LAST_UPDATED_BY,
686: B.LAST_UPDATE_LOGIN,
687: L.LANGUAGE_CODE,
688: B.SOURCE_LANG
689: from OKC_BUS_VARIABLES_TL B, FND_LANGUAGES L
690: where L.INSTALLED_FLAG in ('I', 'B')
691: and B.LANGUAGE = userenv('LANG')
692: and not exists
693: (select NULL

Line 694: from OKC_BUS_VARIABLES_TL T

690: where L.INSTALLED_FLAG in ('I', 'B')
691: and B.LANGUAGE = userenv('LANG')
692: and not exists
693: (select NULL
694: from OKC_BUS_VARIABLES_TL T
695: where T.VARIABLE_CODE = B.VARIABLE_CODE
696: and T.LANGUAGE = L.LANGUAGE_CODE);
697: end ADD_LANGUAGE;
698: