DBA Data[Home] [Help]

APPS.HZ_PARTY_V2PUB dependencies on HZ_CLASSIFICATION_V2PUB

Line 1070: -- call hz_classification_v2pub.set_primary_code_assignment when

1066: --4232060
1067: l_created_by_module := nvl(p_group_rec.created_by_module,l_created_by_module);
1068: END IF;
1069:
1070: -- call hz_classification_v2pub.set_primary_code_assignment when
1071: -- CATEGORY_CODE is specified for a user entered party.
1072: -- you can have customer category for a person not just organization.
1073: -- we should remove category_code from the party_rec once CRM uptake the
1074: -- new TCA classification model. Other application should not use the

Line 1090: hz_classification_v2pub.set_primary_code_assignment(

1086: -- l_party_rec.category_code <> FND_API.G_MISS_CHAR AND
1087: l_party_rec.category_code <> l_old_party_rec.category_code) AND
1088: l_data_source_type = G_MISS_CONTENT_SOURCE_TYPE
1089: THEN
1090: hz_classification_v2pub.set_primary_code_assignment(
1091: p_owner_table_name => 'HZ_PARTIES',
1092: p_owner_table_id => l_party_rec.party_id,
1093: p_class_category => 'CUSTOMER_CATEGORY',
1094: p_class_code => l_party_rec.category_code,

Line 1146: -- call hz_classification_v2pub.set_primary_code_assignment.

1142: fnd_msg_pub.add;
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;
1145:
1146: -- call hz_classification_v2pub.set_primary_code_assignment.
1147: -- if sic_code_type is not 'OTHER', then make the sic_code as the primary
1148: -- industrial class code for the party by calling
1149: -- hz_classification_v2pub.set_primary_code_assignment.
1150: -- if local_activity_code has a value, call

Line 1149: -- hz_classification_v2pub.set_primary_code_assignment.

1145:
1146: -- call hz_classification_v2pub.set_primary_code_assignment.
1147: -- if sic_code_type is not 'OTHER', then make the sic_code as the primary
1148: -- industrial class code for the party by calling
1149: -- hz_classification_v2pub.set_primary_code_assignment.
1150: -- if local_activity_code has a value, call
1151: -- hz_classification_v2pub.set_primary_code_assignment.
1152:
1153: IF l_sic_code=FND_API.G_MISS_CHAR

Line 1151: -- hz_classification_v2pub.set_primary_code_assignment.

1147: -- if sic_code_type is not 'OTHER', then make the sic_code as the primary
1148: -- industrial class code for the party by calling
1149: -- hz_classification_v2pub.set_primary_code_assignment.
1150: -- if local_activity_code has a value, call
1151: -- hz_classification_v2pub.set_primary_code_assignment.
1152:
1153: IF l_sic_code=FND_API.G_MISS_CHAR
1154: AND l_sic_code_type=FND_API.G_MISS_CHAR
1155: AND p_old_organization_rec.sic_code_type IS NOT NULL

Line 1173: hz_classification_v2pub.set_primary_code_assignment(

1169: OR -- Bug 4043346
1170: NVL(p_organization_rec.sic_code_type, FND_API.G_MISS_CHAR) <>
1171: p_old_organization_rec.sic_code_type))
1172: THEN
1173: hz_classification_v2pub.set_primary_code_assignment(
1174: p_owner_table_name => 'HZ_PARTIES',
1175: p_owner_table_id => p_organization_rec.party_rec.party_id,
1176: p_class_category => l_sic_code_type,
1177: p_class_code => l_sic_code,

Line 1211: hz_classification_v2pub.set_primary_code_assignment(

1207: if(l_local_activity_code_type = '4' OR l_local_activity_code_type = '5') then
1208: l_local_activity_code_type := 'NACE';
1209: end if;
1210:
1211: hz_classification_v2pub.set_primary_code_assignment(
1212: p_owner_table_name => 'HZ_PARTIES',
1213: p_owner_table_id => p_organization_rec.party_rec.party_id,
1214:
1215: -- p_class_category => 'NACE',