170: LOOP
171:
172: BEGIN
173:
174: HZ_PREFERENCE_PUB.REMOVE(
175: P_PARTY_ID => C_INACTIVE_CONTACTS_REC.PARTY_ID,
176: P_CATEGORY => l_category,
177: P_PREFERENCE_CODE => l_preference_code,
178: --P_VALUE_VARCHAR2 => l_value_varchar2,
212: loop
213:
214: BEGIN
215:
216: HZ_PREFERENCE_PUB.REMOVE(
217: P_PARTY_ID => C_SALES_TEAM_ACCESS_REC.PARTY_ID,
218: P_CATEGORY => l_category,
219: P_PREFERENCE_CODE => l_preference_code,
220: --P_VALUE_VARCHAR2 => l_value_varchar2,
253: loop
254:
255: BEGIN
256:
257: HZ_PREFERENCE_PUB.REMOVE(
258: P_PARTY_ID => C_MANAGER_ACCESS_REC.PARTY_ID,
259: P_CATEGORY => l_category,
260: P_PREFERENCE_CODE => l_preference_code,
261: --P_VALUE_VARCHAR2 => l_value_varchar2,