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 7456: from gms_concurrency_control

7452:
7453: Begin
7454:
7455: Delete
7456: from gms_concurrency_control
7457: where process_name = 'GMS_BLNG'
7458: and process_key = X_project_id;
7459:
7460: Exception

Line 7600: from gms_concurrency_control

7596: -- 2. COMMIT
7597: -- 3. RETURN
7598:
7599: Delete
7600: from gms_concurrency_control
7601: where process_name = 'GMS_BLNG'
7602: and process_key = X_project_id;
7603:
7604: COMMIT;

Line 7641: from gms_concurrency_control

7637:
7638: ROLLBACK; -- If record not found , rollback to release lock
7639:
7640: Delete
7641: from gms_concurrency_control
7642: where process_name = 'GMS_BLNG'
7643: and process_key = X_project_id;
7644: COMMIT;
7645:

Line 7676: from gms_concurrency_control

7672: X_Err_Code => St_Err_Code,
7673: X_Err_Buff => St_Err_Buff);
7674:
7675: Delete
7676: from gms_concurrency_control
7677: where process_name = 'GMS_BLNG'
7678: and process_key = X_project_id;
7679:
7680: return;