225: l_dnz_chr_id Number;
226: l_cle_id Number;
227: Begin
228:
229: If okl_context.get_okc_org_id is null then
230: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
231: End If;
232:
233:
226: l_cle_id Number;
227: Begin
228:
229: If okl_context.get_okc_org_id is null then
230: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
231: End If;
232:
233:
234: If p_chr_id is not null and p_cle_id is null
851: WHERE id = p_cpl_id;
852:
853: Begin
854:
855: If okl_context.get_okc_org_id is null then
856: l_chr_id := p_chr_id;
857: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
858: End If;
859:
853: Begin
854:
855: If okl_context.get_okc_org_id is null then
856: l_chr_id := p_chr_id;
857: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
858: End If;
859:
860: -- call START_ACTIVITY to create savepoint, check compatibility
861: -- and initialize message list
1371:
1372: BEGIN
1373:
1374:
1375: If okl_context.get_okc_org_id is null then
1376: l_chr_id := p_chr_id;
1377: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
1378: End If;
1379:
1373:
1374:
1375: If okl_context.get_okc_org_id is null then
1376: l_chr_id := p_chr_id;
1377: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
1378: End If;
1379:
1380: x_return_status := OKC_API.START_ACTIVITY(
1381: p_api_name => l_api_name,