APPS.PNT_LOCATION_FEATURES_PKG dependencies on PN_LOCATION_FEATURES_ALL

Line 48: FROM PN_LOCATION_FEATURES_ALL

44: )
45: IS
46: CURSOR C IS
47: SELECT rowid
48: FROM PN_LOCATION_FEATURES_ALL
49: WHERE LOCATION_FEATURE_ID = x_location_feature_id;
50:
51: CURSOR org_cur IS
52: SELECT org_id FROM pn_locations_all WHERE location_id = x_LOCATION_ID AND ROWNUM = 1;

Line 75: INSERT INTO PN_LOCATION_FEATURES_ALL

71: ELSE
72: l_org_id := x_org_id;
73: END IF;
74:
75: INSERT INTO PN_LOCATION_FEATURES_ALL
76: (
77: LOCATION_FEATURE_ID
78: ,org_id
79: ,LAST_UPDATE_DATE

Line 196: UPDATE PN_LOCATION_FEATURES_ALL

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
200: ,LAST_UPDATED_BY = x_LAST_UPDATED_BY

Line 273: FROM PN_LOCATION_FEATURES_ALL

269: )
270: IS
271: CURSOR C IS
272: SELECT *
273: FROM PN_LOCATION_FEATURES_ALL
274: WHERE LOCATION_FEATURE_ID = x_LOCATION_FEATURE_ID
275: FOR UPDATE OF LOCATION_FEATURE_ID NOWAIT;
276:
277: Recinfo C%ROWTYPE;

Line 428: DELETE FROM PN_LOCATION_FEATURES_ALL

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
432: RAISE NO_DATA_FOUND;