APPS.OKC_PDP_PVT dependencies on OKC_PROCESS_DEFS_V

Line 441: FROM Okc_Process_Defs_V

437: ) RETURN VARCHAR2 IS
438: item_not_found_error EXCEPTION;
439: CURSOR okc_pdfv_pk_csr (p_id IN NUMBER) IS
440: SELECT 'x'
441: FROM Okc_Process_Defs_V
442: WHERE okc_process_defs_v.id = p_id;
443: l_okc_pdfv_pk okc_pdfv_pk_csr%ROWTYPE;
444: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
445: l_row_notfound BOOLEAN := TRUE;

Line 442: WHERE okc_process_defs_v.id = p_id;

438: item_not_found_error EXCEPTION;
439: CURSOR okc_pdfv_pk_csr (p_id IN NUMBER) IS
440: SELECT 'x'
441: FROM Okc_Process_Defs_V
442: WHERE okc_process_defs_v.id = p_id;
443: l_okc_pdfv_pk okc_pdfv_pk_csr%ROWTYPE;
444: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
445: l_row_notfound BOOLEAN := TRUE;
446: BEGIN

Line 533: FROM Okc_Process_Defs_V

529: p_pdpv_rec IN pdpv_rec_type) IS
530:
531: CURSOR okc_pdfv_pk_csr IS
532: SELECT '1'
533: FROM Okc_Process_Defs_V
534: WHERE okc_process_defs_v.id = p_pdpv_rec.pdf_id;
535:
536: l_dummy VARCHAR2(1) := '?';
537:

Line 534: WHERE okc_process_defs_v.id = p_pdpv_rec.pdf_id;

530:
531: CURSOR okc_pdfv_pk_csr IS
532: SELECT '1'
533: FROM Okc_Process_Defs_V
534: WHERE okc_process_defs_v.id = p_pdpv_rec.pdf_id;
535:
536: l_dummy VARCHAR2(1) := '?';
537:
538: BEGIN

Line 567: p_token3_value => 'OKC_PROCESS_DEFS_V');

563: p_token1_value => 'pdf_id',
564: p_token2 => g_child_table_token,
565: p_token2_value => 'OKC_PROCESS_DEF_PARAMETERS_V',
566: p_token3 => g_parent_table_token,
567: p_token3_value => 'OKC_PROCESS_DEFS_V');
568:
569: x_return_status := OKC_API.G_RET_STS_ERROR;
570: RAISE G_EXCEPTION_HALT_VALIDATION;
571: END IF;

Line 606: SELECT pdf.USAGE , pdf.pdf_type from okc_process_defs_v pdf

602: pdf_usage varchar2(60);
603: pdf_type varchar2(30);
604:
605: CURSOR k1_csr is
606: SELECT pdf.USAGE , pdf.pdf_type from okc_process_defs_v pdf
607: where pdf.id = p_pdpv_rec.pdf_id ;
608:
609: k1_rec k1_csr%ROWTYPE;
610: