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

Line 305: p_shipping_id1 IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE) IS

301: -- Version : 1.0
302: -- End of Commnets
303:
304: PROCEDURE validate_shipping_id1(x_return_status OUT NOCOPY VARCHAR2,
305: p_shipping_id1 IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE) IS
306:
307: ln_dummy number := 0;
308: CURSOR c_shipping_id1_validate(p_shipping_id1 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE) is
309: SELECT 1

Line 308: CURSOR c_shipping_id1_validate(p_shipping_id1 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE) is

304: PROCEDURE validate_shipping_id1(x_return_status OUT NOCOPY VARCHAR2,
305: p_shipping_id1 IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE) IS
306:
307: ln_dummy number := 0;
308: CURSOR c_shipping_id1_validate(p_shipping_id1 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE) is
309: SELECT 1
310: FROM DUAL
311: WHERE EXISTS (SELECT '1'
312: FROM OKX_CUST_SITE_USES_V

Line 381: p_shipping_id1 IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE,

377: -- Version : 1.0
378: -- End of Commnets
379:
380: PROCEDURE validate_shipping_id2(x_return_status OUT NOCOPY VARCHAR2,
381: p_shipping_id1 IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE,
382: p_shipping_id2 IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID2%TYPE) IS
383:
384: ln_dummy number := 0;
385: CURSOR c_shipping_id2_validate(p_shipping_id1 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE,

Line 382: p_shipping_id2 IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID2%TYPE) IS

378: -- End of Commnets
379:
380: PROCEDURE validate_shipping_id2(x_return_status OUT NOCOPY VARCHAR2,
381: p_shipping_id1 IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE,
382: p_shipping_id2 IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID2%TYPE) IS
383:
384: ln_dummy number := 0;
385: CURSOR c_shipping_id2_validate(p_shipping_id1 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE,
386: p_shipping_id2 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID2%TYPE) is

Line 385: CURSOR c_shipping_id2_validate(p_shipping_id1 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE,

381: p_shipping_id1 IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE,
382: p_shipping_id2 IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID2%TYPE) IS
383:
384: ln_dummy number := 0;
385: CURSOR c_shipping_id2_validate(p_shipping_id1 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE,
386: p_shipping_id2 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID2%TYPE) is
387: SELECT 1
388: FROM DUAL
389: WHERE EXISTS (SELECT '1'

Line 386: p_shipping_id2 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID2%TYPE) is

382: p_shipping_id2 IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID2%TYPE) IS
383:
384: ln_dummy number := 0;
385: CURSOR c_shipping_id2_validate(p_shipping_id1 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE,
386: p_shipping_id2 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID2%TYPE) is
387: SELECT 1
388: FROM DUAL
389: WHERE EXISTS (SELECT '1'
390: FROM OKX_CUST_SITE_USES_V

Line 460: p_shipping_code IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_CODE%TYPE) IS

456: -- Version : 1.0
457: -- End of Commnets
458:
459: PROCEDURE validate_shipping_code(x_return_status OUT NOCOPY VARCHAR2,
460: p_shipping_code IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_CODE%TYPE) IS
461:
462: ln_dummy number := 0;
463: CURSOR c_shipping_code_validate(p_shipping_code OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_CODE%TYPE) is
464: SELECT 1

Line 463: CURSOR c_shipping_code_validate(p_shipping_code OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_CODE%TYPE) is

459: PROCEDURE validate_shipping_code(x_return_status OUT NOCOPY VARCHAR2,
460: p_shipping_code IN OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_CODE%TYPE) IS
461:
462: ln_dummy number := 0;
463: CURSOR c_shipping_code_validate(p_shipping_code OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_CODE%TYPE) is
464: SELECT 1
465: FROM DUAL
466: WHERE EXISTS (SELECT '1'
467: FROM JTF_OBJECTS_B

Line 616: -- FUNCTION get_rec for: OKL_SUPP_INVOICE_DTLS_V

612: null;
613: END api_copy;
614:
615: ---------------------------------------------------------------------------
616: -- FUNCTION get_rec for: OKL_SUPP_INVOICE_DTLS_V
617: ---------------------------------------------------------------------------
618: FUNCTION get_rec (p_sidv_rec IN sidv_rec_type,
619: x_no_data_found OUT NOCOPY BOOLEAN)
620: RETURN sidv_rec_type IS

Line 621: CURSOR okl_supp_invoice_dtls_v_pk_csr(p_id IN NUMBER) IS

617: ---------------------------------------------------------------------------
618: FUNCTION get_rec (p_sidv_rec IN sidv_rec_type,
619: x_no_data_found OUT NOCOPY BOOLEAN)
620: RETURN sidv_rec_type IS
621: CURSOR okl_supp_invoice_dtls_v_pk_csr(p_id IN NUMBER) IS
622: SELECT ID,
623: OBJECT_VERSION_NUMBER,
624: CLE_ID,
625: FA_CLE_ID,

Line 653: FROM Okl_Supp_Invoice_Dtls_V

649: CREATION_DATE,
650: LAST_UPDATED_BY,
651: LAST_UPDATE_DATE,
652: LAST_UPDATE_LOGIN
653: FROM Okl_Supp_Invoice_Dtls_V
654: WHERE okl_supp_invoice_dtls_V.id = p_id;
655: l_okl_supp_invoice_dtls_v_pk okl_supp_invoice_dtls_v_pk_csr%ROWTYPE;
656: l_sidv_rec sidv_rec_type;
657: BEGIN

Line 654: WHERE okl_supp_invoice_dtls_V.id = p_id;

650: LAST_UPDATED_BY,
651: LAST_UPDATE_DATE,
652: LAST_UPDATE_LOGIN
653: FROM Okl_Supp_Invoice_Dtls_V
654: WHERE okl_supp_invoice_dtls_V.id = p_id;
655: l_okl_supp_invoice_dtls_v_pk okl_supp_invoice_dtls_v_pk_csr%ROWTYPE;
656: l_sidv_rec sidv_rec_type;
657: BEGIN
658: x_no_data_found := TRUE;

Line 655: l_okl_supp_invoice_dtls_v_pk okl_supp_invoice_dtls_v_pk_csr%ROWTYPE;

651: LAST_UPDATE_DATE,
652: LAST_UPDATE_LOGIN
653: FROM Okl_Supp_Invoice_Dtls_V
654: WHERE okl_supp_invoice_dtls_V.id = p_id;
655: l_okl_supp_invoice_dtls_v_pk okl_supp_invoice_dtls_v_pk_csr%ROWTYPE;
656: l_sidv_rec sidv_rec_type;
657: BEGIN
658: x_no_data_found := TRUE;
659: -- Get current database values

Line 660: OPEN okl_supp_invoice_dtls_v_pk_csr (p_sidv_rec.id);

656: l_sidv_rec sidv_rec_type;
657: BEGIN
658: x_no_data_found := TRUE;
659: -- Get current database values
660: OPEN okl_supp_invoice_dtls_v_pk_csr (p_sidv_rec.id);
661: FETCH okl_supp_invoice_dtls_v_pk_csr INTO
662: l_sidv_rec.id,
663: l_sidv_rec.object_version_number,
664: l_sidv_rec.cle_id,

Line 661: FETCH okl_supp_invoice_dtls_v_pk_csr INTO

657: BEGIN
658: x_no_data_found := TRUE;
659: -- Get current database values
660: OPEN okl_supp_invoice_dtls_v_pk_csr (p_sidv_rec.id);
661: FETCH okl_supp_invoice_dtls_v_pk_csr INTO
662: l_sidv_rec.id,
663: l_sidv_rec.object_version_number,
664: l_sidv_rec.cle_id,
665: l_sidv_rec.fa_cle_id,

Line 693: x_no_data_found := okl_supp_invoice_dtls_v_pk_csr%NOTFOUND;

689: l_sidv_rec.creation_date,
690: l_sidv_rec.last_updated_by,
691: l_sidv_rec.last_update_date,
692: l_sidv_rec.last_update_login;
693: x_no_data_found := okl_supp_invoice_dtls_v_pk_csr%NOTFOUND;
694: CLOSE okl_supp_invoice_dtls_v_pk_csr;
695: RETURN(l_sidv_rec);
696: END get_rec;
697:

Line 694: CLOSE okl_supp_invoice_dtls_v_pk_csr;

690: l_sidv_rec.last_updated_by,
691: l_sidv_rec.last_update_date,
692: l_sidv_rec.last_update_login;
693: x_no_data_found := okl_supp_invoice_dtls_v_pk_csr%NOTFOUND;
694: CLOSE okl_supp_invoice_dtls_v_pk_csr;
695: RETURN(l_sidv_rec);
696: END get_rec;
697:
698: ------------------------------------------------------------------

Line 728: -- FUNCTION get_rec for: OKL_SUPP_INVOICE_DTLS

724: BEGIN
725: RETURN(get_rec(p_sidv_rec, l_row_not_found));
726: END get_rec;
727: ---------------------------------------------------------------------------
728: -- FUNCTION get_rec for: OKL_SUPP_INVOICE_DTLS
729: ---------------------------------------------------------------------------
730: FUNCTION get_rec (
731: p_sid_rec IN sid_rec_type,
732: x_no_data_found OUT NOCOPY BOOLEAN

Line 734: CURSOR okl_supp_invoice_dtls_pk_csr (p_id IN NUMBER) IS

730: FUNCTION get_rec (
731: p_sid_rec IN sid_rec_type,
732: x_no_data_found OUT NOCOPY BOOLEAN
733: ) RETURN sid_rec_type IS
734: CURSOR okl_supp_invoice_dtls_pk_csr (p_id IN NUMBER) IS
735: SELECT
736: ID,
737: OBJECT_VERSION_NUMBER,
738: CLE_ID,

Line 767: FROM Okl_Supp_Invoice_Dtls

763: CREATION_DATE,
764: LAST_UPDATED_BY,
765: LAST_UPDATE_DATE,
766: LAST_UPDATE_LOGIN
767: FROM Okl_Supp_Invoice_Dtls
768: WHERE okl_supp_invoice_dtls.id = p_id;
769: l_okl_supp_invoice_dtls_pk okl_supp_invoice_dtls_pk_csr%ROWTYPE;
770: l_sid_rec sid_rec_type;
771: BEGIN

Line 768: WHERE okl_supp_invoice_dtls.id = p_id;

764: LAST_UPDATED_BY,
765: LAST_UPDATE_DATE,
766: LAST_UPDATE_LOGIN
767: FROM Okl_Supp_Invoice_Dtls
768: WHERE okl_supp_invoice_dtls.id = p_id;
769: l_okl_supp_invoice_dtls_pk okl_supp_invoice_dtls_pk_csr%ROWTYPE;
770: l_sid_rec sid_rec_type;
771: BEGIN
772: x_no_data_found := TRUE;

Line 769: l_okl_supp_invoice_dtls_pk okl_supp_invoice_dtls_pk_csr%ROWTYPE;

765: LAST_UPDATE_DATE,
766: LAST_UPDATE_LOGIN
767: FROM Okl_Supp_Invoice_Dtls
768: WHERE okl_supp_invoice_dtls.id = p_id;
769: l_okl_supp_invoice_dtls_pk okl_supp_invoice_dtls_pk_csr%ROWTYPE;
770: l_sid_rec sid_rec_type;
771: BEGIN
772: x_no_data_found := TRUE;
773: -- Get current database values

Line 774: OPEN okl_supp_invoice_dtls_pk_csr (p_sid_rec.id);

770: l_sid_rec sid_rec_type;
771: BEGIN
772: x_no_data_found := TRUE;
773: -- Get current database values
774: OPEN okl_supp_invoice_dtls_pk_csr (p_sid_rec.id);
775: FETCH okl_supp_invoice_dtls_pk_csr INTO
776: l_sid_rec.id,
777: l_sid_rec.object_version_number,
778: l_sid_rec.cle_id,

Line 775: FETCH okl_supp_invoice_dtls_pk_csr INTO

771: BEGIN
772: x_no_data_found := TRUE;
773: -- Get current database values
774: OPEN okl_supp_invoice_dtls_pk_csr (p_sid_rec.id);
775: FETCH okl_supp_invoice_dtls_pk_csr INTO
776: l_sid_rec.id,
777: l_sid_rec.object_version_number,
778: l_sid_rec.cle_id,
779: l_sid_rec.fa_cle_id,

Line 807: x_no_data_found := okl_supp_invoice_dtls_pk_csr%NOTFOUND;

803: l_sid_rec.creation_date,
804: l_sid_rec.last_updated_by,
805: l_sid_rec.last_update_date,
806: l_sid_rec.last_update_login;
807: x_no_data_found := okl_supp_invoice_dtls_pk_csr%NOTFOUND;
808: CLOSE okl_supp_invoice_dtls_pk_csr;
809: RETURN(l_sid_rec);
810: END get_rec;
811:

Line 808: CLOSE okl_supp_invoice_dtls_pk_csr;

804: l_sid_rec.last_updated_by,
805: l_sid_rec.last_update_date,
806: l_sid_rec.last_update_login;
807: x_no_data_found := okl_supp_invoice_dtls_pk_csr%NOTFOUND;
808: CLOSE okl_supp_invoice_dtls_pk_csr;
809: RETURN(l_sid_rec);
810: END get_rec;
811:
812: ------------------------------------------------------------------

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 955: -- FUNCTION null_out_defaults for: OKL_SUPP_INVOICE_DTLS_V

951: BEGIN
952: RETURN(get_rec(p_sidh_rec, l_row_not_found));
953: END get_rec;
954: ---------------------------------------------------------------------------
955: -- FUNCTION null_out_defaults for: OKL_SUPP_INVOICE_DTLS_V
956: ---------------------------------------------------------------------------
957: FUNCTION null_out_defaults (
958: p_sidv_rec IN sidv_rec_type
959: ) RETURN sidv_rec_type IS

Line 1061: -- Validate_Attributes for:OKL_SUPP_INVOICE_DTLS_V --

1057: ---------------------------------------------------------------------------
1058: -- FUNCTION Validate_Attributes
1059: ---------------------------------------------------------------------------
1060: -----------------------------------------------------
1061: -- Validate_Attributes for:OKL_SUPP_INVOICE_DTLS_V --
1062: -----------------------------------------------------
1063: FUNCTION Validate_Attributes (
1064: p_sidv_rec IN sidv_rec_type
1065: ) RETURN VARCHAR2 IS

Line 1070: OKC_UTIL.ADD_VIEW('OKL_SUPP_INVOICE_DTLS_V', x_return_status);

1066: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1067: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1068: BEGIN
1069: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1070: OKC_UTIL.ADD_VIEW('OKL_SUPP_INVOICE_DTLS_V', x_return_status);
1071: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1072: l_return_status := x_return_status;
1073: RAISE G_EXCEPTION_HALT_VALIDATION;
1074: END IF;

Line 1128: -- Validate Record for:OKL_SUPP_INVOICE_DTLS_V --

1124: ---------------------------------------------------------------------------
1125: -- PROCEDURE Validate_Record
1126: ---------------------------------------------------------------------------
1127: -------------------------------------------------
1128: -- Validate Record for:OKL_SUPP_INVOICE_DTLS_V --
1129: -------------------------------------------------
1130: FUNCTION Validate_Record (p_sidv_rec IN sidv_rec_type)
1131: RETURN VARCHAR2 IS
1132: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1276: -- validate_row for:OKL_SUPP_INVOICE_DTLS_V --

1272: ---------------------------------------------------------------------------
1273: -- PROCEDURE validate_row
1274: ---------------------------------------------------------------------------
1275: ----------------------------------------------
1276: -- validate_row for:OKL_SUPP_INVOICE_DTLS_V --
1277: ----------------------------------------------
1278: PROCEDURE validate_row(
1279: p_api_version IN NUMBER,
1280: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1353: -- PL/SQL TBL validate_row for:OKL_SUPP_INVOICE_DTLS_V --

1349: '_PVT'
1350: );
1351: END validate_row;
1352: ---------------------------------------------------------
1353: -- PL/SQL TBL validate_row for:OKL_SUPP_INVOICE_DTLS_V --
1354: ---------------------------------------------------------
1355: PROCEDURE validate_row(
1356: p_api_version IN NUMBER,
1357: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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 1573: -- insert_row for:OKL_SUPP_INVOICE_DTLS --

1569: ---------------------------------------------------------------------------
1570: -- PROCEDURE insert_row
1571: ---------------------------------------------------------------------------
1572: ------------------------------------------
1573: -- insert_row for:OKL_SUPP_INVOICE_DTLS --
1574: ------------------------------------------
1575: PROCEDURE insert_row(
1576: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1577: x_return_status OUT NOCOPY VARCHAR2,

Line 1589: -- Set_Attributes for:OKL_SUPP_INVOICE_DTLS --

1585: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1586: l_sid_rec sid_rec_type := p_sid_rec;
1587: l_def_sid_rec sid_rec_type;
1588: ----------------------------------------------
1589: -- Set_Attributes for:OKL_SUPP_INVOICE_DTLS --
1590: ----------------------------------------------
1591: FUNCTION Set_Attributes (
1592: p_sid_rec IN sid_rec_type,
1593: x_sid_rec OUT NOCOPY sid_rec_type

Line 1620: INSERT INTO OKL_SUPP_INVOICE_DTLS(

1616: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1617: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1618: RAISE OKL_API.G_EXCEPTION_ERROR;
1619: END IF;
1620: INSERT INTO OKL_SUPP_INVOICE_DTLS(
1621: id,
1622: object_version_number,
1623: cle_id,
1624: fa_cle_id,

Line 1721: -- insert_row for :OKL_SUPP_INVOICE_DTLS_V --

1717: '_PVT'
1718: );
1719: END insert_row;
1720: ---------------------------------------------
1721: -- insert_row for :OKL_SUPP_INVOICE_DTLS_V --
1722: ---------------------------------------------
1723: PROCEDURE insert_row(
1724: p_api_version IN NUMBER,
1725: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1755: -- Set_Attributes for:OKL_SUPP_INVOICE_DTLS_V --

1751: l_sidv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1752: RETURN(l_sidv_rec);
1753: END fill_who_columns;
1754: ------------------------------------------------
1755: -- Set_Attributes for:OKL_SUPP_INVOICE_DTLS_V --
1756: ------------------------------------------------
1757: FUNCTION Set_Attributes (
1758: p_sidv_rec IN sidv_rec_type,
1759: x_sidv_rec OUT NOCOPY sidv_rec_type

Line 1935: -- lock_row for:OKL_SUPP_INVOICE_DTLS --

1931: ---------------------------------------------------------------------------
1932: -- PROCEDURE lock_row
1933: ---------------------------------------------------------------------------
1934: ----------------------------------------
1935: -- lock_row for:OKL_SUPP_INVOICE_DTLS --
1936: ----------------------------------------
1937: PROCEDURE lock_row(
1938: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1939: x_return_status OUT NOCOPY VARCHAR2,

Line 1948: FROM OKL_SUPP_INVOICE_DTLS

1944: E_Resource_Busy EXCEPTION;
1945: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1946: CURSOR lock_csr (p_sid_rec IN sid_rec_type) IS
1947: SELECT OBJECT_VERSION_NUMBER
1948: FROM OKL_SUPP_INVOICE_DTLS
1949: WHERE ID = p_sid_rec.id
1950: AND OBJECT_VERSION_NUMBER = p_sid_rec.object_version_number
1951: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1952:

Line 1955: FROM OKL_SUPP_INVOICE_DTLS

1951: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1952:
1953: CURSOR lchk_csr (p_sid_rec IN sid_rec_type) IS
1954: SELECT OBJECT_VERSION_NUMBER
1955: FROM OKL_SUPP_INVOICE_DTLS
1956: WHERE ID = p_sid_rec.id;
1957: l_api_version CONSTANT NUMBER := 1;
1958: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1959: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1960: l_object_version_number OKL_SUPP_INVOICE_DTLS.OBJECT_VERSION_NUMBER%TYPE;

1956: WHERE ID = p_sid_rec.id;
1957: l_api_version CONSTANT NUMBER := 1;
1958: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1959: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1960: l_object_version_number OKL_SUPP_INVOICE_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1961: lc_object_version_number OKL_SUPP_INVOICE_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1962: l_row_notfound BOOLEAN := FALSE;
1963: lc_row_notfound BOOLEAN := FALSE;
1964: BEGIN

Line 1961: lc_object_version_number OKL_SUPP_INVOICE_DTLS.OBJECT_VERSION_NUMBER%TYPE;

1957: l_api_version CONSTANT NUMBER := 1;
1958: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1959: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1960: l_object_version_number OKL_SUPP_INVOICE_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1961: lc_object_version_number OKL_SUPP_INVOICE_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1962: l_row_notfound BOOLEAN := FALSE;
1963: lc_row_notfound BOOLEAN := FALSE;
1964: BEGIN
1965: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2042: -- lock_row for: OKL_SUPP_INVOICE_DTLS_V --

2038: '_PVT'
2039: );
2040: END lock_row;
2041: -------------------------------------------
2042: -- lock_row for: OKL_SUPP_INVOICE_DTLS_V --
2043: -------------------------------------------
2044: PROCEDURE lock_row(
2045: p_api_version IN NUMBER,
2046: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2191: -- update_row for:OKL_SUPP_INVOICE_DTLS --

2187: ---------------------------------------------------------------------------
2188: -- PROCEDURE update_row
2189: ---------------------------------------------------------------------------
2190: ------------------------------------------
2191: -- update_row for:OKL_SUPP_INVOICE_DTLS --
2192: ------------------------------------------
2193: PROCEDURE update_row(
2194: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2195: x_return_status OUT NOCOPY VARCHAR2,

Line 2356: -- Set_Attributes for:OKL_SUPP_INVOICE_DTLS --

2352: END IF;
2353: RETURN(l_return_status);
2354: END populate_new_record;
2355: ----------------------------------------------
2356: -- Set_Attributes for:OKL_SUPP_INVOICE_DTLS --
2357: ----------------------------------------------
2358: FUNCTION Set_Attributes (
2359: p_sid_rec IN sid_rec_type,
2360: x_sid_rec OUT NOCOPY sid_rec_type

Line 2394: UPDATE OKL_SUPP_INVOICE_DTLS

2390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2391: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2392: RAISE OKL_API.G_EXCEPTION_ERROR;
2393: END IF;
2394: UPDATE OKL_SUPP_INVOICE_DTLS
2395: SET OBJECT_VERSION_NUMBER = l_def_sid_rec.object_version_number,
2396: CLE_ID = l_def_sid_rec.cle_id,
2397: FA_CLE_ID = l_def_sid_rec.fa_cle_id,
2398: INVOICE_NUMBER = l_def_sid_rec.invoice_number,

Line 2462: -- update_row for:OKL_SUPP_INVOICE_DTLS_V --

2458: '_PVT'
2459: );
2460: END update_row;
2461: --------------------------------------------
2462: -- update_row for:OKL_SUPP_INVOICE_DTLS_V --
2463: --------------------------------------------
2464: PROCEDURE update_row(
2465: p_api_version IN NUMBER,
2466: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2638: -- Set_Attributes for:OKL_SUPP_INVOICE_DTLS_V --

2634: END IF;
2635: RETURN(l_return_status);
2636: END populate_new_record;
2637: ------------------------------------------------
2638: -- Set_Attributes for:OKL_SUPP_INVOICE_DTLS_V --
2639: ------------------------------------------------
2640: FUNCTION Set_Attributes (
2641: p_sidv_rec IN sidv_rec_type,
2642: x_sidv_rec OUT NOCOPY sidv_rec_type

Line 2819: -- delete_row for:OKL_SUPP_INVOICE_DTLS --

2815: ---------------------------------------------------------------------------
2816: -- PROCEDURE delete_row
2817: ---------------------------------------------------------------------------
2818: ------------------------------------------
2819: -- delete_row for:OKL_SUPP_INVOICE_DTLS --
2820: ------------------------------------------
2821: PROCEDURE delete_row(
2822: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2823: x_return_status OUT NOCOPY VARCHAR2,

Line 2844: DELETE FROM OKL_SUPP_INVOICE_DTLS

2840: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2841: RAISE OKL_API.G_EXCEPTION_ERROR;
2842: END IF;
2843:
2844: DELETE FROM OKL_SUPP_INVOICE_DTLS
2845: WHERE ID = p_sid_rec.id;
2846:
2847: x_return_status := l_return_status;
2848: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2882: -- delete_row for:OKL_SUPP_INVOICE_DTLS_V --

2878: '_PVT'
2879: );
2880: END delete_row;
2881: --------------------------------------------
2882: -- delete_row for:OKL_SUPP_INVOICE_DTLS_V --
2883: --------------------------------------------
2884: PROCEDURE delete_row(
2885: p_api_version IN NUMBER,
2886: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2964: -- PL/SQL TBL delete_row for:OKL_SUPP_INVOICE_DTLS_V --

2960: '_PVT'
2961: );
2962: END delete_row;
2963: -------------------------------------------------------
2964: -- PL/SQL TBL delete_row for:OKL_SUPP_INVOICE_DTLS_V --
2965: -------------------------------------------------------
2966: PROCEDURE delete_row(
2967: p_api_version IN NUMBER,
2968: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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 3103: FROM OKL_SUPP_INVOICE_DTLS

3099: creation_date,
3100: last_updated_by,
3101: last_update_date,
3102: last_update_login
3103: FROM OKL_SUPP_INVOICE_DTLS
3104: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id);
3105: RETURN l_return_status;
3106: EXCEPTION
3107: -- other appropriate handlers

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 3129: INSERT INTO OKL_SUPP_INVOICE_DTLS(

3125: RETURN VARCHAR2
3126: IS
3127: l_return_status VARCHAR2(3) := OKC_API.G_RET_STS_SUCCESS;
3128: BEGIN
3129: INSERT INTO OKL_SUPP_INVOICE_DTLS(
3130: id,
3131: object_version_number,
3132: cle_id,
3133: fa_cle_id,

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