462:
463:
464: Begin
465:
466: If okl_context.get_okc_org_id is null then
467: l_chr_id := p_chr_id;
468: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
469: End If;
470:
464: Begin
465:
466: If okl_context.get_okc_org_id is null then
467: l_chr_id := p_chr_id;
468: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
469: End If;
470:
471:
472:
938: Begin
939:
940:
941:
942: If okl_context.get_okc_org_id is null then
943:
944: l_chr_id := p_chr_id;
945:
946: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
942: If okl_context.get_okc_org_id is null then
943:
944: l_chr_id := p_chr_id;
945:
946: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
947:
948: End If;
949:
950:
1006: End If;
1007:
1008:
1009:
1010: If okl_context.get_okc_org_id is null then
1011:
1012: l_chr_id := p_chr_id;
1013:
1014: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
1010: If okl_context.get_okc_org_id is null then
1011:
1012: l_chr_id := p_chr_id;
1013:
1014: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
1015:
1016: End If;
1017: --Added by kthiruva 23-Sep-2003 Bug No.3156265
1018:
1476:
1477:
1478: Begin
1479:
1480: If okl_context.get_okc_org_id is null then
1481: l_chr_id := p_chr_id;
1482: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
1483: End If;
1484:
1478: Begin
1479:
1480: If okl_context.get_okc_org_id is null then
1481: l_chr_id := p_chr_id;
1482: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
1483: End If;
1484:
1485: -- call START_ACTIVITY to create savepoint, check compatibility
1486: -- and initialize message list
2385: Begin
2386:
2387:
2388:
2389: If okl_context.get_okc_org_id is null then
2390: l_chr_id := p_chr_id;
2391: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
2392: End If;
2393:
2387:
2388:
2389: If okl_context.get_okc_org_id is null then
2390: l_chr_id := p_chr_id;
2391: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
2392: End If;
2393:
2394:
2395:
3490:
3491:
3492: Begin
3493:
3494: If okl_context.get_okc_org_id is null then
3495: l_chr_id := p_chr_id;
3496: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
3497: End If;
3498:
3492: Begin
3493:
3494: If okl_context.get_okc_org_id is null then
3495: l_chr_id := p_chr_id;
3496: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
3497: End If;
3498:
3499:
3500: -- call START_ACTIVITY to create savepoint, check compatibility
5065:
5066:
5067: Begin
5068:
5069: If okl_context.get_okc_org_id is null then
5070: l_chr_id := p_chr_id;
5071: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
5072: End If;
5073:
5067: Begin
5068:
5069: If okl_context.get_okc_org_id is null then
5070: l_chr_id := p_chr_id;
5071: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
5072: End If;
5073:
5074:
5075: -- call START_ACTIVITY to create savepoint, check compatibility
6906:
6907: BEGIN
6908:
6909: l_chr_id := p_chr_id;
6910: If okl_context.get_okc_org_id is null then
6911: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
6912: End If;
6913:
6914: x_return_status := OKC_API.START_ACTIVITY(
6907: BEGIN
6908:
6909: l_chr_id := p_chr_id;
6910: If okl_context.get_okc_org_id is null then
6911: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
6912: End If;
6913:
6914: x_return_status := OKC_API.START_ACTIVITY(
6915: p_api_name => l_api_name,
7292: BEGIN
7293:
7294:
7295:
7296: If okl_context.get_okc_org_id is null then
7297:
7298: l_chr_id := p_chr_id;
7299:
7300: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
7296: If okl_context.get_okc_org_id is null then
7297:
7298: l_chr_id := p_chr_id;
7299:
7300: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
7301:
7302: End If;
7303:
7304:
8020: BEGIN
8021:
8022:
8023:
8024: If okl_context.get_okc_org_id is null then
8025:
8026: l_chr_id := p_chr_id;
8027:
8028: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
8024: If okl_context.get_okc_org_id is null then
8025:
8026: l_chr_id := p_chr_id;
8027:
8028: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
8029:
8030: End If;
8031:
8032:
8194: BEGIN
8195:
8196:
8197:
8198: If okl_context.get_okc_org_id is null then
8199:
8200: l_chr_id := p_chr_id;
8201:
8202: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
8198: If okl_context.get_okc_org_id is null then
8199:
8200: l_chr_id := p_chr_id;
8201:
8202: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
8203:
8204: End If;
8205:
8206:
8338:
8339:
8340: l_chr_id := p_chr_id;
8341:
8342: If okl_context.get_okc_org_id is null then
8343:
8344: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
8345:
8346: End If;
8340: l_chr_id := p_chr_id;
8341:
8342: If okl_context.get_okc_org_id is null then
8343:
8344: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
8345:
8346: End If;
8347:
8348:
9429:
9430: BEGIN
9431:
9432: l_chr_id := p_chr_id;
9433: If okl_context.get_okc_org_id is null then
9434: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
9435: End If;
9436:
9437: x_return_status := OKC_API.START_ACTIVITY(
9430: BEGIN
9431:
9432: l_chr_id := p_chr_id;
9433: If okl_context.get_okc_org_id is null then
9434: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
9435: End If;
9436:
9437: x_return_status := OKC_API.START_ACTIVITY(
9438: p_api_name => l_api_name,
9561:
9562: BEGIN
9563:
9564: l_chr_id := p_chr_id;
9565: If okl_context.get_okc_org_id is null then
9566: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
9567: End If;
9568:
9569: x_return_status := OKC_API.START_ACTIVITY(
9562: BEGIN
9563:
9564: l_chr_id := p_chr_id;
9565: If okl_context.get_okc_org_id is null then
9566: okl_context.set_okc_org_context(p_chr_id => l_chr_id );
9567: End If;
9568:
9569: x_return_status := OKC_API.START_ACTIVITY(
9570: p_api_name => l_api_name,