APPS.PNT_LOCATIONS_PKG dependencies on PNT_ADDR_PKG

Line 1171: -- PNT_ADDR_PKG.insert_row

1167: -- disposition, acc_treatment.
1168: -- 28-APR-05 piagrawa o Modified the select statements to retrieve values
1169: -- from pn_locations_all instead of pn_locations
1170: -- Also passed org_id as parameter to
1171: -- PNT_ADDR_PKG.insert_row
1172: -- 19-JUL-05 SatyaDeep o Added argument x_source to insert the source
1173: -- product from pn_locations_itf for bug#4468893
1174: -- 28-NOV-05 pikhar o fetched org_id using cursor
1175: -- 21-AUG-08 rthumma o Bug 7273859 : Modified call to pnt_addr_pkg.insert_row

Line 1175: -- 21-AUG-08 rthumma o Bug 7273859 : Modified call to pnt_addr_pkg.insert_row

1171: -- PNT_ADDR_PKG.insert_row
1172: -- 19-JUL-05 SatyaDeep o Added argument x_source to insert the source
1173: -- product from pn_locations_itf for bug#4468893
1174: -- 28-NOV-05 pikhar o fetched org_id using cursor
1175: -- 21-AUG-08 rthumma o Bug 7273859 : Modified call to pnt_addr_pkg.insert_row
1176: -- to pass NULL for ATTRIBUTE_CATEGORY,attribute1..15
1177: -------------------------------------------------------------------------------
1178: PROCEDURE insert_row (
1179: x_rowid IN OUT NOCOPY rowid

Line 1409: PNT_ADDR_PKG.insert_row (

1405:
1406: pnp_debug_pkg.put_log_msg('Calling address insert address =' || x_address_id);
1407: IF (NVL(x_LOCATION_TYPE_LOOKUP_CODE, ' ') IN ('BUILDING','LAND'))
1408: AND x_address_id is null THEN
1409: PNT_ADDR_PKG.insert_row (
1410: x_address_id,
1411: x_address_line1,
1412: x_address_line2,
1413: x_address_line3,

Line 1653: -- 21-AUG-08 rthumma o Bug 7273859 : Modified call to pnt_addr_pkg.update_row

1649: -- in Where clause.
1650: -- 27-feb-06 piagrawa o Bug#5015429 - Modified to make a call to
1651: -- loctn_assgn_area_update when x_assgn_area_chgd_flag
1652: -- is equal to 'CORRECT' or 'UPDATE'
1653: -- 21-AUG-08 rthumma o Bug 7273859 : Modified call to pnt_addr_pkg.update_row
1654: -- to pass NULL for ATTRIBUTE_CATEGORY,attribute1..15
1655: -------------------------------------------------------------------------------
1656: PROCEDURE UPDATE_ROW (
1657: x_LOCATION_ID NUMBER

Line 1856: PNT_ADDR_PKG.update_row (

1852: -- elements. This will only be called when we update the
1853: -- building record.
1854: -----------------------------------------------------------------
1855: IF NVL(x_LOCATION_TYPE_LOOKUP_CODE, ' ') IN ('BUILDING','LAND') THEN
1856: PNT_ADDR_PKG.update_row (
1857: x_address_id,
1858: x_address_line1,
1859: x_address_line2,
1860: x_address_line3,

Line 1922: -- 21-AUG-2008 rthumma o Bug 7273859 : Modified call to pnt_addr_pkg.lock_row

1918: -- PROCEDURE : lock_row
1919: -- 01-DEC-2004 Satish Tripathi o Modified for Portfolio Status Enh BUG# 4030816.
1920: -- Added parameters occupancy_status_code, assignable_emp,
1921: -- assignable_cc, assignable_cust, disposition, acc_treatment.
1922: -- 21-AUG-2008 rthumma o Bug 7273859 : Modified call to pnt_addr_pkg.lock_row
1923: -- to pass NULL for ATTRIBUTE_CATEGORY,attribute1..15
1924: ------------------------------------------------------------------------
1925: PROCEDURE lock_row (
1926: x_LOCATION_ID NUMBER

Line 2353: PNT_ADDR_PKG.LOCK_ROW(

2349: -- row for update. This will only be called when we lock the
2350: -- building record.
2351: -----------------------------------------------------------------
2352: IF (NVL(x_LOCATION_TYPE_LOOKUP_CODE, ' ') IN ('BUILDING','LAND')) THEN
2353: PNT_ADDR_PKG.LOCK_ROW(
2354: x_address_id,
2355: x_address_line1,
2356: x_address_line2,
2357: x_address_line3,