1: PACKAGE BODY pn_options_pkg AS
2: -- $Header: PNTOPTNB.pls 120.2 2005/12/01 08:25:59 appldev ship $
3: -------------------------------------------------------------------------------
4: -- PROCDURE : Insert_Row
5: -- HISTORY :
63: l_org_id NUMBER;
64:
65: BEGIN
66:
67: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.INSERT_ROW (+)');
68:
69: -------------------------------------------------------
70: -- We need to generate the lease change number
71: -------------------------------------------------------
186: RAISE NO_DATA_FOUND;
187: END IF;
188: CLOSE c;
189:
190: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.INSERT_ROW (-)');
191:
192: END Insert_Row;
193:
194: -------------------------------------------------------------------------------
244: tlinfo c1%ROWTYPE;
245:
246: BEGIN
247:
248: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.LOCK_ROW (+)');
249:
250: OPEN c1;
251: FETCH c1 INTO tlinfo;
252: IF (c1%NOTFOUND) THEN
419: OR ((tlinfo.OPTION_COMMENTS IS NULL) AND (X_OPTION_COMMENTS IS NULL))) THEN
420: pn_var_rent_pkg.lock_row_exception('OPTION_COMMENTS',tlinfo.OPTION_COMMENTS);
421: END IF;
422:
423: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.LOCK_ROW (-)');
424:
425: END Lock_Row;
426:
427: -------------------------------------------------------------------------------
481: l_optionHistoryId NUMBER := NULL;
482: l_leaseStatus VARCHAR2(30) := NULL;
483:
484: BEGIN
485: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.UPDATE_ROW (+)');
486:
487: ----------------------------------------------------
488: -- get the lease status
489: ----------------------------------------------------
642: IF (SQL%NOTFOUND) THEN
643: RAISE NO_DATA_FOUND;
644: END IF;
645:
646: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.UPDATE_ROW (-)');
647:
648: END Update_Row;
649:
650: -------------------------------------------------------------------------------
660: )
661: IS
662: BEGIN
663:
664: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.DELETE_ROW (+)');
665:
666: DELETE FROM pn_options_all
667: WHERE option_id = x_option_id;
668:
669: IF (SQL%NOTFOUND) THEN
670: RAISE NO_DATA_FOUND;
671: END IF;
672:
673: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.DELETE_ROW (-)');
674:
675: END Delete_Row;
676:
677: END pn_options_pkg;
673: pnp_debug_pkg.debug ('PN_OPTIONS_PKG.DELETE_ROW (-)');
674:
675: END Delete_Row;
676:
677: END pn_options_pkg;