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_ADJ_PVT dependencies on OKL_TRX_AR_ADJSTS_B

Line 130: -- FUNCTION get_rec for: OKL_TRX_AR_ADJSTS_B

126:
127: END add_language;
128:
129: ---------------------------------------------------------------------------
130: -- FUNCTION get_rec for: OKL_TRX_AR_ADJSTS_B
131: ---------------------------------------------------------------------------
132: FUNCTION get_rec (
133: p_adj_rec IN adj_rec_type,
134: x_no_data_found OUT NOCOPY BOOLEAN

Line 176: FROM Okl_Trx_Ar_Adjsts_B

172: TRX_STATUS_CODE,
173: --gkhuntet start 02-Nov-07
174: TRANSACTION_DATE
175: --gkhuntet end 02-Nov-07
176: FROM Okl_Trx_Ar_Adjsts_B
177: WHERE okl_trx_ar_adjsts_b.id = p_id;
178: l_okl_trx_ar_adjsts_pk okl_trx_ar_adjsts_pk_csr%ROWTYPE;
179: l_adj_rec adj_rec_type;
180: BEGIN

Line 177: WHERE okl_trx_ar_adjsts_b.id = p_id;

173: --gkhuntet start 02-Nov-07
174: TRANSACTION_DATE
175: --gkhuntet end 02-Nov-07
176: FROM Okl_Trx_Ar_Adjsts_B
177: WHERE okl_trx_ar_adjsts_b.id = p_id;
178: l_okl_trx_ar_adjsts_pk okl_trx_ar_adjsts_pk_csr%ROWTYPE;
179: l_adj_rec adj_rec_type;
180: BEGIN
181: x_no_data_found := TRUE;

Line 1472: -- insert_row for:OKL_TRX_AR_ADJSTS_B --

1468: ---------------------------------------------------------------------------
1469: -- PROCEDURE insert_row
1470: ---------------------------------------------------------------------------
1471: ----------------------------------------
1472: -- insert_row for:OKL_TRX_AR_ADJSTS_B --
1473: ----------------------------------------
1474: PROCEDURE insert_row(
1475: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1476: x_return_status OUT NOCOPY VARCHAR2,

Line 1488: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_B --

1484: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1485: l_adj_rec adj_rec_type := p_adj_rec;
1486: l_def_adj_rec adj_rec_type;
1487: --------------------------------------------
1488: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_B --
1489: --------------------------------------------
1490: FUNCTION Set_Attributes (
1491: p_adj_rec IN adj_rec_type,
1492: x_adj_rec OUT NOCOPY adj_rec_type

Line 1530: INSERT INTO OKL_TRX_AR_ADJSTS_B(

1526: l_adj_rec.TRANSACTION_DATE := SYSDATE;
1527: END IF;
1528: --gkhuntet end 02-Nov-07
1529:
1530: INSERT INTO OKL_TRX_AR_ADJSTS_B(
1531: id,
1532: ccw_id,
1533: tcn_id,
1534: try_id,

Line 2028: -- lock_row for:OKL_TRX_AR_ADJSTS_B --

2024: ---------------------------------------------------------------------------
2025: -- PROCEDURE lock_row
2026: ---------------------------------------------------------------------------
2027: --------------------------------------
2028: -- lock_row for:OKL_TRX_AR_ADJSTS_B --
2029: --------------------------------------
2030: PROCEDURE lock_row(
2031: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2032: x_return_status OUT NOCOPY VARCHAR2,

Line 2041: FROM OKL_TRX_AR_ADJSTS_B

2037: E_Resource_Busy EXCEPTION;
2038: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2039: CURSOR lock_csr (p_adj_rec IN adj_rec_type) IS
2040: SELECT OBJECT_VERSION_NUMBER
2041: FROM OKL_TRX_AR_ADJSTS_B
2042: WHERE ID = p_adj_rec.id
2043: AND OBJECT_VERSION_NUMBER = p_adj_rec.object_version_number
2044: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2045:

Line 2048: FROM OKL_TRX_AR_ADJSTS_B

2044: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2045:
2046: CURSOR lchk_csr (p_adj_rec IN adj_rec_type) IS
2047: SELECT OBJECT_VERSION_NUMBER
2048: FROM OKL_TRX_AR_ADJSTS_B
2049: WHERE ID = p_adj_rec.id;
2050: l_api_version CONSTANT NUMBER := 1;
2051: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2052: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2053: l_object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE;

2049: WHERE ID = p_adj_rec.id;
2050: l_api_version CONSTANT NUMBER := 1;
2051: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2052: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2053: l_object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE;
2054: lc_object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE;
2055: l_row_notfound BOOLEAN := FALSE;
2056: lc_row_notfound BOOLEAN := FALSE;
2057: BEGIN

Line 2054: lc_object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE;

2050: l_api_version CONSTANT NUMBER := 1;
2051: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2052: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2053: l_object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE;
2054: lc_object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE;
2055: l_row_notfound BOOLEAN := FALSE;
2056: lc_row_notfound BOOLEAN := FALSE;
2057: BEGIN
2058: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2398: -- update_row for:OKL_TRX_AR_ADJSTS_B --

2394: ---------------------------------------------------------------------------
2395: -- PROCEDURE update_row
2396: ---------------------------------------------------------------------------
2397: ----------------------------------------
2398: -- update_row for:OKL_TRX_AR_ADJSTS_B --
2399: ----------------------------------------
2400: PROCEDURE update_row(
2401: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2402: x_return_status OUT NOCOPY VARCHAR2,

Line 2579: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_B --

2575: --gkhuntet end 02-Nov-07
2576: RETURN(l_return_status);
2577: END populate_new_record;
2578: --------------------------------------------
2579: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_B --
2580: --------------------------------------------
2581: FUNCTION Set_Attributes (
2582: p_adj_rec IN adj_rec_type,
2583: x_adj_rec OUT NOCOPY adj_rec_type

Line 2617: UPDATE OKL_TRX_AR_ADJSTS_B

2613: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2614: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2615: RAISE OKL_API.G_EXCEPTION_ERROR;
2616: END IF;
2617: UPDATE OKL_TRX_AR_ADJSTS_B
2618: SET CCW_ID = l_def_adj_rec.ccw_id,
2619: TCN_ID = l_def_adj_rec.tcn_id,
2620: TRY_ID = l_def_adj_rec.try_id,
2621: ADJUSTMENT_REASON_CODE = l_def_adj_rec.adjustment_reason_code,

Line 3313: -- delete_row for:OKL_TRX_AR_ADJSTS_B --

3309: ---------------------------------------------------------------------------
3310: -- PROCEDURE delete_row
3311: ---------------------------------------------------------------------------
3312: ----------------------------------------
3313: -- delete_row for:OKL_TRX_AR_ADJSTS_B --
3314: ----------------------------------------
3315: PROCEDURE delete_row(
3316: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3317: x_return_status OUT NOCOPY VARCHAR2,

Line 3337: DELETE FROM OKL_TRX_AR_ADJSTS_B

3333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3334: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3335: RAISE OKL_API.G_EXCEPTION_ERROR;
3336: END IF;
3337: DELETE FROM OKL_TRX_AR_ADJSTS_B
3338: WHERE ID = l_adj_rec.id;
3339:
3340: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3341: EXCEPTION