APPS.OKC_CGP_PVT dependencies on FND_PROFILE

Line 4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: PACKAGE BODY OKC_CGP_PVT AS
2: /* $Header: OKCSCGPB.pls 120.0 2005/05/25 19:20:47 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: ---------------------------------------------------------------------------
6: -- FUNCTION get_seq_id
7: ---------------------------------------------------------------------------
8: FUNCTION get_seq_id RETURN NUMBER IS

Line 458: l_pub_grp_creator := fnd_profile.value('OKC_PUB_GRP_CREATOR');

454: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
455: BEGIN
456: x_return_status := OKC_API.G_RET_STS_SUCCESS;
457: IF p_cgpv_rec.public_yn = 'Y' THEN
458: l_pub_grp_creator := fnd_profile.value('OKC_PUB_GRP_CREATOR');
459: IF Nvl(l_pub_grp_creator, 'N') = 'N' Then
460: OKC_API.set_message(G_APP_NAME, 'OKC_PUBLIC_GROUP_ERROR');
461: x_return_status := OKC_API.G_RET_STS_ERROR;
462: raise G_EXCEPTION_HALT_VALIDATION;

Line 484: l_user_id := TO_NUMBER(fnd_profile.value('USER_ID'));

480: l_user_id NUMBER(15);
481: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
482: BEGIN
483: x_return_status := OKC_API.G_RET_STS_SUCCESS;
484: l_user_id := TO_NUMBER(fnd_profile.value('USER_ID'));
485: IF p_cgpv_rec.public_yn = 'N' THEN
486: IF l_user_id <> p_cgpv_rec.user_id THEN
487: OKC_API.set_message(G_APP_NAME, 'OKC_PRIVATE_GROUP_ERROR');
488: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 3113: l_user_id Number := TO_NUMBER(fnd_profile.value('USER_ID'));

3109: PROCEDURE Build_Groups_Tbl(x_id_tbl OUT NOCOPY id_tbl,
3110: x_public_yn_tbl OUT NOCOPY public_yn_tbl,
3111: x_name_tbl OUT NOCOPY name_tbl,
3112: x_return_status OUT NOCOPY Varchar2) IS
3113: l_user_id Number := TO_NUMBER(fnd_profile.value('USER_ID'));
3114: CURSOR c1 IS
3115: SELECT id, public_yn, name
3116: FROM OKC_K_GROUPS_V
3117: WHERE ((public_yn = 'Y')