2406: p_end_date_active IN DATE,
2407: x_return_status IN OUT NOCOPY VARCHAR2
2408: ) IS
2409:
2410: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
2411: l_msg_count NUMBER;
2412: l_msg_data VARCHAR2(2000);
2413:
2414: BEGIN
2424: THEN
2425: l_party_usg_assignment_rec.effective_start_date := p_end_date_active;
2426: END IF;
2427:
2428: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (
2429: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,
2430: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
2431: x_return_status => x_return_status,
2432: x_msg_count => l_msg_count,
2425: l_party_usg_assignment_rec.effective_start_date := p_end_date_active;
2426: END IF;
2427:
2428: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (
2429: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,
2430: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
2431: x_return_status => x_return_status,
2432: x_msg_count => l_msg_count,
2433: x_msg_data => l_msg_data
2452: p_end_date_active IN DATE,
2453: x_return_status IN OUT NOCOPY VARCHAR2
2454: ) IS
2455:
2456: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
2457: l_msg_count NUMBER;
2458: l_msg_data VARCHAR2(2000);
2459: l_class_code VARCHAR2(30);
2460: l_end_date_active DATE;
2501: l_party_usg_assignment_rec.party_id := p_party_id;
2502: l_party_usg_assignment_rec.party_usage_code := l_class_code;
2503: l_party_usg_assignment_rec.effective_end_date := trunc(p_end_date_active);
2504:
2505: HZ_PARTY_USG_ASSIGNMENT_PVT.update_usg_assignment (
2506: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,
2507: p_party_usg_assignment_id => l_assignment_id,
2508: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
2509: x_return_status => x_return_status,
2502: l_party_usg_assignment_rec.party_usage_code := l_class_code;
2503: l_party_usg_assignment_rec.effective_end_date := trunc(p_end_date_active);
2504:
2505: HZ_PARTY_USG_ASSIGNMENT_PVT.update_usg_assignment (
2506: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,
2507: p_party_usg_assignment_id => l_assignment_id,
2508: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
2509: x_return_status => x_return_status,
2510: x_msg_count => l_msg_count,