DBA Data[Home] [Help]

APPS.CSI_COUNTERS_PKG dependencies on FND_GLOBAL

Line 392: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_LAST_UPDATE_LOGIN)

388: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)
389: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
390: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
391: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
392: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_LAST_UPDATE_LOGIN)
393: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
394: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
395: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
396: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)

Line 451: last_updated_by = decode( p_last_updated_by, NULL,last_updated_by, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),

447: name = decode( p_name, NULL, name, fnd_api.g_miss_char, NULL, p_name),
448: description = decode( p_description, NULL, description, fnd_api.g_miss_char, NULL, p_description),
449: created_by = decode( p_created_by, NULL,created_by, fnd_api.g_miss_num,created_by, p_created_by),
450: creation_date = decode( p_creation_date, NULL,creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
451: last_updated_by = decode( p_last_updated_by, NULL,last_updated_by, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),
452: last_update_date = decode( p_last_update_date, NULL,last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
453: last_update_login = decode( p_last_update_login, NULL,last_update_login, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_update_login)
454: WHERE counter_id = p_counter_id
455: AND userenv('LANG') IN (LANGUAGE,SOURCE_LANG);

Line 453: last_update_login = decode( p_last_update_login, NULL,last_update_login, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_update_login)

449: created_by = decode( p_created_by, NULL,created_by, fnd_api.g_miss_num,created_by, p_created_by),
450: creation_date = decode( p_creation_date, NULL,creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
451: last_updated_by = decode( p_last_updated_by, NULL,last_updated_by, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),
452: last_update_date = decode( p_last_update_date, NULL,last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
453: last_update_login = decode( p_last_update_login, NULL,last_update_login, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_update_login)
454: WHERE counter_id = p_counter_id
455: AND userenv('LANG') IN (LANGUAGE,SOURCE_LANG);
456:
457: If (SQL%NOTFOUND) then