DBA Data[Home] [Help]

APPS.PO_CHANGE_ORDER_TOLERANCES_PKG dependencies on FND_LOAD_UTIL

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

124: db_ludate date; -- entity update date in db
125:
126: begin
127:
128: f_luby := fnd_load_util.owner_id(X_OWNER);
129: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'DD/MM/YYYY'), sysdate);
130:
131: -- bug3703523
132: -- for old see data we have last_updated_by as -1.

Line 146: -- if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then

142: and ( (X_ORG_ID is null and org_id = -3113 )
143: or (X_ORG_ID is not null and org_id = X_ORG_ID));
144:
145: -- Chanded the condition in such a way that only date is considered while updating owner is not updated
146: -- if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
147: if (fnd_load_util.upload_test(f_luby, f_ludate, f_luby, db_ludate, X_CUSTOM_MODE)) then
148:
149: UPDATE PO_CHANGE_ORDER_TOLERANCES_ALL
150: SET MAXIMUM_INCREMENT = X_MAXIMUM_INCREMENT,

Line 147: if (fnd_load_util.upload_test(f_luby, f_ludate, f_luby, db_ludate, X_CUSTOM_MODE)) then

143: or (X_ORG_ID is not null and org_id = X_ORG_ID));
144:
145: -- Chanded the condition in such a way that only date is considered while updating owner is not updated
146: -- if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
147: if (fnd_load_util.upload_test(f_luby, f_ludate, f_luby, db_ludate, X_CUSTOM_MODE)) then
148:
149: UPDATE PO_CHANGE_ORDER_TOLERANCES_ALL
150: SET MAXIMUM_INCREMENT = X_MAXIMUM_INCREMENT,
151: MAXIMUM_DECREMENT = X_MAXIMUM_DECREMENT,