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_TAB_PVT dependencies on OKL_TRNS_ACC_DSTRS

Line 12: SELECT OKL_TRNS_ACC_DSTRS_ALL_S.NEXTVAL INTO l_seq FROM DUAL;

8: FUNCTION get_seq_id RETURN NUMBER IS
9: l_seq NUMBER;
10: BEGIN
11: -- Changed sequence name by nikshah for SLA project (Bug 5707866) 16-Apr-2007
12: SELECT OKL_TRNS_ACC_DSTRS_ALL_S.NEXTVAL INTO l_seq FROM DUAL;
13: RETURN l_seq;
14: END get_seq_id;
15:
16: ---------------------------------------------------------------------------

Line 41: -- FUNCTION get_rec for: OKL_TRNS_ACC_DSTRS

37: NULL;
38: END api_copy;
39:
40: ---------------------------------------------------------------------------
41: -- FUNCTION get_rec for: OKL_TRNS_ACC_DSTRS
42: ---------------------------------------------------------------------------
43: FUNCTION get_rec (
44: p_tab_rec IN tab_rec_type,
45: x_no_data_found OUT NOCOPY BOOLEAN

Line 109: FROM Okl_Trns_Acc_Dstrs

105: ACCOUNTING_TEMPLATE_NAME,
106: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
107: UPGRADE_STATUS_FLAG
108: -- Changes End
109: FROM Okl_Trns_Acc_Dstrs
110: WHERE okl_trns_acc_dstrs.id = p_id;
111: l_tab_pk tab_pk_csr%ROWTYPE;
112: l_tab_rec tab_rec_type;
113: BEGIN

Line 110: WHERE okl_trns_acc_dstrs.id = p_id;

106: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
107: UPGRADE_STATUS_FLAG
108: -- Changes End
109: FROM Okl_Trns_Acc_Dstrs
110: WHERE okl_trns_acc_dstrs.id = p_id;
111: l_tab_pk tab_pk_csr%ROWTYPE;
112: l_tab_rec tab_rec_type;
113: BEGIN
114: x_no_data_found := TRUE;

Line 193: -- FUNCTION get_rec for: OKL_TRNS_ACC_DSTRS_V

189: BEGIN
190: RETURN(get_rec(p_tab_rec, l_row_notfound));
191: END get_rec;
192: ---------------------------------------------------------------------------
193: -- FUNCTION get_rec for: OKL_TRNS_ACC_DSTRS_V
194: ---------------------------------------------------------------------------
195: FUNCTION get_rec (
196: p_tabv_rec IN tabv_rec_type,
197: x_no_data_found OUT NOCOPY BOOLEAN

Line 262: FROM OKL_TRNS_ACC_DSTRS

258: -- Added by zrehman for SLA project (Bug 5707866) 9-Feb-2007
259: ACCOUNTING_TEMPLATE_NAME,
260: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
261: UPGRADE_STATUS_FLAG
262: FROM OKL_TRNS_ACC_DSTRS
263: WHERE OKL_TRNS_ACC_DSTRS.id = p_id;
264: l_tabv_pk tabv_pk_csr%ROWTYPE;
265: BEGIN
266: x_no_data_found := TRUE;

Line 263: WHERE OKL_TRNS_ACC_DSTRS.id = p_id;

259: ACCOUNTING_TEMPLATE_NAME,
260: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
261: UPGRADE_STATUS_FLAG
262: FROM OKL_TRNS_ACC_DSTRS
263: WHERE OKL_TRNS_ACC_DSTRS.id = p_id;
264: l_tabv_pk tabv_pk_csr%ROWTYPE;
265: BEGIN
266: x_no_data_found := TRUE;
267: -- Get current database values

Line 344: -- FUNCTION null_out_defaults for: OKL_TRNS_ACC_DSTRS_V --

340: RETURN(get_rec(p_tabv_rec, l_row_notfound));
341: END get_rec;
342:
343: ----------------------------------------------------------
344: -- FUNCTION null_out_defaults for: OKL_TRNS_ACC_DSTRS_V --
345: ----------------------------------------------------------
346: FUNCTION null_out_defaults (
347: p_tabv_rec IN tabv_rec_type
348: ) RETURN tabv_rec_type IS

Line 546: -- Validate_Attributes for:OKL_TRNS_ACC_DSTRS_V --

542: ---------------------------------------------------------------------------
543: -- PROCEDURE Validate_Attributes
544: ---------------------------------------------------------------------------
545: --------------------------------------------------
546: -- Validate_Attributes for:OKL_TRNS_ACC_DSTRS_V --
547: --------------------------------------------------
548: FUNCTION Validate_Attributes (
549: p_tabv_rec IN tabv_rec_type
550: ) RETURN VARCHAR2 IS

Line 1751: -- Validate_Record for:OKL_TRNS_ACC_DSTRS_V --

1747: ---------------------------------------------------------------------------
1748: -- PROCEDURE Validate_Record
1749: ---------------------------------------------------------------------------
1750: ----------------------------------------------
1751: -- Validate_Record for:OKL_TRNS_ACC_DSTRS_V --
1752: ----------------------------------------------
1753: FUNCTION Validate_Record (
1754: p_tabv_rec IN tabv_rec_type
1755: ) RETURN VARCHAR2 IS

Line 1904: -- validate_row for:OKL_TRNS_ACC_DSTRS_V --

1900: ---------------------------------------------------------------------------
1901: -- PROCEDURE validate_row
1902: ---------------------------------------------------------------------------
1903: -------------------------------------------
1904: -- validate_row for:OKL_TRNS_ACC_DSTRS_V --
1905: -------------------------------------------
1906: PROCEDURE validate_row(
1907: p_api_version IN NUMBER,
1908: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2057: -- insert_row for:OKL_TRNS_ACC_DSTRS --

2053: ---------------------------------------------------------------------------
2054: -- PROCEDURE insert_row
2055: ---------------------------------------------------------------------------
2056: ---------------------------------------
2057: -- insert_row for:OKL_TRNS_ACC_DSTRS --
2058: ---------------------------------------
2059: PROCEDURE insert_row(
2060: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2061: x_return_status OUT NOCOPY VARCHAR2,

Line 2073: -- Set_Attributes for:OKL_TRNS_ACC_DSTRS --

2069: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2070: l_tab_rec tab_rec_type := p_tab_rec;
2071: l_def_tab_rec tab_rec_type;
2072: -------------------------------------------
2073: -- Set_Attributes for:OKL_TRNS_ACC_DSTRS --
2074: -------------------------------------------
2075: FUNCTION Set_Attributes (
2076: p_tab_rec IN tab_rec_type,
2077: x_tab_rec OUT NOCOPY tab_rec_type

Line 2104: INSERT INTO OKL_TRNS_ACC_DSTRS(

2100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2101: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2102: RAISE OKC_API.G_EXCEPTION_ERROR;
2103: END IF;
2104: INSERT INTO OKL_TRNS_ACC_DSTRS(
2105: id,
2106: currency_conversion_type,
2107: set_of_books_id,
2108: cr_dr_flag,

Line 2266: -- insert_row for:OKL_TRNS_ACC_DSTRS_V --

2262: '_PVT'
2263: );
2264: END insert_row;
2265: -----------------------------------------
2266: -- insert_row for:OKL_TRNS_ACC_DSTRS_V --
2267: -----------------------------------------
2268: PROCEDURE insert_row(
2269: p_api_version IN NUMBER,
2270: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2300: -- Set_Attributes for:OKL_TRNS_ACC_DSTRS_V --

2296: l_tabv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2297: RETURN(l_tabv_rec);
2298: END fill_who_columns;
2299: ---------------------------------------------
2300: -- Set_Attributes for:OKL_TRNS_ACC_DSTRS_V --
2301: ---------------------------------------------
2302: FUNCTION Set_Attributes (
2303: p_tabv_rec IN tabv_rec_type,
2304: x_tabv_rec OUT NOCOPY tabv_rec_type

Line 2531: -- lock_row for:OKL_TRNS_ACC_DSTRS --

2527: ---------------------------------------------------------------------------
2528: -- PROCEDURE lock_row
2529: ---------------------------------------------------------------------------
2530: -------------------------------------
2531: -- lock_row for:OKL_TRNS_ACC_DSTRS --
2532: -------------------------------------
2533: PROCEDURE lock_row(
2534: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2535: x_return_status OUT NOCOPY VARCHAR2,

Line 2544: FROM OKL_TRNS_ACC_DSTRS

2540: E_Resource_Busy EXCEPTION;
2541: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2542: CURSOR lock_csr (p_tab_rec IN tab_rec_type) IS
2543: SELECT OBJECT_VERSION_NUMBER
2544: FROM OKL_TRNS_ACC_DSTRS
2545: WHERE ID = p_tab_rec.id
2546: AND OBJECT_VERSION_NUMBER = p_tab_rec.object_version_number
2547: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2548:

Line 2551: FROM OKL_TRNS_ACC_DSTRS

2547: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2548:
2549: CURSOR lchk_csr (p_tab_rec IN tab_rec_type) IS
2550: SELECT OBJECT_VERSION_NUMBER
2551: FROM OKL_TRNS_ACC_DSTRS
2552: WHERE ID = p_tab_rec.id;
2553: l_api_version CONSTANT NUMBER := 1;
2554: l_api_name CONSTANT VARCHAR2(30) := 'DSTRS_lock_row';
2555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2556: l_object_version_number OKL_TRNS_ACC_DSTRS.OBJECT_VERSION_NUMBER%TYPE;

2552: WHERE ID = p_tab_rec.id;
2553: l_api_version CONSTANT NUMBER := 1;
2554: l_api_name CONSTANT VARCHAR2(30) := 'DSTRS_lock_row';
2555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2556: l_object_version_number OKL_TRNS_ACC_DSTRS.OBJECT_VERSION_NUMBER%TYPE;
2557: lc_object_version_number OKL_TRNS_ACC_DSTRS.OBJECT_VERSION_NUMBER%TYPE;
2558: l_row_notfound BOOLEAN := FALSE;
2559: lc_row_notfound BOOLEAN := FALSE;
2560: BEGIN

Line 2557: lc_object_version_number OKL_TRNS_ACC_DSTRS.OBJECT_VERSION_NUMBER%TYPE;

2553: l_api_version CONSTANT NUMBER := 1;
2554: l_api_name CONSTANT VARCHAR2(30) := 'DSTRS_lock_row';
2555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2556: l_object_version_number OKL_TRNS_ACC_DSTRS.OBJECT_VERSION_NUMBER%TYPE;
2557: lc_object_version_number OKL_TRNS_ACC_DSTRS.OBJECT_VERSION_NUMBER%TYPE;
2558: l_row_notfound BOOLEAN := FALSE;
2559: lc_row_notfound BOOLEAN := FALSE;
2560: BEGIN
2561: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2637: -- lock_row for:OKL_TRNS_ACC_DSTRS_V --

2633: '_PVT'
2634: );
2635: END lock_row;
2636: ---------------------------------------
2637: -- lock_row for:OKL_TRNS_ACC_DSTRS_V --
2638: ---------------------------------------
2639: PROCEDURE lock_row(
2640: p_api_version IN NUMBER,
2641: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2792: -- update_row for:OKL_TRNS_ACC_DSTRS --

2788: ---------------------------------------------------------------------------
2789: -- PROCEDURE update_row
2790: ---------------------------------------------------------------------------
2791: ---------------------------------------
2792: -- update_row for:OKL_TRNS_ACC_DSTRS --
2793: ---------------------------------------
2794: PROCEDURE update_row(
2795: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2796: x_return_status OUT NOCOPY VARCHAR2,

Line 3066: -- Set_Attributes for:OKL_TRNS_ACC_DSTRS --

3062: END IF;
3063: RETURN(l_return_status);
3064: END populate_new_record;
3065: -------------------------------------------
3066: -- Set_Attributes for:OKL_TRNS_ACC_DSTRS --
3067: -------------------------------------------
3068: FUNCTION Set_Attributes (
3069: p_tab_rec IN tab_rec_type,
3070: x_tab_rec OUT NOCOPY tab_rec_type

Line 3103: UPDATE OKL_TRNS_ACC_DSTRS

3099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3100: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3101: RAISE OKC_API.G_EXCEPTION_ERROR;
3102: END IF;
3103: UPDATE OKL_TRNS_ACC_DSTRS
3104: SET CURRENCY_CONVERSION_TYPE = l_def_tab_rec.currency_conversion_type,
3105: SET_OF_BOOKS_ID = l_def_tab_rec.set_of_books_id,
3106: CR_DR_FLAG = l_def_tab_rec.cr_dr_flag,
3107: CODE_COMBINATION_ID = l_def_tab_rec.code_combination_id,

Line 3201: -- update_row for:OKL_TRNS_ACC_DSTRS_V --

3197: '_PVT'
3198: );
3199: END update_row;
3200: -----------------------------------------
3201: -- update_row for:OKL_TRNS_ACC_DSTRS_V --
3202: -----------------------------------------
3203: PROCEDURE update_row(
3204: p_api_version IN NUMBER,
3205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3490: -- Set_Attributes for:OKL_TRNS_ACC_DSTRS_V --

3486: END IF;
3487: RETURN(l_return_status);
3488: END populate_new_record;
3489: ---------------------------------------------
3490: -- Set_Attributes for:OKL_TRNS_ACC_DSTRS_V --
3491: ---------------------------------------------
3492: FUNCTION Set_Attributes (
3493: p_tabv_rec IN tabv_rec_type,
3494: x_tabv_rec OUT NOCOPY tabv_rec_type

Line 3704: -- delete_row for:OKL_TRNS_ACC_DSTRS --

3700: ---------------------------------------------------------------------------
3701: -- PROCEDURE delete_row
3702: ---------------------------------------------------------------------------
3703: ---------------------------------------
3704: -- delete_row for:OKL_TRNS_ACC_DSTRS --
3705: ---------------------------------------
3706: PROCEDURE delete_row(
3707: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3708: x_return_status OUT NOCOPY VARCHAR2,

Line 3728: DELETE FROM OKL_TRNS_ACC_DSTRS

3724: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3725: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3726: RAISE OKC_API.G_EXCEPTION_ERROR;
3727: END IF;
3728: DELETE FROM OKL_TRNS_ACC_DSTRS
3729: WHERE ID = l_tab_rec.id;
3730:
3731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3732: EXCEPTION

Line 3765: -- delete_row for:OKL_TRNS_ACC_DSTRS_V --

3761: '_PVT'
3762: );
3763: END delete_row;
3764: -----------------------------------------
3765: -- delete_row for:OKL_TRNS_ACC_DSTRS_V --
3766: -----------------------------------------
3767: PROCEDURE delete_row(
3768: p_api_version IN NUMBER,
3769: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,