9: Arguement is registration_id for row with requested username to be
10: tested. Will throw exception if registration_id is invalid.
11: */
12: EVENT_SUCCESS CONSTANT VARCHAR2(7) := 'SUCCESS';
13: APPROVAL_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_TYPE';
14: APPROVAL_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_KEY';
15: INVITATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_TYPE';
16: INVITATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_';
17: REGISTRATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_TYPE';
10: tested. Will throw exception if registration_id is invalid.
11: */
12: EVENT_SUCCESS CONSTANT VARCHAR2(7) := 'SUCCESS';
13: APPROVAL_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_TYPE';
14: APPROVAL_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_KEY';
15: INVITATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_TYPE';
16: INVITATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_';
17: REGISTRATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_TYPE';
18: REGISTRATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_KEY';
11: */
12: EVENT_SUCCESS CONSTANT VARCHAR2(7) := 'SUCCESS';
13: APPROVAL_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_TYPE';
14: APPROVAL_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_KEY';
15: INVITATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_TYPE';
16: INVITATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_';
17: REGISTRATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_TYPE';
18: REGISTRATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_KEY';
19: REJECTION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_TYPE';
12: EVENT_SUCCESS CONSTANT VARCHAR2(7) := 'SUCCESS';
13: APPROVAL_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_TYPE';
14: APPROVAL_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_KEY';
15: INVITATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_TYPE';
16: INVITATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_';
17: REGISTRATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_TYPE';
18: REGISTRATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_KEY';
19: REJECTION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_TYPE';
20: REJECTION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_KEY';
13: APPROVAL_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_TYPE';
14: APPROVAL_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_KEY';
15: INVITATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_TYPE';
16: INVITATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_';
17: REGISTRATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_TYPE';
18: REGISTRATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_KEY';
19: REJECTION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_TYPE';
20: REJECTION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_KEY';
21:
14: APPROVAL_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'APPR_WF_ITEM_KEY';
15: INVITATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_TYPE';
16: INVITATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_';
17: REGISTRATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_TYPE';
18: REGISTRATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_KEY';
19: REJECTION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_TYPE';
20: REJECTION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_KEY';
21:
22: function is_requested_username_unique(
15: INVITATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_TYPE';
16: INVITATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_';
17: REGISTRATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_TYPE';
18: REGISTRATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_KEY';
19: REJECTION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_TYPE';
20: REJECTION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_KEY';
21:
22: function is_requested_username_unique(
23: p_username IN VARCHAR2)
16: INVITATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'INV_WF_ITEM_';
17: REGISTRATION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_TYPE';
18: REGISTRATION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REG_WF_ITEM_KEY';
19: REJECTION_WF_ITEM_TYPE CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_TYPE';
20: REJECTION_WF_ITEM_KEY CONSTANT FND_REGISTRATION_DETAILS.FIELD_VALUE_STRING%TYPE := 'REJ_WF_ITEM_KEY';
21:
22: function is_requested_username_unique(
23: p_username IN VARCHAR2)
24: return VARCHAR2;