[Home] [Help]
PACKAGE: APPS.HZ_WORD_REPLACEMENTS1_PKG
Source
1 PACKAGE HZ_WORD_REPLACEMENTS1_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHDQWRS.pls 120.6 2006/01/16 05:12:17 rchanamo noship $ */
3
4 PROCEDURE Insert_Row(
5 x_Rowid IN OUT NOCOPY VARCHAR2,
6 x_word_list_id NUMBER,
7 x_ORIGINAL_WORD VARCHAR2,
8 x_REPLACEMENT_WORD VARCHAR2,
9 x_TYPE VARCHAR2,
10 x_COUNTRY_CODE VARCHAR2,
11 x_LAST_UPDATE_DATE DATE,
12 x_LAST_UPDATED_BY NUMBER,
13 x_CREATION_DATE DATE,
14 x_CREATED_BY NUMBER,
15 x_LAST_UPDATE_LOGIN NUMBER,
16 x_ATTRIBUTE_CATEGORY VARCHAR2,
17 x_ATTRIBUTE1 VARCHAR2,
18 x_ATTRIBUTE2 VARCHAR2,
19 x_ATTRIBUTE3 VARCHAR2,
20 x_ATTRIBUTE4 VARCHAR2,
21 x_ATTRIBUTE5 VARCHAR2,
22 x_ATTRIBUTE6 VARCHAR2,
23 x_ATTRIBUTE7 VARCHAR2,
24 x_ATTRIBUTE8 VARCHAR2,
25 x_ATTRIBUTE9 VARCHAR2,
26 x_ATTRIBUTE10 VARCHAR2,
27 x_ATTRIBUTE11 VARCHAR2,
28 x_ATTRIBUTE12 VARCHAR2,
29 x_ATTRIBUTE13 VARCHAR2,
30 x_ATTRIBUTE14 VARCHAR2,
31 x_ATTRIBUTE15 VARCHAR2,
32 x_object_version_number in out NOCOPY NUMBER,
33 x_condition_id NUMBER DEFAULT NULL,
34 x_user_spec_cond_value VARCHAR2 DEFAULT NULL);
35
36 PROCEDURE Insert_Row(
37 x_Rowid IN OUT NOCOPY VARCHAR2,
38 x_word_list_id NUMBER,
39 x_ORIGINAL_WORD VARCHAR2,
40 x_REPLACEMENT_WORD VARCHAR2,
41 x_TYPE VARCHAR2,
42 x_COUNTRY_CODE VARCHAR2,
43 x_LAST_UPDATE_DATE DATE,
44 x_LAST_UPDATED_BY NUMBER,
45 x_CREATION_DATE DATE,
46 x_CREATED_BY NUMBER,
47 x_LAST_UPDATE_LOGIN NUMBER,
48 x_ATTRIBUTE_CATEGORY VARCHAR2,
49 x_ATTRIBUTE1 VARCHAR2,
50 x_ATTRIBUTE2 VARCHAR2,
51 x_ATTRIBUTE3 VARCHAR2,
52 x_ATTRIBUTE4 VARCHAR2,
53 x_ATTRIBUTE5 VARCHAR2,
54 x_ATTRIBUTE6 VARCHAR2,
55 x_ATTRIBUTE7 VARCHAR2,
56 x_ATTRIBUTE8 VARCHAR2,
57 x_ATTRIBUTE9 VARCHAR2,
58 x_ATTRIBUTE10 VARCHAR2,
59 x_ATTRIBUTE11 VARCHAR2,
60 x_ATTRIBUTE12 VARCHAR2,
61 x_ATTRIBUTE13 VARCHAR2,
62 x_ATTRIBUTE14 VARCHAR2,
63 x_ATTRIBUTE15 VARCHAR2,
64 x_object_version_number in out NOCOPY NUMBER,
65 x_msg_count in out NOCOPY NUMBER,
66 x_condition_id NUMBER DEFAULT NULL,
67 x_user_spec_cond_value VARCHAR2 DEFAULT NULL);
68
69
70 PROCEDURE Lock_Row(
71 x_Rowid VARCHAR2,
72 x_word_list_id NUMBER,
73 x_ORIGINAL_WORD VARCHAR2,
74 x_object_version_number NUMBER);
75
76 PROCEDURE Update_Row(
77 x_Rowid VARCHAR2,
78 x_word_list_id NUMBER,
79 x_ORIGINAL_WORD VARCHAR2,
80 x_REPLACEMENT_WORD VARCHAR2,
81 x_TYPE VARCHAR2,
82 x_COUNTRY_CODE VARCHAR2,
83 x_LAST_UPDATE_DATE DATE,
84 x_LAST_UPDATED_BY NUMBER,
85 x_CREATION_DATE DATE,
86 x_CREATED_BY NUMBER,
87 x_LAST_UPDATE_LOGIN NUMBER,
88 x_ATTRIBUTE_CATEGORY VARCHAR2,
89 x_ATTRIBUTE1 VARCHAR2,
90 x_ATTRIBUTE2 VARCHAR2,
91 x_ATTRIBUTE3 VARCHAR2,
92 x_ATTRIBUTE4 VARCHAR2,
93 x_ATTRIBUTE5 VARCHAR2,
94 x_ATTRIBUTE6 VARCHAR2,
95 x_ATTRIBUTE7 VARCHAR2,
96 x_ATTRIBUTE8 VARCHAR2,
97 x_ATTRIBUTE9 VARCHAR2,
98 x_ATTRIBUTE10 VARCHAR2,
99 x_ATTRIBUTE11 VARCHAR2,
100 x_ATTRIBUTE12 VARCHAR2,
101 x_ATTRIBUTE13 VARCHAR2,
102 x_ATTRIBUTE14 VARCHAR2,
103 x_ATTRIBUTE15 VARCHAR2,
104 x_object_version_number IN OUT NOCOPY NUMBER,
105 x_condition_id NUMBER DEFAULT NULL,
106 x_user_spec_cond_value VARCHAR2 DEFAULT NULL);
107
108 PROCEDURE Update_Row(
109 x_Rowid VARCHAR2,
110 x_word_list_id NUMBER,
111 x_ORIGINAL_WORD VARCHAR2,
112 x_REPLACEMENT_WORD VARCHAR2,
113 x_TYPE VARCHAR2,
114 x_COUNTRY_CODE VARCHAR2,
115 x_LAST_UPDATE_DATE DATE,
116 x_LAST_UPDATED_BY NUMBER,
117 x_CREATION_DATE DATE,
118 x_CREATED_BY NUMBER,
119 x_LAST_UPDATE_LOGIN NUMBER,
120 x_ATTRIBUTE_CATEGORY VARCHAR2,
121 x_ATTRIBUTE1 VARCHAR2,
122 x_ATTRIBUTE2 VARCHAR2,
123 x_ATTRIBUTE3 VARCHAR2,
124 x_ATTRIBUTE4 VARCHAR2,
125 x_ATTRIBUTE5 VARCHAR2,
126 x_ATTRIBUTE6 VARCHAR2,
127 x_ATTRIBUTE7 VARCHAR2,
128 x_ATTRIBUTE8 VARCHAR2,
129 x_ATTRIBUTE9 VARCHAR2,
130 x_ATTRIBUTE10 VARCHAR2,
131 x_ATTRIBUTE11 VARCHAR2,
132 x_ATTRIBUTE12 VARCHAR2,
133 x_ATTRIBUTE13 VARCHAR2,
134 x_ATTRIBUTE14 VARCHAR2,
135 x_ATTRIBUTE15 VARCHAR2,
136 x_object_version_number IN OUT NOCOPY NUMBER,
137 x_msg_count in out NOCOPY NUMBER,
138 x_condition_id NUMBER DEFAULT NULL,
139 x_user_spec_cond_value VARCHAR2 DEFAULT NULL);
140
141
142 PROCEDURE Delete_Row(x_word_list_id in number , x_original_word in varchar2,x_condition_id IN NUMBER,x_user_spec_cond_value IN VARCHAR2);
143
144 PROCEDURE Delete_Row(X_WORD_LIST_ID IN NUMBER);
145
146 END HZ_WORD_REPLACEMENTS1_PKG;