3:
4: PROCEDURE change_alias(
5: errbuf OUT NOCOPY VARCHAR2,
6: retcode OUT NOCOPY VARCHAR2,
7: p_location_type IN pn_locations.location_type_lookup_code%TYPE,
8: p_location_code IN pn_locations.location_code%TYPE,
9: p_new_alias IN pn_locations.location_alias%TYPE);
10:
11: END pn_location_alias_pkg;
4: PROCEDURE change_alias(
5: errbuf OUT NOCOPY VARCHAR2,
6: retcode OUT NOCOPY VARCHAR2,
7: p_location_type IN pn_locations.location_type_lookup_code%TYPE,
8: p_location_code IN pn_locations.location_code%TYPE,
9: p_new_alias IN pn_locations.location_alias%TYPE);
10:
11: END pn_location_alias_pkg;
5: errbuf OUT NOCOPY VARCHAR2,
6: retcode OUT NOCOPY VARCHAR2,
7: p_location_type IN pn_locations.location_type_lookup_code%TYPE,
8: p_location_code IN pn_locations.location_code%TYPE,
9: p_new_alias IN pn_locations.location_alias%TYPE);
10:
11: END pn_location_alias_pkg;