APPS.XLA_ACCTG_METHODS_F_PKG dependencies on XLA_ACCTG_METHODS_B

Line 84: FROM xla_acctg_methods_b

80: IS
81:
82: CURSOR c IS
83: SELECT rowid
84: FROM xla_acctg_methods_b
85: WHERE accounting_method_type_code = x_accounting_method_type_code
86: AND accounting_method_code = x_accounting_method_code
87: ;
88:

Line 101: INSERT INTO xla_acctg_methods_b

97: p_module => l_log_module,
98: p_level => C_LEVEL_PROCEDURE);
99: END IF;
100:
101: INSERT INTO xla_acctg_methods_b
102: (creation_date
103: ,created_by
104: ,accounting_method_type_code
105: ,accounting_method_code

Line 196: FROM xla_acctg_methods_b

192: SELECT last_update_login
193: ,transaction_coa_id
194: ,accounting_coa_id
195: ,enabled_flag
196: FROM xla_acctg_methods_b
197: WHERE accounting_method_type_code = x_accounting_method_type_code
198: AND accounting_method_code = x_accounting_method_code
199: FOR UPDATE OF accounting_method_type_code NOWAIT;
200:

Line 308: UPDATE xla_acctg_methods_b

304: p_module => l_log_module,
305: p_level => C_LEVEL_PROCEDURE);
306: END IF;
307:
308: UPDATE xla_acctg_methods_b
309: SET
310: last_update_date = x_last_update_date
311: ,transaction_coa_id = x_transaction_coa_id
312: ,accounting_coa_id = x_accounting_coa_id

Line 379: DELETE FROM xla_acctg_methods_b

375: IF (SQL%NOTFOUND) THEN
376: RAISE NO_DATA_FOUND;
377: END IF;
378:
379: DELETE FROM xla_acctg_methods_b
380: WHERE accounting_method_type_code = x_accounting_method_type_code
381: AND accounting_method_code = x_accounting_method_code;
382:
383:

Line 422: FROM xla_acctg_methods_b b

418:
419: DELETE FROM xla_acctg_methods_tl T
420: WHERE NOT EXISTS
421: (SELECT NULL
422: FROM xla_acctg_methods_b b
423: WHERE b.accounting_method_type_code = t.accounting_method_type_code
424: AND b.accounting_method_code = t.accounting_method_code);
425:
426: UPDATE xla_acctg_methods_tl t