APPS.PN_REC_ARCL_DTLLN_PKG dependencies on PN_REC_ARCL_DTLLN_PKG

Line 1: PACKAGE BODY pn_rec_arcl_dtlln_pkg AS

1: PACKAGE BODY pn_rec_arcl_dtlln_pkg AS
2: /* $Header: PNRACLDB.pls 120.2 2005/11/30 23:29:12 appldev noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

Line 46: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.insert_row';

42: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
43: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
44: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)
45: IS
46: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.insert_row';
47:
48: CURSOR org_cur IS
49: SELECT org_id
50: FROM pn_rec_arcl_dtl_all

Line 184: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.update_row';

180: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
181: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
182: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)
183: IS
184: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.update_row';
185: BEGIN
186:
187: pnp_debug_pkg.debug(l_desc ||' (+)');
188:

Line 239: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.delete_row';

235: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
236: -------------------------------------------------------------------------------
237: PROCEDURE delete_row(x_area_class_dtl_line_id pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE)
238: IS
239: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.delete_row';
240: BEGIN
241:
242: pnp_debug_pkg.debug(l_desc ||' (+)');
243:

Line 255: END pn_rec_arcl_dtlln_pkg;

251: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));
252: app_exception.raise_exception;
253: END delete_row;
254:
255: END pn_rec_arcl_dtlln_pkg;