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_CNL_PVT dependencies on OKX_COUNTERS_V

Line 661: CURSOR okx_counters_v_pk_csr (p_counter_id IN NUMBER) IS

657: FUNCTION validate_foreign_keys (
658: p_cnlv_rec IN cnlv_rec_type
659: ) RETURN VARCHAR2 IS
660: item_not_found_error EXCEPTION;
661: CURSOR okx_counters_v_pk_csr (p_counter_id IN NUMBER) IS
662: SELECT
663: ID1,
664: ID2,
665: COUNTER_ID,

Line 685: FROM Okx_Counters_V

681: NET_READING,
682: PREV_NET_READING,
683: STATUS,
684: PRIMARY_UOM_CODE
685: FROM Okx_Counters_V
686: WHERE okx_counters_v.counter_id = p_counter_id;
687: l_okx_counters_v_pk okx_counters_v_pk_csr%ROWTYPE;
688: CURSOR okc_cnhv_pk_csr (p_id IN NUMBER) IS
689: SELECT

Line 686: WHERE okx_counters_v.counter_id = p_counter_id;

682: PREV_NET_READING,
683: STATUS,
684: PRIMARY_UOM_CODE
685: FROM Okx_Counters_V
686: WHERE okx_counters_v.counter_id = p_counter_id;
687: l_okx_counters_v_pk okx_counters_v_pk_csr%ROWTYPE;
688: CURSOR okc_cnhv_pk_csr (p_id IN NUMBER) IS
689: SELECT
690: ID,

Line 687: l_okx_counters_v_pk okx_counters_v_pk_csr%ROWTYPE;

683: STATUS,
684: PRIMARY_UOM_CODE
685: FROM Okx_Counters_V
686: WHERE okx_counters_v.counter_id = p_counter_id;
687: l_okx_counters_v_pk okx_counters_v_pk_csr%ROWTYPE;
688: CURSOR okc_cnhv_pk_csr (p_id IN NUMBER) IS
689: SELECT
690: ID,
691: OBJECT_VERSION_NUMBER,

Line 829: OPEN okx_counters_v_pk_csr(p_cnlv_rec.LEFT_COUNTER_ID);

825: l_row_notfound BOOLEAN := TRUE;
826: BEGIN
827: IF (p_cnlv_rec.LEFT_COUNTER_ID IS NOT NULL)
828: THEN
829: OPEN okx_counters_v_pk_csr(p_cnlv_rec.LEFT_COUNTER_ID);
830: FETCH okx_counters_v_pk_csr INTO l_okx_counters_v_pk;
831: l_row_notfound := okx_counters_v_pk_csr%NOTFOUND;
832: CLOSE okx_counters_v_pk_csr;
833: IF (l_row_notfound) THEN

Line 830: FETCH okx_counters_v_pk_csr INTO l_okx_counters_v_pk;

826: BEGIN
827: IF (p_cnlv_rec.LEFT_COUNTER_ID IS NOT NULL)
828: THEN
829: OPEN okx_counters_v_pk_csr(p_cnlv_rec.LEFT_COUNTER_ID);
830: FETCH okx_counters_v_pk_csr INTO l_okx_counters_v_pk;
831: l_row_notfound := okx_counters_v_pk_csr%NOTFOUND;
832: CLOSE okx_counters_v_pk_csr;
833: IF (l_row_notfound) THEN
834: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEFT_COUNTER_ID');

Line 831: l_row_notfound := okx_counters_v_pk_csr%NOTFOUND;

827: IF (p_cnlv_rec.LEFT_COUNTER_ID IS NOT NULL)
828: THEN
829: OPEN okx_counters_v_pk_csr(p_cnlv_rec.LEFT_COUNTER_ID);
830: FETCH okx_counters_v_pk_csr INTO l_okx_counters_v_pk;
831: l_row_notfound := okx_counters_v_pk_csr%NOTFOUND;
832: CLOSE okx_counters_v_pk_csr;
833: IF (l_row_notfound) THEN
834: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEFT_COUNTER_ID');
835: RAISE item_not_found_error;

Line 832: CLOSE okx_counters_v_pk_csr;

828: THEN
829: OPEN okx_counters_v_pk_csr(p_cnlv_rec.LEFT_COUNTER_ID);
830: FETCH okx_counters_v_pk_csr INTO l_okx_counters_v_pk;
831: l_row_notfound := okx_counters_v_pk_csr%NOTFOUND;
832: CLOSE okx_counters_v_pk_csr;
833: IF (l_row_notfound) THEN
834: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEFT_COUNTER_ID');
835: RAISE item_not_found_error;
836: END IF;

