DBA Data[Home] [Help]

APPS.PN_REC_ARCL_DTL_PKG dependencies on PN_REC_ARCL_DTL_PKG

Line 1: PACKAGE BODY pn_rec_arcl_dtl_pkg AS

1: PACKAGE BODY pn_rec_arcl_dtl_pkg AS
2: /* $Header: PNRACLHB.pls 120.2 2005/11/30 23:30:33 appldev noship $ */
3:
4:
5: -------------------------------------------------------------------------------

Line 37: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.insert_row';

33: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
34: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
36: IS
37: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.insert_row';
38:
39: CURSOR org_cur IS
40: SELECT org_id
41: FROM pn_rec_arcl_all

Line 146: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.update_row';

142: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
143: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
144: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
145: IS
146: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.update_row';
147: BEGIN
148:
149: pnp_debug_pkg.debug(l_desc ||' (+)');
150:

Line 193: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.delete_row';

189: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
190: -------------------------------------------------------------------------------
191: PROCEDURE delete_row(x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE)
192: IS
193: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.delete_row';
194: BEGIN
195:
196: pnp_debug_pkg.debug(l_desc ||' (+)');
197:

Line 209: END pn_rec_arcl_dtl_pkg;

205: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));
206: app_exception.raise_exception;
207: END delete_row;
208:
209: END pn_rec_arcl_dtl_pkg;