APPS.GHG_TRANSACTIONS_PKG dependencies on GHG_TRANSACTIONS_ALL

Line 65: FROM GHG_transactions_all

61: v_debug_info VARCHAR2(100);
62:
63: CURSOR c IS
64: SELECT ROWID
65: FROM GHG_transactions_all
66: WHERE transaction_id = x_emission_id;
67:
68: BEGIN
69:

Line 70: v_debug_info := 'Inserting into GHG_transactions_all';

66: WHERE transaction_id = x_emission_id;
67:
68: BEGIN
69:
70: v_debug_info := 'Inserting into GHG_transactions_all';
71:
72: begin
73: INSERT INTO GHG_transactions_all (txn_type_lookup_code,
74: transaction_id,

Line 73: INSERT INTO GHG_transactions_all (txn_type_lookup_code,

69:
70: v_debug_info := 'Inserting into GHG_transactions_all';
71:
72: begin
73: INSERT INTO GHG_transactions_all (txn_type_lookup_code,
74: transaction_id,
75: transaction_batch_id,
76: transaction_source_id,
77: ghg_organization_id,

Line 283: v_debug_info := 'Updating GHG_transactions_all';

279: v_debug_info VARCHAR2(100);
280:
281: BEGIN
282:
283: v_debug_info := 'Updating GHG_transactions_all';
284:
285: UPDATE GHG_transactions_all
286: SET txn_type_lookup_code = x_txn_type_lookup_code,
287: transaction_id = x_emission_id,

Line 285: UPDATE GHG_transactions_all

281: BEGIN
282:
283: v_debug_info := 'Updating GHG_transactions_all';
284:
285: UPDATE GHG_transactions_all
286: SET txn_type_lookup_code = x_txn_type_lookup_code,
287: transaction_id = x_emission_id,
288: transaction_batch_id = x_emission_batch_id,
289: transaction_source_id = x_emission_source_id,

Line 362: DELETE FROM GHG_transactions_all

358: PROCEDURE delete_row (x_emission_id NUMBER) IS
359:
360: BEGIN
361:
362: DELETE FROM GHG_transactions_all
363: WHERE transaction_id = x_emission_id;
364:
365: DELETE FROM GHG_transaction_details_all
366: WHERE transaction_id = x_emission_id;

Line 486: FROM GHG_transactions_all

482: last_update_date,
483: last_update_login,
484: emission_scope_lookup_code,
485: location_code
486: FROM GHG_transactions_all
487: WHERE rowid = x_rowid
488: FOR UPDATE of transaction_id NOWAIT;
489: recinfo C%ROWTYPE;
490: