APPS.MSC_SUPPLIER_PWB dependencies on FND_GLOBAL

Line 24: open c_user_resp(fnd_global.user_id, 23815, 724);

20: l_count number := 0;
21: l_retval boolean := false;
22: begin
23: --check whether this user has supplier resp
24: open c_user_resp(fnd_global.user_id, 23815, 724);
25: fetch c_user_resp into l_count;
26: close c_user_resp ;
27:
28: if ( l_count = 0 ) then

Line 327: l_amp varchar2(2) := fnd_global.local_chr(38);

323: l_plsql_proc varchar2(250);
324: l_actual_params varchar2(250);
325: l_temp varchar2(250);
326: l_length number ;
327: l_amp varchar2(2) := fnd_global.local_chr(38);
328: l_found number;
329:
330: begin
331: p_err_msg := null; --initialize to null

Line 461: and fu.user_id = fnd_global.user_id;

457: and mcrs.relationship_id = map.company_key
458: and map.map_type = 1
459: and map.tp_key = mtp.modeled_supplier_id
460: and mtp.partner_type = 3
461: and fu.user_id = fnd_global.user_id;
462: l_temp number;
463: BEGIN
464: open c_org;
465: fetch c_org into l_temp;

Line 491: and fu.user_id = fnd_global.user_id ;

487: and mcrs.relationship_type = 2
488: and mcrs.relationship_id = map.company_key
489: and map.map_type = 1
490: and map.tp_key = mtp.partner_id
491: and fu.user_id = fnd_global.user_id ;
492:
493: l_sup number;
494: l_inst number;
495: BEGIN