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_V

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 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 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 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 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 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,