APPS.PN_LOCATION_ALIAS_PKG dependencies on PN_LOCATION_ALIAS_PKG

Line 1: PACKAGE BODY pn_location_alias_pkg AS

1: PACKAGE BODY pn_location_alias_pkg AS
2: /* $Header: PNLCALSB.pls 120.2.12010000.2 2008/11/27 04:24:49 rthumma ship $ */
3:
4: TYPE id_tbl IS TABLE OF pn_locations.location_id%TYPE INDEX BY BINARY_INTEGER;
5: TYPE code_tbl IS TABLE OF pn_locations.location_code%TYPE INDEX BY BINARY_INTEGER;

Line 25: l_desc VARCHAR2(300) := 'pn_location_alias_pkg.get_parent_location_code';

21: p_id_tbl IN id_tbl,
22: p_loc_id IN pn_locations.location_id%TYPE) RETURN VARCHAR2
23: IS
24: l_info VARCHAR2(300);
25: l_desc VARCHAR2(300) := 'pn_location_alias_pkg.get_parent_location_code';
26: l_result pn_locations.location_code%TYPE := '';
27: BEGIN
28: pnp_debug_pkg.debug(l_desc ||' (+)');
29:

Line 95: l_desc VARCHAR2(300) := 'pn_location_alias_pkg.change_alias';

91: old_cd_tbl code_tbl;
92: new_cd_tbl code_tbl;
93:
94: l_info VARCHAR2(300);
95: l_desc VARCHAR2(300) := 'pn_location_alias_pkg.change_alias';
96: l_count NUMBER;
97: l_uniq_loc_count NUMBER := 0; --Bug#5571818
98: INVALID_LOC_CODE EXCEPTION; --Bug#5571818
99:

Line 176: END pn_location_alias_pkg;

172: raise;
173:
174: END change_alias;
175:
176: END pn_location_alias_pkg;