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_TAI_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 705: FROM OKL_TRX_AR_INVOICES_B

701: l_dummy_var VARCHAR2(1) := '0';
702:
703: CURSOR l_tai_id_reverses_csr IS
704: SELECT '1'
705: FROM OKL_TRX_AR_INVOICES_B
706: WHERE id = p_taiv_rec.tai_id_reverses;
707:
708: BEGIN
709: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1063: FROM OKL_TRX_AR_INVOICES_B B

1059: BEGIN
1060: DELETE FROM OKL_TRX_AR_INVOICES_TL T
1061: WHERE NOT EXISTS (
1062: SELECT NULL
1063: FROM OKL_TRX_AR_INVOICES_B B
1064: WHERE B.ID = T.ID
1065: AND T.LANGUAGE = USERENV('LANG')
1066: );
1067:

Line 1123: -- FUNCTION get_rec for: OKL_TRX_AR_INVOICES_B

1119:
1120: END add_language;
1121:
1122: ---------------------------------------------------------------------------
1123: -- FUNCTION get_rec for: OKL_TRX_AR_INVOICES_B
1124: ---------------------------------------------------------------------------
1125: FUNCTION get_rec (
1126: p_tai_rec IN tai_rec_type,
1127: x_no_data_found OUT NOCOPY BOOLEAN

Line 1211: FROM Okl_Trx_Ar_Invoices_B

1207: --gkhuntet start 02-Nov-07
1208: TRANSACTION_DATE
1209: --gkhuntet end 02-Nov-07
1210:
1211: FROM Okl_Trx_Ar_Invoices_B
1212: WHERE okl_trx_ar_invoices_b.id = p_id;
1213: l_tai_pk tai_pk_csr%ROWTYPE;
1214: l_tai_rec tai_rec_type;
1215: BEGIN

Line 1212: WHERE okl_trx_ar_invoices_b.id = p_id;

1208: TRANSACTION_DATE
1209: --gkhuntet end 02-Nov-07
1210:
1211: FROM Okl_Trx_Ar_Invoices_B
1212: WHERE okl_trx_ar_invoices_b.id = p_id;
1213: l_tai_pk tai_pk_csr%ROWTYPE;
1214: l_tai_rec tai_rec_type;
1215: BEGIN
1216: x_no_data_found := TRUE;

Line 1849: FROM OKL_TRX_AR_INVOICES_B INV

1845: l_rec_exist VARCHAR2(1) DEFAULT '0';
1846:
1847: CURSOR l_trx_number_uniq_csr(p_trx_number varchar2) is
1848: SELECT '1'
1849: FROM OKL_TRX_AR_INVOICES_B INV
1850: WHERE ID <> p_rec_id
1851: AND TRX_NUMBER IS NOT NULL
1852: AND TRX_NUMBER = p_trx_number;
1853:

Line 2598: -- insert_row for:OKL_TRX_AR_INVOICES_B --

2594: ---------------------------------------------------------------------------
2595: -- PROCEDURE insert_row
2596: ---------------------------------------------------------------------------
2597: ------------------------------------------
2598: -- insert_row for:OKL_TRX_AR_INVOICES_B --
2599: ------------------------------------------
2600: PROCEDURE insert_row(
2601: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2602: x_return_status OUT NOCOPY VARCHAR2,

Line 2614: -- Set_Attributes for:OKL_TRX_AR_INVOICES_B --

2610: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2611: l_tai_rec tai_rec_type := p_tai_rec;
2612: l_def_tai_rec tai_rec_type;
2613: ----------------------------------------------
2614: -- Set_Attributes for:OKL_TRX_AR_INVOICES_B --
2615: ----------------------------------------------
2616: FUNCTION Set_Attributes (
2617: p_tai_rec IN tai_rec_type,
2618: x_tai_rec OUT NOCOPY tai_rec_type

Line 2654: INSERT INTO OKL_TRX_AR_INVOICES_B(

2650: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2651: RAISE Okl_Api.G_EXCEPTION_ERROR;
2652: END IF;
2653:
2654: INSERT INTO OKL_TRX_AR_INVOICES_B(
2655: id,
2656: currency_code,
2657: --Start change by pgomes on 15-NOV-2002
2658: currency_conversion_type,

Line 3284: -- lock_row for:OKL_TRX_AR_INVOICES_B --

3280: ---------------------------------------------------------------------------
3281: -- PROCEDURE lock_row
3282: ---------------------------------------------------------------------------
3283: ----------------------------------------
3284: -- lock_row for:OKL_TRX_AR_INVOICES_B --
3285: ----------------------------------------
3286: PROCEDURE lock_row(
3287: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
3288: x_return_status OUT NOCOPY VARCHAR2,

Line 3297: FROM OKL_TRX_AR_INVOICES_B

3293: E_Resource_Busy EXCEPTION;
3294: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3295: CURSOR lock_csr (p_tai_rec IN tai_rec_type) IS
3296: SELECT OBJECT_VERSION_NUMBER
3297: FROM OKL_TRX_AR_INVOICES_B
3298: WHERE ID = p_tai_rec.id
3299: AND OBJECT_VERSION_NUMBER = p_tai_rec.object_version_number
3300: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3301:

Line 3304: FROM OKL_TRX_AR_INVOICES_B

3300: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3301:
3302: CURSOR lchk_csr (p_tai_rec IN tai_rec_type) IS
3303: SELECT OBJECT_VERSION_NUMBER
3304: FROM OKL_TRX_AR_INVOICES_B
3305: WHERE ID = p_tai_rec.id;
3306: l_api_version CONSTANT NUMBER := 1;
3307: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3308: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 3309: l_object_version_number OKL_TRX_AR_INVOICES_B.OBJECT_VERSION_NUMBER%TYPE;

3305: WHERE ID = p_tai_rec.id;
3306: l_api_version CONSTANT NUMBER := 1;
3307: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3308: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3309: l_object_version_number OKL_TRX_AR_INVOICES_B.OBJECT_VERSION_NUMBER%TYPE;
3310: lc_object_version_number OKL_TRX_AR_INVOICES_B.OBJECT_VERSION_NUMBER%TYPE;
3311: l_row_notfound BOOLEAN := FALSE;
3312: lc_row_notfound BOOLEAN := FALSE;
3313: BEGIN

Line 3310: lc_object_version_number OKL_TRX_AR_INVOICES_B.OBJECT_VERSION_NUMBER%TYPE;

3306: l_api_version CONSTANT NUMBER := 1;
3307: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3308: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3309: l_object_version_number OKL_TRX_AR_INVOICES_B.OBJECT_VERSION_NUMBER%TYPE;
3310: lc_object_version_number OKL_TRX_AR_INVOICES_B.OBJECT_VERSION_NUMBER%TYPE;
3311: l_row_notfound BOOLEAN := FALSE;
3312: lc_row_notfound BOOLEAN := FALSE;
3313: BEGIN
3314: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 3655: -- update_row for:OKL_TRX_AR_INVOICES_B --

3651: ---------------------------------------------------------------------------
3652: -- PROCEDURE update_row
3653: ---------------------------------------------------------------------------
3654: ------------------------------------------
3655: -- update_row for:OKL_TRX_AR_INVOICES_B --
3656: ------------------------------------------
3657: PROCEDURE update_row(
3658: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
3659: x_return_status OUT NOCOPY VARCHAR2,

Line 3671: l_legal_entity_id OKL_TRX_AR_INVOICES_B.LEGAL_ENTITY_ID%TYPE; -- for LE Uptake project 08-11-2006

3667: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3668: l_tai_rec tai_rec_type := p_tai_rec;
3669: l_def_tai_rec tai_rec_type;
3670: l_row_notfound BOOLEAN := TRUE;
3671: l_legal_entity_id OKL_TRX_AR_INVOICES_B.LEGAL_ENTITY_ID%TYPE; -- for LE Uptake project 08-11-2006
3672: ----------------------------------
3673: -- FUNCTION populate_new_record --
3674: ----------------------------------
3675: FUNCTION populate_new_record (

Line 4019: -- Set_Attributes for:OKL_TRX_AR_INVOICES_B --

4015:
4016: RETURN(l_return_status);
4017: END populate_new_record;
4018: ----------------------------------------------
4019: -- Set_Attributes for:OKL_TRX_AR_INVOICES_B --
4020: ----------------------------------------------
4021: FUNCTION Set_Attributes (
4022: p_tai_rec IN tai_rec_type,
4023: x_tai_rec OUT NOCOPY tai_rec_type

Line 4057: UPDATE OKL_TRX_AR_INVOICES_B

4053: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4054: RAISE Okl_Api.G_EXCEPTION_ERROR;
4055: END IF;
4056:
4057: UPDATE OKL_TRX_AR_INVOICES_B
4058: SET CURRENCY_CODE = l_def_tai_rec.currency_code,
4059: --Start change by pgomes on 15-NOV-2002
4060: currency_conversion_type = l_def_tai_rec.currency_conversion_type,
4061: currency_conversion_rate = l_def_tai_rec.currency_conversion_rate,

Line 4959: -- delete_row for:OKL_TRX_AR_INVOICES_B --

4955: ---------------------------------------------------------------------------
4956: -- PROCEDURE delete_row
4957: ---------------------------------------------------------------------------
4958: ------------------------------------------
4959: -- delete_row for:OKL_TRX_AR_INVOICES_B --
4960: ------------------------------------------
4961: PROCEDURE delete_row(
4962: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
4963: x_return_status OUT NOCOPY VARCHAR2,

Line 4983: DELETE FROM OKL_TRX_AR_INVOICES_B

4979: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4980: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4981: RAISE Okl_Api.G_EXCEPTION_ERROR;
4982: END IF;
4983: DELETE FROM OKL_TRX_AR_INVOICES_B
4984: WHERE ID = l_tai_rec.id;
4985:
4986: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
4987: EXCEPTION