DBA Data[Home] [Help]

APPS.GME_DELETE_BATCH_STEP_PVT dependencies on GME_RESOURCE_TXNS_GTMP

Line 136: UPDATE gme_resource_txns_gtmp

132:
133: -- Navin: START Changed the logic --
134: -- 1. First delete all the resources transactions associated with the resource
135: -- gme_resource_engine_pvt.delete_resource_trans
136: UPDATE gme_resource_txns_gtmp
137: SET action_code = 'DEL'
138: WHERE line_id IN (
139: SELECT batchstep_resource_id
140: FROM gme_batch_step_resources

Line 631: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;

627: PROCEDURE delete_resource_transactions (
628: p_batch_step_resources_rec gme_batch_step_resources%ROWTYPE
629: ,x_return_status OUT NOCOPY VARCHAR2)
630: IS
631: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
632: l_resource_tab gme_common_pvt.resource_transactions_tab;
633: l_api_name CONSTANT VARCHAR2 (30) := 'delete_resource_transactions';
634: l_return_status VARCHAR2 (1);
635: BEGIN