APPS.JTF_AMV_ITEMS_PKG dependencies on JTF_AMV_ITEMS_TL

Line 217: from JTF_AMV_ITEMS_TL

213: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
214:
215: select LAST_UPDATED_BY, LAST_UPDATE_DATE
216: into db_luby, db_ludate
217: from JTF_AMV_ITEMS_TL
218: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
219: and ITEM_ID = X_ITEM_ID;
220:
221: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 224: update JTF_AMV_ITEMS_TL set

220:
221: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
222: db_ludate, X_CUSTOM_MODE)) then
223:
224: update JTF_AMV_ITEMS_TL set
225: ITEM_NAME = X_ITEM_NAME,
226: DESCRIPTION = x_description,
227: TEXT_STRING = X_TEXT_STRING,
228: LAST_UPDATE_DATE = f_ludate,

Line 375: insert into JTF_AMV_ITEMS_TL (

371: X_LAST_UPDATED_BY,
372: X_LAST_UPDATE_LOGIN
373: );
374:
375: insert into JTF_AMV_ITEMS_TL (
376: ITEM_ID,
377: LAST_UPDATE_DATE,
378: LAST_UPDATED_BY,
379: CREATION_DATE,

Line 403: from JTF_AMV_ITEMS_TL T

399: from FND_LANGUAGES L
400: where L.INSTALLED_FLAG in ('I', 'B')
401: and not exists
402: (select NULL
403: from JTF_AMV_ITEMS_TL T
404: where T.ITEM_ID = X_ITEM_ID
405: and T.LANGUAGE = L.LANGUAGE_CODE);
406:
407: open c;

Line 502: from JTF_AMV_ITEMS_TL

498: ITEM_NAME,
499: DESCRIPTION,
500: TEXT_STRING,
501: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
502: from JTF_AMV_ITEMS_TL
503: where ITEM_ID = X_ITEM_ID
504: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
505: for update of ITEM_ID nowait;
506: begin

Line 699: update JTF_AMV_ITEMS_TL set

695: if (sql%notfound) then
696: raise no_data_found;
697: end if;
698:
699: update JTF_AMV_ITEMS_TL set
700: ITEM_NAME = decode( X_ITEM_NAME,
701: FND_API.G_MISS_CHAR, ITEM_NAME, X_ITEM_NAME),
702: DESCRIPTION = decode( X_DESCRIPTION,
703: FND_API.G_MISS_CHAR, DESCRIPTION, X_DESCRIPTION),

Line 722: delete from JTF_AMV_ITEMS_TL

718: procedure DELETE_ROW (
719: X_ITEM_ID in NUMBER
720: ) is
721: begin
722: delete from JTF_AMV_ITEMS_TL
723: where ITEM_ID = X_ITEM_ID;
724:
725: if (sql%notfound) then
726: raise no_data_found;

Line 740: delete from JTF_AMV_ITEMS_TL T

736:
737: procedure ADD_LANGUAGE
738: is
739: begin
740: delete from JTF_AMV_ITEMS_TL T
741: where not exists
742: (select NULL
743: from JTF_AMV_ITEMS_B B
744: where B.ITEM_ID = T.ITEM_ID

Line 747: update JTF_AMV_ITEMS_TL T set (

743: from JTF_AMV_ITEMS_B B
744: where B.ITEM_ID = T.ITEM_ID
745: );
746:
747: update JTF_AMV_ITEMS_TL T set (
748: ITEM_NAME,
749: DESCRIPTION,
750: TEXT_STRING
751: ) = (select

Line 755: from JTF_AMV_ITEMS_TL B

751: ) = (select
752: B.ITEM_NAME,
753: B.DESCRIPTION,
754: B.TEXT_STRING
755: from JTF_AMV_ITEMS_TL B
756: where B.ITEM_ID = T.ITEM_ID
757: and B.LANGUAGE = T.SOURCE_LANG)
758: where (
759: T.ITEM_ID,

Line 764: from JTF_AMV_ITEMS_TL SUBB, JTF_AMV_ITEMS_TL SUBT

760: T.LANGUAGE
761: ) in (select
762: SUBT.ITEM_ID,
763: SUBT.LANGUAGE
764: from JTF_AMV_ITEMS_TL SUBB, JTF_AMV_ITEMS_TL SUBT
765: where SUBB.ITEM_ID = SUBT.ITEM_ID
766: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
767: and (SUBB.ITEM_NAME <> SUBT.ITEM_NAME
768: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 776: insert into JTF_AMV_ITEMS_TL (

772: or (SUBB.TEXT_STRING is null and SUBT.TEXT_STRING is not null)
773: or (SUBB.TEXT_STRING is not null and SUBT.TEXT_STRING is null)
774: ));
775:
776: insert into JTF_AMV_ITEMS_TL (
777: ITEM_ID,
778: LAST_UPDATE_DATE,
779: LAST_UPDATED_BY,
780: CREATION_DATE,

Line 800: from JTF_AMV_ITEMS_TL B, FND_LANGUAGES L

796: B.DESCRIPTION,
797: B.TEXT_STRING,
798: L.LANGUAGE_CODE,
799: B.SOURCE_LANG
800: from JTF_AMV_ITEMS_TL B, FND_LANGUAGES L
801: where L.INSTALLED_FLAG in ('I', 'B')
802: and B.LANGUAGE = userenv('LANG')
803: and not exists
804: (select NULL

Line 805: from JTF_AMV_ITEMS_TL T

801: where L.INSTALLED_FLAG in ('I', 'B')
802: and B.LANGUAGE = userenv('LANG')
803: and not exists
804: (select NULL
805: from JTF_AMV_ITEMS_TL T
806: where T.ITEM_ID = B.ITEM_ID
807: and T.LANGUAGE = L.LANGUAGE_CODE);
808: end ADD_LANGUAGE;
809: