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.4.12020000.3 2013/02/07 09:35:08 ppenumar 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 101: l_desc VARCHAR2(300) := 'pn_location_alias_pkg.change_alias';

97: old_cd_tbl code_tbl;
98: new_cd_tbl code_tbl;
99:
100: l_info VARCHAR2(300);
101: l_desc VARCHAR2(300) := 'pn_location_alias_pkg.change_alias';
102: l_count NUMBER;
103: l_uniq_loc_count NUMBER := 0; --Bug#5571818
104: INVALID_LOC_CODE EXCEPTION; --Bug#5571818
105: l_new_loc_code VARCHAR2(300); -- Bug#16098151

Line 187: END pn_location_alias_pkg;

183: raise;
184:
185: END change_alias;
186:
187: END pn_location_alias_pkg;