APPS.HZ_RELATIONSHIP_V2PUB dependencies on HZ_PARTY_USG_ASSIGNMENT_PVT

Line 403: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;

399: l_gen_contact_number VARCHAR2(1);
400: -- Bug 3306941.
401: l_meaning VARCHAR2(80);
402:
403: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
404: l_party_usage_validation_level NUMBER;
405: TYPE t_number15_table IS TABLE OF NUMBER(15);
406: TYPE t_varchar30_table IS TABLE OF VARCHAR2(30);
407: l_party_id_tbl t_number15_table := t_number15_table();

Line 1109: l_party_usage_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_MEDIUM;

1105: IF p_contact_party_usage_code IS NOT NULL THEN
1106: l_party_id_tbl(1) := p_contact_party_id;
1107: l_party_usage_code_tbl(1) := p_contact_party_usage_code;
1108: l_party_usg_assignment_rec.created_by_module := p_relationship_rec.created_by_module;
1109: l_party_usage_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_MEDIUM;
1110: ELSE
1111: l_party_usage_code_tbl(1) := 'ORG_CONTACT';
1112: l_party_usg_assignment_rec.created_by_module := 'TCA_V2_API';
1113: l_party_usage_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_LOW;

Line 1113: l_party_usage_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_LOW;

1109: l_party_usage_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_MEDIUM;
1110: ELSE
1111: l_party_usage_code_tbl(1) := 'ORG_CONTACT';
1112: l_party_usg_assignment_rec.created_by_module := 'TCA_V2_API';
1113: l_party_usage_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_LOW;
1114:
1115: IF p_relationship_rec.subject_type = 'PERSON' AND
1116: p_relationship_rec.object_type = 'ORGANIZATION'
1117: THEN

Line 1163: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (

1159: FOR i IN 1..l_party_usage_code_tbl.count LOOP
1160: l_party_usg_assignment_rec.party_id := l_party_id_tbl(i);
1161: l_party_usg_assignment_rec.party_usage_code := l_party_usage_code_tbl(i);
1162:
1163: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (
1164: p_validation_level => l_party_usage_validation_level,
1165: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
1166: x_return_status => x_return_status,
1167: x_msg_count => l_msg_count,

Line 1278: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;

1274:
1275: -- Bug 2197181: added for mix-n-match project.
1276: db_actual_content_source hz_relationships.actual_content_source%TYPE;
1277:
1278: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
1279:
1280: -- Bug 4693719 : Added for local assignment
1281: l_acs hz_relationships.actual_content_source%TYPE;
1282:

Line 2044: HZ_PARTY_USG_ASSIGNMENT_PVT.update_usg_assignment (

2040: l_party_usg_assignment_rec.effective_end_date := trunc(sysdate);
2041: END IF;
2042: END IF;
2043:
2044: HZ_PARTY_USG_ASSIGNMENT_PVT.update_usg_assignment (
2045: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,
2046: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
2047: x_return_status => x_return_status,
2048: x_msg_count => l_msg_count,

Line 2045: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,

2041: END IF;
2042: END IF;
2043:
2044: HZ_PARTY_USG_ASSIGNMENT_PVT.update_usg_assignment (
2045: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,
2046: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
2047: x_return_status => x_return_status,
2048: x_msg_count => l_msg_count,
2049: x_msg_data => l_msg_data