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

Line 56: ,p_tai_id IN OKL_TRX_AR_INVOICES_B.ID%TYPE

52: ,x_return_status OUT NOCOPY VARCHAR2
53: ,x_msg_count OUT NOCOPY NUMBER
54: ,x_msg_data OUT NOCOPY VARCHAR2
55: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
56: ,p_tai_id IN OKL_TRX_AR_INVOICES_B.ID%TYPE
57: )
58: IS
59: l_api_name CONSTANT VARCHAR2(30) := 'create_accounting_dist';
60: l_api_version CONSTANT NUMBER := 1.0;

Line 68: l_trx_header_id OKL_TRX_AR_INVOICES_B.ID%TYPE;

64: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
65: l_tld_loop_cnt NUMBER;
66: lx_tldv_rec okl_tld_pvt.tldv_rec_type;
67: l_til_id NUMBER;
68: l_trx_header_id OKL_TRX_AR_INVOICES_B.ID%TYPE;
69: l_til_debug_cnt NUMBER;
70: l_tld_debug_cnt NUMBER;
71: p_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;
72:

Line 165: l_trx_header_tbl:= 'OKL_TRX_AR_INVOICES_B';

161: l_tld_loop_cnt := lp_tldv_tbl.NEXT(l_tld_loop_cnt);
162: end loop;
163:
164: ---- Added by Vpanwar --- Code for new accounting API uptake
165: l_trx_header_tbl:= 'OKL_TRX_AR_INVOICES_B';
166: l_trx_header_id := p_tai_id;
167: --Call accounting with new signature
168:
169: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(

Line 237: -- okl_trx_ar_invoices_b

233: -- Start of comments
234: --
235: -- Procedure Name : additional_tai_attr
236: -- Description : Internal procedure to add additional columns for
237: -- okl_trx_ar_invoices_b
238: -- Business Rules :
239: -- Parameters :
240: --
241: -- Version : 1.0

Line 259: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006

255: l_api_version CONSTANT NUMBER := 1.0;
256: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
257:
258: --START: cklee 3/20/07
259: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
260:
261: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
262: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
263: l_object1_id1 okc_rules_b.object1_id1%TYPE;

Line 346: l_term_id okl_trx_ar_invoices_b.irt_id%type; -- cklee 3/20/07

342: FROM RA_TERMS_TL T, RA_TERMS_B B
343: where T.name = 'IMMEDIATE' and T.LANGUAGE = userenv('LANG')
344: and B.TERM_ID = T.TERM_ID;
345:
346: l_term_id okl_trx_ar_invoices_b.irt_id%type; -- cklee 3/20/07
347:
348: CURSOR rcpt_method_csr(p_rct_method_id NUMBER) IS
349: SELECT c.creation_method_code
350: FROM ar_receipt_methods m,

Line 360: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;

356:
357: --Start code added by pgomes on 20-NOV-2002
358: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
359: l_khr_id khr_id_type;
360: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
361: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
362: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
363: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
364:

Line 361: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;

357: --Start code added by pgomes on 20-NOV-2002
358: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
359: l_khr_id khr_id_type;
360: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
361: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
362: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
363: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
364:
365: --Get currency conversion attributes for a contract

Line 362: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;

358: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
359: l_khr_id khr_id_type;
360: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
361: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
362: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
363: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
364:
365: --Get currency conversion attributes for a contract
366: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS

Line 363: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;

359: l_khr_id khr_id_type;
360: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
361: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
362: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
363: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
364:
365: --Get currency conversion attributes for a contract
366: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS
367: SELECT currency_code,

Line 998: okl_trx_ar_invoices_b b

994: CURSOR l_curr_csr(p_khr_id number) IS
995: SELECT c.minimum_accountable_unit,
996: c.PRECISION
997: FROM fnd_currencies c,
998: okl_trx_ar_invoices_b b
999: WHERE c.currency_code = b.currency_code
1000: AND b.khr_id = p_khr_id;
1001:
1002:

Line 1383: p_token1_value => 'okl_trx_ar_invoices_b.ixx_id');

1379: THEN
1380: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1381: p_msg_name => G_REQUIRED_VALUE,
1382: p_token1 => G_COL_NAME_TOKEN,
1383: p_token1_value => 'okl_trx_ar_invoices_b.ixx_id');
1384:
1385: RAISE G_EXCEPTION_HALT_VALIDATION;
1386: END IF;
1387:

Line 1394: p_token1_value => 'okl_trx_ar_invoices_b.irm_id');

1390: THEN
1391: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1392: p_msg_name => G_REQUIRED_VALUE,
1393: p_token1 => G_COL_NAME_TOKEN,
1394: p_token1_value => 'okl_trx_ar_invoices_b.irm_id');
1395:
1396: RAISE G_EXCEPTION_HALT_VALIDATION;
1397: END IF;
1398:

Line 1405: p_token1_value => 'okl_trx_ar_invoices_b.irt_id');

1401: THEN
1402: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1403: p_msg_name => G_REQUIRED_VALUE,
1404: p_token1 => G_COL_NAME_TOKEN,
1405: p_token1_value => 'okl_trx_ar_invoices_b.irt_id');
1406:
1407: RAISE G_EXCEPTION_HALT_VALIDATION;
1408: END IF;
1409:

Line 1416: p_token1_value => 'okl_trx_ar_invoices_b.ibt_id');