Line 840: OPEN okx_counters_v_pk_csr(p_cnlv_rec.RIGHT_COUNTER_ID);

836: END IF;
837: END IF;
838: IF (p_cnlv_rec.RIGHT_COUNTER_ID IS NOT NULL)
839: THEN
840: OPEN okx_counters_v_pk_csr(p_cnlv_rec.RIGHT_COUNTER_ID);
841: FETCH okx_counters_v_pk_csr INTO l_okx_counters_v_pk;
842: l_row_notfound := okx_counters_v_pk_csr%NOTFOUND;
843: CLOSE okx_counters_v_pk_csr;
844: IF (l_row_notfound) THEN

Line 841: FETCH okx_counters_v_pk_csr INTO l_okx_counters_v_pk;

837: END IF;
838: IF (p_cnlv_rec.RIGHT_COUNTER_ID IS NOT NULL)
839: THEN
840: OPEN okx_counters_v_pk_csr(p_cnlv_rec.RIGHT_COUNTER_ID);
841: FETCH okx_counters_v_pk_csr INTO l_okx_counters_v_pk;
842: l_row_notfound := okx_counters_v_pk_csr%NOTFOUND;
843: CLOSE okx_counters_v_pk_csr;
844: IF (l_row_notfound) THEN
845: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'RIGHT_COUNTER_ID');

Line 842: l_row_notfound := okx_counters_v_pk_csr%NOTFOUND;

838: IF (p_cnlv_rec.RIGHT_COUNTER_ID IS NOT NULL)
839: THEN
840: OPEN okx_counters_v_pk_csr(p_cnlv_rec.RIGHT_COUNTER_ID);
841: FETCH okx_counters_v_pk_csr INTO l_okx_counters_v_pk;
842: l_row_notfound := okx_counters_v_pk_csr%NOTFOUND;
843: CLOSE okx_counters_v_pk_csr;
844: IF (l_row_notfound) THEN
845: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'RIGHT_COUNTER_ID');
846: RAISE item_not_found_error;

Line 843: CLOSE okx_counters_v_pk_csr;

839: THEN
840: OPEN okx_counters_v_pk_csr(p_cnlv_rec.RIGHT_COUNTER_ID);
841: FETCH okx_counters_v_pk_csr INTO l_okx_counters_v_pk;
842: l_row_notfound := okx_counters_v_pk_csr%NOTFOUND;
843: CLOSE okx_counters_v_pk_csr;
844: IF (l_row_notfound) THEN
845: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'RIGHT_COUNTER_ID');
846: RAISE item_not_found_error;
847: END IF;

Line 1150: okx_counters_v ctr

1146: CURSOR ctr_cur IS
1147: SELECT 'X'
1148: FROM okc_condition_headers_b cnh,
1149: okc_condition_lines_b cnl,
1150: okx_counters_v ctr
1151: WHERE cnh.id = cnl.cnh_id
1152: AND cnh.counter_group_id = ctr.counter_group_id
1153: AND ctr.counter_id = p_cnlv_rec.left_ctr_master_id;
1154: ctr_rec ctr_cur%ROWTYPE;

Line 1220: okx_counters_v ctr

1216: CURSOR ctr_cur IS
1217: SELECT 'X'
1218: FROM okc_condition_headers_b cnh,
1219: okc_condition_lines_b cnl,
1220: okx_counters_v ctr
1221: WHERE cnh.id = cnl.cnh_id
1222: AND cnh.counter_group_id = ctr.counter_group_id
1223: AND ctr.counter_id = p_cnlv_rec.right_ctr_master_id;
1224: ctr_rec ctr_cur%ROWTYPE;

Line 1290: okx_counters_v ctr

1286: CURSOR ctr_cur IS
1287: SELECT 'X'
1288: FROM okc_condition_headers_b cnh,
1289: okc_condition_lines_b cnl,
1290: okx_counters_v ctr
1291: WHERE cnh.id = cnl.cnh_id
1292: AND cnh.counter_group_id = ctr.counter_group_id
1293: AND ctr.counter_id = p_cnlv_rec.right_counter_id;
1294: ctr_rec ctr_cur%ROWTYPE;

Line 1362: okx_counters_v ctr

1358: CURSOR ctr_cur IS
1359: SELECT 'X'
1360: FROM okc_condition_headers_b cnh,
1361: okc_condition_lines_b cnl,
1362: okx_counters_v ctr
1363: WHERE cnh.id = cnl.cnh_id
1364: AND cnh.counter_group_id = ctr.counter_group_id
1365: AND ctr.counter_id = p_cnlv_rec.left_counter_id;
1366: ctr_rec ctr_cur%ROWTYPE;