DBA Data[Home] [Help]

APPS.JTF_AMV_ITEMS_PKG dependencies on FND_LOAD_UTIL

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

42: X_OWNER in VARCHAR2,
43: X_CUSTOM_MODE in VARCHAR2 DEFAULT NULL,
44: X_LAST_UPDATE_DATE in VARCHAR2 DEFAULT NULL
45: ) AS
46: l_user_id number := fnd_load_util.owner_id(x_owner);
47: L_ITEM_ID NUMBER;
48: L_OBJECT_VERSION_NUMBER NUMBER;
49: L_APPLICATION_ID NUMBER;
50: L_EFFECTIVE_START_DATE DATE;

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

77: L_OWNER_ID := to_number(X_OWNER_ID);
78: L_DEFAULT_APPROVER_ID := to_number(X_DEFAULT_APPROVER_ID);
79:
80: -- Translate owner to file_last_updated_by
81: f_luby := fnd_load_util.owner_id(x_owner);
82:
83: -- Translate char last_update_date to date
84: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
85:

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

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
97:
98: UPDATE_ROW (
99: X_ITEM_ID => l_ITEM_ID,

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

206: db_ludate date; -- entity update date in db
207: begin
208:
209: -- Translate owner to file_last_updated_by
210: f_luby := fnd_load_util.owner_id(x_owner);
211:
212: -- Translate char last_update_date to date
213: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
214:

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

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,
222: db_ludate, X_CUSTOM_MODE)) then
223:
224: update JTF_AMV_ITEMS_TL set
225: ITEM_NAME = X_ITEM_NAME,