[Home] [Help]
PACKAGE BODY: APPS.HZ_WORD_REPLACEMENT_PUB_W
Source
1 package body HZ_WORD_REPLACEMENT_PUB_W AS
2 /*$Header: ARHWRLWB.pls 120.1 2005/06/16 21:16:36 jhuang ship $ */
3
4
5 procedure create_word_replacement (
6 p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2,
8 p_commit IN VARCHAR2,
9 p_original_word IN VARCHAR2,
10 p_replacement_word IN VARCHAR2,
11 p_type IN VARCHAR2,
12 p_country_code IN VARCHAR2 DEFAULT 'US',
13 p_attribute_category IN VARCHAR2,
14 p_attribute1 IN VARCHAR2,
15 p_attribute2 IN VARCHAR2,
16 p_attribute3 IN VARCHAR2,
17 p_attribute4 IN VARCHAR2,
18 p_attribute5 IN VARCHAR2,
19 p_attribute6 IN VARCHAR2,
20 p_attribute7 IN VARCHAR2,
21 p_attribute8 IN VARCHAR2,
22 p_attribute9 IN VARCHAR2,
23 p_attribute10 IN VARCHAR2,
24 p_attribute11 IN VARCHAR2,
25 p_attribute12 IN VARCHAR2,
26 p_attribute13 IN VARCHAR2,
27 p_attribute14 IN VARCHAR2,
28 p_attribute15 IN VARCHAR2,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 x_original_word OUT NOCOPY VARCHAR2,
33 x_type OUT NOCOPY VARCHAR2,
34 p_validation_level IN NUMBER
35 )
36 is
37 l_word_replacement_rec HZ_WORD_REPLACEMENT_PUB.WORD_REPLACEMENT_REC_TYPE;
38 begin
39 -- build the record to be passed to the public api
40 l_word_replacement_rec.original_word := p_original_word ;
41 l_word_replacement_rec.replacement_word := p_replacement_word;
42 l_word_replacement_rec.type := p_type;
43 l_word_replacement_rec.country_code := p_country_code;
44 l_word_replacement_rec.attribute_category :=p_attribute_category ;
45 l_word_replacement_rec.attribute1 := p_attribute1;
46 l_word_replacement_rec.attribute2 := p_attribute2;
47 l_word_replacement_rec.attribute3 := p_attribute3;
48 l_word_replacement_rec.attribute4 := p_attribute4;
49 l_word_replacement_rec.attribute5 := p_attribute5;
50 l_word_replacement_rec.attribute6 := p_attribute6;
51 l_word_replacement_rec.attribute7 := p_attribute7;
52 l_word_replacement_rec.attribute8 := p_attribute8;
53 l_word_replacement_rec.attribute9 := p_attribute9;
54 l_word_replacement_rec.attribute10 := p_attribute10;
55 l_word_replacement_rec.attribute11 := p_attribute11;
56 l_word_replacement_rec.attribute12 := p_attribute12;
57 l_word_replacement_rec.attribute13 := p_attribute13;
58 l_word_replacement_rec.attribute14 := p_attribute14;
59 l_word_replacement_rec.attribute15 := p_attribute15;
60
61 -- call the word replacement creation api
62 hz_word_replacement_pub.create_word_replacement (
63 p_api_version => p_api_version,
64 p_init_msg_list => p_init_msg_list,
65 p_commit => p_commit,
66 p_word_replacement_rec => l_word_replacement_rec,
67 x_return_status => x_return_status,
68 x_msg_count => x_msg_count,
69 x_msg_data => x_msg_data,
70 x_original_word => x_original_word,
71 x_type => x_type,
72 p_validation_level => p_validation_level);
73
74 end create_word_replacement;
75
76
77 procedure update_word_replacement (
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2,
80 p_commit IN VARCHAR2,
81 p_original_word IN VARCHAR2,
82 p_replacement_word IN VARCHAR2,
83 p_type IN VARCHAR2,
84 p_country_code IN VARCHAR2 DEFAULT 'US',
85 p_attribute_category IN VARCHAR2,
86 p_attribute1 IN VARCHAR2,
87 p_attribute2 IN VARCHAR2,
88 p_attribute3 IN VARCHAR2,
89 p_attribute4 IN VARCHAR2,
90 p_attribute5 IN VARCHAR2,
91 p_attribute6 IN VARCHAR2,
92 p_attribute7 IN VARCHAR2,
93 p_attribute8 IN VARCHAR2,
94 p_attribute9 IN VARCHAR2,
95 p_attribute10 IN VARCHAR2,
96 p_attribute11 IN VARCHAR2,
97 p_attribute12 IN VARCHAR2,
98 p_attribute13 IN VARCHAR2,
99 p_attribute14 IN VARCHAR2,
100 p_attribute15 IN VARCHAR2,
101 p_last_update_date IN OUT NOCOPY DATE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_validation_level IN NUMBER
106 )
107 is
108 l_word_replacement_rec HZ_WORD_REPLACEMENT_PUB.WORD_REPLACEMENT_REC_TYPE;
109 l_last_update_date date;
110 begin
111 -- build the record to be passed to the public api
112 l_word_replacement_rec.original_word := p_original_word ;
113 l_word_replacement_rec.replacement_word := p_replacement_word;
114 l_word_replacement_rec.type := p_type;
115 l_word_replacement_rec.country_code := p_country_code;
116 l_word_replacement_rec.attribute_category :=p_attribute_category ;
117 l_word_replacement_rec.attribute1 := p_attribute1;
118 l_word_replacement_rec.attribute2 := p_attribute2;
119 l_word_replacement_rec.attribute3 := p_attribute3;
120 l_word_replacement_rec.attribute4 := p_attribute4;
121 l_word_replacement_rec.attribute5 := p_attribute5;
122 l_word_replacement_rec.attribute6 := p_attribute6;
123 l_word_replacement_rec.attribute7 := p_attribute7;
124 l_word_replacement_rec.attribute8 := p_attribute8;
125 l_word_replacement_rec.attribute9 := p_attribute9;
126 l_word_replacement_rec.attribute10 := p_attribute10;
127 l_word_replacement_rec.attribute11 := p_attribute11;
128 l_word_replacement_rec.attribute12 := p_attribute12;
129 l_word_replacement_rec.attribute13 := p_attribute13;
130 l_word_replacement_rec.attribute14 := p_attribute14;
131 l_word_replacement_rec.attribute15 := p_attribute15;
132
133 -- call the word replacement update api
134 hz_word_replacement_pub.update_word_replacement (
135 p_api_version => p_api_version,
136 p_init_msg_list => p_init_msg_list,
137 p_commit => p_commit,
138 p_word_replacement_rec => l_word_replacement_rec,
139 p_last_update_date => p_last_update_date,
140 x_return_status => x_return_status,
141 x_msg_count => x_msg_count,
142 x_msg_data => x_msg_data,
143 p_validation_level => p_validation_level);
144 null;
145 end update_word_replacement;
146
147 END HZ_WORD_REPLACEMENT_PUB_W;