APPS.HZ_CUST_ACCOUNT_V2PUB dependencies on HZ_PARTY_USG_ASSIGNMENT_PVT

Line 222: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;

218: where ORIG_SYSTEM_REFERENCE = p_cust_account_rec.orig_system_reference;
219: l_orig_system_reference varchar2(255) :=p_cust_account_rec.orig_system_reference;
220: l_tmp varchar2(1);
221:
222: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
223: l_dummy VARCHAR2(1);
224: l_party_usg_validation_level NUMBER;
225:
226: CURSOR c_has_active_account (

Line 444: l_party_usg_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE;

440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441: END IF;
442: END IF;
443:
444: l_party_usg_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE;
445:
446: ELSE
447: l_party_usg_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_LOW;
448: END IF;

Line 447: l_party_usg_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_LOW;

443:
444: l_party_usg_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE;
445:
446: ELSE
447: l_party_usg_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_LOW;
448: END IF;
449:
450:
451:

Line 670: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (

666: l_party_usg_assignment_rec.party_id := l_party_id;
667: l_party_usg_assignment_rec.party_usage_code := 'CUSTOMER';
668: l_party_usg_assignment_rec.created_by_module := 'TCA_V2_API';
669:
670: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (
671: p_validation_level => l_party_usg_validation_level,
672: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
673: x_return_status => x_return_status,
674: x_msg_count => l_msg_count,

Line 755: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;

751: l_status VARCHAR2(1);
752: l_dummy VARCHAR2(1);
753: l_msg_count NUMBER;
754: l_msg_data VARCHAR2(2000);
755: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
756:
757: CURSOR c_has_active_account (
758: p_party_id NUMBER,
759: p_cust_account_id NUMBER

Line 973: HZ_PARTY_USG_ASSIGNMENT_PVT.inactivate_usg_assignment (

969: -- inactivate the CUSTOMER usage if we are inactivating last
970: -- active account
971: --
972: IF p_cust_account_rec.status = 'I' THEN
973: HZ_PARTY_USG_ASSIGNMENT_PVT.inactivate_usg_assignment (
974: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,
975: p_party_id => l_party_id,
976: p_party_usage_code => 'CUSTOMER',
977: x_return_status => x_return_status,

Line 974: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,

970: -- active account
971: --
972: IF p_cust_account_rec.status = 'I' THEN
973: HZ_PARTY_USG_ASSIGNMENT_PVT.inactivate_usg_assignment (
974: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,
975: p_party_id => l_party_id,
976: p_party_usage_code => 'CUSTOMER',
977: x_return_status => x_return_status,
978: x_msg_count => l_msg_count,

Line 986: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (

982: l_party_usg_assignment_rec.party_id := l_party_id;
983: l_party_usg_assignment_rec.party_usage_code := 'CUSTOMER';
984: l_party_usg_assignment_rec.created_by_module := 'TCA_V2_API';
985:
986: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (
987: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,
988: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
989: x_return_status => x_return_status,
990: x_msg_count => l_msg_count,

Line 987: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,

983: l_party_usg_assignment_rec.party_usage_code := 'CUSTOMER';
984: l_party_usg_assignment_rec.created_by_module := 'TCA_V2_API';
985:
986: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (
987: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,
988: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
989: x_return_status => x_return_status,
990: x_msg_count => l_msg_count,
991: x_msg_data => l_msg_data