DBA Data[Home] [Help]

APPS.XLA_PROD_SEG_RULES_F_PKG dependencies on XLA_UTILITY_PKG

Line 64: xla_utility_pkg.trace('> .insert_row' ,20);

60: AND flexfield_segment_code = x_flexfield_segment_code
61: ;
62:
63: BEGIN
64: xla_utility_pkg.trace('> .insert_row' ,20);
65:
66: INSERT INTO xla_prod_seg_rules
67: (creation_date
68: ,created_by

Line 113: xla_utility_pkg.trace('< .insert_row' ,20);

109: RAISE NO_DATA_FOUND;
110: END IF;
111: CLOSE c;
112:
113: xla_utility_pkg.trace('< .insert_row' ,20);
114: END insert_row;
115:
116: /*======================================================================+
117: | |

Line 167: xla_utility_pkg.trace('> .lock_row' ,20);

163:
164: recinfo c%ROWTYPE;
165:
166: BEGIN
167: xla_utility_pkg.trace('> .lock_row' ,20);
168:
169: OPEN c;
170: FETCH c INTO recinfo;
171:

Line 198: xla_utility_pkg.trace('< .lock_row' ,20);

194: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
195: app_exception.raise_exception;
196: END IF;
197:
198: xla_utility_pkg.trace('< .lock_row' ,20);
199: RETURN;
200:
201: END lock_row;
202:

Line 228: xla_utility_pkg.trace('> .update_row' ,20);

224: ,x_last_update_login IN NUMBER)
225: IS
226:
227: BEGIN
228: xla_utility_pkg.trace('> .update_row' ,20);
229: UPDATE xla_prod_seg_rules
230: SET
231: last_update_date = x_last_update_date
232: ,segment_rule_type_code = x_segment_rule_type_code

Line 251: xla_utility_pkg.trace('< .update_row' ,20);

247: IF (SQL%NOTFOUND) THEN
248: RAISE NO_DATA_FOUND;
249: END IF;
250:
251: xla_utility_pkg.trace('< .update_row' ,20);
252: END update_row;
253:
254: /*======================================================================+
255: | |

Line 274: xla_utility_pkg.trace('> .delete_row' ,20);

270:
271: IS
272:
273: BEGIN
274: xla_utility_pkg.trace('> .delete_row' ,20);
275: DELETE FROM xla_prod_seg_rules
276: WHERE application_id = x_application_id
277: AND amb_context_code = x_amb_context_code
278: AND product_rule_type_code = x_product_rule_type_code

Line 291: xla_utility_pkg.trace('< .delete_row' ,20);

287: IF (SQL%NOTFOUND) THEN
288: RAISE NO_DATA_FOUND;
289: END IF;
290:
291: xla_utility_pkg.trace('< .delete_row' ,20);
292: END delete_row;
293:
294: end xla_prod_seg_rules_f_pkg;