APPS.PNT_LOCATION_FEATURES_PKG dependencies on PNT_LOCATION_FEATURES_PKG

Line 1: PACKAGE BODY PNT_LOCATION_FEATURES_PKG AS

1: PACKAGE BODY PNT_LOCATION_FEATURES_PKG AS
2: -- $Header: PNTFEATB.pls 120.2 2005/12/01 08:37:45 appldev ship $
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

Line 58: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.insert_row (+)');

54: l_org_ID NUMBER;
55:
56: BEGIN
57:
58: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.insert_row (+)');
59:
60: -----------------------------------------------------------------
61: -- Allocate the sequence to the primary key loction_id
62: -----------------------------------------------------------------

Line 149: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.insert_row (-)');

145: Raise NO_DATA_FOUND;
146: END IF;
147: CLOSE C;
148:
149: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.insert_row (-)');
150:
151: END insert_row;
152:
153: -------------------------------------------------------------------------------

Line 195: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.update_row (+)');

191: ,x_ATTRIBUTE15 VARCHAR2
192: ) IS
193: BEGIN
194:
195: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.update_row (+)');
196: UPDATE PN_LOCATION_FEATURES_ALL
197: SET
198: LOCATION_FEATURE_ID = x_LOCATION_FEATURE_ID
199: ,LAST_UPDATE_DATE = x_LAST_UPDATE_DATE

Line 233: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.update_row (-)');

229: IF (SQL%NOTFOUND) THEN
230: RAISE NO_DATA_FOUND;
231: END IF;
232:
233: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.update_row (-)');
234: END UPDATE_ROW;
235:
236: -------------------------------------------------------------------------------
237: -- PROCDURE : lock_row

Line 281: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.lock_row (+)');

277: Recinfo C%ROWTYPE;
278:
279: BEGIN
280:
281: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.lock_row (+)');
282: OPEN C;
283: FETCH C INTO Recinfo;
284: IF (C%NOTFOUND) THEN
285: CLOSE C;

Line 411: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.lock_row (-)');

407: OR ((Recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null))) THEN
408: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15', Recinfo.attribute15);
409: END IF;
410:
411: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.lock_row (-)');
412: END LOCK_ROW;
413:
414: -------------------------------------------------------------------------------
415: -- PROCDURE : delete_row

Line 427: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.delete_row (+)');

423: x_location_feature_id NUMBER
424: ) IS
425: BEGIN
426:
427: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.delete_row (+)');
428: DELETE FROM PN_LOCATION_FEATURES_ALL
429: WHERE location_feature_id = x_location_feature_id;
430:
431: IF (sql%notfound) THEN

Line 435: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.delete_row (-)');

431: IF (sql%notfound) THEN
432: RAISE NO_DATA_FOUND;
433: END IF;
434:
435: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.delete_row (-)');
436: END delete_row;
437:
438: END PNT_LOCATION_FEATURES_PKG ;

Line 438: END PNT_LOCATION_FEATURES_PKG ;

434:
435: PNP_DEBUG_PKG.debug ('PNT_LOCATION_FEATURES_PKG.delete_row (-)');
436: END delete_row;
437:
438: END PNT_LOCATION_FEATURES_PKG ;