eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ACTION_SETS_PKG dependencies on FND_API

Line 43: x_return_status := FND_API.G_RET_STS_SUCCESS;

39:
40: BEGIN
41:
42: -- Initialize the return status to success
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44:
45: -- Bug 4403338
46: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
47:

Line 138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

134: -- Set the excetption Message and the stack
135: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PKG.Insert_row'
136: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
137: --
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: RAISE;
140:
141: END Insert_Row;
142:

Line 146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR

142:
143:
144: PROCEDURE update_row
145: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM

Line 147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE

143:
144: PROCEDURE update_row
145: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR

Line 148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE

144: PROCEDURE update_row
145: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE

Line 149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR

145: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

Line 150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM

146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR

147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR

Line 152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE

148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR

150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR

151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR

152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR

153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR

154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR

155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR

156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR

157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR

158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR

159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR

160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR

161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR

162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
170: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR

163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
170: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
171: )

Line 168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR

164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
170: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
171: )
172: IS

Line 169: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR

165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
170: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
171: )
172: IS
173:

Line 179: x_return_status := FND_API.G_RET_STS_SUCCESS;

175:
176: BEGIN
177:
178: -- Initialize the return status to success
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180:
181: -- Bug 4403338
182: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
183:

Line 192: SET action_set_name = decode(p_action_set_name, FND_API.G_MISS_CHAR, action_set_name, p_action_set_name)

188: ,x_log_level => 5);
189: END IF;
190:
191: UPDATE pa_action_sets
192: SET action_set_name = decode(p_action_set_name, FND_API.G_MISS_CHAR, action_set_name, p_action_set_name)
193: ,start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE, start_date_active, p_start_date_active)
194: ,end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE, end_date_active, p_end_date_active)
195: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
196: ,status_code = decode(p_status_code, FND_API.G_MISS_CHAR, status_code, p_status_code)

Line 193: ,start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE, start_date_active, p_start_date_active)

189: END IF;
190:
191: UPDATE pa_action_sets
192: SET action_set_name = decode(p_action_set_name, FND_API.G_MISS_CHAR, action_set_name, p_action_set_name)
193: ,start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE, start_date_active, p_start_date_active)
194: ,end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE, end_date_active, p_end_date_active)
195: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
196: ,status_code = decode(p_status_code, FND_API.G_MISS_CHAR, status_code, p_status_code)
197: ,actual_start_date = decode(p_actual_start_date, FND_API.G_MISS_DATE, actual_start_date, p_actual_start_date)

Line 194: ,end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE, end_date_active, p_end_date_active)

190:
191: UPDATE pa_action_sets
192: SET action_set_name = decode(p_action_set_name, FND_API.G_MISS_CHAR, action_set_name, p_action_set_name)
193: ,start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE, start_date_active, p_start_date_active)
194: ,end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE, end_date_active, p_end_date_active)
195: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
196: ,status_code = decode(p_status_code, FND_API.G_MISS_CHAR, status_code, p_status_code)
197: ,actual_start_date = decode(p_actual_start_date, FND_API.G_MISS_DATE, actual_start_date, p_actual_start_date)
198: ,record_version_number = record_version_number+1

Line 195: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)

191: UPDATE pa_action_sets
192: SET action_set_name = decode(p_action_set_name, FND_API.G_MISS_CHAR, action_set_name, p_action_set_name)
193: ,start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE, start_date_active, p_start_date_active)
194: ,end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE, end_date_active, p_end_date_active)
195: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
196: ,status_code = decode(p_status_code, FND_API.G_MISS_CHAR, status_code, p_status_code)
197: ,actual_start_date = decode(p_actual_start_date, FND_API.G_MISS_DATE, actual_start_date, p_actual_start_date)
198: ,record_version_number = record_version_number+1
199: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)

Line 196: ,status_code = decode(p_status_code, FND_API.G_MISS_CHAR, status_code, p_status_code)

192: SET action_set_name = decode(p_action_set_name, FND_API.G_MISS_CHAR, action_set_name, p_action_set_name)
193: ,start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE, start_date_active, p_start_date_active)
194: ,end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE, end_date_active, p_end_date_active)
195: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
196: ,status_code = decode(p_status_code, FND_API.G_MISS_CHAR, status_code, p_status_code)
197: ,actual_start_date = decode(p_actual_start_date, FND_API.G_MISS_DATE, actual_start_date, p_actual_start_date)
198: ,record_version_number = record_version_number+1
199: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
200: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)

Line 197: ,actual_start_date = decode(p_actual_start_date, FND_API.G_MISS_DATE, actual_start_date, p_actual_start_date)

