2: /*$Header: ARHWRLSS.pls 120.1 2005/06/16 21:16:33 jhuang ship $ */
3:
4:
5: TYPE word_replacement_rec_type IS RECORD(
6: original_word VARCHAR2(50) := FND_API.G_MISS_CHAR,
7: replacement_word VARCHAR2(50) := FND_API.G_MISS_CHAR,
8: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
9: country_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
3:
4:
5: TYPE word_replacement_rec_type IS RECORD(
6: original_word VARCHAR2(50) := FND_API.G_MISS_CHAR,
7: replacement_word VARCHAR2(50) := FND_API.G_MISS_CHAR,
8: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
9: country_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
4:
5: TYPE word_replacement_rec_type IS RECORD(
6: original_word VARCHAR2(50) := FND_API.G_MISS_CHAR,
7: replacement_word VARCHAR2(50) := FND_API.G_MISS_CHAR,
8: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
9: country_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
5: TYPE word_replacement_rec_type IS RECORD(
6: original_word VARCHAR2(50) := FND_API.G_MISS_CHAR,
7: replacement_word VARCHAR2(50) := FND_API.G_MISS_CHAR,
8: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
9: country_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
6: original_word VARCHAR2(50) := FND_API.G_MISS_CHAR,
7: replacement_word VARCHAR2(50) := FND_API.G_MISS_CHAR,
8: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
9: country_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
7: replacement_word VARCHAR2(50) := FND_API.G_MISS_CHAR,
8: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
9: country_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
8: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
9: country_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
9: country_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
10: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
11: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: );
19: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: );
27:
20: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: );
27:
28:
21: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: );
27:
28:
29: procedure create_word_replacement (
27:
28:
29: procedure create_word_replacement (
30: p_api_version IN NUMBER,
31: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
32: p_commit IN VARCHAR2:= FND_API.G_FALSE,
33: p_word_replacement_rec IN WORD_REPLACEMENT_REC_TYPE,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
28:
29: procedure create_word_replacement (
30: p_api_version IN NUMBER,
31: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
32: p_commit IN VARCHAR2:= FND_API.G_FALSE,
33: p_word_replacement_rec IN WORD_REPLACEMENT_REC_TYPE,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: x_original_word OUT NOCOPY VARCHAR2,
38: x_type OUT NOCOPY VARCHAR2,
39: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
40: );
41:
42: procedure update_word_replacement (
43: p_api_version IN NUMBER,
40: );
41:
42: procedure update_word_replacement (
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
45: p_commit IN VARCHAR2:=FND_API.G_FALSE,
46: p_word_replacement_rec IN WORD_REPLACEMENT_REC_TYPE,
47: p_last_update_date IN OUT NOCOPY DATE,
48: x_return_status OUT NOCOPY VARCHAR2,
41:
42: procedure update_word_replacement (
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
45: p_commit IN VARCHAR2:=FND_API.G_FALSE,
46: p_word_replacement_rec IN WORD_REPLACEMENT_REC_TYPE,
47: p_last_update_date IN OUT NOCOPY DATE,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
47: p_last_update_date IN OUT NOCOPY DATE,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2,
51: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
52: );
53:
54: END HZ_WORD_REPLACEMENT_PUB;