APPS.OKC_PDF_PVT dependencies on OKC_UTIL

Line 8: l_lang VARCHAR2(12) := OKC_UTIL.get_userenv_lang;

4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: ---------------------------------------------------------------------------
6: -- Define a local variable to get the value of USERENV('LANG')
7: ---------------------------------------------------------------------------
8: l_lang VARCHAR2(12) := OKC_UTIL.get_userenv_lang;
9:
10: ---------------------------------------------------------------------------
11: -- FUNCTION get_seq_id
12: ---------------------------------------------------------------------------

Line 907: OKC_UTIL.check_Unique(G_VIEW

903: p_msg_name => 'OKC_DUP_PROCESS_NAME');
904: END IF;
905: /*
906: IF p_pdfv_rec.name IS NOT NULL THEN
907: OKC_UTIL.check_Unique(G_VIEW
908: ,'NAME'
909: ,p_pdfv_rec.name
910: ,p_pdfv_rec.id
911: ,x_return_status);

Line 1371: --l_unq_tbl OKC_UTIL.unq_tbl_type;

1367: x_return_status OUT NOCOPY VARCHAR2,
1368: p_pdfv_rec IN pdfv_rec_type) IS
1369:
1370: --l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1371: --l_unq_tbl OKC_UTIL.unq_tbl_type;
1372: l_dummy VARCHAR2(1);
1373: l_row_found Boolean := False;
1374: CURSOR c1(p_package_name okc_process_defs_v.package_name%TYPE,
1375: p_procedure_name okc_process_defs_v.procedure_name%TYPE) is

Line 1400: OKC_UTIL.check_comp_unique(G_VIEW

1396: l_unq_tbl(2).p_col_name := 'procedure_name';
1397: l_unq_tbl(2).p_col_val := p_pdfv_rec.procedure_name;
1398:
1399: If p_pdfv_rec.package_name is not null or p_pdfv_rec.procedure_name is not null then
1400: OKC_UTIL.check_comp_unique(G_VIEW
1401: ,p_col_tbl => l_unq_tbl
1402: ,p_id => p_pdfv_rec.id
1403: ,x_return_status => l_return_status);
1404: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1446: --l_unq_tbl OKC_UTIL.unq_tbl_type;

1442: x_return_status OUT NOCOPY VARCHAR2,
1443: p_pdfv_rec IN pdfv_rec_type) IS
1444:
1445: --l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1446: --l_unq_tbl OKC_UTIL.unq_tbl_type;
1447: l_dummy VARCHAR2(1);
1448: l_row_found Boolean := False;
1449: CURSOR c1(p_wf_name okc_process_defs_v.wf_name%TYPE,
1450: p_wf_process_name okc_process_defs_v.wf_process_name%TYPE) is

Line 1475: OKC_UTIL.check_comp_unique(G_VIEW

1471: l_unq_tbl(2).p_col_name := 'wf_process_name';
1472: l_unq_tbl(2).p_col_val := p_pdfv_rec.wf_process_name;
1473:
1474: If p_pdfv_rec.wf_name is not null or p_pdfv_rec.wf_process_name is not null then
1475: OKC_UTIL.check_comp_unique(G_VIEW
1476: ,p_col_tbl => l_unq_tbl
1477: ,p_id => p_pdfv_rec.id
1478: ,x_return_status => l_return_status);
1479: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN