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_TGD_PVT dependencies on OKX_TIMEZONES_V

Line 687: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS

683: p_tgdv_rec IN tgdv_rec_type) IS
684: item_not_found_error EXCEPTION;
685: l_row_notfound BOOLEAN := TRUE;
686: l_row_found BOOLEAN := FALSE;
687: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
688: SELECT '1'
689: FROM Okx_TimeZones_V
690: WHERE okx_timezones_v.timezone_id = p_tze_id;
691: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;

Line 689: FROM Okx_TimeZones_V

685: l_row_notfound BOOLEAN := TRUE;
686: l_row_found BOOLEAN := FALSE;
687: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
688: SELECT '1'
689: FROM Okx_TimeZones_V
690: WHERE okx_timezones_v.timezone_id = p_tze_id;
691: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
692: BEGIN
693: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 690: WHERE okx_timezones_v.timezone_id = p_tze_id;

686: l_row_found BOOLEAN := FALSE;
687: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
688: SELECT '1'
689: FROM Okx_TimeZones_V
690: WHERE okx_timezones_v.timezone_id = p_tze_id;
691: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
692: BEGIN
693: x_return_status := OKC_API.G_RET_STS_SUCCESS;
694: IF (p_tgdv_rec.TZE_ID IS NOT NULL AND

Line 691: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;

687: CURSOR okx_timezones_v_pk_csr (p_tze_id IN NUMBER) IS
688: SELECT '1'
689: FROM Okx_TimeZones_V
690: WHERE okx_timezones_v.timezone_id = p_tze_id;
691: l_okx_timezones_v_pk okx_timezones_v_pk_csr%ROWTYPE;
692: BEGIN
693: x_return_status := OKC_API.G_RET_STS_SUCCESS;
694: IF (p_tgdv_rec.TZE_ID IS NOT NULL AND
695: p_tgdv_rec.TZE_ID <> OKC_API.G_MISS_NUM)

Line 697: OPEN okx_timezones_v_pk_csr(p_tgdv_rec.TZE_ID);

693: x_return_status := OKC_API.G_RET_STS_SUCCESS;
694: IF (p_tgdv_rec.TZE_ID IS NOT NULL AND
695: p_tgdv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
696: THEN
697: OPEN okx_timezones_v_pk_csr(p_tgdv_rec.TZE_ID);
698: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
699: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
700: CLOSE okx_timezones_v_pk_csr;
701: IF (l_row_notfound) THEN

Line 698: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;

694: IF (p_tgdv_rec.TZE_ID IS NOT NULL AND
695: p_tgdv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
696: THEN
697: OPEN okx_timezones_v_pk_csr(p_tgdv_rec.TZE_ID);
698: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
699: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
700: CLOSE okx_timezones_v_pk_csr;
701: IF (l_row_notfound) THEN
702: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');

Line 699: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;

695: p_tgdv_rec.TZE_ID <> OKC_API.G_MISS_NUM)
696: THEN
697: OPEN okx_timezones_v_pk_csr(p_tgdv_rec.TZE_ID);
698: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
699: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
700: CLOSE okx_timezones_v_pk_csr;
701: IF (l_row_notfound) THEN
702: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
703: RAISE item_not_found_error;

Line 700: CLOSE okx_timezones_v_pk_csr;

696: THEN
697: OPEN okx_timezones_v_pk_csr(p_tgdv_rec.TZE_ID);
698: FETCH okx_timezones_v_pk_csr INTO l_okx_timezones_v_pk;
699: l_row_notfound := okx_timezones_v_pk_csr%NOTFOUND;
700: CLOSE okx_timezones_v_pk_csr;
701: IF (l_row_notfound) THEN
702: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TZE_ID');
703: RAISE item_not_found_error;
704: END IF;