DBA Data[Home] [Help]

APPS.GCS_CONS_MONITOR_PKG dependencies on FND_GLOBAL

Line 243: gcds.last_updated_by = fnd_global.user_id

239: WHEN MATCHED THEN
240: UPDATE
241: SET gcds.status_code = src.status_code,
242: gcds.last_update_date = sysdate,
243: gcds.last_updated_by = fnd_global.user_id
244: WHEN NOT MATCHED THEN
245: INSERT
246: (gcds.hierarchy_id,
247: gcds.consolidation_entity_id,

Line 261: fnd_global.user_id,

257: p_entity_id,
258: p_cal_period_id,
259: p_balance_type_code,
260: src.status_code,
261: fnd_global.user_id,
262: sysdate,
263: fnd_global.user_id,
264: sysdate);
265: END load_entity;

Line 263: fnd_global.user_id,

259: p_balance_type_code,
260: src.status_code,
261: fnd_global.user_id,
262: sysdate,
263: fnd_global.user_id,
264: sysdate);
265: END load_entity;
266:
267: -- update the gcs_cons_data_statuses table for a newly added entity in the specified hierarchy

Line 332: last_updated_by = fnd_global.user_id

328: END IF;
329: UPDATE gcs_cons_data_statuses gcds
330: SET status_code = 'IN_PROGRESS',
331: last_update_date = sysdate,
332: last_updated_by = fnd_global.user_id
333: WHERE hierarchy_id = p_hierarchy_id
334: AND status_code in ('COMPLETED', 'WARNING', 'ERROR')
335: AND consolidation_entity_id in
336: (SELECT gcr.parent_entity_id