DBA Data[Home] [Help]

APPS.GCS_FORMULA_VARIABLES_PKG dependencies on FND_LOAD_UTIL

Line 106: f_luby := fnd_load_util.owner_id(owner);

102: db_luby NUMBER; -- entity owner in db
103: db_ludate DATE; -- entity update date in db
104: BEGIN
105: -- Get last updated information from the loader data file
106: f_luby := fnd_load_util.owner_id(owner);
107: f_ludate := nvl(to_date(last_update_date, 'YYYY/MM/DD'), sysdate);
108:
109: BEGIN
110: SELECT fv.last_updated_by, fv.last_update_date

Line 116: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,

112: FROM GCS_FORMULA_VARIABLES fv
113: WHERE fv.user_variable_name = load_row.user_variable_name;
114:
115: -- Test for customization information
116: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
117: custom_mode) THEN
118: update_row( user_variable_name => user_variable_name,
119: rule_type_code => rule_type_code,
120: sql_statement_value => sql_statement_value,

Line 154: f_luby := fnd_load_util.owner_id(owner);

150: db_luby NUMBER; -- entity owner in db
151: db_ludate DATE; -- entity update date in db
152: BEGIN
153: -- Get last updated information from the loader data file
154: f_luby := fnd_load_util.owner_id(owner);
155: f_ludate := nvl(to_date(last_update_date, 'YYYY/MM/DD'), sysdate);
156:
157: BEGIN
158: SELECT fv.last_updated_by, fv.last_update_date

Line 164: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,

160: FROM GCS_FORMULA_VARIABLES fv
161: WHERE fv.user_variable_name = translate_row.user_variable_name;
162:
163: -- Test for customization information
164: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
165: custom_mode) THEN
166: UPDATE gcs_formula_variables fv
167: SET last_update_date = f_ludate,
168: last_updated_by = f_luby,