APPS.GHG_TRANSACTION_BATCHES_PKG dependencies on GHG_TRANSACTION_BATCHES_ALL

Line 28: FROM GHG_TRANSACTION_BATCHES_ALL

24: v_debug_info VARCHAR2(100);
25:
26: CURSOR c IS
27: SELECT ROWID
28: FROM GHG_TRANSACTION_BATCHES_ALL
29: WHERE transaction_batch_id = x_transaction_batch_id;
30:
31: BEGIN
32:

Line 33: v_debug_info := 'Inserting into GHG_TRANSACTION_BATCHES_ALL';

29: WHERE transaction_batch_id = x_transaction_batch_id;
30:
31: BEGIN
32:
33: v_debug_info := 'Inserting into GHG_TRANSACTION_BATCHES_ALL';
34:
35: INSERT INTO GHG_TRANSACTION_BATCHES_ALL (transaction_batch_id,
36: transaction_batch_number,
37: batch_type,

Line 35: INSERT INTO GHG_TRANSACTION_BATCHES_ALL (transaction_batch_id,

31: BEGIN
32:
33: v_debug_info := 'Inserting into GHG_TRANSACTION_BATCHES_ALL';
34:
35: INSERT INTO GHG_TRANSACTION_BATCHES_ALL (transaction_batch_id,
36: transaction_batch_number,
37: batch_type,
38: batch_sub_type,
39: vendor_id,

Line 123: v_debug_info := 'Updating GHG_TRANSACTION_BATCHES_ALL';

119: v_debug_info VARCHAR2(100);
120:
121: BEGIN
122:
123: v_debug_info := 'Updating GHG_TRANSACTION_BATCHES_ALL';
124:
125: UPDATE GHG_TRANSACTION_BATCHES_ALL
126: SET transaction_batch_id = x_transaction_batch_id,
127: transaction_batch_number = x_transaction_batch_number,

Line 125: UPDATE GHG_TRANSACTION_BATCHES_ALL

121: BEGIN
122:
123: v_debug_info := 'Updating GHG_TRANSACTION_BATCHES_ALL';
124:
125: UPDATE GHG_TRANSACTION_BATCHES_ALL
126: SET transaction_batch_id = x_transaction_batch_id,
127: transaction_batch_number = x_transaction_batch_number,
128: batch_type = x_batch_type,
129: batch_sub_type = x_batch_sub_type,

Line 179: DELETE FROM GHG_TRANSACTION_BATCHES_ALL

175: IF (sql%notfound) THEN
176: NULL;
177: END IF;
178:
179: DELETE FROM GHG_TRANSACTION_BATCHES_ALL
180: WHERE transaction_batch_id = x_transaction_batch_id;
181:
182: IF (sql%notfound) THEN
183: RAISE no_data_found;

Line 227: FROM GHG_TRANSACTION_BATCHES_ALL

223: creation_date,
224: last_updated_by,
225: last_update_date,
226: last_update_login
227: FROM GHG_TRANSACTION_BATCHES_ALL
228: WHERE rowid = x_rowid
229: FOR UPDATE of transaction_batch_id NOWAIT;
230: recinfo C%ROWTYPE;
231: