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.OKL_COPY_ASSET_PVT dependencies on OKL_SUPP_INVOICE_DTLS_V

Line 1168: CURSOR okl_supp_invoice_dtls_v_pk_csr(p_id OKL_SUPP_INVOICE_DTLS.ID%TYPE) IS

1164: FUNCTION get_sidv_rec(p_cle_id IN OKL_SUPP_INVOICE_DTLS.ID%TYPE,
1165: x_sidv_rec OUT NOCOPY sidv_rec_type)
1166: RETURN VARCHAR2 IS
1167: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1168: CURSOR okl_supp_invoice_dtls_v_pk_csr(p_id OKL_SUPP_INVOICE_DTLS.ID%TYPE) IS
1169: SELECT ID,
1170: OBJECT_VERSION_NUMBER,
1171: CLE_ID,
1172: FA_CLE_ID,

Line 1200: FROM Okl_Supp_Invoice_Dtls_V sid

1196: CREATION_DATE,
1197: LAST_UPDATED_BY,
1198: LAST_UPDATE_DATE,
1199: LAST_UPDATE_LOGIN
1200: FROM Okl_Supp_Invoice_Dtls_V sid
1201: WHERE sid.cle_id = p_id;
1202: l_okl_supp_invoice_dtls_v_pk okl_supp_invoice_dtls_v_pk_csr%ROWTYPE;
1203: BEGIN
1204: -- Get current database values

Line 1202: l_okl_supp_invoice_dtls_v_pk okl_supp_invoice_dtls_v_pk_csr%ROWTYPE;

1198: LAST_UPDATE_DATE,
1199: LAST_UPDATE_LOGIN
1200: FROM Okl_Supp_Invoice_Dtls_V sid
1201: WHERE sid.cle_id = p_id;
1202: l_okl_supp_invoice_dtls_v_pk okl_supp_invoice_dtls_v_pk_csr%ROWTYPE;
1203: BEGIN
1204: -- Get current database values
1205: OPEN okl_supp_invoice_dtls_v_pk_csr (p_id => p_cle_id);
1206: FETCH okl_supp_invoice_dtls_v_pk_csr INTO

Line 1205: OPEN okl_supp_invoice_dtls_v_pk_csr (p_id => p_cle_id);

1201: WHERE sid.cle_id = p_id;
1202: l_okl_supp_invoice_dtls_v_pk okl_supp_invoice_dtls_v_pk_csr%ROWTYPE;
1203: BEGIN
1204: -- Get current database values
1205: OPEN okl_supp_invoice_dtls_v_pk_csr (p_id => p_cle_id);
1206: FETCH okl_supp_invoice_dtls_v_pk_csr INTO
1207: x_sidv_rec.id,
1208: x_sidv_rec.object_version_number,
1209: x_sidv_rec.cle_id,

Line 1206: FETCH okl_supp_invoice_dtls_v_pk_csr INTO

1202: l_okl_supp_invoice_dtls_v_pk okl_supp_invoice_dtls_v_pk_csr%ROWTYPE;
1203: BEGIN
1204: -- Get current database values
1205: OPEN okl_supp_invoice_dtls_v_pk_csr (p_id => p_cle_id);
1206: FETCH okl_supp_invoice_dtls_v_pk_csr INTO
1207: x_sidv_rec.id,
1208: x_sidv_rec.object_version_number,
1209: x_sidv_rec.cle_id,
1210: x_sidv_rec.fa_cle_id,

Line 1238: IF okl_supp_invoice_dtls_v_pk_csr%NOTFOUND THEN

1234: x_sidv_rec.creation_date,
1235: x_sidv_rec.last_updated_by,
1236: x_sidv_rec.last_update_date,
1237: x_sidv_rec.last_update_login;
1238: IF okl_supp_invoice_dtls_v_pk_csr%NOTFOUND THEN
1239: OKL_API.set_message(p_app_name => G_APP_NAME,
1240: p_msg_name => G_NO_MATCHING_RECORD,
1241: p_token1 => G_COL_NAME_TOKEN,
1242: p_token1_value => 'OKL_SUPP_INVOICE_DTLS Record');

