DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_GEOGRAPHY_IDENTIFIERS_PKG

Line 1335: HZ_GEOGRAPHY_IDENTIFIERS_PKG.insert_row(

1331: ----dbms_output.put_line('before identifier insert');
1332:
1333: -- call table handler to insert the row in hz_geography_identifiers
1334:
1335: HZ_GEOGRAPHY_IDENTIFIERS_PKG.insert_row(
1336: x_rowid => l_rowid,
1337: x_geography_id => p_geo_identifier_rec.geography_id,
1338: x_identifier_subtype => l_identifier_subtype,
1339: x_identifier_value => l_identifier_value,

Line 1710: hz_geography_identifiers_pkg.update_row(

1706: -- --dbms_output.put_line ( 'After update of primary from Y to N');
1707: END IF;
1708: END IF;
1709:
1710: hz_geography_identifiers_pkg.update_row(
1711: x_rowid => l_rowid,
1712: x_geography_id => p_geo_identifier_rec.geography_id,
1713: x_identifier_subtype => l_new_geo_subtype,
1714: x_identifier_value => l_new_geo_value,

Line 1832: HZ_GEOGRAPHY_IDENTIFIERS_PKG.delete_row(

1828: END IF;
1829: END IF;
1830:
1831: IF l_delete_flag = 'Y' THEN
1832: HZ_GEOGRAPHY_IDENTIFIERS_PKG.delete_row(
1833: x_geography_id => p_geography_id,
1834: x_identifier_subtype => p_identifier_subtype,
1835: x_identifier_value => p_identifier_value,
1836: x_language_code => p_language_code,