APPS.HXC_SUPERVISOR_DASHBOARD dependencies on FND_GLOBAL

Line 58: l_user_id number := FND_GLOBAL.login_id;

54:
55: l_recurring_period VARCHARTAB;
56:
57: l_recc_pref varchar2(10);
58: l_user_id number := FND_GLOBAL.login_id;
59: l_direct_cursor SYS_REFCURSOR;
60: l_all_cursor SYS_REFCURSOR;
61:
62: l_org_id varchar2(100) := p_organization_id;

Line 1488: hr_utility.trace('PNS fnd_global.user_id '||fnd_global.user_id);

1484: IF g_debug THEN
1485: l_proc := g_package||'insert_notification_id';
1486: hr_utility.set_location('Entering:'|| l_proc, 10);
1487: END IF;
1488: hr_utility.trace('PNS fnd_global.user_id '||fnd_global.user_id);
1489: SELECT user_name
1490: INTO l_user_name
1491: FROM fnd_user
1492: WHERE user_id = fnd_global.user_id;

Line 1492: WHERE user_id = fnd_global.user_id;

1488: hr_utility.trace('PNS fnd_global.user_id '||fnd_global.user_id);
1489: SELECT user_name
1490: INTO l_user_name
1491: FROM fnd_user
1492: WHERE user_id = fnd_global.user_id;
1493:
1494: OPEN c_timecards(p_user_id);
1495: LOOP
1496: FETCH c_timecards BULK COLLECT INTO l_timecard_ids;

Line 3091: WHERE user_id = fnd_global.LOGIN_ID';

3087: ,period_end_date
3088: ,last_modified_by
3089: ,last_modified_date
3090: FROM hxc_tcd_timecards htt
3091: WHERE user_id = fnd_global.LOGIN_ID';
3092:
3093: l_dynamic_cursor SYS_REFCURSOR;
3094:
3095: CURSOR c_report(supervisor_id number, column_name varchar2 default null, approval_status varchar2)

Line 3111: WHERE user_id = fnd_global.login_id

3107: ,period_end_date
3108: ,last_modified_by
3109: ,last_modified_date
3110: FROM hxc_tcd_timecards htt
3111: WHERE user_id = fnd_global.login_id
3112: AND supervisor_id = supervisor_id
3113: AND approval_status = 'SUBMITTED';
3114: /*AND nvl (column_name
3115: ,1) = nvl2 (column_name

Line 3190: || 'where user_id = fnd_global.user_id' ;

3186: query1 := 'SELECT '
3187: || 'user_name INITIATED_BY, '
3188: || 'TO_CHAR(SYSDATE, ''' || l_icx_date_format || ''') RUN_DATE '
3189: || 'from fnd_user '
3190: || 'where user_id = fnd_global.user_id' ;
3191:
3192: qryCtx1 := dbms_xmlgen.newContext(query1);
3193: dbms_xmlgen.setRowTag(qryCtx1, NULL);
3194: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');