DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_GEOGRAPHIES_PKG

Line 1736: -- It will call procedure HZ_GEOGRAPHIES_PKG.update_geo_element_cp

1732: x_application_id => NULL,
1733: x_program_login_id => NULL);
1734:
1735: -- Kick off conc prog if primary flag is Y and name or code has been updated
1736: -- It will call procedure HZ_GEOGRAPHIES_PKG.update_geo_element_cp
1737: IF ((l_geography_use = 'MASTER_REF') AND
1738: ((l_old_primary_flag = 'N' AND p_geo_identifier_rec.primary_flag = 'Y') OR
1739: ((l_old_primary_flag = 'Y' AND p_geo_identifier_rec.primary_flag = 'Y') AND
1740: (l_name_updated = 'Y'))

Line 1916: HZ_GEOGRAPHIES_PKG.insert_row(

1912: END IF;
1913:
1914: --dbms_output.put_line('before insert_row');
1915: --insert row into HZ_GEOGRAPHIES
1916: HZ_GEOGRAPHIES_PKG.insert_row(
1917: x_rowid => l_rowid,
1918: x_geography_id => x_geography_id,
1919: x_object_version_number => 1,
1920: x_geography_type => UPPER(p_master_geography_rec.geography_type),

Line 2192: HZ_GEOGRAPHIES_PKG.update_row(

2188: END IF;
2189: --dbms_output.put_line('After date validation '|| x_return_status);
2190:
2191: --call table handler to update the geography
2192: HZ_GEOGRAPHIES_PKG.update_row(
2193: x_rowid => l_rowid,
2194: x_geography_id => p_geography_id,
2195: x_object_version_number => p_object_version_number,
2196: x_geography_type => NULL,

Line 3074: HZ_GEOGRAPHIES_PKG.insert_row(

3070:
3071:
3072: -- call table handler to insert a row in hz_geographies
3073:
3074: HZ_GEOGRAPHIES_PKG.insert_row(
3075: x_rowid => l_rowid,
3076: x_geography_id => x_geography_id,
3077: x_object_version_number => 1,
3078: x_geography_type => p_zone_type,