APPS.GME_API_PUB dependencies on GME_RESOURCE_TXNS_GTMP

Line 75: FROM gme_resource_txns_gtmp

71:
72: CURSOR header_cursor
73: IS
74: SELECT DISTINCT doc_id batch_id
75: FROM gme_resource_txns_gtmp
76: ORDER BY batch_id;
77: BEGIN
78: IF g_debug <= gme_debug.g_log_procedure THEN
79: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 120: delete from gme_resource_txns_gtmp

116: END IF;
117:
118: -- Bug 14685438 - Remove processed data.
119: IF p_commit = fnd_api.g_false THEN
120: delete from gme_resource_txns_gtmp
121: where doc_id = header_row.batch_id;
122: END IF;
123:
124: END LOOP;

Line 1093: FROM gme_resource_txns_gtmp t, gme_resource_txns r

1089: /*end */
1090: CURSOR cur_get_trans_id (v_line_id NUMBER)
1091: IS
1092: SELECT r.*
1093: FROM gme_resource_txns_gtmp t, gme_resource_txns r
1094: WHERE action_code = 'NONE' AND t.line_id = v_line_id
1095: AND t.poc_trans_id = r.poc_trans_id;
1096:
1097: update_rsrc_usage EXCEPTION;