DBA Data[Home] [Help]

APPS.OKC_OAT_PVT dependencies on OKC_OUTCOMES_V

Line 290: FROM Okc_Outcomes_V

286: CREATION_DATE,
287: LAST_UPDATED_BY,
288: LAST_UPDATE_DATE,
289: LAST_UPDATE_LOGIN
290: FROM Okc_Outcomes_V
291: WHERE okc_outcomes_v.id = p_id;
292: l_okc_ocev_pk okc_ocev_pk_csr%ROWTYPE;
293: CURSOR okc_pdpv_pk_csr (p_id IN NUMBER) IS
294: SELECT

Line 291: WHERE okc_outcomes_v.id = p_id;

287: LAST_UPDATED_BY,
288: LAST_UPDATE_DATE,
289: LAST_UPDATE_LOGIN
290: FROM Okc_Outcomes_V
291: WHERE okc_outcomes_v.id = p_id;
292: l_okc_ocev_pk okc_ocev_pk_csr%ROWTYPE;
293: CURSOR okc_pdpv_pk_csr (p_id IN NUMBER) IS
294: SELECT
295: ID,

Line 606: p_token3_value => 'OKC_OUTCOMES_V');

602: p_token1_value => 'pdp_id',
603: p_token2 => g_child_table_token,
604: p_token2_value => 'OKC_PROCESS_DEF_PARAMETERS_V',
605: p_token3 => g_parent_table_token,
606: p_token3_value => 'OKC_OUTCOMES_V');
607: x_return_status := OKC_API.G_RET_STS_ERROR;
608: RAISE G_EXCEPTION_HALT_VALIDATION;
609: END IF;
610: EXCEPTION

Line 647: FROM Okc_outcomes_v

643: p_oatv_rec IN oatv_rec_type) IS
644:
645: CURSOR okc_ocev_pk_csr IS
646: SELECT '1'
647: FROM Okc_outcomes_v
648: WHERE okc_outcomes_v.id = p_oatv_rec.oce_id;
649:
650: l_dummy VARCHAR2(1) := '?';
651: BEGIN

Line 648: WHERE okc_outcomes_v.id = p_oatv_rec.oce_id;

644:
645: CURSOR okc_ocev_pk_csr IS
646: SELECT '1'
647: FROM Okc_outcomes_v
648: WHERE okc_outcomes_v.id = p_oatv_rec.oce_id;
649:
650: l_dummy VARCHAR2(1) := '?';
651: BEGIN
652: -- initialize return status

Line 679: p_token3_value => 'OKC_OUTCOMES_V');

675: p_token1_value => 'oce_id',
676: p_token2 => g_child_table_token,
677: p_token2_value => 'OKC_OUTCOME_ARGUMENTS_V',
678: p_token3 => g_parent_table_token,
679: p_token3_value => 'OKC_OUTCOMES_V');
680: x_return_status := OKC_API.G_RET_STS_ERROR;
681: RAISE G_EXCEPTION_HALT_VALIDATION;
682: END IF;
683: EXCEPTION