DBA Data[Home] [Help]

APPS.OKL_SETUPFMACONSTRAINTS_PVT dependencies on OKL_OPERANDS_V

Line 84: CURSOR okl_opdv_pk_csr (p_opd_id IN Okl_Operands_V.id%TYPE,

80: p_fodv_rec IN fodv_rec_type,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_valid OUT NOCOPY BOOLEAN
83: ) IS
84: CURSOR okl_opdv_pk_csr (p_opd_id IN Okl_Operands_V.id%TYPE,
85: p_fma_id IN Okl_Formulae_V.id%TYPE
86: ) IS
87: SELECT '1'
88: FROM Okl_Operands_V opd,

Line 88: FROM Okl_Operands_V opd,

84: CURSOR okl_opdv_pk_csr (p_opd_id IN Okl_Operands_V.id%TYPE,
85: p_fma_id IN Okl_Formulae_V.id%TYPE
86: ) IS
87: SELECT '1'
88: FROM Okl_Operands_V opd,
89: Okl_Formulae_V fma
90: WHERE opd.ID = p_opd_id
91: AND fma.ID = p_fma_id
92: AND (opd.START_DATE > fma.START_DATE OR

Line 112: p_token1_value => 'Okl_Operands_V',

108: IF l_row_not_found = FALSE then
109: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
110: p_msg_name => G_DATES_MISMATCH,
111: p_token1 => G_PARENT_TABLE_TOKEN,
112: p_token1_value => 'Okl_Operands_V',
113: p_token2 => G_CHILD_TABLE_TOKEN,
114: p_token2_value => 'Okl_Fmla_Oprnds_V');
115: x_valid := FALSE;
116: x_return_status := OKL_API.G_RET_STS_ERROR;