960: l_party_id VARCHAR2(1);
961: l_row_not_found BOOLEAN := FALSE;
962: CURSOR c1(p_party_id NUMBER) IS
963: SELECT '1' 964: FROM hz_parties 965: WHERE party_id = p_party_id ;
966: BEGIN
967: IF ( p_party_id IS NOT NULL) THEN
968: -- initialize return status