DBA Data[Home] [Help]

APPS.IBY_ECAPP_PKG dependencies on FND_GLOBAL

Line 116: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,

112: INSERT into iby_ecapp (ecappid, name, application_short_name,
113: last_update_date, last_updated_by, creation_date, created_by,
114: last_update_login, object_version_number)
115: VALUES ( io_ecappid, i_ecappname, i_app_short_name,
116: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
117: fnd_global.login_id, 1);
118: close c_ecappid;
119: commit;
120: end createEcApp;

Line 117: fnd_global.login_id, 1);

113: last_update_date, last_updated_by, creation_date, created_by,
114: last_update_login, object_version_number)
115: VALUES ( io_ecappid, i_ecappname, i_app_short_name,
116: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id,
117: fnd_global.login_id, 1);
118: close c_ecappid;
119: commit;
120: end createEcApp;
121:

Line 159: last_update_login = fnd_global.login_id,

155: -- no check in object version number in this case
156: UPDATE iby_ecapp
157: SET name = i_ecappname, application_short_name = i_app_short_name,
158: last_update_date = sysdate,
159: last_update_login = fnd_global.login_id,
160: object_version_number = object_version_number + 1
161: WHERE ecappid = i_ecappid ;
162: else
163: UPDATE iby_ecapp

Line 166: last_update_login = fnd_global.login_id,

162: else
163: UPDATE iby_ecapp
164: SET name = i_ecappname, application_short_name = i_app_short_name,
165: last_update_date = sysdate,
166: last_update_login = fnd_global.login_id,
167: object_version_number = object_version_number + 1
168: WHERE ecappid = i_ecappid
169: AND object_version_number = i_object_version;
170: end if;