1 PACKAGE MTH_UDA_PKG AS
2 /*$Header: mthuntbs.pls 120.3.12010000.1 2008/05/01 18:59:00 appldev ship $*/
3
4 PROCEDURE UPDATE_TO_PRIMARY_KEY(P_ENTITY IN VARCHAR2) ;
5 PROCEDURE NTB_UPLOAD_STANDARD_WHO(P_EXT_TBL_NAME IN VARCHAR2, P_EXTENSION_ID IN NUMBER, P_IF_ROW_EXISTS IN NUMBER) ;
6 PROCEDURE NTB_UPLOADTL(P_ENTITY IN VARCHAR2, P_EXTID IN NUMBER, P_IF_ROW_EXISTS IN NUMBER) ;
7 PROCEDURE NTB_UPLOAD(P_TARGET IN VARCHAR2) ;
8 PROCEDURE DEVICE_PRE_LOG(P_TARGET IN VARCHAR2) ;
9 PROCEDURE TB_UPLOAD ;
10 PROCEDURE DEVICE_POST_LOG(P_TARGET IN VARCHAR2) ;
11
12
13 FUNCTION GET_MST_TABLE_NAME(P_ENTITY IN VARCHAR2) RETURN VARCHAR2 ;
14 FUNCTION GET_MST_PK_NAME(P_ENTITY IN VARCHAR2) RETURN VARCHAR2 ;
15 FUNCTION GET_EXT_TL_TABLE_NAME(P_ENTITY IN VARCHAR2) RETURN VARCHAR2 ;
16 FUNCTION GET_EXT_TABLE_NAME(P_ENTITY IN VARCHAR2) RETURN VARCHAR2 ;
17 FUNCTION GET_ENTITY_CODE(P_ENTITY IN VARCHAR2) RETURN NUMBER ;
18 END MTH_UDA_PKG;