DBA Data[Home] [Help]

APPS.PN_REC_EXPCL_DTL_PKG dependencies on PN_REC_EXPCL_DTL_PKG

Line 1: PACKAGE BODY pn_rec_expcl_dtl_pkg AS

1: PACKAGE BODY pn_rec_expcl_dtl_pkg AS
2: /* $Header: PNRECLSB.pls 120.2 2005/11/30 23:39:30 appldev noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

Line 28: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtl_pkg.insert_row';

24: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
25: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
26: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE)
27: IS
28: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtl_pkg.insert_row';
29:
30: CURSOR org_cur IS
31: SELECT org_id
32: FROM pn_rec_exp_line_all

Line 112: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtl_pkg.update_row';

108: x_creation_date pn_rec_expcl_dtl.creation_date%TYPE,
109: x_created_by pn_rec_expcl_dtl.created_by%TYPE,
110: x_last_update_login pn_rec_expcl_dtl.last_update_login%TYPE)
111: IS
112: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtl_pkg.update_row';
113: BEGIN
114:
115: pnp_debug_pkg.debug(l_desc ||' (+)');
116:

Line 149: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtl_pkg.delete_row';

145: -- HISTORY :
146: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
147: -------------------------------------------------------------------------------
148: PROCEDURE delete_row(x_expense_class_dtl_id pn_rec_expcl_dtl.expense_class_dtl_id%TYPE) IS
149: l_desc VARCHAR2(100) := 'pn_rec_expcl_dtl_pkg.delete_row';
150: BEGIN
151:
152: pnp_debug_pkg.debug(l_desc ||' (+)');
153:

Line 165: END pn_rec_expcl_dtl_pkg;

161: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));
162: app_exception.raise_exception;
163: END delete_row;
164:
165: END pn_rec_expcl_dtl_pkg;