37: db_ludate date; -- entity update date in db
38:
39: begin
40: -- Translate owner to file_last_updated_by
41: f_luby := fnd_load_util.owner_id(x_owner);
42:
43: -- Translate char last_update_date to date
44: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
45:
48: into sgroup_id, db_luby, db_ludate
49: from fnd_security_groups
50: where security_group_key = X_SECURITY_GROUP_KEY;
51:
52: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
53: db_ludate, X_CUSTOM_MODE)) then
54: fnd_security_groups_pkg.UPDATE_ROW (
55: X_SECURITY_GROUP_ID => sgroup_id,
56: X_SECURITY_GROUP_KEY => X_SECURITY_GROUP_KEY,
113:
114: begin
115:
116: -- Translate owner to file_last_updated_by
117: f_luby := fnd_load_util.owner_id(x_owner);
118:
119: -- Translate char last_update_date to date
120: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
121:
127: from fnd_security_groups
128: where security_group_key = X_SECURITY_GROUP_KEY)
129: and LANGUAGE = userenv('LANG');
130:
131: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
132: db_ludate, X_CUSTOM_MODE)) then
133: update fnd_security_groups_tl set
134: security_group_name = nvl(X_SECURITY_GROUP_NAME, security_group_name),
135: description = nvl(X_DESCRIPTION, description),