[Home] [Help]
239: , a.end_cust_name
240: , ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS_LABEL(Null,a.end_cust_address1,a.end_cust_address2,
241: a.end_cust_address3,a.end_cust_address4,a.end_cust_city,a.end_cust_county,
242: a.end_cust_state,a.end_cust_province,a.end_cust_postal_code,
243: null,null,Null,Null,Null,Null,Null,FND_PROFILE.Value('ASF_DEFAULT_COUNTRY'),
244: NULL,NULL,2000,1,1) ADDRESS
245: -- BUG 4460277 (+)
246: --, pt_cont.source_first_name || ' ' || pt_cont.source_last_name pt_contact_name
247: , cont.person_last_name||
521: open lc_get_function_id(pc_func_name => 'OZF_SP_PARTNER_CRTPRO');
522: fetch lc_get_function_id into l_function_id;
523: close lc_get_function_id;
524:
525: l_partner_profile_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');
526:
527: l_partner_profile_url := substr(l_partner_profile_url,1,instr(l_partner_profile_url,'/',1,3)-1); -- just get the http://
528:
529: l_partner_url := fnd_run_function.get_run_function_url(
702: 0,
703: 'reqId=' || p_entity_id || '&' ||
704: 'pgMode=PDT');
705:
706: l_partner_profile_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');
707: l_partner_profile_url := substr(l_partner_profile_url,1,instr(l_partner_profile_url,'/',1,3)-1); -- just get the http://
708:
709: if length(l_partner_profile_url) > 0 then -- if profile is set, use it for partner URL
710: l_partner_url := l_partner_profile_url || substr(l_partner_url, instr(l_partner_url,'/',1,3));