DBA Data[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;