DBA Data[Home] [Help]

APPS.PN_REC_EXPCL_DTLLN_PKG dependencies on PN_REC_EXPCL_DTLLN_PKG

Line 1: PACKAGE BODY pn_rec_expcl_dtlln_pkg AS

1: PACKAGE BODY pn_rec_expcl_dtlln_pkg AS
2: /* $Header: PNRECLNB.pls 120.2 2005/11/30 23:38:27 appldev noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

Line 38: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.insert_row';

34: x_created_by pn_rec_expcl_dtlln.created_by%TYPE,
35: x_last_update_login pn_rec_expcl_dtlln.last_update_login%TYPE
36: )
37: IS
38: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.insert_row';
39: CURSOR org_cur IS
40: SELECT org_id
41: FROM pn_rec_expcl_dtl_all
42: WHERE expense_class_dtl_id = x_expense_class_dtl_id;

Line 148: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.update_row';

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

Line 195: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.delete_row';

191: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
192: -------------------------------------------------------------------------------
193: PROCEDURE delete_row(x_expense_class_line_id pn_rec_expcl_dtlln.expense_class_line_id%TYPE)
194: IS
195: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtlln_pkg.delete_row';
196: BEGIN
197:
198: pnp_debug_pkg.debug(l_desc ||' (+)');
199:

Line 211: END pn_rec_expcl_dtlln_pkg;

207: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));
208: app_exception.raise_exception;
209: END delete_row;
210:
211: END pn_rec_expcl_dtlln_pkg;