Add 2FA account into CAMIS

2FA account creation so that the CAMIS administrator can assign eMER status to CAME.
This assumes that record in CAMIS has already been created.

Connect using TWOFA@TTSXP18
Get next value from sequence: SELECT AC040_STAKEHOLDER_ID_SEQ.nextval FROM dual;

Create record in the TWOFA.AC040_STAKEHOLDER table - use an existing record as a template
**Note: the value in GLOBAL_USERID_LBL is just a random bunch of characters - 12 characters

INSERT INTO TWOFA.AC040_STAKEHOLDER (STAKEHOLDER_ID, STAKEHOLDER_TYPE_CD, NAME_FIRST_NM, NAME_LAST_NM, STAKEHOLDER_CREATED_ID, GLOBAL_USERID_LBL, USER_LAST_UPDATE_ID)
VALUES ([Value from Step 2], 1, 'First Name', 'Last Name', 1, '[Random generated 12 char alphanumeric]', 1);

Example:

INSERT INTO TWOFA.AC040_STAKEHOLDER (STAKEHOLDER_ID, STAKEHOLDER_TYPE_CD, NAME_FIRST_NM, NAME_LAST_NM, STAKEHOLDER_CREATED_ID, GLOBAL_USERID_LBL, USER_LAST_UPDATE_ID)
VALUES (2491, 1, 'Samia', 'Dawi', 1, 'J5MBODB0SAJM', 1);

Create record in the TWOFA.AC043_INTERNAL_STAKEHOLDER table - use existing record as a template
Copy the random characters from TWOFA.AC040_STAKEHOLDER.GLOBAL_USERID_LBL into CAMIS database CAMIS.AA008_APPLICATION_USER.TWOFA_USERID_LBL for the newly created TWOFA account
Create in the TWOFA.AC002_XREF_APPLICATION_USER table - use existing record as a template
** BE SURE TO SET ROLE_CD = 2