[Home] [Help]
PACKAGE: APPS.CZ_BASE_MGR
Source
1 package CZ_BASE_MGR AUTHID CURRENT_USER as
2 /* $Header: czbsmgrs.pls 120.2 2011/04/19 18:36:57 smanna ship $ */
3
4 type Table_Record is record(name varchar2(30),pk_name varchar2(30));
5 type Table_List is table of Table_Record index by binary_integer;
6 DSQL_ERROR integer:=0;
7 CZ_SCHEMA varchar2(30);
8 BATCH_SIZE INTEGER:=10000;
9
10 procedure TRIGGERS_ENABLED
11 (Subschema_Name in varchar2,
12 Switch in varchar2);
13
14 procedure CONSTRAINTS_ENABLED
15 (Subschema_Name in varchar2,
16 Switch in varchar2);
17
18 function Redo_StartValue
19 (Table_Name in Table_Record) return integer;
20
21 procedure REDO_SEQUENCE
22 (SequenceTable in Table_Record,
23 RedoStart_Flag in varchar2,
24 var_incr in varchar2,
25 Status_flag OUT NOCOPY varchar2,
26 Proc_Name in varchar2);
27
28 procedure REDO_SEQUENCES
29 (Subschema_Name in varchar2,
30 RedoStart_Flag in varchar2,
31 incr in integer default null);
32
33 procedure PURGE(Subschema_Name in varchar2);
34
35 procedure MODIFIED
36 (Subschema_Name in varchar2,
37 AS_OF IN OUT NOCOPY date);
38
39 procedure RESET_CLEAR(Subschema_Name in varchar2);
40
41 procedure REDO_STATISTICS(Subschema_Name in varchar2);
42
43 procedure dsql
44 (stmt in varchar2);
45
46 procedure exec
47 (stmt in varchar2);
48
49 --For SUN : Bug12346474
50 procedure WRITE_TO_DB_LOGS
51 (inCaller IN VARCHAR2,
52 inMessage IN VARCHAR2,
53 inTableName IN VARCHAR2 DEFAULT NULL,
54 inMessageId IN NUMBER DEFAULT NULL,
55 inRunId IN NUMBER DEFAULT NULL);
56
57 procedure LOG_REPORT
58 (err in varchar2,
59 str in varchar2);
60
61 procedure get_TABLE_NAMES
62 (SubSchema in varchar2,
63 Tables IN OUT NOCOPY Table_List);
64
65 PROCEDURE exec
66 (
67 p_table_name IN VARCHAR2,
68 p_where IN VARCHAR2,
69 p_pk_col1 IN VARCHAR2,
70 p_pk_col2 IN VARCHAR2,
71 p_pk_col3 IN VARCHAR2,
72 p_pk_col4 IN VARCHAR2,
73 p_delete IN BOOLEAN);
74
75 PROCEDURE exec
76 (
77 p_table_name IN VARCHAR2,
78 p_where IN VARCHAR2,
79 p_pk_col1 IN VARCHAR2,
80 p_pk_col2 IN VARCHAR2,
81 p_pk_col3 IN VARCHAR2,
82 p_delete IN BOOLEAN);
83
84 PROCEDURE exec
85 (
86 p_table_name IN VARCHAR2,
87 p_where IN VARCHAR2,
88 p_pk_col1 IN VARCHAR2,
89 p_pk_col2 IN VARCHAR2,
90 p_delete IN BOOLEAN);
91
92 PROCEDURE exec
93 (
94 p_table_name IN VARCHAR2,
95 p_where IN VARCHAR2,
96 p_pk_col1 IN VARCHAR2,
97 p_delete IN BOOLEAN);
98
99 end;