APPS.HZ_MERGE_PKG dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 586: 'HZ_PARTY_USG_ASSIGNMENTS','HZ_PARTIES',

582:
583: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
584: p_to_fk_id, p_par_entity_name,
585: 'HZ_MERGE_PKG.party_usage_merge',
586: 'HZ_PARTY_USG_ASSIGNMENTS','HZ_PARTIES',
587: 'PARTY_USG_ASSIGNMENT_ID', 'PARTY_ID',x_return_status);
588:
589: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
590: do_party_usage_merge(p_from_id,l_to_id, p_from_fk_id,

Line 4922: FROM hz_party_usg_assignments

4918: p_init_msg_list := 'T';
4919:
4920: begin
4921: SELECT PARTY_USAGE_CODE INTO l_from_usage_code
4922: FROM hz_party_usg_assignments
4923: where party_usg_assignment_id = p_from_id;
4924: EXCEPTION
4925: WHEN NO_DATA_FOUND THEN RETURN;
4926: end;

Line 4929: UPDATE hz_party_usg_assignments

4925: WHEN NO_DATA_FOUND THEN RETURN;
4926: end;
4927: /*
4928: IF l_from_usage_code = 'DEFAULT' THEN
4929: UPDATE hz_party_usg_assignments
4930: SET status_flag = 'M',
4931: effective_end_date = TRUNC(sysdate)
4932: WHERE party_usg_assignment_id = p_from_id;
4933: ELSE

Line 4939: UPDATE hz_party_usg_assignments

4935: --check for duplicate usage
4936: HZ_PARTY_USG_ASSIGNMENT_PVT.find_duplicates(p_from_id,p_to_fk_id,x_to_id);
4937: IF x_to_id IS NOT NULL THEN
4938: --duplicate usage exists
4939: UPDATE hz_party_usg_assignments
4940: SET status_flag = 'M',
4941: effective_end_date = sysdate
4942: WHERE party_usg_assignment_id = p_from_id;
4943:

Line 5007: FROM hz_party_usg_assignments

5003: p_party_usg_assignment_rec.attribute17,
5004: p_party_usg_assignment_rec.attribute18,
5005: p_party_usg_assignment_rec.attribute19,
5006: p_party_usg_assignment_rec.attribute20
5007: FROM hz_party_usg_assignments
5008: WHERE party_usg_assignment_id = p_from_id;
5009:
5010: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage
5011: (p_init_msg_list,0,p_party_usg_assignment_rec,x_return_status,x_msg_count,x_msg_data);

Line 5015: DELETE FROM hz_party_usg_assignments

5011: (p_init_msg_list,0,p_party_usg_assignment_rec,x_return_status,x_msg_count,x_msg_data);
5012:
5013: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5014:
5015: DELETE FROM hz_party_usg_assignments
5016: WHERE party_usg_assignment_id = p_from_id;
5017:
5018: /* bug 5007937
5019: DELETE FROM hz_party_usg_assignments

Line 5019: DELETE FROM hz_party_usg_assignments

5015: DELETE FROM hz_party_usg_assignments
5016: WHERE party_usg_assignment_id = p_from_id;
5017:
5018: /* bug 5007937
5019: DELETE FROM hz_party_usg_assignments
5020: WHERE party_id = p_to_fk_id
5021: AND party_usage_code = 'DEFAULT';
5022: */
5023:

Line 5188: UPDATE hz_party_usg_assignments

5184: program_update_date = sysdate
5185: WHERE relationship_id = p_from_id;
5186:
5187: --4307667 merge usages with owner_table_name 'HZ_RELATIONSHIPS'
5188: UPDATE hz_party_usg_assignments
5189: SET status_flag = 'M',
5190: effective_end_date = trunc(sysdate)
5191: WHERE owner_table_id = p_from_id
5192: AND owner_table_name = 'HZ_RELATIONSHIPS'

Line 5648: UPDATE hz_party_usg_assignments

5644: WHERE relationship_id = p_from_id;
5645:
5646:
5647: --4307667 merge usages with owner_table_name 'HZ_RELATIONSHIPS'
5648: UPDATE hz_party_usg_assignments
5649: SET status_flag = 'M',
5650: effective_end_date = trunc(sysdate)
5651: WHERE owner_table_id = p_from_id
5652: AND owner_table_name = 'HZ_RELATIONSHIPS'