APPS.OKL_VERSION_PVT dependencies on OKC_K_HEADERS_V

Line 27: G_LEASE_SCS_CODE CONSTANT OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';

23: G_ID2 CONSTANT VARCHAR2(200) := '#';
24: G_TRY_TYPE CONSTANT OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
25: G_TLS_TYPE CONSTANT OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
26: G_SLS_TYPE CONSTANT OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
27: G_LEASE_SCS_CODE CONSTANT OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
28: G_LOAN_SCS_CODE CONSTANT OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
29: ----------------------------------------------------------------------------------------
30: -- GLOBAL EXCEPTION
31: ----------------------------------------------------------------------------------------

Line 28: G_LOAN_SCS_CODE CONSTANT OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';

24: G_TRY_TYPE CONSTANT OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
25: G_TLS_TYPE CONSTANT OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
26: G_SLS_TYPE CONSTANT OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
27: G_LEASE_SCS_CODE CONSTANT OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
28: G_LOAN_SCS_CODE CONSTANT OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
29: ----------------------------------------------------------------------------------------
30: -- GLOBAL EXCEPTION
31: ----------------------------------------------------------------------------------------
32: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 1085: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;

1081: l_api_version CONSTANT NUMBER := 1;
1082: l_api_name CONSTANT VARCHAR2(30) := 'VERSION_CONTRACT';
1083: l_chr_id NUMBER;
1084: l_major_version NUMBER;
1085: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
1086: CURSOR c_get_sts_code(p_chr_id OKC_K_HEADERS_V.ID%TYPE)
1087: IS
1088: SELECT st.ste_code
1089: FROM OKC_K_HEADERS_V chr,

Line 1086: CURSOR c_get_sts_code(p_chr_id OKC_K_HEADERS_V.ID%TYPE)

1082: l_api_name CONSTANT VARCHAR2(30) := 'VERSION_CONTRACT';
1083: l_chr_id NUMBER;
1084: l_major_version NUMBER;
1085: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
1086: CURSOR c_get_sts_code(p_chr_id OKC_K_HEADERS_V.ID%TYPE)
1087: IS
1088: SELECT st.ste_code
1089: FROM OKC_K_HEADERS_V chr,
1090: okc_statuses_b st

Line 1089: FROM OKC_K_HEADERS_V chr,

1085: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
1086: CURSOR c_get_sts_code(p_chr_id OKC_K_HEADERS_V.ID%TYPE)
1087: IS
1088: SELECT st.ste_code
1089: FROM OKC_K_HEADERS_V chr,
1090: okc_statuses_b st
1091: WHERE chr.id = p_chr_id
1092: and st.code = chr.sts_code;
1093: BEGIN

Line 1113: p_token1_value => 'OKC_K_HEADERS_V.STS_CODE');

1109: IF c_get_sts_code%NOTFOUND THEN
1110: OKL_API.set_message(p_app_name => G_APP_NAME,
1111: p_msg_name => G_NO_MATCHING_RECORD,
1112: p_token1 => G_COL_NAME_TOKEN,
1113: p_token1_value => 'OKC_K_HEADERS_V.STS_CODE');
1114: RAISE OKL_API.G_EXCEPTION_ERROR;
1115: END IF;
1116: FETCH c_get_sts_code INTO lv_sts_code;
1117: CLOSE c_get_sts_code;