APPS.PN_RIGHTS_PKG dependencies on PN_RIGHTS_ALL

Line 49: FROM pn_rights_all

45: IS
46:
47: CURSOR rights IS
48: SELECT ROWID
49: FROM pn_rights_all
50: WHERE right_id = x_right_id;
51:
52: CURSOR org_cur IS
53: SELECT org_id FROM pn_leases_all WHERE lease_id = x_lease_id;

Line 66: FROM pn_rights_all pnr

62: -- We need to generate the right number
63: -------------------------------------------------------
64: SELECT NVL(MAX(pnr.right_num),0)
65: INTO x_right_num
66: FROM pn_rights_all pnr
67: WHERE pnr.lease_id = x_lease_id;
68:
69: X_RIGHT_NUM := X_RIGHT_NUM + 1;
70:

Line 90: INSERT INTO PN_RIGHTS_ALL

86: l_org_id := x_org_id;
87: END IF;
88:
89:
90: INSERT INTO PN_RIGHTS_ALL
91: (
92: RIGHT_ID,
93: LAST_UPDATE_DATE,
94: LAST_UPDATED_BY,

Line 212: FROM pn_rights_all

208: )
209: IS
210: CURSOR c1 IS
211: SELECT *
212: FROM pn_rights_all
213: WHERE right_id = x_right_id
214: FOR UPDATE OF right_id NOWAIT;
215:
216: tlinfo c1%ROWTYPE;

Line 399: FROM pn_rights_all

395: )
396: IS
397: CURSOR c2 IS
398: SELECT *
399: FROM pn_rights_all
400: WHERE right_id = x_right_id;
401:
402: recInfoForHist c2%ROWTYPE;
403: l_rightHistoryId NUMBER := NULL;

Line 508: UPDATE PN_RIGHTS_ALL

504: );
505: END IF;
506: END IF;
507:
508: UPDATE PN_RIGHTS_ALL
509: SET LEASE_ID = X_LEASE_ID,
510: LEASE_CHANGE_ID = X_LEASE_CHANGE_ID,
511: RIGHT_NUM = X_RIGHT_NUM,
512: RIGHT_TYPE_CODE = X_RIGHT_TYPE_CODE,

Line 563: DELETE FROM PN_RIGHTS_ALL --sdm_MOAC

559: BEGIN
560:
561: pnp_debug_pkg.debug ('PN_RIGHTS_PKG.DELETE_ROW (+)');
562:
563: DELETE FROM PN_RIGHTS_ALL --sdm_MOAC
564: WHERE RIGHT_ID = X_RIGHT_ID;
565:
566: IF (SQL%NOTFOUND) THEN
567: RAISE NO_DATA_FOUND;