APPS.JTF_AMV_ITEMS_PKG dependencies on JTF_AMV_ITEMS_B

Line 92: FROM JTF_AMV_ITEMS_B

88: -- Exception is thrown otherwise.
89:
90: select LAST_UPDATED_BY, LAST_UPDATE_DATE
91: into db_luby, db_ludate
92: FROM JTF_AMV_ITEMS_B
93: where ITEM_ID = X_ITEM_ID;
94:
95: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
96: db_ludate, X_CUSTOM_MODE)) then

Line 287: cursor C is select ROWID from JTF_AMV_ITEMS_B

283: X_ATTRIBUTE13 in VARCHAR2,
284: X_ATTRIBUTE14 in VARCHAR2,
285: X_ATTRIBUTE15 in VARCHAR2
286: ) is
287: cursor C is select ROWID from JTF_AMV_ITEMS_B
288: where ITEM_ID = X_ITEM_ID
289: ;
290: begin
291: insert into JTF_AMV_ITEMS_B (

Line 291: insert into JTF_AMV_ITEMS_B (

287: cursor C is select ROWID from JTF_AMV_ITEMS_B
288: where ITEM_ID = X_ITEM_ID
289: ;
290: begin
291: insert into JTF_AMV_ITEMS_B (
292: ITEM_ID,
293: EXTERNAL_ACCESS_FLAG,
294: PUBLICATION_DATE,
295: OBJECT_VERSION_NUMBER,

Line 492: from JTF_AMV_ITEMS_B

488: ATTRIBUTE10,
489: ATTRIBUTE11,
490: ATTRIBUTE12,
491: ATTRIBUTE13
492: from JTF_AMV_ITEMS_B
493: where ITEM_ID = X_ITEM_ID
494: for update of ITEM_ID nowait;
495: recinfo c%rowtype;
496:

Line 648: update JTF_AMV_ITEMS_B set

644: X_ATTRIBUTE14 in VARCHAR2,
645: X_ATTRIBUTE15 in VARCHAR2
646: ) is
647: begin
648: update JTF_AMV_ITEMS_B set
649: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
650: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
651: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
652: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 729: delete from JTF_AMV_ITEMS_B

725: if (sql%notfound) then
726: raise no_data_found;
727: end if;
728:
729: delete from JTF_AMV_ITEMS_B
730: where ITEM_ID = X_ITEM_ID;
731:
732: if (sql%notfound) then
733: raise no_data_found;

Line 743: from JTF_AMV_ITEMS_B B

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
745: );
746:
747: update JTF_AMV_ITEMS_TL T set (