APPS.HZ_LOCATION_SERVICES_PUB dependencies on HZ_LOCATION_V2PUB

Line 22: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,

18: p_object_version_number IN NUMBER,
19: p_inout_doc IN CLOB );
20:
21: PROCEDURE validate_mandatory_column(
22: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
23: x_return_status IN OUT NOCOPY VARCHAR2);
24:
25: PROCEDURE log(
26: message IN VARCHAR2,

Line 55: p_location_rec IN hz_location_v2pub.location_rec_type,

51: p_from_out OUT NOCOPY VARCHAR2,
52: p_to_out OUT NOCOPY VARCHAR2 );
53:
54: PROCEDURE set_loc_assign_id(
55: p_location_rec IN hz_location_v2pub.location_rec_type,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2);
59:

Line 644: l_location_rec hz_location_v2pub.location_rec_type;

640: p_prov_state_admin_code IN VARCHAR2,
641: p_postal_code IN VARCHAR2,
642: p_validation_status_code IN VARCHAR2 )
643: IS
644: l_location_rec hz_location_v2pub.location_rec_type;
645: l_location_profile_rec hz_location_profile_pvt.location_profile_rec_type;
646: l_location_profile_id NUMBER;
647: l_state VARCHAR2(60);
648: l_province VARCHAR2(60);

Line 1125: p_location_rec IN hz_location_v2pub.location_rec_type,

1121:
1122: END get_validated_xml;
1123:
1124: PROCEDURE set_loc_assign_id (
1125: p_location_rec IN hz_location_v2pub.location_rec_type,
1126: x_return_status OUT NOCOPY VARCHAR2,
1127: x_msg_count OUT NOCOPY NUMBER,
1128: x_msg_data OUT NOCOPY VARCHAR2
1129: )

Line 1144: l_location_rec hz_location_v2pub.location_rec_type;

1140: where location_table_name = 'HZ_LOCATIONS'
1141: and location_id = l_loc_id
1142: and rownum = 1;
1143:
1144: l_location_rec hz_location_v2pub.location_rec_type;
1145: l_loc_id NUMBER;
1146: l_default_country VARCHAR2(2);
1147: l_org_id NUMBER;
1148: l_is_remit_to_location VARCHAR2(1) := 'N';

Line 1993: p_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

1989: RETURN 'SUCCESS';
1990: END indoc_rule;
1991:
1992: PROCEDURE validate_mandatory_column(
1993: p_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
1994: x_return_status IN OUT NOCOPY VARCHAR2) IS
1995: BEGIN
1996:
1997: IF(p_location_rec.address1 IS NULL OR p_location_rec.address1 = FND_API.G_MISS_CHAR) THEN