PACKAGE: APPS.CZ_BASE_MGR

Source

1 package CZ_BASE_MGR as
2 /*  $Header: czbsmgrs.pls 120.0 2005/05/25 06:50:55 appldev noship $	*/
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 procedure LOG_REPORT
50 (err in varchar2,
51  str in varchar2);
52 
53 procedure get_TABLE_NAMES
54 (SubSchema     in varchar2,
55  Tables        IN OUT NOCOPY Table_List);
56 
57 PROCEDURE exec
58 (
59  p_table_name   IN VARCHAR2,
60  p_where        IN VARCHAR2,
61  p_pk_col1      IN VARCHAR2,
62  p_pk_col2      IN VARCHAR2,
63  p_pk_col3      IN VARCHAR2,
64  p_pk_col4      IN VARCHAR2,
65  p_delete       IN BOOLEAN);
66 
67 PROCEDURE exec
68 (
69  p_table_name   IN VARCHAR2,
70  p_where        IN VARCHAR2,
71  p_pk_col1      IN VARCHAR2,
72  p_pk_col2      IN VARCHAR2,
73  p_pk_col3      IN VARCHAR2,
74  p_delete       IN BOOLEAN);
75 
76 PROCEDURE exec
77 (
78  p_table_name   IN VARCHAR2,
79  p_where        IN VARCHAR2,
80  p_pk_col1      IN VARCHAR2,
81  p_pk_col2      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_delete       IN BOOLEAN);
90 
91 end;