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:
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:
54: -- l_get_agent finds the current user who has submitted the requisition in wf_roles,