DBA Data[Home] [Help]

APPS.FND_INDUSTRIES_PKG dependencies on FND_LOAD_UTIL

Line 27: f_luby := fnd_load_util.owner_id(X_OWNER);

23: f_creator NUMBER; -- entity creator in file
24:
25: BEGIN
26: -- Translate owner to file_last_updated_by
27: f_luby := fnd_load_util.owner_id(X_OWNER);
28: -- Translate char last_update_date to date
29: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
30: -- Translate creator to f_creator
31: f_creator := fnd_load_util.owner_id(X_CREATED_BY);

Line 31: f_creator := fnd_load_util.owner_id(X_CREATED_BY);

27: f_luby := fnd_load_util.owner_id(X_OWNER);
28: -- Translate char last_update_date to date
29: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
30: -- Translate creator to f_creator
31: f_creator := fnd_load_util.owner_id(X_CREATED_BY);
32: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
33: into db_luby, db_ludate
34: FROM FND_INDUSTRIES
35: WHERE INDUSTRY_ID = X_INDUSTRY_ID AND

Line 38: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

34: FROM FND_INDUSTRIES
35: WHERE INDUSTRY_ID = X_INDUSTRY_ID AND
36: CREATED_BY = f_creator AND
37: LANGUAGE = userenv('LANG');
38: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
39: db_ludate, X_CUSTOM_MODE)) then
40: update fnd_industries set
41: industry_name = X_INDUSTRY_NAME,
42: description = X_DESCRIPTION,

Line 74: f_luby := fnd_load_util.owner_id(X_OWNER);

70: f_creator NUMBER; -- entity creator in file
71:
72: BEGIN
73: -- Translate owner to file_last_updated_by
74: f_luby := fnd_load_util.owner_id(X_OWNER);
75: -- Translate char last_update_date to date
76: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
77: -- Translate creator to f_creator
78: f_creator := fnd_load_util.owner_id(X_CREATED_BY);

Line 78: f_creator := fnd_load_util.owner_id(X_CREATED_BY);

74: f_luby := fnd_load_util.owner_id(X_OWNER);
75: -- Translate char last_update_date to date
76: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
77: -- Translate creator to f_creator
78: f_creator := fnd_load_util.owner_id(X_CREATED_BY);
79: BEGIN
80: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
81: into db_luby, db_ludate
82: FROM FND_INDUSTRIES

Line 86: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

82: FROM FND_INDUSTRIES
83: WHERE INDUSTRY_ID = X_INDUSTRY_ID AND
84: CREATED_BY = f_creator AND
85: LANGUAGE = userenv('LANG');
86: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
87: db_ludate, X_CUSTOM_MODE)) then
88: update fnd_industries set
89: industry_name = X_INDUSTRY_NAME,
90: description = X_DESCRIPTION,