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 897: l_relationship_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

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

Line 983: HZ_RELATIONSHIP_V2PUB.update_relationship(

979: l_relationship_rec.created_by_module := NULL;
980: l_relationship_rec.application_id := NULL;
981:
982: IF l_relationship_type <> 'MASTER_REF' THEN
983: HZ_RELATIONSHIP_V2PUB.update_relationship(
984: p_init_msg_list =>'F',
985: p_relationship_rec => l_relationship_rec,
986: p_object_version_number => p_object_version_number,
987: p_party_object_version_number => l_party_object_version_number,

Line 1042: HZ_RELATIONSHIP_V2PUB.update_relationship(

1038: ----dbms_output.put_line('l_update_flag '||l_update_flag);
1039:
1040: IF l_update_flag = 'Y' THEN
1041: -- call relationship API for update
1042: HZ_RELATIONSHIP_V2PUB.update_relationship(
1043: p_init_msg_list =>'F',
1044: p_relationship_rec => l_relationship_rec,
1045: p_object_version_number => p_object_version_number,
1046: p_party_object_version_number => l_party_object_version_number,

Line 2090: l_relationship_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;

2086: l_start_date DATE;
2087: l_end_date DATE;
2088: l_geography_use VARCHAR2(30);
2089: l_count NUMBER;
2090: l_relationship_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
2091: CURSOR c_get_all_relationships IS
2092: SELECT distinct relationship_id,object_version_number
2093: FROM HZ_RELATIONSHIPS
2094: WHERE (subject_id = p_geography_id

Line 2284: HZ_RELATIONSHIP_V2PUB.update_relationship(

2280:
2281: l_relationship_rec.relationship_id := l_get_all_relationships.relationship_id;
2282:
2283: --l_relationship_rec.relationship_code := l_get_all_relationships.relationship_code;
2284: HZ_RELATIONSHIP_V2PUB.update_relationship(
2285: p_init_msg_list => 'F',
2286: p_relationship_rec => l_relationship_rec,
2287: p_object_version_number => l_get_all_relationships.object_version_number,
2288: p_party_object_version_number => l_party_object_version_number,

Line 2671: l_relationship_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

2667: --l_parent_geography_type VARCHAR2(30);
2668: l_zone_type VARCHAR2(30);
2669: l_geography_use VARCHAR2(30);
2670: l_zone_relation_rec HZ_GEOGRAPHY_VALIDATE_PVT.zone_relation_rec_type;
2671: l_relationship_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
2672: l_geography_range_rec GEOGRAPHY_RANGE_REC_TYPE;
2673: l_incl_geo_type VARCHAR2(30);
2674: x_relationship_id NUMBER;
2675: x_party_id NUMBER;

Line 2853: HZ_RELATIONSHIP_V2PUB.create_relationship(

2849: l_relationship_rec.created_by_module := p_created_by_module;
2850: l_relationship_rec.application_id := p_application_id;
2851:
2852: -- call to relationship API to create a relationship
2853: HZ_RELATIONSHIP_V2PUB.create_relationship(
2854: p_init_msg_list => 'F',
2855: p_relationship_rec => l_relationship_rec,
2856: x_relationship_id => x_relationship_id,
2857: x_party_id => x_party_id,