DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_VALIDATE_PVT dependencies on HZ_GEOGRAPHY_PUB

Line 183: p_master_relation_rec IN HZ_GEOGRAPHY_PUB.master_relation_rec_type,

179: * 11-22-2002 Rekha Nalluri o Created.
180: *
181: */
182: PROCEDURE validate_master_relation (
183: p_master_relation_rec IN HZ_GEOGRAPHY_PUB.master_relation_rec_type,
184: p_create_update_flag IN VARCHAR2,
185: x_return_status IN OUT NOCOPY VARCHAR2
186: )IS
187:

Line 344: p_geo_identifier_rec IN HZ_GEOGRAPHY_PUB.geo_identifier_rec_type,

340: *
341: */
342:
343: PROCEDURE validate_geo_identifier (
344: p_geo_identifier_rec IN HZ_GEOGRAPHY_PUB.geo_identifier_rec_type,
345: p_create_update_flag IN VARCHAR2,
346: x_return_status IN OUT NOCOPY VARCHAR2
347: )IS
348:

Line 527: p_master_geography_rec IN HZ_GEOGRAPHY_PUB.master_geography_rec_type,

523: *
524: */
525:
526: PROCEDURE validate_master_geography (
527: p_master_geography_rec IN HZ_GEOGRAPHY_PUB.master_geography_rec_type,
528: p_create_update_flag IN VARCHAR2,
529: x_return_status IN OUT NOCOPY VARCHAR2
530: ) IS
531:

Line 533: l_parent_geography_tbl HZ_GEOGRAPHY_PUB.parent_geography_tbl_type;

529: x_return_status IN OUT NOCOPY VARCHAR2
530: ) IS
531:
532: l_count NUMBER;
533: l_parent_geography_tbl HZ_GEOGRAPHY_PUB.parent_geography_tbl_type;
534: l_start_date DATE;
535: l_end_date DATE;
536: l_last NUMBER;
537: --l_geography_type VARCHAR2(30);

Line 727: p_geography_range_rec IN HZ_GEOGRAPHY_PUB.geography_range_rec_type,

723: *
724: */
725:
726: PROCEDURE validate_geography_range (
727: p_geography_range_rec IN HZ_GEOGRAPHY_PUB.geography_range_rec_type,
728: p_create_update_flag IN VARCHAR2,
729: x_return_status IN OUT NOCOPY VARCHAR2
730: ) IS
731: