186: l_api_name CONSTANT VARCHAR2(30) := 'Associate_Name_With_User';
187: l_system_id NUMBER;
188: CURSOR c1 IS
189: SELECT system_id
190: FROM CS_SYSTEMS_ALL_VL
191: WHERE name = p_system_name;
192:
193: BEGIN
194:
256: l_api_name CONSTANT VARCHAR2(30) := 'Disassociate_Name_With_User';
257: l_system_id NUMBER;
258: CURSOR c1 IS
259: SELECT system_id
260: FROM CS_SYSTEMS_ALL_VL
261: WHERE name = p_system_name;
262:
263: BEGIN
264:
492: l_api_name CONSTANT VARCHAR2(30) := 'Associate_Name_With_SR';
493: l_system_id NUMBER;
494: CURSOR c1 IS
495: SELECT system_id
496: FROM CS_SYSTEMS_ALL_VL
497: WHERE name = p_system_name;
498:
499: BEGIN
500:
562: l_api_name CONSTANT VARCHAR2(30) := 'Disassociate_Name_With_SR';
563: l_system_id NUMBER;
564: CURSOR c1 IS
565: SELECT system_id
566: FROM CS_SYSTEMS_ALL_VL
567: WHERE name = p_system_name;
568:
569: BEGIN
570: