APPS.GMS_BILLING dependencies on GMS_CONCURRENCY_CONTROL

Line 920: from gms_concurrency_control

916: Begin
917:
918: Select 0
919: into X_Err_Code
920: from gms_concurrency_control
921: where process_key = X_Award_Project_Id
922: and process_name = 'GMS_BLNG'
923: for update NOWAIT;
924:

Line 928: insert into gms_concurrency_control

924:
925: Exception
926: When no_data_found then
927: -- Bug 2441525 : GSCC Errors :Added columns in insert command
928: insert into gms_concurrency_control
929: (PROCESS_NAME,
930: PROCESS_KEY ,
931: REQUEST_ID,
932: LAST_UPDATE_DATE,

Line 956: from gms_concurrency_control

952: Begin
953:
954: Select 0
955: into X_Err_Code
956: from gms_concurrency_control
957: where process_key = X_Award_Project_Id
958: and process_name = 'GMS_BLNG'
959: for update NOWAIT;
960:

Line 7425: from gms_concurrency_control

7421:
7422: Begin
7423:
7424: Delete
7425: from gms_concurrency_control
7426: where process_name = 'GMS_BLNG'
7427: and process_key = X_project_id;
7428:
7429: Exception

Line 7569: from gms_concurrency_control

7565: -- 2. COMMIT
7566: -- 3. RETURN
7567:
7568: Delete
7569: from gms_concurrency_control
7570: where process_name = 'GMS_BLNG'
7571: and process_key = X_project_id;
7572:
7573: COMMIT;

Line 7610: from gms_concurrency_control

7606:
7607: ROLLBACK; -- If record not found , rollback to release lock
7608:
7609: Delete
7610: from gms_concurrency_control
7611: where process_name = 'GMS_BLNG'
7612: and process_key = X_project_id;
7613: COMMIT;
7614:

Line 7645: from gms_concurrency_control

7641: X_Err_Code => St_Err_Code,
7642: X_Err_Buff => St_Err_Buff);
7643:
7644: Delete
7645: from gms_concurrency_control
7646: where process_name = 'GMS_BLNG'
7647: and process_key = X_project_id;
7648:
7649: return;