DBA Data[Home] [Help]

APPS.IBE_MSITE_INFORMATION_PKG dependencies on FND_GLOBAL

Line 182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

178: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
179: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
180: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
181: p_creation_date),
182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
183: NULL, FND_GLOBAL.user_id, p_created_by),
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 183: NULL, FND_GLOBAL.user_id, p_created_by),

179: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
180: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
181: p_creation_date),
182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
183: NULL, FND_GLOBAL.user_id, p_created_by),
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),

Line 186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
183: NULL, FND_GLOBAL.user_id, p_created_by),
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),
188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
189: NULL, FND_GLOBAL.login_id, p_last_update_login)
190: );

Line 187: NULL, FND_GLOBAL.user_id, p_last_updated_by),

183: NULL, FND_GLOBAL.user_id, p_created_by),
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),
188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
189: NULL, FND_GLOBAL.login_id, p_last_update_login)
190: );
191:

Line 188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),
188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
189: NULL, FND_GLOBAL.login_id, p_last_update_login)
190: );
191:
192: OPEN c;

Line 189: NULL, FND_GLOBAL.login_id, p_last_update_login)

185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),
188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
189: NULL, FND_GLOBAL.login_id, p_last_update_login)
190: );
191:
192: OPEN c;
193: FETCH c INTO x_rowid;

Line 328: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

324: attribute15, p_attribute15),
325: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
326: NULL, sysdate, p_last_update_date),
327: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
328: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
329: p_last_updated_by),
330: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
331: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
332: p_last_update_login)

Line 331: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

327: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
328: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
329: p_last_updated_by),
330: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
331: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
332: p_last_update_login)
333: WHERE msite_information_id = p_msite_information_id
334: AND object_version_number = decode(p_object_version_number,
335: FND_API.G_MISS_NUM,