DBA Data[Home] [Help]

APPS.PV_GE_HIST_LOG_PKG dependencies on FND_GLOBAL

Line 88: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

84: DECODE( p_arc_history_for_entity_code, FND_API.g_miss_char, NULL, p_arc_history_for_entity_code),
85: DECODE( p_history_for_entity_id, FND_API.G_MISS_NUM, NULL, p_history_for_entity_id),
86: DECODE( p_message_code, FND_API.g_miss_char, NULL, p_message_code),
87: DECODE( p_history_category_code, FND_API.g_miss_char, NULL, p_history_category_code),
88: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
89: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
90: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
91: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 90: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

86: DECODE( p_message_code, FND_API.g_miss_char, NULL, p_message_code),
87: DECODE( p_history_category_code, FND_API.g_miss_char, NULL, p_history_category_code),
88: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
89: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
90: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
91: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
93: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
94: DECODE( p_access_level_flag, FND_API.g_miss_char, NULL, p_access_level_flag),

Line 92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

88: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
89: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
90: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
91: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
93: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
94: DECODE( p_access_level_flag, FND_API.g_miss_char, NULL, p_access_level_flag),
95: DECODE( p_interaction_level, FND_API.G_MISS_NUM, NULL, p_interaction_level));
96:

Line 112: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),

108: SELECT
109: DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id),
110: l.language_code,
111: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
112: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
113: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
114: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
115: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
116: USERENV('LANG'),

Line 114: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),

110: l.language_code,
111: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
112: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
113: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
114: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
115: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
116: USERENV('LANG'),
117: DECODE( p_COMMENTS , FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
118: FROM fnd_languages l

Line 115: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

111: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
112: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
113: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
114: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
115: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
116: USERENV('LANG'),
117: DECODE( p_COMMENTS , FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
118: FROM fnd_languages l
119: WHERE l.installed_flag IN ('I','B')