DBA Data[Home] [Help]

APPS.OKL_SETUPCGRPARAMETERS_PVT dependencies on OKL_FORMULAE_V

Line 75: CURSOR okl_fmav_fk_csr (p_cgr_id IN Okl_Formulae_V.cgr_id%TYPE

71: p_cgmv_rec IN cgmv_rec_type,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_valid OUT NOCOPY BOOLEAN
74: ) IS
75: CURSOR okl_fmav_fk_csr (p_cgr_id IN Okl_Formulae_V.cgr_id%TYPE
76: ) IS
77: SELECT '1'
78: FROM Okl_Formulae_V fma
79: WHERE fma.CGR_ID = p_cgr_id;

Line 78: FROM Okl_Formulae_V fma

74: ) IS
75: CURSOR okl_fmav_fk_csr (p_cgr_id IN Okl_Formulae_V.cgr_id%TYPE
76: ) IS
77: SELECT '1'
78: FROM Okl_Formulae_V fma
79: WHERE fma.CGR_ID = p_cgr_id;
80:
81: l_check VARCHAR2(1) := '?';
82: l_row_not_found BOOLEAN := FALSE;

Line 97: p_token1_value => 'Okl_Formulae_V',

93: IF l_row_not_found = FALSE then
94: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
95: p_msg_name => G_IN_USE,
96: p_token1 => G_PARENT_TABLE_TOKEN,
97: p_token1_value => 'Okl_Formulae_V',
98: p_token2 => G_CHILD_TABLE_TOKEN,
99: p_token2_value => 'Okl_Context_Groups_V');
100: x_valid := FALSE;
101: x_return_status := OKL_API.G_RET_STS_ERROR;