APPS.FV_CCR_DATA_LOAD_PKG dependencies on FND_GLOBAL

Line 378: l_user_id CONSTANT number := fnd_global.user_id;

374: dummy number;
375: l_duns_list varchar2(1000);
376: l_counter number;
377: l_valid_tin varchar2(9);
378: l_user_id CONSTANT number := fnd_global.user_id;
379: l_xml_opt_param_set varchar2(1);
380: l_update_type varchar2(1);
381: l_report_count number;
382: l_run_from_xml varchar2(1); -- added by ks for 5906546

Line 2594: fcv.last_updated_by = fnd_global.user_id

2590: fcv.enabled ='N' ,
2591: fcv.extract_code ='1' ,
2592: fcv.last_update_date = sysdate,
2593: fcv.last_import_date = nvl(l_file_date,sysdate),
2594: fcv.last_updated_by = fnd_global.user_id
2595: WHERE exists ( SELECT 1 FROM fv_ccr_process_gt fcpg
2596: WHERE fcv.duns = fcpg.duns
2597: AND nvl(fcv.plus_four,-99)= nvl(fcpg.plus_four,-99)
2598: AND fcpg.extract_code = '1');

Line 2606: last_updated_by = fnd_global.user_id,

2602: UPDATE fv_ccr_vendors fcv SET ccr_status ='E',
2603: enabled='N',
2604: extract_code ='4',
2605: last_update_date = sysdate,
2606: last_updated_by = fnd_global.user_id,
2607: last_import_date = nvl(l_file_date,sysdate)
2608: WHERE exists ( SELECT 1 FROM fv_ccr_process_gt fcpg
2609: WHERE fcv.duns = fcpg.duns
2610: AND nvl(fcv.plus_four,-99)= nvl(fcpg.plus_four,-99)