[Home] [Help]
PACKAGE: APPS.JTS_CONFIGURATIONS_PKG
Source
1 PACKAGE JTS_CONFIGURATIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: jtstcfgs.pls 115.1 2002/06/07 11:53:11 pkm ship $ */
3
4
5 -----------------------------------------------------------
6 -- PACKAGE
7 -- JTS_CONFIGURATIONS_PKG
8 --
9 -- PURPOSE
10 -- Table Handler for jts_configurations_b and _tl tables
11 -- History : 06-Jun-02 SHuh Created.
12 --
13 -- PROCEDURES
14 -- DELETE_ROW(NUMBER)
15 -- LOAD_ROW
16 -- INSERT_ROW
17 -- UPDATE_ROW
18 -- ADD_LANGUAGE
19 --
20 ------------------------------------------------------------
21
22 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTS_CONFIGURATIONS_PKG';
23 G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtstcfgs.pls';
24
25 procedure INSERT_ROW (
26 X_ROWID in out VARCHAR2,
27 X_CONFIGURATION_ID in NUMBER,
28 X_CONFIG_NAME in VARCHAR2,
29 X_FLOW_ID in NUMBER,
30 X_RECORD_MODE in VARCHAR2,
31 X_OBJECT_VERSION_NUMBER in NUMBER,
32 X_ATTRIBUTE_CATEGORY in VARCHAR2,
33 X_ATTRIBUTE1 in VARCHAR2,
34 X_ATTRIBUTE2 in VARCHAR2,
35 X_ATTRIBUTE3 in VARCHAR2,
36 X_ATTRIBUTE4 in VARCHAR2,
37 X_ATTRIBUTE5 in VARCHAR2,
38 X_ATTRIBUTE6 in VARCHAR2,
39 X_ATTRIBUTE7 in VARCHAR2,
40 X_ATTRIBUTE8 in VARCHAR2,
41 X_ATTRIBUTE9 in VARCHAR2,
42 X_ATTRIBUTE10 in VARCHAR2,
43 X_ATTRIBUTE11 in VARCHAR2,
44 X_ATTRIBUTE12 in VARCHAR2,
45 X_ATTRIBUTE13 in VARCHAR2,
46 X_ATTRIBUTE14 in VARCHAR2,
47 X_ATTRIBUTE15 in VARCHAR2,
48 X_SECURITY_GROUP_ID in NUMBER,
49 X_DESCRIPTION in VARCHAR2,
50 X_CREATION_DATE in DATE,
51 X_CREATED_BY in NUMBER,
52 X_LAST_UPDATE_DATE in DATE,
53 X_LAST_UPDATED_BY in NUMBER,
54 X_LAST_UPDATE_LOGIN in NUMBER);
55
56 procedure LOCK_ROW (
57 X_CONFIGURATION_ID in NUMBER,
58 X_CONFIG_NAME in VARCHAR2,
59 X_FLOW_ID in NUMBER,
60 X_RECORD_MODE in VARCHAR2,
61 X_OBJECT_VERSION_NUMBER in NUMBER,
62 X_ATTRIBUTE_CATEGORY in VARCHAR2,
63 X_ATTRIBUTE1 in VARCHAR2,
64 X_ATTRIBUTE2 in VARCHAR2,
65 X_ATTRIBUTE3 in VARCHAR2,
66 X_ATTRIBUTE4 in VARCHAR2,
67 X_ATTRIBUTE5 in VARCHAR2,
68 X_ATTRIBUTE6 in VARCHAR2,
69 X_ATTRIBUTE7 in VARCHAR2,
70 X_ATTRIBUTE8 in VARCHAR2,
71 X_ATTRIBUTE9 in VARCHAR2,
72 X_ATTRIBUTE10 in VARCHAR2,
73 X_ATTRIBUTE11 in VARCHAR2,
74 X_ATTRIBUTE12 in VARCHAR2,
75 X_ATTRIBUTE13 in VARCHAR2,
76 X_ATTRIBUTE14 in VARCHAR2,
77 X_ATTRIBUTE15 in VARCHAR2,
78 X_SECURITY_GROUP_ID in NUMBER,
79 X_DESCRIPTION in VARCHAR2
80 );
81
82 procedure UPDATE_ROW (
83 X_CONFIGURATION_ID in NUMBER,
84 X_CONFIG_NAME in VARCHAR2,
85 X_FLOW_ID in NUMBER,
86 X_RECORD_MODE in VARCHAR2,
87 X_OBJECT_VERSION_NUMBER in NUMBER,
88 X_ATTRIBUTE_CATEGORY in VARCHAR2,
89 X_ATTRIBUTE1 in VARCHAR2,
90 X_ATTRIBUTE2 in VARCHAR2,
91 X_ATTRIBUTE3 in VARCHAR2,
92 X_ATTRIBUTE4 in VARCHAR2,
93 X_ATTRIBUTE5 in VARCHAR2,
94 X_ATTRIBUTE6 in VARCHAR2,
95 X_ATTRIBUTE7 in VARCHAR2,
96 X_ATTRIBUTE8 in VARCHAR2,
97 X_ATTRIBUTE9 in VARCHAR2,
98 X_ATTRIBUTE10 in VARCHAR2,
99 X_ATTRIBUTE11 in VARCHAR2,
100 X_ATTRIBUTE12 in VARCHAR2,
101 X_ATTRIBUTE13 in VARCHAR2,
102 X_ATTRIBUTE14 in VARCHAR2,
103 X_ATTRIBUTE15 in VARCHAR2,
104 X_SECURITY_GROUP_ID in NUMBER,
105 X_DESCRIPTION in VARCHAR2,
106 X_LAST_UPDATE_DATE in DATE,
107 X_LAST_UPDATED_BY in NUMBER,
108 X_LAST_UPDATE_LOGIN in NUMBER
109 );
110
111 procedure DELETE_ROW (
112 P_CONFIG_ID in NUMBER
113 );
114
115 procedure ADD_LANGUAGE;
116
117 -------------------------------------------------
118 -- Translates the description
119 -------------------------------------------------
120 PROCEDURE TRANSLATE_ROW (
121 p_config_id IN NUMBER,
122 p_owner IN VARCHAR2,
123 p_description IN VARCHAR2
124 );
125
126 END JTS_CONFIGURATIONS_PKG;