eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CONTRACT_GROUP_PVT dependencies on OKC_K_GROUPS_B

Line 555: FROM OKC_K_GROUPS_B

551: invalid_group_error EXCEPTION;
552: CURSOR okc_cgpv_csr (p_id IN NUMBER) IS
553: SELECT public_yn,
554: user_id
555: FROM OKC_K_GROUPS_B
556: WHERE id = p_id;
557: l_group_public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE;
558: l_subgroup_public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE;
559: l_group_user_id OKC_K_GROUPS_B.USER_ID%TYPE;

Line 557: l_group_public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE;

553: SELECT public_yn,
554: user_id
555: FROM OKC_K_GROUPS_B
556: WHERE id = p_id;
557: l_group_public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE;
558: l_subgroup_public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE;
559: l_group_user_id OKC_K_GROUPS_B.USER_ID%TYPE;
560: l_subgroup_user_id OKC_K_GROUPS_B.USER_ID%TYPE;
561: l_user_id NUMBER(15) := TO_NUMBER(fnd_profile.value('USER_ID'));

Line 558: l_subgroup_public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE;

554: user_id
555: FROM OKC_K_GROUPS_B
556: WHERE id = p_id;
557: l_group_public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE;
558: l_subgroup_public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE;
559: l_group_user_id OKC_K_GROUPS_B.USER_ID%TYPE;
560: l_subgroup_user_id OKC_K_GROUPS_B.USER_ID%TYPE;
561: l_user_id NUMBER(15) := TO_NUMBER(fnd_profile.value('USER_ID'));
562: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 559: l_group_user_id OKC_K_GROUPS_B.USER_ID%TYPE;

555: FROM OKC_K_GROUPS_B
556: WHERE id = p_id;
557: l_group_public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE;
558: l_subgroup_public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE;
559: l_group_user_id OKC_K_GROUPS_B.USER_ID%TYPE;
560: l_subgroup_user_id OKC_K_GROUPS_B.USER_ID%TYPE;
561: l_user_id NUMBER(15) := TO_NUMBER(fnd_profile.value('USER_ID'));
562: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
563: BEGIN

Line 560: l_subgroup_user_id OKC_K_GROUPS_B.USER_ID%TYPE;

556: WHERE id = p_id;
557: l_group_public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE;
558: l_subgroup_public_yn OKC_K_GROUPS_B.PUBLIC_YN%TYPE;
559: l_group_user_id OKC_K_GROUPS_B.USER_ID%TYPE;
560: l_subgroup_user_id OKC_K_GROUPS_B.USER_ID%TYPE;
561: l_user_id NUMBER(15) := TO_NUMBER(fnd_profile.value('USER_ID'));
562: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
563: BEGIN
564: OPEN okc_cgpv_csr(p_cgcv_rec.cgp_parent_id);