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_SID_PVT dependencies on OKL_SUPP_INVOICE_DTLS_H

Line 842: -- FUNCTION get_rec for: OKL_SUPP_INVOICE_DTLS_H

838: BEGIN
839: RETURN(get_rec(p_sid_rec, l_row_not_found));
840: END get_rec;
841: ---------------------------------------------------------------------------
842: -- FUNCTION get_rec for: OKL_SUPP_INVOICE_DTLS_H
843: ---------------------------------------------------------------------------
844: FUNCTION get_rec (p_sidh_rec IN okl_sidh_rec_type,
845: x_no_data_found OUT NOCOPY BOOLEAN)
846: RETURN okl_sidh_rec_type IS

Line 847: CURSOR okl_supp_invoice_dtls_h_pk_csr(p_id IN NUMBER) IS

843: ---------------------------------------------------------------------------
844: FUNCTION get_rec (p_sidh_rec IN okl_sidh_rec_type,
845: x_no_data_found OUT NOCOPY BOOLEAN)
846: RETURN okl_sidh_rec_type IS
847: CURSOR okl_supp_invoice_dtls_h_pk_csr(p_id IN NUMBER) IS
848: SELECT ID,
849: OBJECT_VERSION_NUMBER,
850: MAJOR_VERSION,
851: CLE_ID,

Line 880: FROM Okl_Supp_Invoice_Dtls_h

876: CREATION_DATE,
877: LAST_UPDATED_BY,
878: LAST_UPDATE_DATE,
879: LAST_UPDATE_LOGIN
880: FROM Okl_Supp_Invoice_Dtls_h
881: WHERE okl_supp_invoice_dtls_h.id = p_id;
882: l_okl_supp_invoice_dtls_h_pk okl_supp_invoice_dtls_h_pk_csr%ROWTYPE;
883: l_okl_sidh_rec okl_sidh_rec_type;
884: BEGIN

Line 881: WHERE okl_supp_invoice_dtls_h.id = p_id;

877: LAST_UPDATED_BY,
878: LAST_UPDATE_DATE,
879: LAST_UPDATE_LOGIN
880: FROM Okl_Supp_Invoice_Dtls_h
881: WHERE okl_supp_invoice_dtls_h.id = p_id;
882: l_okl_supp_invoice_dtls_h_pk okl_supp_invoice_dtls_h_pk_csr%ROWTYPE;
883: l_okl_sidh_rec okl_sidh_rec_type;
884: BEGIN
885: x_no_data_found := TRUE;

Line 882: l_okl_supp_invoice_dtls_h_pk okl_supp_invoice_dtls_h_pk_csr%ROWTYPE;

878: LAST_UPDATE_DATE,
879: LAST_UPDATE_LOGIN
880: FROM Okl_Supp_Invoice_Dtls_h
881: WHERE okl_supp_invoice_dtls_h.id = p_id;
882: l_okl_supp_invoice_dtls_h_pk okl_supp_invoice_dtls_h_pk_csr%ROWTYPE;
883: l_okl_sidh_rec okl_sidh_rec_type;
884: BEGIN
885: x_no_data_found := TRUE;
886: -- Get current database values

Line 887: OPEN okl_supp_invoice_dtls_h_pk_csr(p_sidh_rec.id);

883: l_okl_sidh_rec okl_sidh_rec_type;
884: BEGIN
885: x_no_data_found := TRUE;
886: -- Get current database values
887: OPEN okl_supp_invoice_dtls_h_pk_csr(p_sidh_rec.id);
888: FETCH okl_supp_invoice_dtls_h_pk_csr INTO
889: l_okl_sidh_rec.ID,
890: l_okl_sidh_rec.OBJECT_VERSION_NUMBER,
891: l_okl_sidh_rec.MAJOR_VERSION,

Line 888: FETCH okl_supp_invoice_dtls_h_pk_csr INTO

884: BEGIN
885: x_no_data_found := TRUE;
886: -- Get current database values
887: OPEN okl_supp_invoice_dtls_h_pk_csr(p_sidh_rec.id);
888: FETCH okl_supp_invoice_dtls_h_pk_csr INTO
889: l_okl_sidh_rec.ID,
890: l_okl_sidh_rec.OBJECT_VERSION_NUMBER,
891: l_okl_sidh_rec.MAJOR_VERSION,
892: l_okl_sidh_rec.CLE_ID,

Line 921: x_no_data_found := okl_supp_invoice_dtls_h_pk_csr%NOTFOUND;

