26:
27: IF p_entity_name IN ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES') THEN
28: x_create_flag := 'Y';
29: ELSE
30: HZ_MIXNM_UTILITY.CheckUserCreationPrivilege(
31: p_entity_name => p_entity_name,
32: p_entity_attr_id => l_entity_attr_id,
33: p_mixnmatch_enabled => NULL,
34: p_actual_content_source => 'USER_ENTERED',
252: If p_entity_name in ('HZ_RELATIONSHIPS', 'HZ_CODE_ASSIGNMENTS',
253: 'HZ_CONTACT_POINTS', 'HZ_CREDIT_RATINGS', 'HZ_FINANCIAL_REPORTS',
254: 'HZ_LOCATIONS', 'HZ_PARTY_SITES', 'HZ_FINANCIAL_NUMBERS') then
255:
256: HZ_MIXNM_UTILITY.CheckUserUpdatePrivilege (
257: p_actual_content_source => p_data_source,
258: p_new_actual_content_source => 'USER_ENTERED',
259: p_entity_name => p_entity_name,
260: x_return_status => l_return_status
343: p_entity_pk1 IN VARCHAR2, -- primary key
344: p_entity_pk2 IN VARCHAR2, -- primary key pt. 2
345: p_party_id IN NUMBER , -- only pass if available
346: p_function_name IN VARCHAR2, -- function name
347: p_attribute_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR30List, -- pl/sql table of attribute names
348: p_value_is_null_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR1List, -- pl/sql table of flags
349: x_viewable_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List, -- pl/sql table of flags
350: x_updateable_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List -- pl/sql table of flags
351: ) IS
344: p_entity_pk2 IN VARCHAR2, -- primary key pt. 2
345: p_party_id IN NUMBER , -- only pass if available
346: p_function_name IN VARCHAR2, -- function name
347: p_attribute_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR30List, -- pl/sql table of attribute names
348: p_value_is_null_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR1List, -- pl/sql table of flags
349: x_viewable_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List, -- pl/sql table of flags
350: x_updateable_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List -- pl/sql table of flags
351: ) IS
352: l_return_status VARCHAR2(1);
345: p_party_id IN NUMBER , -- only pass if available
346: p_function_name IN VARCHAR2, -- function name
347: p_attribute_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR30List, -- pl/sql table of attribute names
348: p_value_is_null_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR1List, -- pl/sql table of flags
349: x_viewable_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List, -- pl/sql table of flags
350: x_updateable_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List -- pl/sql table of flags
351: ) IS
352: l_return_status VARCHAR2(1);
353: i NUMBER;
346: p_function_name IN VARCHAR2, -- function name
347: p_attribute_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR30List, -- pl/sql table of attribute names
348: p_value_is_null_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR1List, -- pl/sql table of flags
349: x_viewable_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List, -- pl/sql table of flags
350: x_updateable_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List -- pl/sql table of flags
351: ) IS
352: l_return_status VARCHAR2(1);
353: i NUMBER;
354: BEGIN
356: /*
357: * Call the Third Party Data Integration column checking routine.
358: */
359:
360: HZ_MIXNM_UTILITY.areSSTColumnsUpdeable (
361: p_party_id => p_party_id,
362: p_entity_name => p_entity_name,
363: p_attribute_name_list => p_attribute_list,
364: p_value_is_null_list => p_value_is_null_list,