1412: THEN
1413: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1414: p_msg_name => G_REQUIRED_VALUE,
1415: p_token1 => G_COL_NAME_TOKEN,
1416: p_token1_value => 'okl_trx_ar_invoices_b.ibt_id');
1417:
1418: RAISE G_EXCEPTION_HALT_VALIDATION;
1419: END IF;
1420:

Line 1427: p_token1_value => 'okl_trx_ar_invoices_b.org_id');

1423: THEN
1424: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1425: p_msg_name => G_REQUIRED_VALUE,
1426: p_token1 => G_COL_NAME_TOKEN,
1427: p_token1_value => 'okl_trx_ar_invoices_b.org_id');
1428:
1429: RAISE G_EXCEPTION_HALT_VALIDATION;
1430: END IF;
1431:

Line 1438: p_token1_value => 'okl_trx_ar_invoices_b.legal_entity_id');

1434: THEN
1435: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1436: p_msg_name => G_REQUIRED_VALUE,
1437: p_token1 => G_COL_NAME_TOKEN,
1438: p_token1_value => 'okl_trx_ar_invoices_b.legal_entity_id');
1439:
1440: RAISE G_EXCEPTION_HALT_VALIDATION;
1441: END IF;
1442:

Line 1454: p_token1_value => 'okl_trx_ar_invoices_b.trx_status_code');

1450: THEN
1451: OKL_API.set_message(p_app_name => 'OKL',
1452: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1453: p_token1 => 'COL_NAME',
1454: p_token1_value => 'okl_trx_ar_invoices_b.trx_status_code');
1455: RAISE G_EXCEPTION_HALT_VALIDATION;
1456: END IF;
1457: --end: | 30-Mar-2007 cklee -- validate taiv_rec.trx_status_code and default to |
1458: --| 'SUBMITTED' |

Line 1814: -- 2. Create okl_trx_ar_invoices_b record: okl_tai_pvt.insert_row;

1810:
1811: /*** Begin API body ****************************************************/
1812:
1813:
1814: -- 2. Create okl_trx_ar_invoices_b record: okl_tai_pvt.insert_row;
1815:
1816: -- start: cklee -- add additional columns 3/19/07
1817: validate_tai_values(
1818: p_taiv_rec => lp_taiv_rec,

Line 2159: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';

2155: l_tld_loop_cnt := lp_tldv_tbl.NEXT(l_tld_loop_cnt);
2156: end loop;
2157:
2158: ---- Added by Vpanwar --- Code for new accounting API uptake
2159: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';
2160: l_trx_header_id := lx_taiv_rec.id;
2161: --Call accounting with new signature
2162: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
2163: p_api_version => p_api_version,

Line 2370: -- 2. Create okl_trx_ar_invoices_b record: okl_tai_pvt.insert_row;

2366: /*** Begin API body ****************************************************/
2367:
2368: --
2369:
2370: -- 2. Create okl_trx_ar_invoices_b record: okl_tai_pvt.insert_row;
2371:
2372: -- start: cklee -- add additional columns 3/19/07
2373:
2374: validate_tai_values(

Line 2695: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';

2691: l_tld_loop_cnt := lp_tldv_tbl.NEXT(l_tld_loop_cnt);
2692: end loop;
2693:
2694: ---- Added by Vpanwar --- Code for new accounting API uptake
2695: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';
2696: l_trx_header_id := lx_taiv_rec.id;
2697: --Call accounting with new signature
2698: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
2699: p_api_version => p_api_version,

Line 3180: -- p_taiv_rec - Record type for OKL_TRX_AR_INVOICES_B.

3176: -- make a accounting call for all TLD records.
3177: -- Parameters :
3178: -- IN : p_api_version - Standard input parameter
3179: -- p_init_msg_list - Standard input parameter
3180: -- p_taiv_rec - Record type for OKL_TRX_AR_INVOICES_B.
3181: -- p_tilv_tbl -- Table type for OKL_TXL_AR_INV_LNS_B.
3182: -- Version : 1.0
3183: -- History : gkhuntet created.
3184: -- End of comments

Line 3589: -- p_taiv_id - ID of OKL_TRX_AR_INVOICES_B.

3585: -- And If p_tilv_id is passed then delete TIL and all TLD of TIL.
3586: -- Parameters :
3587: -- IN : p_api_version - Standard input parameter
3588: -- p_init_msg_list - Standard input parameter
3589: -- p_taiv_id - ID of OKL_TRX_AR_INVOICES_B.
3590: -- p_tilv_id -- ID of OKL_TXL_AR_INV_LNS_B.
3591: -- Version : 1.0
3592: -- History : gkhuntet created.
3593: -- End of comments

Line 3610: lp_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE :=p_taiv_id;

3606: l_api_name CONSTANT VARCHAR2(30) := 'update_manual_invoice';
3607: l_api_version CONSTANT NUMBER := 1.0;
3608: l_til_loop_cnt NUMBER;
3609: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3610: lp_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE :=p_taiv_id;
3611: lp_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE :=p_tilv_id;
3612: l_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE;
3613: l_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE ;
3614: l_til_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE ;

Line 3612: l_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE;

3608: l_til_loop_cnt NUMBER;
3609: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3610: lp_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE :=p_taiv_id;
3611: lp_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE :=p_tilv_id;
3612: l_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE;
3613: l_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE ;
3614: l_til_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE ;
3615: l_taiv_rec okl_tai_pvt.taiv_rec_type;
3616: l_tilv_rec okl_til_pvt.tilv_rec_type;