DBA Data[Home] [Help]

APPS.IBC_DIRECTORY_NODE_RELS_PKG dependencies on FND_GLOBAL

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

78: p_PARENT_DIR_NODE_ID,
79: p_OBJECT_VERSION_NUMBER,
80: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
81: p_creation_date),
82: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
83: NULL, FND_GLOBAL.user_id, p_created_by),
84: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_last_update_date),
86: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

79: p_OBJECT_VERSION_NUMBER,
80: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
81: p_creation_date),
82: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
83: NULL, FND_GLOBAL.user_id, p_created_by),
84: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_last_update_date),
86: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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

82: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
83: NULL, FND_GLOBAL.user_id, p_created_by),
84: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_last_update_date),
86: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_last_updated_by),
88: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
89: NULL, FND_GLOBAL.login_id, p_last_update_login)
90: );

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

83: NULL, FND_GLOBAL.user_id, p_created_by),
84: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_last_update_date),
86: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_last_updated_by),
88: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
89: NULL, FND_GLOBAL.login_id, p_last_update_login)
90: );
91:

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

84: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
85: p_last_update_date),
86: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_last_updated_by),
88: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
89: NULL, FND_GLOBAL.login_id, p_last_update_login)
90: );
91:
92: OPEN c;

Line 89: NULL, FND_GLOBAL.login_id, p_last_update_login)

85: p_last_update_date),
86: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
87: NULL, FND_GLOBAL.user_id, p_last_updated_by),
88: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
89: NULL, FND_GLOBAL.login_id, p_last_update_login)
90: );
91:
92: OPEN c;
93: FETCH c INTO x_ROWID;

Line 175: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

171: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
172: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
173: NULL, SYSDATE, p_last_update_date),
174: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
175: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
176: p_last_updated_by),
177: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
178: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
179: p_last_update_login)

Line 178: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

174: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
175: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
176: p_last_updated_by),
177: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
178: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
179: p_last_update_login)
180: WHERE Directory_Node_Rel_ID = p_Directory_Node_Rel_ID
181: AND object_version_number = DECODE(p_object_version_number,
182: FND_API.G_MISS_NUM,object_version_number,