DBA Data[Home] [Help]

APPS.JTF_AMV_ATTCHS_PKG dependencies on FND_LOAD_UTIL

Line 56: l_user_id number := fnd_load_util.owner_id(x_owner);

52: X_CUSTOM_MODE VARCHAR2 DEFAULT NULL,
53: X_LAST_UPDATE_DATE VARCHAR2 DEFAULT NULL
54: ) AS
55: --
56: l_user_id number := fnd_load_util.owner_id(x_owner);
57: l_row_id varchar2(2000);
58: l_ATTACHMENT_ID NUMBER;
59: L_OBJECT_VERSION_NUMBER NUMBER;
60: L_APPLICATION_ID NUMBER;

Line 88: f_luby := fnd_load_util.owner_id(x_owner);

84: L_DOCUMENT_ID := to_number(X_DOCUMENT_ID);
85:
86:
87: -- Translate owner to file_last_updated_by
88: f_luby := fnd_load_util.owner_id(x_owner);
89: -- Translate char last_update_date to date
90: f_ludate := to_date(nvl(x_last_update_date,sysdate ), 'YYYY/MM/DD');
91: --f_ludate :=sysdate;
92: -- This select stmnt also checks if

Line 101: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

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
103: UPDATE_ROW (
104: X_ATTACHMENT_ID => l_ATTACHMENT_ID,
105: X_LAST_UPDATE_DATE => f_ludate,