DBA Data[Home] [Help]

APPS.XLA_ACCT_ATTRIBUTES_F_PKG dependencies on XLA_ACCT_ATTRIBUTES_B

Line 47: FROM xla_acct_attributes_b

43: IS
44:
45: CURSOR c IS
46: SELECT rowid
47: FROM xla_acct_attributes_b
48: WHERE accounting_attribute_code = x_accounting_attribute_code
49: ;
50:
51: BEGIN

Line 54: INSERT INTO xla_acct_attributes_b

50:
51: BEGIN
52: xla_utility_pkg.trace('> xla_acct_attributes_f_pkg.insert_row' ,20);
53:
54: INSERT INTO xla_acct_attributes_b
55: (creation_date
56: ,created_by
57: ,accounting_attribute_code
58: ,assignment_required_code

Line 151: FROM xla_acct_attributes_b

147: ,journal_entry_level_code
148: ,assignment_extensible_flag
149: ,assignment_level_code
150: ,inherited_flag
151: FROM xla_acct_attributes_b
152: WHERE accounting_attribute_code = x_accounting_attribute_code
153: FOR UPDATE OF accounting_attribute_code NOWAIT;
154:
155: recinfo c%ROWTYPE;

Line 236: UPDATE xla_acct_attributes_b

232: IS
233:
234: BEGIN
235: xla_utility_pkg.trace('> xla_acct_attributes_f_pkg.update_row' ,20);
236: UPDATE xla_acct_attributes_b
237: SET
238: last_update_date = x_last_update_date
239: ,assignment_required_code = x_assignment_required_code
240: ,assignment_group_code = x_assignment_group_code

Line 291: DELETE FROM xla_acct_attributes_b

287: IF (SQL%NOTFOUND) THEN
288: RAISE NO_DATA_FOUND;
289: END IF;
290:
291: DELETE FROM xla_acct_attributes_b
292: WHERE accounting_attribute_code = x_accounting_attribute_code;
293:
294:
295: IF (SQL%NOTFOUND) THEN

Line 318: FROM xla_acct_attributes_b b

314:
315: DELETE FROM xla_acct_attributes_tl T
316: WHERE NOT EXISTS
317: (SELECT NULL
318: FROM xla_acct_attributes_b b
319: WHERE b.accounting_attribute_code = t.accounting_attribute_code);
320:
321: UPDATE xla_acct_attributes_tl t
322: SET (name)