DBA Data[Home] [Help]

APPS.OKC_CAC_PVT dependencies on JTF_RS_GROUPS_B

Line 30: from JTF_RS_GROUPS_B

26: p_cacv_rec IN cacv_rec_type) is
27: l_dummy_var VARCHAR2(1) := '?';
28: Cursor l_jtfv_csr Is
29: select 'x'
30: from JTF_RS_GROUPS_B
31: where GROUP_ID = p_cacv_rec.group_id;
32: Begin
33:
34: IF (l_debug = 'Y') THEN

Line 42: -- Check JTF_RS_GROUPS_B for valid group id

38:
39: -- initialize return status
40: x_return_status := OKC_API.G_RET_STS_SUCCESS;
41:
42: -- Check JTF_RS_GROUPS_B for valid group id
43: If (p_cacv_rec.group_id <> OKC_API.G_MISS_NUM and
44: p_cacv_rec.group_id IS NOT NULL)
45: Then
46: -- enforce foreign key

Line 60: p_token3_value => 'JTF_RS_GROUPS_B');

56: p_token1_value => 'Group Id',
57: p_token2 => g_child_table_token,
58: p_token2_value => G_VIEW,
59: p_token3 => g_parent_table_token,
60: p_token3_value => 'JTF_RS_GROUPS_B');
61:
62: -- notify caller of an error
63: x_return_status := OKC_API.G_RET_STS_ERROR;
64: End If;