DBA Data[Home] [Help]

APPS.HRI_OPL_SUP_WRKFC_ASG dependencies on FND_GLOBAL

Line 363: l_user_id := fnd_global.user_id;

359: --
360: dbg('Inside asg_event_changes');
361: --
362: l_current_time := SYSDATE;
363: l_user_id := fnd_global.user_id;
364: --
365: -- First remove the deleted asg event records
366: --
367: DELETE hri_map_sup_wrkfc_asg asg_sph

Line 844: l_user_id := fnd_global.user_id;

840: --
841: dbg('Inside sup_changes');
842: --
843: l_current_time := SYSDATE;
844: l_user_id := fnd_global.user_id;
845: --
846: -- SUPERVISOR HIERARCHY CHANGES
847: -- Delete all records from asg delta table which have been removed from the supervisor
848: -- hierarchy table during incremental refresh. The variour metrics

Line 1522: l_user_id := fnd_global.user_id;

1518: l_table_name := 'HRI_MAP_SUP_WRKFC_ASG';
1519: END IF;
1520: --
1521: l_current_time := SYSDATE;
1522: l_user_id := fnd_global.user_id;
1523: --
1524: l_sql_stmt :=
1525: 'INSERT ' || l_hint || 'INTO ' || l_table_name || ' ' || l_partition_clause || '
1526: (supervisor_person_id

Line 2072: IF fnd_global.conc_request_id is null THEN

2068: p_table_owner => l_schema);
2069: --
2070: -- Collect the statistics only when the process is not called by a concurrent manager
2071: --
2072: IF fnd_global.conc_request_id is null THEN
2073: --
2074: dbg('Running from outside the request set - gathering stats');
2075: fnd_stats.gather_table_stats(l_schema,'HRI_MAP_SUP_WRKFC_ASG');
2076: --