45: G_WF_USER_ORIG_SYSTEM_HR CONSTANT VARCHAR2(5) := 'PER';
46:
47: G_AMP_SIGN CONSTANT VARCHAR2(1) := '&';
48:
49: G_DECLINED_STS_CODE CONSTANT okc_statuses_b.code%TYPE DEFAULT 'DECLINED';
50: G_ACTIVE_STS_CODE CONSTANT okc_statuses_b.code%TYPE DEFAULT 'ACTIVE';
51:
52: -- local procedure. START
53: PROCEDURE l_get_agent(p_user_id IN NUMBER,
46:
47: G_AMP_SIGN CONSTANT VARCHAR2(1) := '&';
48:
49: G_DECLINED_STS_CODE CONSTANT okc_statuses_b.code%TYPE DEFAULT 'DECLINED';
50: G_ACTIVE_STS_CODE CONSTANT okc_statuses_b.code%TYPE DEFAULT 'ACTIVE';
51:
52: -- local procedure. START
53: PROCEDURE l_get_agent(p_user_id IN NUMBER,
54: x_return_status OUT NOCOPY VARCHAR2,