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_CNH_PVT dependencies on OKX_COUNTER_GROUPS_V

Line 780: CURSOR okx_counter_groups_v_pk_csr (p_counter_group_id IN NUMBER) IS

776: LAST_UPDATE_LOGIN
777: FROM Okc_Actions_V
778: WHERE okc_actions_v.id = p_id;
779: l_okc_acnv_pk okc_acnv_pk_csr%ROWTYPE;
780: CURSOR okx_counter_groups_v_pk_csr (p_counter_group_id IN NUMBER) IS
781: SELECT
782: COUNTER_GROUP_ID,
783: NAME,
784: DESCRIPTION,

Line 793: FROM Okx_Counter_Groups_V

789: SOURCE_OBJECT_CODE,
790: SOURCE_OBJECT_ID,
791: CREATED_FROM_CTR_GRP_TMPL_ID,
792: SOURCE_COUNTER_GROUP_ID
793: FROM Okx_Counter_Groups_V
794: WHERE okx_counter_groups_v.counter_group_id = p_counter_group_id;
795: l_okx_counter_groups_v_pk okx_counter_groups_v_pk_csr%ROWTYPE;
796: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
797: l_row_notfound BOOLEAN := TRUE;

Line 794: WHERE okx_counter_groups_v.counter_group_id = p_counter_group_id;

790: SOURCE_OBJECT_ID,
791: CREATED_FROM_CTR_GRP_TMPL_ID,
792: SOURCE_COUNTER_GROUP_ID
793: FROM Okx_Counter_Groups_V
794: WHERE okx_counter_groups_v.counter_group_id = p_counter_group_id;
795: l_okx_counter_groups_v_pk okx_counter_groups_v_pk_csr%ROWTYPE;
796: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
797: l_row_notfound BOOLEAN := TRUE;
798: BEGIN

Line 795: l_okx_counter_groups_v_pk okx_counter_groups_v_pk_csr%ROWTYPE;

791: CREATED_FROM_CTR_GRP_TMPL_ID,
792: SOURCE_COUNTER_GROUP_ID
793: FROM Okx_Counter_Groups_V
794: WHERE okx_counter_groups_v.counter_group_id = p_counter_group_id;
795: l_okx_counter_groups_v_pk okx_counter_groups_v_pk_csr%ROWTYPE;
796: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
797: l_row_notfound BOOLEAN := TRUE;
798: BEGIN
799: IF (p_cnhv_rec.ACN_ID IS NOT NULL)

Line 812: OPEN okx_counter_groups_v_pk_csr(p_cnhv_rec.COUNTER_GROUP_ID);

808: END IF;
809: END IF;
810: IF (p_cnhv_rec.COUNTER_GROUP_ID IS NOT NULL)
811: THEN
812: OPEN okx_counter_groups_v_pk_csr(p_cnhv_rec.COUNTER_GROUP_ID);
813: FETCH okx_counter_groups_v_pk_csr INTO l_okx_counter_groups_v_pk;
814: l_row_notfound := okx_counter_groups_v_pk_csr%NOTFOUND;
815: CLOSE okx_counter_groups_v_pk_csr;
816: IF (l_row_notfound) THEN

Line 813: FETCH okx_counter_groups_v_pk_csr INTO l_okx_counter_groups_v_pk;

809: END IF;
810: IF (p_cnhv_rec.COUNTER_GROUP_ID IS NOT NULL)
811: THEN
812: OPEN okx_counter_groups_v_pk_csr(p_cnhv_rec.COUNTER_GROUP_ID);
813: FETCH okx_counter_groups_v_pk_csr INTO l_okx_counter_groups_v_pk;
814: l_row_notfound := okx_counter_groups_v_pk_csr%NOTFOUND;
815: CLOSE okx_counter_groups_v_pk_csr;
816: IF (l_row_notfound) THEN
817: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COUNTER_GROUP_ID');

Line 814: l_row_notfound := okx_counter_groups_v_pk_csr%NOTFOUND;

810: IF (p_cnhv_rec.COUNTER_GROUP_ID IS NOT NULL)
811: THEN
812: OPEN okx_counter_groups_v_pk_csr(p_cnhv_rec.COUNTER_GROUP_ID);
813: FETCH okx_counter_groups_v_pk_csr INTO l_okx_counter_groups_v_pk;
814: l_row_notfound := okx_counter_groups_v_pk_csr%NOTFOUND;
815: CLOSE okx_counter_groups_v_pk_csr;
816: IF (l_row_notfound) THEN
817: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COUNTER_GROUP_ID');
818: RAISE item_not_found_error;

Line 815: CLOSE okx_counter_groups_v_pk_csr;

811: THEN
812: OPEN okx_counter_groups_v_pk_csr(p_cnhv_rec.COUNTER_GROUP_ID);
813: FETCH okx_counter_groups_v_pk_csr INTO l_okx_counter_groups_v_pk;
814: l_row_notfound := okx_counter_groups_v_pk_csr%NOTFOUND;
815: CLOSE okx_counter_groups_v_pk_csr;
816: IF (l_row_notfound) THEN
817: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COUNTER_GROUP_ID');
818: RAISE item_not_found_error;
819: END IF;

Line 932: SELECT 'X' FROM okx_counter_groups_v cgp

928:
929: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
930: l_temp NUMBER ;
931: CURSOR cgp_cur IS
932: SELECT 'X' FROM okx_counter_groups_v cgp
933: WHERE cgp.counter_group_id = p_cnhv_rec.counter_group_id;
934: cgp_rec cgp_cur%ROWTYPE;
935: CURSOR acn_cur IS
936: SELECT acn.counter_action_yn counter_action_yn