APPS.ZX_FC_TYPES_PKG dependencies on ZX_FC_TYPES_TL

Line 139: insert into ZX_FC_TYPES_TL (

135: X_PROGRAM_ID,
136: X_Program_Login_Id,
137: X_OBJECT_VERSION_NUMBER
138: );
139: insert into ZX_FC_TYPES_TL (
140: CLASSIFICATION_TYPE_ID,
141: CLASSIFICATION_TYPE_NAME,
142: CREATED_BY,
143: CREATION_DATE,

Line 163: from ZX_FC_TYPES_TL T

159: from FND_LANGUAGES L
160: where L.INSTALLED_FLAG in ('I', 'B')
161: and not exists
162: (select NULL
163: from ZX_FC_TYPES_TL T
164: where T.CLASSIFICATION_TYPE_ID = X_CLASSIFICATION_TYPE_ID
165: and T.LANGUAGE = L.LANGUAGE_CODE);
166: open c;
167: fetch c into X_ROWID;

Line 327: from ZX_FC_TYPES_TL

323: recinfo c%rowtype;
324: cursor c1 is select
325: CLASSIFICATION_TYPE_NAME,
326: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
327: from ZX_FC_TYPES_TL
328: where CLASSIFICATION_TYPE_ID = X_CLASSIFICATION_TYPE_ID
329: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
330: for update of CLASSIFICATION_TYPE_ID nowait;
331: begin

Line 513: update ZX_FC_TYPES_TL set

509: where CLASSIFICATION_TYPE_ID = X_CLASSIFICATION_TYPE_ID;
510: if (sql%notfound) then
511: raise no_data_found;
512: end if;
513: update ZX_FC_TYPES_TL set
514: CLASSIFICATION_TYPE_NAME = X_CLASSIFICATION_TYPE_NAME,
515: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
516: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
517: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 565: delete from ZX_FC_TYPES_TL

561: procedure DELETE_ROW (
562: X_CLASSIFICATION_TYPE_ID in NUMBER
563: ) is
564: begin
565: delete from ZX_FC_TYPES_TL
566: where CLASSIFICATION_TYPE_ID = X_CLASSIFICATION_TYPE_ID;
567: if (sql%notfound) then
568: raise no_data_found;
569: end if;

Line 580: delete from ZX_FC_TYPES_TL T

576:
577: procedure ADD_LANGUAGE
578: is
579: begin
580: delete from ZX_FC_TYPES_TL T
581: where not exists
582: (select NULL
583: from ZX_FC_TYPES_B B
584: where B.CLASSIFICATION_TYPE_ID = T.CLASSIFICATION_TYPE_ID

Line 586: update ZX_FC_TYPES_TL T set (

582: (select NULL
583: from ZX_FC_TYPES_B B
584: where B.CLASSIFICATION_TYPE_ID = T.CLASSIFICATION_TYPE_ID
585: );
586: update ZX_FC_TYPES_TL T set (
587: CLASSIFICATION_TYPE_NAME
588: ) = (select
589: B.CLASSIFICATION_TYPE_NAME
590: from ZX_FC_TYPES_TL B

Line 590: from ZX_FC_TYPES_TL B

586: update ZX_FC_TYPES_TL T set (
587: CLASSIFICATION_TYPE_NAME
588: ) = (select
589: B.CLASSIFICATION_TYPE_NAME
590: from ZX_FC_TYPES_TL B
591: where B.CLASSIFICATION_TYPE_ID = T.CLASSIFICATION_TYPE_ID
592: and B.LANGUAGE = T.SOURCE_LANG)
593: where (
594: T.CLASSIFICATION_TYPE_ID,

Line 599: from ZX_FC_TYPES_TL SUBB, ZX_FC_TYPES_TL SUBT

595: T.LANGUAGE
596: ) in (select
597: SUBT.CLASSIFICATION_TYPE_ID,
598: SUBT.LANGUAGE
599: from ZX_FC_TYPES_TL SUBB, ZX_FC_TYPES_TL SUBT
600: where SUBB.CLASSIFICATION_TYPE_ID = SUBT.CLASSIFICATION_TYPE_ID
601: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
602: and (SUBB.CLASSIFICATION_TYPE_NAME <> SUBT.CLASSIFICATION_TYPE_NAME
603: or (SUBB.CLASSIFICATION_TYPE_NAME is null and SUBT.CLASSIFICATION_TYPE_NAME is not null)

Line 606: insert into ZX_FC_TYPES_TL (

602: and (SUBB.CLASSIFICATION_TYPE_NAME <> SUBT.CLASSIFICATION_TYPE_NAME
603: or (SUBB.CLASSIFICATION_TYPE_NAME is null and SUBT.CLASSIFICATION_TYPE_NAME is not null)
604: or (SUBB.CLASSIFICATION_TYPE_NAME is not null and SUBT.CLASSIFICATION_TYPE_NAME is null)
605: ));
606: insert into ZX_FC_TYPES_TL (
607: CLASSIFICATION_TYPE_ID,
608: CLASSIFICATION_TYPE_NAME,
609: CREATED_BY,
610: CREATION_DATE,

Line 626: from ZX_FC_TYPES_TL B, FND_LANGUAGES L

622: B.LAST_UPDATE_DATE,
623: B.LAST_UPDATE_LOGIN,
624: L.LANGUAGE_CODE,
625: B.SOURCE_LANG
626: from ZX_FC_TYPES_TL B, FND_LANGUAGES L
627: where L.INSTALLED_FLAG in ('I', 'B')
628: and B.LANGUAGE = userenv('LANG')
629: and not exists
630: (select NULL

Line 631: from ZX_FC_TYPES_TL T

627: where L.INSTALLED_FLAG in ('I', 'B')
628: and B.LANGUAGE = userenv('LANG')
629: and not exists
630: (select NULL
631: from ZX_FC_TYPES_TL T
632: where T.CLASSIFICATION_TYPE_ID = B.CLASSIFICATION_TYPE_ID
633: and T.LANGUAGE = L.LANGUAGE_CODE);
634: end ADD_LANGUAGE;
635: