DBA Data[Home] [Help]

APPS.JTF_AMV_ATTCHS_PKG dependencies on JTF_AMV_ATTACHMENTS

Line 98: FROM JTF_AMV_ATTACHMENTS

94: -- Exception is thrown otherwise.
95:
96: select LAST_UPDATED_BY, LAST_UPDATE_DATE
97: into db_luby, db_ludate
98: FROM JTF_AMV_ATTACHMENTS
99: where ATTACHMENT_ID = X_ATTACHMENT_ID;
100:
101: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
102: db_ludate, X_CUSTOM_MODE)) then

Line 269: cursor C is select ROWID from JTF_AMV_ATTACHMENTS

265: X_ATTACHMENT_SUB_TYPE in VARCHAR2 := NULL,
266: X_DOCUMENT_ID in NUMBER := NULL,
267: X_SECURED_FLAG in VARCHAR2 := NULL
268: ) AS
269: cursor C is select ROWID from JTF_AMV_ATTACHMENTS
270: where attachment_id = x_attachment_id
271: ;
272: begin
273: insert into JTF_AMV_ATTACHMENTS

Line 273: insert into JTF_AMV_ATTACHMENTS

269: cursor C is select ROWID from JTF_AMV_ATTACHMENTS
270: where attachment_id = x_attachment_id
271: ;
272: begin
273: insert into JTF_AMV_ATTACHMENTS
274: (
275: ATTACHMENT_ID,
276: LAST_UPDATE_DATE,
277: LAST_UPDATED_BY,

Line 443: Update JTF_AMV_ATTACHMENTS SET

439: X_DOCUMENT_ID in NUMBER := NULL,
440: X_SECURED_FLAG in VARCHAR2 := NULL
441: ) AS
442: BEGIN
443: Update JTF_AMV_ATTACHMENTS SET
444: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
445: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
446: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
447: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,