DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_GEOGRAPHY_IDENTIFIERS_PKG

Line 1340: HZ_GEOGRAPHY_IDENTIFIERS_PKG.insert_row(

1336: ----dbms_output.put_line('before identifier insert');
1337:
1338: -- call table handler to insert the row in hz_geography_identifiers
1339:
1340: HZ_GEOGRAPHY_IDENTIFIERS_PKG.insert_row(
1341: x_rowid => l_rowid,
1342: x_geography_id => p_geo_identifier_rec.geography_id,
1343: x_identifier_subtype => l_identifier_subtype,
1344: x_identifier_value => l_identifier_value,

Line 1719: hz_geography_identifiers_pkg.update_row(

1715: -- --dbms_output.put_line ( 'After update of primary from Y to N');
1716: END IF;
1717: END IF;
1718:
1719: hz_geography_identifiers_pkg.update_row(
1720: x_rowid => l_rowid,
1721: x_geography_id => p_geo_identifier_rec.geography_id,
1722: x_identifier_subtype => l_new_geo_subtype,
1723: x_identifier_value => l_new_geo_value,

Line 1845: HZ_GEOGRAPHY_IDENTIFIERS_PKG.delete_row(

1841: END IF;
1842: END IF;
1843:
1844: IF l_delete_flag = 'Y' THEN
1845: HZ_GEOGRAPHY_IDENTIFIERS_PKG.delete_row(
1846: x_geography_id => p_geography_id,
1847: x_identifier_subtype => p_identifier_subtype,
1848: x_identifier_value => p_identifier_value,
1849: x_language_code => p_language_code,