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_PTC_PVT dependencies on OKL_PROPERTY_TAX_B

Line 312: -- FUNCTION get_rec for: OKL_PROPERTY_TAX_B

308: BEGIN
309: RETURN(get_rec(p_ptcv_rec, l_row_not_found));
310: END get_rec;
311: ---------------------------------------------------------------------------
312: -- FUNCTION get_rec for: OKL_PROPERTY_TAX_B
313: ---------------------------------------------------------------------------
314: FUNCTION get_rec (
315: p_ptc_rec IN ptc_rec_type,
316: x_no_data_found OUT NOCOPY BOOLEAN

Line 367: FROM OKL_PROPERTY_TAX_B

363: ,TAX_VENDOR_ID
364: ,TAX_VENDOR_NAME
365: ,TAX_VENDOR_SITE_ID
366: ,TAX_VENDOR_SITE_NAME
367: FROM OKL_PROPERTY_TAX_B
368: WHERE okl_property_tax_b.id = p_id;
369: l_okl_ptc_pk okl_ptc_pk_csr%ROWTYPE;
370: l_ptc_rec ptc_rec_type;
371: BEGIN

Line 368: WHERE okl_property_tax_b.id = p_id;

364: ,TAX_VENDOR_NAME
365: ,TAX_VENDOR_SITE_ID
366: ,TAX_VENDOR_SITE_NAME
367: FROM OKL_PROPERTY_TAX_B
368: WHERE okl_property_tax_b.id = p_id;
369: l_okl_ptc_pk okl_ptc_pk_csr%ROWTYPE;
370: l_ptc_rec ptc_rec_type;
371: BEGIN
372: x_no_data_found := TRUE;

Line 1485: -- insert_row for:OKL_PROPERTY_TAX_B --

1481: ---------------------------------------------------------------------------
1482: -- PROCEDURE insert_row
1483: ---------------------------------------------------------------------------
1484: ----------------------------------------------
1485: -- insert_row for:OKL_PROPERTY_TAX_B --
1486: ----------------------------------------------
1487: PROCEDURE insert_row(
1488: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1489: x_return_status OUT NOCOPY VARCHAR2,

Line 1501: -- Set_Attributes for:OKL_PROPERTY_TAX_B --

1497: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1498: l_ptc_rec ptc_rec_type := p_ptc_rec;
1499: l_def_ptc_rec ptc_rec_type;
1500: --------------------------------------------------
1501: -- Set_Attributes for:OKL_PROPERTY_TAX_B --
1502: --------------------------------------------------
1503: FUNCTION Set_Attributes (
1504: p_ptc_rec IN ptc_rec_type,
1505: x_ptc_rec OUT NOCOPY ptc_rec_type

Line 1532: INSERT INTO OKL_PROPERTY_TAX_B(

1528: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1530: RAISE OKC_API.G_EXCEPTION_ERROR;
1531: END IF;
1532: INSERT INTO OKL_PROPERTY_TAX_B(
1533: id,
1534: sequence_number,
1535: asset_id,
1536: asset_number,

Line 2111: -- lock_row for:OKL_PROPERTY_TAX_B --

2107: ---------------------------------------------------------------------------
2108: -- PROCEDURE lock_row
2109: ---------------------------------------------------------------------------
2110: --------------------------------------------
2111: -- lock_row for:OKL_PROPERTY_TAX_B --
2112: --------------------------------------------
2113: PROCEDURE lock_row(
2114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2115: x_return_status OUT NOCOPY VARCHAR2,

Line 2124: FROM OKL_PROPERTY_TAX_B

2120: E_Resource_Busy EXCEPTION;
2121: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2122: CURSOR lock_csr (p_ptc_rec IN ptc_rec_type) IS
2123: SELECT *
2124: FROM OKL_PROPERTY_TAX_B
2125: WHERE ID = p_ptc_rec.id
2126: FOR UPDATE NOWAIT;
2127:
2128: l_api_version CONSTANT NUMBER := 1;

Line 2703: -- update_row for:OKL_PROPERTY_TAX_B --

2699: ---------------------------------------------------------------------------
2700: -- PROCEDURE update_row
2701: ---------------------------------------------------------------------------
2702: ----------------------------------------------
2703: -- update_row for:OKL_PROPERTY_TAX_B --
2704: ----------------------------------------------
2705: PROCEDURE update_row(
2706: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2707: x_return_status OUT NOCOPY VARCHAR2,

Line 2936: -- Set_Attributes for:OKL_PROPERTY_TAX_B --

2932: END IF;
2933: RETURN(l_return_status);
2934: END populate_new_record;
2935: --------------------------------------------------
2936: -- Set_Attributes for:OKL_PROPERTY_TAX_B --
2937: --------------------------------------------------
2938: FUNCTION Set_Attributes (
2939: p_ptc_rec IN ptc_rec_type,
2940: x_ptc_rec OUT NOCOPY ptc_rec_type

Line 2973: UPDATE OKL_PROPERTY_TAX_B

2969: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2970: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2971: RAISE OKC_API.G_EXCEPTION_ERROR;
2972: END IF;
2973: UPDATE OKL_PROPERTY_TAX_B
2974: SET SEQUENCE_NUMBER = l_def_ptc_rec.sequence_number,
2975: ASSET_ID = l_def_ptc_rec.asset_id,
2976: ASSET_NUMBER = l_def_ptc_rec.asset_number,
2977: KHR_ID = l_def_ptc_rec.khr_id,

Line 3802: -- delete_row for:OKL_PROPERTY_TAX_B --

3798: ---------------------------------------------------------------------------
3799: -- PROCEDURE delete_row
3800: ---------------------------------------------------------------------------
3801: ----------------------------------------------
3802: -- delete_row for:OKL_PROPERTY_TAX_B --
3803: ----------------------------------------------
3804: PROCEDURE delete_row(
3805: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3806: x_return_status OUT NOCOPY VARCHAR2,

Line 3827: DELETE FROM OKL_PROPERTY_TAX_B

3823: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3824: RAISE OKC_API.G_EXCEPTION_ERROR;
3825: END IF;
3826:
3827: DELETE FROM OKL_PROPERTY_TAX_B
3828: WHERE ID = p_ptc_rec.id;
3829:
3830: x_return_status := l_return_status;
3831: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);