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 4916: FROM hz_party_usg_assignments

4912: p_init_msg_list := 'T';
4913:
4914: begin
4915: SELECT PARTY_USAGE_CODE INTO l_from_usage_code
4916: FROM hz_party_usg_assignments
4917: where party_usg_assignment_id = p_from_id;
4918: EXCEPTION
4919: WHEN NO_DATA_FOUND THEN RETURN;
4920: end;

Line 4923: UPDATE hz_party_usg_assignments

4919: WHEN NO_DATA_FOUND THEN RETURN;
4920: end;
4921: /*
4922: IF l_from_usage_code = 'DEFAULT' THEN
4923: UPDATE hz_party_usg_assignments
4924: SET status_flag = 'M',
4925: effective_end_date = TRUNC(sysdate)
4926: WHERE party_usg_assignment_id = p_from_id;
4927: ELSE

Line 4933: UPDATE hz_party_usg_assignments

4929: --check for duplicate usage
4930: HZ_PARTY_USG_ASSIGNMENT_PVT.find_duplicates(p_from_id,p_to_fk_id,x_to_id);
4931: IF x_to_id IS NOT NULL THEN
4932: --duplicate usage exists
4933: UPDATE hz_party_usg_assignments
4934: SET status_flag = 'M',
4935: effective_end_date = sysdate
4936: WHERE party_usg_assignment_id = p_from_id;
4937:

Line 5001: FROM hz_party_usg_assignments

4997: p_party_usg_assignment_rec.attribute17,
4998: p_party_usg_assignment_rec.attribute18,
4999: p_party_usg_assignment_rec.attribute19,
5000: p_party_usg_assignment_rec.attribute20
5001: FROM hz_party_usg_assignments
5002: WHERE party_usg_assignment_id = p_from_id;
5003:
5004: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage
5005: (p_init_msg_list,0,p_party_usg_assignment_rec,x_return_status,x_msg_count,x_msg_data);

Line 5009: DELETE FROM hz_party_usg_assignments

5005: (p_init_msg_list,0,p_party_usg_assignment_rec,x_return_status,x_msg_count,x_msg_data);
5006:
5007: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
5008:
5009: DELETE FROM hz_party_usg_assignments
5010: WHERE party_usg_assignment_id = p_from_id;
5011:
5012: /* bug 5007937
5013: DELETE FROM hz_party_usg_assignments

Line 5013: DELETE FROM hz_party_usg_assignments

5009: DELETE FROM hz_party_usg_assignments
5010: WHERE party_usg_assignment_id = p_from_id;
5011:
5012: /* bug 5007937
5013: DELETE FROM hz_party_usg_assignments
5014: WHERE party_id = p_to_fk_id
5015: AND party_usage_code = 'DEFAULT';
5016: */
5017:

Line 5175: UPDATE hz_party_usg_assignments

5171: program_update_date = sysdate
5172: WHERE relationship_id = p_from_id;
5173:
5174: --4307667 merge usages with owner_table_name 'HZ_RELATIONSHIPS'
5175: UPDATE hz_party_usg_assignments
5176: SET status_flag = 'M',
5177: effective_end_date = trunc(sysdate)
5178: WHERE owner_table_id = p_from_id
5179: AND owner_table_name = 'HZ_RELATIONSHIPS'

Line 5570: UPDATE hz_party_usg_assignments

5566: WHERE relationship_id = p_from_id;
5567:
5568:
5569: --4307667 merge usages with owner_table_name 'HZ_RELATIONSHIPS'
5570: UPDATE hz_party_usg_assignments
5571: SET status_flag = 'M',
5572: effective_end_date = trunc(sysdate)
5573: WHERE owner_table_id = p_from_id
5574: AND owner_table_name = 'HZ_RELATIONSHIPS'