APPS.PNT_PROPERTIES_PKG dependencies on PN_PROPERTIES_ALL

Line 23: FROM pn_properties_all

19: l_prop_ID NUMBER;
20: CURSOR dup_prop_code1 IS
21: SELECT property_ID
22: INTO l_prop_ID
23: FROM pn_properties_all
24: WHERE property_code = x_property_code
25: AND org_ID = x_org_id;
26:
27: CURSOR dup_prop_code2 IS

Line 30: FROM pn_properties_all

26:
27: CURSOR dup_prop_code2 IS
28: SELECT property_ID
29: INTO l_prop_ID
30: FROM pn_properties_all
31: WHERE property_code = x_property_code
32: AND property_id <> x_property_id
33: AND org_ID = x_org_id;
34:

Line 113: FROM PN_PROPERTIES_ALL

109: IS
110:
111: CURSOR properties IS
112: SELECT ROWID
113: FROM PN_PROPERTIES_ALL
114: WHERE PROPERTY_ID = X_PROPERTY_ID;
115:
116: l_return_status VARCHAR2(20) := NULL;
117:

Line 141: INSERT INTO PN_PROPERTIES_ALL

137: SELECT pn_properties_s.NEXTVAL
138: INTO X_PROPERTY_ID
139: FROM dual;
140:
141: INSERT INTO PN_PROPERTIES_ALL
142: (
143: ORG_ID,
144: PROPERTY_ID,
145: LAST_UPDATE_DATE,

Line 277: FROM PN_PROPERTIES_ALL

273: ) IS
274:
275: CURSOR c IS
276: SELECT *
277: FROM PN_PROPERTIES_ALL
278: WHERE PROPERTY_ID = X_PROPERTY_ID
279: FOR UPDATE OF property_id NOWAIT;
280:
281: tlinfo c%ROWTYPE;

Line 492: UPDATE PN_PROPERTIES_ALL

488: BEGIN
489:
490: PNP_DEBUG_PKG.debug ('PNT_PROPERTIES_PKG.UPDATE_ROW (+)');
491:
492: UPDATE PN_PROPERTIES_ALL
493: SET
494: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
495: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
496: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,