PACKAGE: APPS.EDW_SOURCE_INSTANCES_PKG

Source

1 Package EDW_SOURCE_INSTANCES_PKG AUTHID CURRENT_USER AS
2 /* $Header: EDWSRCIS.pls 115.6 2003/11/19 09:19:37 smulye ship $ */
3 
4 e_too_many_local_instances EXCEPTION;
5 PRAGMA EXCEPTION_INIT(e_too_many_local_instances, -20000);
6 
7 FUNCTION CHECK_REMOTE_ENTRY(p_dblink in varchar2) return boolean;
8 procedure INSERT_ROW (
9   X_ROWID in out NOCOPY VARCHAR2,
10   X_INSTANCE_CODE in VARCHAR2,
11   X_ENABLED_FLAG in VARCHAR2,
12   X_WAREHOUSE_TO_INSTANCE_LINK in VARCHAR2,
13   X_NAME in VARCHAR2,
14   X_DESCRIPTION in VARCHAR2,
15   X_CREATION_DATE in DATE,
16   X_CREATED_BY in NUMBER,
17   X_LAST_UPDATE_DATE in DATE,
18   X_LAST_UPDATED_BY in NUMBER,
19   X_LAST_UPDATE_LOGIN in NUMBER
20 );
21 procedure LOCK_ROW (
22   X_INSTANCE_CODE in VARCHAR2,
23   X_ENABLED_FLAG in VARCHAR2,
24   X_WAREHOUSE_TO_INSTANCE_LINK in VARCHAR2,
25   X_NAME in VARCHAR2,
26   X_DESCRIPTION in VARCHAR2
27 );
28 procedure UPDATE_ROW (
29   X_INSTANCE_CODE in VARCHAR2,
30   X_ENABLED_FLAG in VARCHAR2,
31   X_WAREHOUSE_TO_INSTANCE_LINK in VARCHAR2,
32   X_NAME in VARCHAR2,
33   X_DESCRIPTION in VARCHAR2,
34   X_LAST_UPDATE_DATE in DATE,
35   X_LAST_UPDATED_BY in NUMBER,
36   X_LAST_UPDATE_LOGIN in NUMBER
37 );
38 procedure DELETE_ROW (
39   X_INSTANCE_CODE in VARCHAR2
40 );
41 procedure ADD_LANGUAGE;
42 
43 procedure CHECK_UNIQUE(
44 X_ROWID in VARCHAR2,
45 X_INSTANCE_CODE in VARCHAR2
46 );
47 procedure CHECK_UNIQUE_NAME(
48 X_ROWID in VARCHAR2,
49 X_INSTANCE_NAME in VARCHAR2
50 );
51 procedure CHECK_UNIQUE_DBLINK(
52 X_ROWID in VARCHAR2,
53 X_DBLINK in VARCHAR2
54 );
55 procedure CHECK_REFERENCES(
56 X_INSTANCE_CODE in VARCHAR2
57 );
58 procedure INSERT_ROW_REMOTE (
59   X_INSTANCE_CODE in VARCHAR2,
60   X_ENABLED_FLAG in VARCHAR2,
61   X_WAREHOUSE_TO_INSTANCE_LINK in VARCHAR2,
62   X_NAME in VARCHAR2,
63   X_DESCRIPTION in VARCHAR2,
64   X_CREATION_DATE in DATE,
65   X_CREATED_BY in NUMBER,
66   X_LAST_UPDATE_DATE in DATE,
67   X_LAST_UPDATED_BY in NUMBER,
68   X_LAST_UPDATE_LOGIN in NUMBER
69 );
70 procedure DELETE_ROW_REMOTE (
71   X_INSTANCE_CODE in VARCHAR2,
72   X_WAREHOUSE_TO_INSTANCE_LINK in VARCHAR2
73 );
74 
75 End EDW_SOURCE_INSTANCES_PKG;