DBA Data[Home] [Help]

APPS.OKE_CHR_PVT dependencies on OKE_K_TYPES_B

Line 29: FUNCTION IS_BOA (P_TYPE_CODE IN OKE_K_TYPES_B.K_TYPE_CODE%type)

25:
26:
27:
28: /* Bug 7115155 Start */
29: FUNCTION IS_BOA (P_TYPE_CODE IN OKE_K_TYPES_B.K_TYPE_CODE%type)
30: RETURN BOOLEAN
31: IS
32: l_type_class_code OKE_K_TYPES_B.TYPE_CLASS_CODE%TYPE;
33: BEGIN

Line 32: l_type_class_code OKE_K_TYPES_B.TYPE_CLASS_CODE%TYPE;

28: /* Bug 7115155 Start */
29: FUNCTION IS_BOA (P_TYPE_CODE IN OKE_K_TYPES_B.K_TYPE_CODE%type)
30: RETURN BOOLEAN
31: IS
32: l_type_class_code OKE_K_TYPES_B.TYPE_CLASS_CODE%TYPE;
33: BEGIN
34:
35: SELECT TYPE_CLASS_CODE
36: INTO l_type_class_code

Line 37: FROM OKE_K_TYPES_B

33: BEGIN
34:
35: SELECT TYPE_CLASS_CODE
36: INTO l_type_class_code
37: FROM OKE_K_TYPES_B
38: WHERE K_TYPE_CODE=P_TYPE_CODE;
39:
40: IF l_type_class_code='BOA' THEN
41: RETURN TRUE;

Line 527: SELECT 'x' FROM OKE_K_TYPES_B

523: p_chr_rec IN chr_rec_type)IS
524:
525: l_dummy_val VARCHAR2(1):= '?';
526: CURSOR l_csr IS
527: SELECT 'x' FROM OKE_K_TYPES_B
528: WHERE K_TYPE_CODE = p_chr_rec.k_type_code;
529:
530: BEGIN
531: x_return_status := OKE_API.G_RET_STS_SUCCESS;

Line 558: p_token3_value =>'OKE_K_TYPES_B');

554: p_token1_value =>'K_TYPE_CODE',
555: p_token2 =>g_child_table_token,
556: p_token2_value =>G_VIEW,
557: p_token3 =>g_parent_table_token,
558: p_token3_value =>'OKE_K_TYPES_B');
559:
560: x_return_status := OKE_API.G_RET_STS_ERROR;
561: END IF;
562: