DBA Data[Home] [Help]

PACKAGE: APPS.HXC_ALIAS_TYPES_CHKS

Source


1 PACKAGE HXC_ALIAS_TYPES_CHKS AUTHID CURRENT_USER as
2 /* $Header: hxcaltchk.pkh 115.2 2002/11/27 19:53:06 jdupont noship $ */
3 p_X_SELECT_WC varchar2(3200);
4 p_X_SELECT_NC varchar2(3200);
5 p_X_MAPPING_CODE varchar2(100);
6 p_X_SUCCESS number;
7 G_MISS_CHAR   	CONSTANT    VARCHAR2(1) := chr(0);
8 c number;
9 p_id number(10);
10 p_name  varchar2(60);
11 rec_tab dbms_sql.desc_tab;
12 col_cnt number;
13 invalid_sql EXCEPTION;
14 PROCEDURE Check_Sql(X_P_ID IN NUMBER,
15                     P_SQL_WC OUT NOCOPY VARCHAR2,
16 		    P_SQL_NC OUT NOCOPY VARCHAR2,
17 		    P_RET OUT NOCOPY VARCHAR2);
18 PROCEDURE get_id_string (X_P_ID IN NUMBER,
19                     P_SQL_WC OUT NOCOPY VARCHAR2,
20                     P_SQL_NC OUT NOCOPY VARCHAR2,
21                     P_RET OUT NOCOPY VARCHAR2);
22 END HXC_ALIAS_TYPES_CHKS;