APPS.OZF_REQUEST_STATUS_PVT dependencies on FND_PROFILE

Line 238: null,null,Null,Null,Null,Null,Null,FND_PROFILE.Value('ASF_DEFAULT_COUNTRY'),

234: , a.end_cust_name
235: , ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS_LABEL(Null,a.end_cust_address1,a.end_cust_address2,
236: a.end_cust_address3,a.end_cust_address4,a.end_cust_city,a.end_cust_county,
237: a.end_cust_state,a.end_cust_province,a.end_cust_postal_code,
238: null,null,Null,Null,Null,Null,Null,FND_PROFILE.Value('ASF_DEFAULT_COUNTRY'),
239: NULL,NULL,2000,1,1) ADDRESS
240: -- BUG 4460277 (+)
241: --, pt_cont.source_first_name || ' ' || pt_cont.source_last_name pt_contact_name
242: , cont.person_last_name||

Line 510: l_partner_profile_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');

506: fetch lc_get_function_id into l_function_id;
507: close lc_get_function_id;
508:
509:
510: l_partner_profile_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');
511:
512: l_partner_profile_url := substr(l_partner_profile_url,1,instr(l_partner_profile_url,'/',1,3)-1); -- just get the http://:
513:
514: l_partner_url := fnd_run_function.get_run_function_url

Line 689: l_partner_profile_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');

685: 0,
686: 'reqId=' || p_entity_id || '&'||
687: 'pgMode=PDT');
688:
689: l_partner_profile_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');
690: l_partner_profile_url := substr(l_partner_profile_url,1,instr(l_partner_profile_url,'/',1,3)-1); -- just get the http://:
691:
692: if length(l_partner_profile_url) > 0 then -- if profile is set, use it for partner URL
693: l_partner_url := l_partner_profile_url || substr(l_partner_url, instr(l_partner_url,'/',1,3));