1 PACKAGE OKC_P_UTIL AS
2 /* $Header: OKCPUTLS.pls 120.0 2005/05/25 23:04:28 appldev noship $ */
3 -- Sub-Program Unit Declarations
4 /* Convert major and minor version numbers into a string for the veiws */
5 FUNCTION VERSION_STRING
6 (P_MAJOR IN NUMBER
7 ,P_MINOR IN NUMBER
8 )
9 RETURN VARCHAR2;
10 PRAGMA RESTRICT_REFERENCES (VERSION_STRING, WNPS, WNDS);
11 /* Convert raw value to number */
12 FUNCTION RAW_TO_NUMBER
13 (P_RAWID IN RAW
14 )
15 RETURN NUMBER;
16 PRAGMA RESTRICT_REFERENCES (RAW_TO_NUMBER, RNPS, WNPS, WNDS);
17 /* Execute any sql via dynamic sql */
18 FUNCTION EXECUTE_SQL
19 (P_SQL IN VARCHAR2
20 )
21 RETURN INTEGER;
22 /* Logic to run in view instead of triggers */
23 PROCEDURE INSTEAD_OF_TRG;
24
25 END OKC_P_UTIL;