917: l_okl_sidh_rec.CREATION_DATE,
918: l_okl_sidh_rec.LAST_UPDATED_BY,
919: l_okl_sidh_rec.LAST_UPDATE_DATE,
920: l_okl_sidh_rec.LAST_UPDATE_LOGIN;
921: x_no_data_found := okl_supp_invoice_dtls_h_pk_csr%NOTFOUND;
922: CLOSE okl_supp_invoice_dtls_h_pk_csr;
923: RETURN(l_okl_sidh_rec);
924: END get_rec;
925: ------------------------------------------------------------------

Line 922: CLOSE okl_supp_invoice_dtls_h_pk_csr;

918: l_okl_sidh_rec.LAST_UPDATED_BY,
919: l_okl_sidh_rec.LAST_UPDATE_DATE,
920: l_okl_sidh_rec.LAST_UPDATE_LOGIN;
921: x_no_data_found := okl_supp_invoice_dtls_h_pk_csr%NOTFOUND;
922: CLOSE okl_supp_invoice_dtls_h_pk_csr;
923: RETURN(l_okl_sidh_rec);
924: END get_rec;
925: ------------------------------------------------------------------
926: -- This version of get_rec sets error messages if no data found --

Line 1417: -- insert_row for: OKL_SUPP_INVOICE_DTLS_H --

1413: '_PVT'
1414: );
1415: END validate_row;
1416: --------------------------------------------------
1417: -- insert_row for: OKL_SUPP_INVOICE_DTLS_H --
1418: --------------------------------------------------
1419: PROCEDURE insert_row(
1420: p_api_version IN NUMBER,
1421: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1434: -- Set_Attributes for: OKL_SUPP_INVOICE_DTLS_H ---

1430: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1431: l_sidh_rec okl_sidh_rec_type := p_sidh_rec;
1432: l_def_sidh_rec okl_sidh_rec_type;
1433: --------------------------------------------------
1434: -- Set_Attributes for: OKL_SUPP_INVOICE_DTLS_H ---
1435: --------------------------------------------------
1436: FUNCTION Set_Attributes (
1437: p_sidh_rec IN okl_sidh_rec_type,
1438: x_sidh_rec OUT NOCOPY okl_sidh_rec_type

Line 1467: INSERT INTO OKL_SUPP_INVOICE_DTLS_H(

1463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1465: RAISE OKC_API.G_EXCEPTION_ERROR;
1466: END IF;
1467: INSERT INTO OKL_SUPP_INVOICE_DTLS_H(
1468: id,
1469: object_version_number,
1470: major_version,
1471: cle_id,

Line 3032: p_major_version IN OKL_SUPP_INVOICE_DTLS_H.MAJOR_VERSION%TYPE)

3028: ---------------------------------------------------------------------------
3029: -- PROCEDURE versioning
3030: ---------------------------------------------------------------------------
3031: FUNCTION create_version(p_chr_id IN OKC_K_LINES_B.ID%TYPE,
3032: p_major_version IN OKL_SUPP_INVOICE_DTLS_H.MAJOR_VERSION%TYPE)
3033: RETURN VARCHAR2
3034: IS
3035: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3036: BEGIN

Line 3037: INSERT INTO OKL_SUPP_INVOICE_DTLS_H(

3033: RETURN VARCHAR2
3034: IS
3035: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3036: BEGIN
3037: INSERT INTO OKL_SUPP_INVOICE_DTLS_H(
3038: id,
3039: object_version_number,
3040: major_version,
3041: cle_id,

Line 3124: p_major_version IN OKL_SUPP_INVOICE_DTLS_H.MAJOR_VERSION%TYPE)

3120: END create_version;
3121: -----------------------------------------------------------------------------------------------------
3122:
3123: FUNCTION restore_version(p_chr_id IN OKC_K_LINES_B.ID%TYPE,
3124: p_major_version IN OKL_SUPP_INVOICE_DTLS_H.MAJOR_VERSION%TYPE)
3125: RETURN VARCHAR2
3126: IS
3127: l_return_status VARCHAR2(3) := OKC_API.G_RET_STS_SUCCESS;
3128: BEGIN

Line 3192: FROM OKL_SUPP_INVOICE_DTLS_H

3188: creation_date,
3189: last_updated_by,
3190: last_update_date,
3191: last_update_login
3192: FROM OKL_SUPP_INVOICE_DTLS_H
3193: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id)
3194: and major_version = p_major_version;
3195: RETURN l_return_status;
3196: EXCEPTION