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_TAA_PVT dependencies on OKL_TAA_REQUEST_DETAILS_B

Line 241: -- FUNCTION get_rec for: OKL_TAA_REQUEST_DETAILS_B

237: BEGIN
238: RETURN(get_rec(p_taav_rec, l_row_not_found));
239: END get_rec;
240: ---------------------------------------------------------------------------
241: -- FUNCTION get_rec for: OKL_TAA_REQUEST_DETAILS_B
242: ---------------------------------------------------------------------------
243: FUNCTION get_rec (
244: p_taa_rec IN taa_rec_type,
245: x_no_data_found OUT NOCOPY BOOLEAN

Line 297: FROM Okl_Taa_Request_Details_B

293: CREATION_DATE,
294: LAST_UPDATED_BY,
295: LAST_UPDATE_DATE,
296: LAST_UPDATE_LOGIN
297: FROM Okl_Taa_Request_Details_B
298: WHERE okl_taa_request_details_b.id = p_id;
299: l_okl_taa_pk okl_taa_pk_csr%ROWTYPE;
300: l_taa_rec taa_rec_type;
301: BEGIN

Line 298: WHERE okl_taa_request_details_b.id = p_id;

294: LAST_UPDATED_BY,
295: LAST_UPDATE_DATE,
296: LAST_UPDATE_LOGIN
297: FROM Okl_Taa_Request_Details_B
298: WHERE okl_taa_request_details_b.id = p_id;
299: l_okl_taa_pk okl_taa_pk_csr%ROWTYPE;
300: l_taa_rec taa_rec_type;
301: BEGIN
302: x_no_data_found := TRUE;

Line 1020: -- insert_row for:OKL_TAA_REQUEST_DETAILS_B --

1016: ---------------------------------------------------------------------------
1017: -- PROCEDURE insert_row
1018: ---------------------------------------------------------------------------
1019: ----------------------------------------------
1020: -- insert_row for:OKL_TAA_REQUEST_DETAILS_B --
1021: ----------------------------------------------
1022: PROCEDURE insert_row(
1023: p_init_msg_list IN VARCHAR2,
1024: x_return_status OUT NOCOPY VARCHAR2,

Line 1036: -- Set_Attributes for:OKL_TAA_REQUEST_DETAILS_B --

1032: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1033: l_taa_rec taa_rec_type := p_taa_rec;
1034: l_def_taa_rec taa_rec_type;
1035: --------------------------------------------------
1036: -- Set_Attributes for:OKL_TAA_REQUEST_DETAILS_B --
1037: --------------------------------------------------
1038: FUNCTION Set_Attributes (
1039: p_taa_rec IN taa_rec_type,
1040: x_taa_rec OUT NOCOPY taa_rec_type

Line 1067: INSERT INTO OKL_TAA_REQUEST_DETAILS_B(

1063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1064: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1065: RAISE OKC_API.G_EXCEPTION_ERROR;
1066: END IF;
1067: INSERT INTO OKL_TAA_REQUEST_DETAILS_B(
1068: id,
1069: tcn_id,
1070: new_contract_number,
1071: bill_to_site_id,

Line 1513: -- lock_row for:OKL_TAA_REQUEST_DETAILS_B --

1509: ---------------------------------------------------------------------------
1510: -- PROCEDURE lock_row
1511: ---------------------------------------------------------------------------
1512: --------------------------------------------
1513: -- lock_row for:OKL_TAA_REQUEST_DETAILS_B --
1514: --------------------------------------------
1515: PROCEDURE lock_row(
1516: p_init_msg_list IN VARCHAR2,
1517: x_return_status OUT NOCOPY VARCHAR2,

Line 1526: FROM OKL_TAA_REQUEST_DETAILS_B

1522: E_Resource_Busy EXCEPTION;
1523: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1524: CURSOR lock_csr (p_taa_rec IN taa_rec_type) IS
1525: SELECT *
1526: FROM OKL_TAA_REQUEST_DETAILS_B
1527: WHERE ID = p_taa_rec.id
1528: FOR UPDATE NOWAIT;
1529:
1530: l_api_version CONSTANT NUMBER := 1;

Line 1849: -- update_row for:OKL_TAA_REQUEST_DETAILS_B --

1845: ---------------------------------------------------------------------------
1846: -- PROCEDURE update_row
1847: ---------------------------------------------------------------------------
1848: ----------------------------------------------
1849: -- update_row for:OKL_TAA_REQUEST_DETAILS_B --
1850: ----------------------------------------------
1851: PROCEDURE update_row(
1852: p_init_msg_list IN VARCHAR2,
1853: x_return_status OUT NOCOPY VARCHAR2,

Line 2076: -- Set_Attributes for:OKL_TAA_REQUEST_DETAILS_B --

2072: END IF;
2073: RETURN(l_return_status);
2074: END populate_new_record;
2075: --------------------------------------------------
2076: -- Set_Attributes for:OKL_TAA_REQUEST_DETAILS_B --
2077: --------------------------------------------------
2078: FUNCTION Set_Attributes (
2079: p_taa_rec IN taa_rec_type,
2080: x_taa_rec OUT NOCOPY taa_rec_type

Line 2113: UPDATE OKL_TAA_REQUEST_DETAILS_B

2109: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2110: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2111: RAISE OKC_API.G_EXCEPTION_ERROR;
2112: END IF;
2113: UPDATE OKL_TAA_REQUEST_DETAILS_B
2114: SET TCN_ID = l_def_taa_rec.tcn_id,
2115: NEW_CONTRACT_NUMBER = l_def_taa_rec.new_contract_number,
2116: BILL_TO_SITE_ID = l_def_taa_rec.bill_to_site_id,
2117: CUST_ACCT_ID = l_def_taa_rec.cust_acct_id,

Line 2737: -- delete_row for:OKL_TAA_REQUEST_DETAILS_B --

2733: ---------------------------------------------------------------------------
2734: -- PROCEDURE delete_row
2735: ---------------------------------------------------------------------------
2736: ----------------------------------------------
2737: -- delete_row for:OKL_TAA_REQUEST_DETAILS_B --
2738: ----------------------------------------------
2739: PROCEDURE delete_row(
2740: p_init_msg_list IN VARCHAR2,
2741: x_return_status OUT NOCOPY VARCHAR2,

Line 2762: DELETE FROM OKL_TAA_REQUEST_DETAILS_B

2758: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2759: RAISE OKC_API.G_EXCEPTION_ERROR;
2760: END IF;
2761:
2762: DELETE FROM OKL_TAA_REQUEST_DETAILS_B
2763: WHERE ID = p_taa_rec.id;
2764:
2765: x_return_status := l_return_status;
2766: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);