1498: funcmode in varchar2,
1499: resultout out nocopy varchar2 ) is
1500:
1501: CURSOR provider_info(provider_name VARCHAR2) IS 1502: SELECT party_id from hz_parties 1503: WHERE party_number = provider_name;
1504:
1505: CURSOR site_id_cur(p_party_id NUMBER) IS
1506: SELECT site_id from OKL_INS_PARTYSITES_V