APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_CONCURRENCY_CONTROL

Line 153: be deleted from gms_concurrency_control table.

149: Procedure : delete_pending_txns
150: Purpose : This procedure will delete pending records in gms_bc_packets associated with a
151: request that has been terminated.
152: After deleting the records from gms_bc_packets, corresponding request_id entry will
153: be deleted from gms_concurrency_control table.
154: -------------------------------------------------------------------------------------------------- */
155:
156: Procedure delete_pending_txns
157: (x_err_code OUT NOCOPY NUMBER,

Line 168: from gms_concurrency_control

164: l_phase_code fnd_concurrent_requests.phase_code%type;
165:
166: Cursor c_pending_request_id is
167: select request_id
168: from gms_concurrency_control
169: where request_id <> nvl(l_request_id,-1)
170: and process_name = 'GMSFCSYS';
171: Begin
172:

Line 215: from gms_concurrency_control

211: and status_code = 'P';
212:
213: -- D. Delete concurrency record ..
214: Delete
215: from gms_concurrency_control
216: where request_id = c_request_id.request_id;
217:
218: End If; -- If l_phase_code = 'C' then
219:

Line 4804: -- This Procedure locks the gms_concurrency_control table before inserting record into

4800: END call_start_end_date_update;
4801: -- Bug 2039271
4802:
4803: ----------------------------------------------------------------------------------------------------------
4804: -- This Procedure locks the gms_concurrency_control table before inserting record into
4805: -- gms_bc_packet_arrival_order, once record is inserted lock is released.
4806: ----------------------------------------------------------------------------------------------------------
4807:
4808: PROCEDURE set_concurrency_tab IS

Line 4819: FROM gms_concurrency_control

4815: INTO l_sys_date
4816: FROM DUAL;
4817: SELECT 0
4818: INTO x_err_code
4819: FROM gms_concurrency_control
4820: WHERE process_name = 'GMSFCTRL'
4821: FOR UPDATE;
4822: EXCEPTION
4823: WHEN NO_DATA_FOUND THEN

Line 4825: LOCK TABLE gms_concurrency_control IN EXCLUSIVE MODE;

4821: FOR UPDATE;
4822: EXCEPTION
4823: WHEN NO_DATA_FOUND THEN
4824: g_error_stage := 'SET_CONCURR_TAB:NO.D.FND';
4825: LOCK TABLE gms_concurrency_control IN EXCLUSIVE MODE;
4826: INSERT INTO gms_concurrency_control
4827: (process_name,
4828: process_key,
4829: request_id,

Line 4826: INSERT INTO gms_concurrency_control

4822: EXCEPTION
4823: WHEN NO_DATA_FOUND THEN
4824: g_error_stage := 'SET_CONCURR_TAB:NO.D.FND';
4825: LOCK TABLE gms_concurrency_control IN EXCLUSIVE MODE;
4826: INSERT INTO gms_concurrency_control
4827: (process_name,
4828: process_key,
4829: request_id,
4830: last_update_date,

Line 4851: -- from gms_concurrency_control using COMMIT;

4847:
4848:
4849: ----------------------------------------------------------------------------------------------------------
4850: -- This Procedure inserts record in gms_bc_packet_arrival_order, once record is inserted lock is released.
4851: -- from gms_concurrency_control using COMMIT;
4852:
4853: -- gms_bc_packet_arrival_order Table will store the order in which packets
4854: -- have completed there setup and are ready for funds check.
4855: -- This is required becase packets arrived later can pass fundscheck as setup

Line 4883: FROM gms_concurrency_control

4879: set_concurrency_tab;
4880: g_error_stage := 'IN ARRIVAL ORD: R,U,C,E';
4881: SELECT 0
4882: INTO x_err_code
4883: FROM gms_concurrency_control
4884: WHERE process_name = 'GMSFCTRL'
4885: FOR UPDATE;
4886:
4887: -- Bug 2176230