Line 1245: CLOSE okl_supp_invoice_dtls_v_pk_csr;

1241: p_token1 => G_COL_NAME_TOKEN,
1242: p_token1_value => 'OKL_SUPP_INVOICE_DTLS Record');
1243: x_return_status := OKL_API.G_RET_STS_ERROR;
1244: END IF;
1245: CLOSE okl_supp_invoice_dtls_v_pk_csr;
1246: RETURN(x_return_status);
1247: EXCEPTION
1248: WHEN OTHERS THEN
1249: -- store SQL error message on message stack for caller

Line 1257: IF okl_supp_invoice_dtls_v_pk_csr%ISOPEN THEN

1253: G_SQLCODE_TOKEN,
1254: SQLCODE,
1255: G_SQLERRM_TOKEN,
1256: SQLERRM);
1257: IF okl_supp_invoice_dtls_v_pk_csr%ISOPEN THEN
1258: CLOSE okl_supp_invoice_dtls_v_pk_csr;
1259: END IF;
1260: -- notify caller of an UNEXPECTED error
1261: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1258: CLOSE okl_supp_invoice_dtls_v_pk_csr;

1254: SQLCODE,
1255: G_SQLERRM_TOKEN,
1256: SQLERRM);
1257: IF okl_supp_invoice_dtls_v_pk_csr%ISOPEN THEN
1258: CLOSE okl_supp_invoice_dtls_v_pk_csr;
1259: END IF;
1260: -- notify caller of an UNEXPECTED error
1261: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1262: RETURN(x_return_status);

Line 2304: FROM OKL_SUPP_INVOICE_DTLS_V

2300: IS
2301: SELECT 1
2302: FROM DUAL
2303: WHERE EXISTS (SELECT 1
2304: FROM OKL_SUPP_INVOICE_DTLS_V
2305: WHERE cle_id = p_cle_id);
2306:
2307: CURSOR c_model_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE)
2308: IS

Line 2400: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_V record');

2396: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2397: OKL_API.set_message(p_app_name => G_APP_NAME,
2398: p_msg_name => G_NO_MATCHING_RECORD,
2399: p_token1 => G_COL_NAME_TOKEN,
2400: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_V record');
2401: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2402: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2403: OKL_API.set_message(p_app_name => G_APP_NAME,
2404: p_msg_name => G_NO_MATCHING_RECORD,

Line 2406: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_V record');

2402: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2403: OKL_API.set_message(p_app_name => G_APP_NAME,
2404: p_msg_name => G_NO_MATCHING_RECORD,
2405: p_token1 => G_COL_NAME_TOKEN,
2406: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_V record');
2407: RAISE OKL_API.G_EXCEPTION_ERROR;
2408: END IF;
2409: OPEN c_model_line_id(p_cle_id => p_fin_cle_id);
2410: FETCH c_model_line_id INTO l_sidv_rec.cle_id,

Line 2441: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_V record');

2437: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2438: OKL_API.set_message(p_app_name => G_APP_NAME,
2439: p_msg_name => G_NO_MATCHING_RECORD,
2440: p_token1 => G_COL_NAME_TOKEN,
2441: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_V record');
2442: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2443: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2444: OKL_API.set_message(p_app_name => G_APP_NAME,
2445: p_msg_name => G_NO_MATCHING_RECORD,

Line 2447: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_V record');

2443: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2444: OKL_API.set_message(p_app_name => G_APP_NAME,
2445: p_msg_name => G_NO_MATCHING_RECORD,
2446: p_token1 => G_COL_NAME_TOKEN,
2447: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_V record');
2448: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2449: END IF;
2450: OPEN c_new_addon_line_id(p_cle_id => p_fin_cle_id,
2451: p_orig_cle_id => r_addon_line_id.ad_cle_id);