APPS.QPR_DEAL_PVT dependencies on FND_GLOBAL

Line 635: where user_id = fnd_global.user_id;

631:
632: elsif quote_origin = 697 then
633: select user_name into l_usr_name
634: from fnd_user
635: where user_id = fnd_global.user_id;
636:
637: l_api_call_st:='select resource_id from jtf_rs_resource_extns';
638: l_api_call_st := l_api_call_st || l_dblink;
639: l_api_call_st := l_api_call_st || ' where category = ''EMPLOYEE'' and user_name = ''' || l_usr_name || ''' and rownum < 2';

Line 648: l_api_call_st := 'begin :1 := fnd_global.user_id' ;

644: when others then
645: l_resource_id := null;
646: end;
647:
648: l_api_call_st := 'begin :1 := fnd_global.user_id' ;
649: l_api_call_st := l_api_call_st || l_dblink || '; end;';
650: execute immediate l_api_call_st using out l_remote_usr_id;
651:
652: if nvl(l_remote_usr_id , -1) = -1 then

Line 668: l_api_call_st := l_api_call_st || 'fnd_global.apps_initialize' || l_dblink ;

664: execute immediate l_api_call_st into l_appl_id, l_resp_id
665: using l_responsibility_name ;
666:
667: l_api_call_st := ' begin ';
668: l_api_call_st := l_api_call_st || 'fnd_global.apps_initialize' || l_dblink ;
669: l_api_call_st := l_api_call_st || '(:usr, :resp, :appl_id); end; ' ;
670: execute immediate l_api_call_st using l_remote_usr_id,
671: l_resp_id, l_appl_id;
672: end if;

Line 825: and role_id in (fnd_global.user_id, fnd_global.resp_id)

821: (
822: select view_all_deals_flag
823: from qpr_usr_assignments
824: where nvl(view_all_deals_flag, 'N') = 'Y'
825: and role_id in (fnd_global.user_id, fnd_global.resp_id)
826: order by role_type_code desc)
827: where rownum < 2;
828: exception
829: when others then

Line 864: l_fnd_user := fnd_global.user_name;

860: l_usr_name varchar2(200);
861: l_resource_id number;
862: l_fnd_user varchar2(50);
863: begin
864: l_fnd_user := fnd_global.user_name;
865: select req.source_id, req.source_ref_hdr_id, req.instance_id
866: into l_source_id, l_source_header_id, l_instance_id
867: from qpr_pn_request_hdrs_b req,
868: qpr_pn_response_hdrs res