APPS.ZX_FC_CODES_PKG dependencies on ZX_FC_CODES_TL

Line 158: insert into ZX_FC_CODES_TL (

154: X_PROGRAM_ID,
155: X_Program_Login_Id,
156: X_OBJECT_VERSION_NUMBER
157: );
158: insert into ZX_FC_CODES_TL (
159: CLASSIFICATION_ID,
160: CLASSIFICATION_NAME,
161: CREATED_BY,
162: CREATION_DATE,

Line 182: from ZX_FC_CODES_TL T

178: from FND_LANGUAGES L
179: where L.INSTALLED_FLAG in ('I', 'B')
180: and not exists
181: (select NULL
182: from ZX_FC_CODES_TL T
183: where T.CLASSIFICATION_ID = X_CLASSIFICATION_ID
184: and T.LANGUAGE = L.LANGUAGE_CODE);
185: open c;
186: fetch c into X_ROWID;

Line 429: from ZX_FC_CODES_TL

425: recinfo c%rowtype;
426: cursor c1 is select
427: CLASSIFICATION_NAME,
428: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
429: from ZX_FC_CODES_TL
430: where CLASSIFICATION_ID = X_CLASSIFICATION_ID
431: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
432: for update of CLASSIFICATION_ID nowait;
433: begin

Line 597: update ZX_FC_CODES_TL set

593: where CLASSIFICATION_ID = X_CLASSIFICATION_ID;
594: if (sql%notfound) then
595: raise no_data_found;
596: end if;
597: update ZX_FC_CODES_TL set
598: CLASSIFICATION_NAME = X_CLASSIFICATION_NAME,
599: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
600: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
601: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 647: delete from ZX_FC_CODES_TL

643: procedure DELETE_ROW (
644: X_CLASSIFICATION_ID in NUMBER
645: ) is
646: begin
647: delete from ZX_FC_CODES_TL
648: where CLASSIFICATION_ID = X_CLASSIFICATION_ID;
649: if (sql%notfound) then
650: raise no_data_found;
651: end if;

Line 662: delete from ZX_FC_CODES_TL T

658:
659: procedure ADD_LANGUAGE
660: is
661: begin
662: delete from ZX_FC_CODES_TL T
663: where not exists
664: (select NULL
665: from ZX_FC_CODES_B B
666: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID

Line 668: update ZX_FC_CODES_TL T set (

664: (select NULL
665: from ZX_FC_CODES_B B
666: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
667: );
668: update ZX_FC_CODES_TL T set (
669: CLASSIFICATION_NAME
670: ) = (select
671: B.CLASSIFICATION_NAME
672: from ZX_FC_CODES_TL B

Line 672: from ZX_FC_CODES_TL B

668: update ZX_FC_CODES_TL T set (
669: CLASSIFICATION_NAME
670: ) = (select
671: B.CLASSIFICATION_NAME
672: from ZX_FC_CODES_TL B
673: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
674: and B.LANGUAGE = T.SOURCE_LANG)
675: where (
676: T.CLASSIFICATION_ID,

Line 681: from ZX_FC_CODES_TL SUBB, ZX_FC_CODES_TL SUBT

677: T.LANGUAGE
678: ) in (select
679: SUBT.CLASSIFICATION_ID,
680: SUBT.LANGUAGE
681: from ZX_FC_CODES_TL SUBB, ZX_FC_CODES_TL SUBT
682: where SUBB.CLASSIFICATION_ID = SUBT.CLASSIFICATION_ID
683: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
684: and (SUBB.CLASSIFICATION_NAME <> SUBT.CLASSIFICATION_NAME
685: ));

Line 686: insert into ZX_FC_CODES_TL (

682: where SUBB.CLASSIFICATION_ID = SUBT.CLASSIFICATION_ID
683: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
684: and (SUBB.CLASSIFICATION_NAME <> SUBT.CLASSIFICATION_NAME
685: ));
686: insert into ZX_FC_CODES_TL (
687: CLASSIFICATION_ID,
688: CLASSIFICATION_NAME,
689: CREATED_BY,
690: CREATION_DATE,

Line 706: from ZX_FC_CODES_TL B, FND_LANGUAGES L

702: B.LAST_UPDATE_DATE,
703: B.LAST_UPDATE_LOGIN,
704: L.LANGUAGE_CODE,
705: B.SOURCE_LANG
706: from ZX_FC_CODES_TL B, FND_LANGUAGES L
707: where L.INSTALLED_FLAG in ('I', 'B')
708: and B.LANGUAGE = userenv('LANG')
709: and not exists
710: (select NULL

Line 711: from ZX_FC_CODES_TL T

707: where L.INSTALLED_FLAG in ('I', 'B')
708: and B.LANGUAGE = userenv('LANG')
709: and not exists
710: (select NULL
711: from ZX_FC_CODES_TL T
712: where T.CLASSIFICATION_ID = B.CLASSIFICATION_ID
713: and T.LANGUAGE = L.LANGUAGE_CODE);
714:
715: /* Logic to delete/update/insert into zx_fc_codes_denorm_b table */