DBA Data[Home] [Help]

APPS.IBC_AUDIT_LOGS_PKG dependencies on FND_GLOBAL

Line 124: FND_GLOBAL.RESP_APPL_ID,

120: DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE4),
121: DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE5),
122: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
123:
124: FND_GLOBAL.RESP_APPL_ID,
125: DECODE(P_OBJECT_STATUS,FND_API.G_MISS_CHAR,NULL,P_OBJECT_STATUS),
126: DECODE(P_INTERNAL_FLAG,FND_API.G_MISS_CHAR,NULL,P_INTERNAL_FLAG),
127: DECODE(P_MESSAGE_APPLICATION,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_APPLICATION),
128: DECODE(P_MESSAGE_NAME,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_NAME),

Line 148: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

144:
145: p_OBJECT_VERSION_NUMBER,
146: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
147: p_creation_date),
148: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
149: NULL, FND_GLOBAL.user_id, p_created_by),
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

145: p_OBJECT_VERSION_NUMBER,
146: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
147: p_creation_date),
148: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
149: NULL, FND_GLOBAL.user_id, p_created_by),
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),

Line 152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

148: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
149: NULL, FND_GLOBAL.user_id, p_created_by),
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),
154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
155: NULL, FND_GLOBAL.login_id, p_last_update_login)
156: );

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

149: NULL, FND_GLOBAL.user_id, p_created_by),
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),
154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
155: NULL, FND_GLOBAL.login_id, p_last_update_login)
156: );
157:

Line 154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),
154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
155: NULL, FND_GLOBAL.login_id, p_last_update_login)
156: );
157:
158:

Line 155: NULL, FND_GLOBAL.login_id, p_last_update_login)

151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),
154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
155: NULL, FND_GLOBAL.login_id, p_last_update_login)
156: );
157:
158:
159: OPEN c;

Line 374: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

370: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
371: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
372: NULL, SYSDATE, p_last_update_date),
373: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
374: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
375: p_last_updated_by),
376: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
377: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
378: p_last_update_login)

Line 377: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

373: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
374: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
375: p_last_updated_by),
376: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
377: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
378: p_last_update_login)
379:
380: WHERE AUDIT_LOG_ID = p_AUDIT_LOG_ID
381: AND object_version_number = DECODE(p_object_version_number,