APPS.FV_CCR_DATA_LOAD_PKG dependencies on FND_GLOBAL

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

364: dummy number;
365: l_duns_list varchar2(1000);
366: l_counter number;
367: l_valid_tin varchar2(9);
368: l_user_id CONSTANT number := fnd_global.user_id;
369: l_xml_opt_param_set varchar2(1);
370: l_update_type varchar2(1);
371: l_report_count number;
372: l_run_from_xml varchar2(1); -- added by ks for 5906546

Line 2653: fcv.last_updated_by = fnd_global.user_id

2649: fcv.enabled ='N' ,
2650: fcv.extract_code ='1' ,
2651: fcv.last_update_date = sysdate,
2652: fcv.last_import_date = nvl(l_file_date,sysdate),
2653: fcv.last_updated_by = fnd_global.user_id
2654: WHERE exists ( SELECT 1 FROM fv_ccr_process_gt fcpg
2655: WHERE fcv.duns = fcpg.duns
2656: AND nvl(fcv.plus_four,-99)= nvl(fcpg.plus_four,-99)
2657: AND fcpg.extract_code = '1');

Line 2665: last_updated_by = fnd_global.user_id,

2661: UPDATE fv_ccr_vendors fcv SET ccr_status ='E',
2662: enabled='N',
2663: extract_code ='4',
2664: last_update_date = sysdate,
2665: last_updated_by = fnd_global.user_id,
2666: last_import_date = nvl(l_file_date,sysdate)
2667: WHERE exists ( SELECT 1 FROM fv_ccr_process_gt fcpg
2668: WHERE fcv.duns = fcpg.duns
2669: AND nvl(fcv.plus_four,-99)= nvl(fcpg.plus_four,-99)