PACKAGE: APPS.DDR_REF_UTIL_PKG

Source

1 PACKAGE ddr_ref_util_pkg AUTHID CURRENT_USER AS
2 /* $Header: ddrurefs.pls 120.0.12010000.4 2010/04/27 00:39:04 gglover ship $ */
3   FUNCTION GET_ERR_MSG (p_err_no VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
4   PROCEDURE TRUNC_INTERFACE (p_table_parameters IN VARCHAR2 DEFAULT NULL);
5   FUNCTION CHECK_MFG_ITEM_HCHY (p_hchy_cd VARCHAR2, p_hchy_level VARCHAR2) RETURN VARCHAR2;
6   FUNCTION CHECK_ORG_HCHY (p_hchy_cd VARCHAR2, p_hchy_level VARCHAR2, p_org_cd VARCHAR2) RETURN VARCHAR2;
7   FUNCTION CHECK_RTL_ITEM_HCHY (p_hchy_cd VARCHAR2, p_hchy_level VARCHAR2) RETURN VARCHAR2;
8   FUNCTION CHECK_TIME_HCHY (p_hchy_cd VARCHAR2, p_hchy_level VARCHAR2) RETURN VARCHAR2;
9   FUNCTION get_ref_map_run_id(p_audit_id VARCHAR2) RETURN NUMBER;
10   PROCEDURE parse_pad_accounts(p_max_level IN NUMBER DEFAULT 10);
11   c_audit_id NUMBER := NULL;
12   c_map_id NUMBER := NULL;
13   TYPE account_array IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
14 END ddr_ref_util_pkg;