497: open lc_get_function_id(pc_func_name => 'OZF_SP_VENDOR_DTAIL');
498: fetch lc_get_function_id into l_function_id;
499: close lc_get_function_id;
500:
501: l_vendor_url := fnd_run_function.get_run_function_url(
502: l_function_id,
503: -1,
504: -1,
505: 0,
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(
530: l_function_id,
531: -1,
532: -1,
533: 0,
675: fetch lc_get_function_id into l_function_id;
676: close lc_get_function_id;
677:
678:
679: l_vendor_url := fnd_run_function.get_run_function_url(
680: l_function_id,
681: -1,
682: -1,
683: 0,
694: open lc_get_function_id(pc_func_name => 'OZF_SF_PARTNER_DETAILS');
695: fetch lc_get_function_id into l_function_id;
696: close lc_get_function_id;
697:
698: l_partner_url := fnd_run_function.get_run_function_url(
699: l_function_id,
700: -1,
701: -1,
702: 0,