DBA Data[Home] [Help]

APPS.GHG_TRANSACTIONS_HISTORY_PKG dependencies on GHG_TRANSACTIONS_HISTORY_ALL

Line 15: v_debug_info := 'Inserting into GHG_TRANSACTIONS_HISTORY_ALL';

11:
12: BEGIN
13:
14: v_package := 'GHG_TRANSACTIONS_HISTORY_PKG.insert_row';
15: v_debug_info := 'Inserting into GHG_TRANSACTIONS_HISTORY_ALL';
16:
17: BEGIN
18:
19: SELECT MAX(transaction_version)

Line 21: FROM GHG_TRANSACTIONS_HISTORY_ALL

17: BEGIN
18:
19: SELECT MAX(transaction_version)
20: INTO v_transaction_version
21: FROM GHG_TRANSACTIONS_HISTORY_ALL
22: WHERE transaction_id = x_transaction_id;
23:
24: EXCEPTION
25: WHEN NO_DATA_FOUND THEN

Line 33: INSERT INTO GHG_TRANSACTIONS_HISTORY_ALL

29:
30: v_transaction_version := NVL(v_transaction_version, 0) + 1;
31:
32:
33: INSERT INTO GHG_TRANSACTIONS_HISTORY_ALL
34: (txn_type_lookup_code,
35: transaction_id,
36: transaction_version,
37: --emission_rate_id,