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 1111: l_party_usage_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_MEDIUM;

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

Line 1115: l_party_usage_validation_level := HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_LOW;

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

Line 1165: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (

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

Line 1284: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;

1280:
1281: -- Bug 2197181: added for mix-n-match project.
1282: db_actual_content_source hz_relationships.actual_content_source%TYPE;
1283:
1284: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
1285:
1286: -- Bug 4693719 : Added for local assignment
1287: l_acs hz_relationships.actual_content_source%TYPE;
1288:

Line 2069: HZ_PARTY_USG_ASSIGNMENT_PVT.update_usg_assignment (

2065: l_party_usg_assignment_rec.effective_end_date := trunc(sysdate);
2066: END IF;
2067: END IF;
2068:
2069: HZ_PARTY_USG_ASSIGNMENT_PVT.update_usg_assignment (
2070: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,
2071: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
2072: x_return_status => x_return_status,
2073: x_msg_count => l_msg_count,

Line 2070: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,

2066: END IF;
2067: END IF;
2068:
2069: HZ_PARTY_USG_ASSIGNMENT_PVT.update_usg_assignment (
2070: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_NONE,
2071: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
2072: x_return_status => x_return_status,
2073: x_msg_count => l_msg_count,
2074: x_msg_data => l_msg_data