APPS.OKC_OAT_PVT dependencies on OKC_PROCESS_DEF_PARAMETERS_V

Line 311: FROM Okc_Process_Def_Parameters_V

307: CREATION_DATE,
308: LAST_UPDATED_BY,
309: LAST_UPDATE_DATE,
310: LAST_UPDATE_LOGIN
311: FROM Okc_Process_Def_Parameters_V
312: WHERE okc_process_def_parameters_v.id = p_id;
313: l_okc_pdpv_pk okc_pdpv_pk_csr%ROWTYPE;
314: CURSOR okc_aaev_pk_csr (p_id IN NUMBER) IS
315: SELECT

Line 312: WHERE okc_process_def_parameters_v.id = p_id;

308: LAST_UPDATED_BY,
309: LAST_UPDATE_DATE,
310: LAST_UPDATE_LOGIN
311: FROM Okc_Process_Def_Parameters_V
312: WHERE okc_process_def_parameters_v.id = p_id;
313: l_okc_pdpv_pk okc_pdpv_pk_csr%ROWTYPE;
314: CURSOR okc_aaev_pk_csr (p_id IN NUMBER) IS
315: SELECT
316: ID,

Line 574: FROM Okc_process_def_parameters_v, okc_process_defs_v

570: p_oatv_rec IN oatv_rec_type) IS
571:
572: CURSOR okc_pdpv_pk_csr IS
573: SELECT '1'
574: FROM Okc_process_def_parameters_v, okc_process_defs_v
575: WHERE okc_process_def_parameters_v.id = p_oatv_rec.pdp_id
576: and okc_process_def_parameters_v.pdf_id = okc_process_defs_v.id;
577:
578: l_dummy VARCHAR2(1) := '?';

Line 575: WHERE okc_process_def_parameters_v.id = p_oatv_rec.pdp_id

571:
572: CURSOR okc_pdpv_pk_csr IS
573: SELECT '1'
574: FROM Okc_process_def_parameters_v, okc_process_defs_v
575: WHERE okc_process_def_parameters_v.id = p_oatv_rec.pdp_id
576: and okc_process_def_parameters_v.pdf_id = okc_process_defs_v.id;
577:
578: l_dummy VARCHAR2(1) := '?';
579: BEGIN

Line 576: and okc_process_def_parameters_v.pdf_id = okc_process_defs_v.id;

572: CURSOR okc_pdpv_pk_csr IS
573: SELECT '1'
574: FROM Okc_process_def_parameters_v, okc_process_defs_v
575: WHERE okc_process_def_parameters_v.id = p_oatv_rec.pdp_id
576: and okc_process_def_parameters_v.pdf_id = okc_process_defs_v.id;
577:
578: l_dummy VARCHAR2(1) := '?';
579: BEGIN
580: -- initialize return status

Line 604: p_token2_value => 'OKC_PROCESS_DEF_PARAMETERS_V',

600: p_msg_name => g_no_parent_record,
601: p_token1 => g_col_name_token,
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;

Line 933: from okc_process_def_parameters_v

929: p_oatv_rec IN oatv_rec_type) IS
930:
931: cursor pdp_cur(p_pdp_id IN NUMBER) is
932: select data_type
933: from okc_process_def_parameters_v
934: where id = p_pdp_id;
935:
936: cursor aae_cur(p_aae_id IN NUMBER) is
937: select data_type

Line 1032: from okc_process_def_parameters_v

1028: p_oatv_rec IN oatv_rec_type) IS
1029:
1030: cursor pdp_cur(p_pdp_id IN NUMBER) is
1031: select data_type
1032: from okc_process_def_parameters_v
1033: where id = p_pdp_id;
1034:
1035: l_pdp_data_type VARCHAR2(90);
1036: l_func_datatype BOOLEAN;