APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_RELATIONSHIP_V2PUB

Line 608: l_relationship_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

604: x_relationship_id OUT NOCOPY NUMBER,
605: x_return_status IN OUT NOCOPY VARCHAR2
606: ) IS
607:
608: l_relationship_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
609: l_status VARCHAR2(1);
610: l_parent_count NUMBER;
611: x_msg_count NUMBER;
612: x_msg_data VARCHAR2(2000);

Line 794: HZ_RELATIONSHIP_V2PUB.create_relationship(

790:
791: --dbms_output.put_line('After constructing the master relation record');
792:
793: -- call to relationship API to create a relationship
794: HZ_RELATIONSHIP_V2PUB.create_relationship(
795: p_init_msg_list => 'F',
796: p_relationship_rec => l_relationship_rec,
797: x_relationship_id => x_relationship_id,
798: x_party_id => x_party_id,

Line 895: l_relationship_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

891: p_object_version_number IN OUT NOCOPY NUMBER,
892: x_return_status IN OUT NOCOPY VARCHAR2
893: ) IS
894:
895: l_relationship_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
896: x_msg_count NUMBER;
897: x_msg_data VARCHAR2(2000);
898: l_party_object_version_number NUMBER := NULL;
899: l_parent_count NUMBER;

Line 978: HZ_RELATIONSHIP_V2PUB.update_relationship(

974: l_relationship_rec.created_by_module := NULL;
975: l_relationship_rec.application_id := NULL;
976:
977: IF l_relationship_type <> 'MASTER_REF' THEN
978: HZ_RELATIONSHIP_V2PUB.update_relationship(
979: p_init_msg_list =>'F',
980: p_relationship_rec => l_relationship_rec,
981: p_object_version_number => p_object_version_number,
982: p_party_object_version_number => l_party_object_version_number,

Line 1037: HZ_RELATIONSHIP_V2PUB.update_relationship(

1033: ----dbms_output.put_line('l_update_flag '||l_update_flag);
1034:
1035: IF l_update_flag = 'Y' THEN
1036: -- call relationship API for update
1037: HZ_RELATIONSHIP_V2PUB.update_relationship(
1038: p_init_msg_list =>'F',
1039: p_relationship_rec => l_relationship_rec,
1040: p_object_version_number => p_object_version_number,
1041: p_party_object_version_number => l_party_object_version_number,

Line 2077: l_relationship_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;

2073: l_start_date DATE;
2074: l_end_date DATE;
2075: l_geography_use VARCHAR2(30);
2076: l_count NUMBER;
2077: l_relationship_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
2078: CURSOR c_get_all_relationships IS
2079: SELECT distinct relationship_id,object_version_number
2080: FROM HZ_RELATIONSHIPS
2081: WHERE (subject_id = p_geography_id

Line 2271: HZ_RELATIONSHIP_V2PUB.update_relationship(

2267:
2268: l_relationship_rec.relationship_id := l_get_all_relationships.relationship_id;
2269:
2270: --l_relationship_rec.relationship_code := l_get_all_relationships.relationship_code;
2271: HZ_RELATIONSHIP_V2PUB.update_relationship(
2272: p_init_msg_list => 'F',
2273: p_relationship_rec => l_relationship_rec,
2274: p_object_version_number => l_get_all_relationships.object_version_number,
2275: p_party_object_version_number => l_party_object_version_number,

Line 2658: l_relationship_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

2654: --l_parent_geography_type VARCHAR2(30);
2655: l_zone_type VARCHAR2(30);
2656: l_geography_use VARCHAR2(30);
2657: l_zone_relation_rec HZ_GEOGRAPHY_VALIDATE_PVT.zone_relation_rec_type;
2658: l_relationship_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
2659: l_geography_range_rec GEOGRAPHY_RANGE_REC_TYPE;
2660: l_incl_geo_type VARCHAR2(30);
2661: x_relationship_id NUMBER;
2662: x_party_id NUMBER;

Line 2840: HZ_RELATIONSHIP_V2PUB.create_relationship(

2836: l_relationship_rec.created_by_module := p_created_by_module;
2837: l_relationship_rec.application_id := p_application_id;
2838:
2839: -- call to relationship API to create a relationship
2840: HZ_RELATIONSHIP_V2PUB.create_relationship(
2841: p_init_msg_list => 'F',
2842: p_relationship_rec => l_relationship_rec,
2843: x_relationship_id => x_relationship_id,
2844: x_party_id => x_party_id,