193: ,start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE, start_date_active, p_start_date_active)
194: ,end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE, end_date_active, p_end_date_active)
195: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
196: ,status_code = decode(p_status_code, FND_API.G_MISS_CHAR, status_code, p_status_code)
197: ,actual_start_date = decode(p_actual_start_date, FND_API.G_MISS_DATE, actual_start_date, p_actual_start_date)
198: ,record_version_number = record_version_number+1
199: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
200: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
201: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)

Line 199: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)

195: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
196: ,status_code = decode(p_status_code, FND_API.G_MISS_CHAR, status_code, p_status_code)
197: ,actual_start_date = decode(p_actual_start_date, FND_API.G_MISS_DATE, actual_start_date, p_actual_start_date)
198: ,record_version_number = record_version_number+1
199: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
200: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
201: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
202: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
203: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)

Line 200: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)

196: ,status_code = decode(p_status_code, FND_API.G_MISS_CHAR, status_code, p_status_code)
197: ,actual_start_date = decode(p_actual_start_date, FND_API.G_MISS_DATE, actual_start_date, p_actual_start_date)
198: ,record_version_number = record_version_number+1
199: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
200: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
201: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
202: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
203: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
204: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)

Line 201: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)

197: ,actual_start_date = decode(p_actual_start_date, FND_API.G_MISS_DATE, actual_start_date, p_actual_start_date)
198: ,record_version_number = record_version_number+1
199: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
200: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
201: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
202: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
203: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
204: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
205: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)

Line 202: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)

198: ,record_version_number = record_version_number+1
199: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
200: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
201: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
202: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
203: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
204: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
205: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
206: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)

Line 203: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)

199: ,attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category)
200: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
201: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
202: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
203: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
204: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
205: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
206: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
207: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)

Line 204: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)

200: ,attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1)
201: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
202: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
203: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
204: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
205: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
206: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
207: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
208: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)

Line 205: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)

201: ,attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2)
202: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
203: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
204: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
205: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
206: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
207: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
208: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
209: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)

Line 206: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)

202: ,attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3)
203: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
204: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
205: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
206: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
207: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
208: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
209: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
210: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)

Line 207: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)

203: ,attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4)
204: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
205: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
206: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
207: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
208: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
209: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
210: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
211: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)

Line 208: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)

204: ,attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5)
205: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
206: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
207: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
208: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
209: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
210: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
211: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
212: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)

Line 209: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)

205: ,attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6)
206: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
207: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
208: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
209: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
210: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
211: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
212: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
213: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)

Line 210: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)

206: ,attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7)
207: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
208: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
209: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
210: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
211: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
212: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
213: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
214: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)

Line 211: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)

207: ,attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8)
208: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
209: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
210: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
211: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
212: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
213: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
214: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
215: ,last_update_date = sysdate

Line 212: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)

208: ,attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9)
209: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
210: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
211: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
212: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
213: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
214: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
215: ,last_update_date = sysdate
216: ,last_updated_by = fnd_global.user_id

Line 213: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)

209: ,attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10)
210: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
211: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
212: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
213: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
214: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
215: ,last_update_date = sysdate
216: ,last_updated_by = fnd_global.user_id
217: ,last_update_login = fnd_global.login_id

Line 214: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)

210: ,attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11)
211: ,attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12)
212: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
213: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
214: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
215: ,last_update_date = sysdate
216: ,last_updated_by = fnd_global.user_id
217: ,last_update_login = fnd_global.login_id
218: WHERE action_set_id = p_action_set_id

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: IF (SQL%NOTFOUND) THEN
222:
223: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
224: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
225: x_return_status := FND_API.G_RET_STS_ERROR;
226:
227: END IF;
228:
229: -- Put any message text from message stack into the Message ARRAY

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

232: -- Set the excetption Message and the stack
233: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PKG.update_row'
234: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
235: --
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: RAISE;
238:
239: END update_row;
240:

Line 250: x_return_status := FND_API.G_RET_STS_SUCCESS;

246: IS
247:
248: BEGIN
249:
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: DELETE FROM pa_action_sets
253: WHERE action_set_id = p_action_set_id
254: AND nvl(p_record_version_number, record_version_number) = record_version_number;

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

257: IF (SQL%NOTFOUND) THEN
258:
259: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
260: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
261: x_return_status := FND_API.G_RET_STS_ERROR;
262:
263: END IF;
264: --
265: --

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

268: WHEN OTHERS THEN
269: -- Set the exception Message and the stack
270: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ACTION_SETS_PKG.Delete_Row'
271: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273: RAISE;
274: END Delete_Row;
275:
276: