DBA Data[Home] [Help]

APPS.OKL_VP_OA_WF dependencies on OKC_STATUSES_B

Line 49: G_DECLINED_STS_CODE CONSTANT okc_statuses_b.code%TYPE DEFAULT 'DECLINED';

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,

Line 50: G_ACTIVE_STS_CODE CONSTANT okc_statuses_b.code%TYPE DEFAULT 'ACTIVE';

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,