1 package CLN_CH_DISPLAY_LABELS_DTL_PKG AS
2 /* $Header: ECXDISLS.pls 120.0 2005/08/25 04:45:12 nparihar noship $ */
3 --
4 -- Package
5 -- CLN_CH_DISPLAY_LABELS_DTL_PKG
6 --
7 -- Purpose
8 -- Spec of package CLN_CH_DISPLAY_LABELS_DTL_PKG
9 -- This package is used for downloading/uploading the display labels data into the database
10 -- History
11 --
12
13 PROCEDURE TRANSLATE_ROW
14 (
15 X_GUID IN RAW,
16 X_OWNER IN VARCHAR2,
17 X_DISPLAY_LABEL IN VARCHAR2
18 ) ;
19
20 PROCEDURE LOAD_ROW
21 (
22 X_GUID IN RAW ,
23 X_OWNER IN VARCHAR2,
24 X_PARENT_GUID IN RAW,
25 X_CLN_COLUMNS IN VARCHAR2,
26 X_DISPLAY_LABEL IN VARCHAR2,
27 X_SEARCH_ENABLED IN VARCHAR2,
28 X_DISPLAY_ENABLED_EVENTS_SCR IN VARCHAR2,
29 X_DISPLAY_ENABLED_RESULTS_TBL IN VARCHAR2
30 ) ;
31
32 procedure INSERT_ROW (
33 X_ROWID in out nocopy VARCHAR2,
34 X_GUID in RAW,
35 X_PARENT_GUID in RAW,
36 X_CLN_COLUMNS in VARCHAR2,
37 X_SEARCH_ENABLED in VARCHAR2,
38 X_DISPLAY_ENABLED_EVENTS_SCREE in VARCHAR2,
39 X_DISPLAY_ENABLED_RESULTS_TABL in VARCHAR2,
40 X_DISPLAY_LABEL in VARCHAR2,
41 X_CREATION_DATE in DATE,
42 X_CREATED_BY in NUMBER,
43 X_LAST_UPDATE_DATE in DATE,
44 X_LAST_UPDATED_BY in NUMBER,
45 X_LAST_UPDATE_LOGIN in NUMBER);
46
47 procedure LOCK_ROW (
48 X_GUID in RAW,
49 X_PARENT_GUID in RAW,
50 X_CLN_COLUMNS in VARCHAR2,
51 X_SEARCH_ENABLED in VARCHAR2,
52 X_DISPLAY_ENABLED_EVENTS_SCREE in VARCHAR2,
53 X_DISPLAY_ENABLED_RESULTS_TABL in VARCHAR2,
54 X_DISPLAY_LABEL in VARCHAR2
55 );
56
57 procedure UPDATE_ROW (
58 X_GUID in RAW,
59 X_PARENT_GUID in RAW,
60 X_CLN_COLUMNS in VARCHAR2,
61 X_SEARCH_ENABLED in VARCHAR2,
62 X_DISPLAY_ENABLED_EVENTS_SCREE in VARCHAR2,
63 X_DISPLAY_ENABLED_RESULTS_TABL in VARCHAR2,
64 X_DISPLAY_LABEL in VARCHAR2,
65 X_LAST_UPDATE_DATE in DATE,
66 X_LAST_UPDATED_BY in NUMBER,
67 X_LAST_UPDATE_LOGIN in NUMBER
68 );
69
70 procedure DELETE_ROW (
71 X_GUID in RAW
72 );
73
74 procedure ADD_LANGUAGE;
75
76 end CLN_CH_DISPLAY_LABELS_DTL_PKG;