DBA Data[Home] [Help]

APPS.AMS_IBA_PS_CNDCLSES_B_PKG dependencies on FND_GLOBAL

Line 94: FND_GLOBAL.user_id,

90: cnd_clause_description,
91: language,
92: source_lang
93: ) SELECT
94: FND_GLOBAL.user_id,
95: SYSDATE,
96: FND_GLOBAL.user_id,
97: SYSDATE,
98: FND_GLOBAL.conc_login_id,

Line 96: FND_GLOBAL.user_id,

92: source_lang
93: ) SELECT
94: FND_GLOBAL.user_id,
95: SYSDATE,
96: FND_GLOBAL.user_id,
97: SYSDATE,
98: FND_GLOBAL.conc_login_id,
99: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
100: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 98: FND_GLOBAL.conc_login_id,

94: FND_GLOBAL.user_id,
95: SYSDATE,
96: FND_GLOBAL.user_id,
97: SYSDATE,
98: FND_GLOBAL.conc_login_id,
99: DECODE( px_cnd_clause_id, FND_API.g_miss_num, NULL, px_cnd_clause_id),
100: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
101:
102: DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, NULL, p_CND_CLAUSE_NAME),

Line 174: last_updated_by = FND_GLOBAL.user_id,

170: UPDATE ams_iba_ps_cndclses_tl SET
171: cnd_clause_name = DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, cnd_clause_name, p_CND_CLAUSE_NAME),
172: cnd_clause_description = DECODE( p_CND_CLAUSE_DESCRIPTION, FND_API.G_MISS_CHAR, cnd_clause_description, p_CND_CLAUSE_DESCRIPTION),
173: last_update_date = SYSDATE,
174: last_updated_by = FND_GLOBAL.user_id,
175: last_update_login = FND_GLOBAL.conc_login_id,
176: source_lang = USERENV('LANG')
177: WHERE cnd_clause_id = p_cnd_clause_id
178: AND USERENV('LANG') IN (language, source_lang);

Line 175: last_update_login = FND_GLOBAL.conc_login_id,

171: cnd_clause_name = DECODE( p_CND_CLAUSE_NAME, FND_API.G_MISS_CHAR, cnd_clause_name, p_CND_CLAUSE_NAME),
172: cnd_clause_description = DECODE( p_CND_CLAUSE_DESCRIPTION, FND_API.G_MISS_CHAR, cnd_clause_description, p_CND_CLAUSE_DESCRIPTION),
173: last_update_date = SYSDATE,
174: last_updated_by = FND_GLOBAL.user_id,
175: last_update_login = FND_GLOBAL.conc_login_id,
176: source_lang = USERENV('LANG')
177: WHERE cnd_clause_id = p_cnd_clause_id
178: AND USERENV('LANG') IN (language, source_lang);
179: