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 265: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006

261: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
262: l_rgd_code okc_rule_groups_b.rgd_code%TYPE DEFAULT NULL;
263:
264: --START: cklee 3/20/07
265: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
266:
267: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
268: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
269: l_object1_id1 okc_rules_b.object1_id1%TYPE;

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

366: FROM RA_TERMS_TL T, RA_TERMS_B B
367: where T.name = 'IMMEDIATE' and T.LANGUAGE = userenv('LANG')
368: and B.TERM_ID = T.TERM_ID;
369:
370: l_term_id okl_trx_ar_invoices_b.irt_id%type; -- cklee 3/20/07
371:
372: CURSOR rcpt_method_csr(p_rct_method_id NUMBER) IS
373: SELECT c.creation_method_code
374: FROM ar_receipt_methods m,

Line 384: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;

380:
381: --Start code added by pgomes on 20-NOV-2002
382: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
383: l_khr_id khr_id_type;
384: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
385: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
386: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
387: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
388:

Line 385: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;

381: --Start code added by pgomes on 20-NOV-2002
382: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
383: l_khr_id khr_id_type;
384: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
385: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
386: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
387: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
388:
389: --Get currency conversion attributes for a contract

Line 386: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;

382: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
383: l_khr_id khr_id_type;
384: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
385: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
386: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
387: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
388:
389: --Get currency conversion attributes for a contract
390: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS

Line 387: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;

383: l_khr_id khr_id_type;
384: l_currency_code okl_trx_ar_invoices_b.currency_code%TYPE;
385: l_currency_conversion_type okl_trx_ar_invoices_b.currency_conversion_type%TYPE;
386: l_currency_conversion_rate okl_trx_ar_invoices_b.currency_conversion_rate%TYPE;
387: l_currency_conversion_date okl_trx_ar_invoices_b.currency_conversion_date%TYPE;
388:
389: --Get currency conversion attributes for a contract
390: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS
391: SELECT currency_code,

Line 1101: okl_trx_ar_invoices_b b

1097: CURSOR l_curr_csr(p_khr_id number) IS
1098: SELECT c.minimum_accountable_unit,
1099: c.PRECISION
1100: FROM fnd_currencies c,
1101: okl_trx_ar_invoices_b b
1102: WHERE c.currency_code = b.currency_code
1103: AND b.khr_id = p_khr_id;
1104:
1105:

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

1482: THEN
1483: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1484: p_msg_name => G_REQUIRED_VALUE,
1485: p_token1 => G_COL_NAME_TOKEN,
1486: p_token1_value => 'okl_trx_ar_invoices_b.ixx_id');
1487:
1488: RAISE G_EXCEPTION_HALT_VALIDATION;
1489: END IF;
1490:

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

1493: THEN
1494: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1495: p_msg_name => G_REQUIRED_VALUE,
1496: p_token1 => G_COL_NAME_TOKEN,
1497: p_token1_value => 'okl_trx_ar_invoices_b.irm_id');
1498:
1499: RAISE G_EXCEPTION_HALT_VALIDATION;
1500: END IF;
1501:

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

1504: THEN
1505: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1506: p_msg_name => G_REQUIRED_VALUE,
1507: p_token1 => G_COL_NAME_TOKEN,
1508: p_token1_value => 'okl_trx_ar_invoices_b.irt_id');
1509:
1510: RAISE G_EXCEPTION_HALT_VALIDATION;
1511: END IF;
1512:

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

1515: THEN
1516: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1517: p_msg_name => G_REQUIRED_VALUE,
1518: p_token1 => G_COL_NAME_TOKEN,
1519: p_token1_value => 'okl_trx_ar_invoices_b.ibt_id');
1520:
1521: RAISE G_EXCEPTION_HALT_VALIDATION;
1522: END IF;
1523:

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

1526: THEN
1527: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1528: p_msg_name => G_REQUIRED_VALUE,
1529: p_token1 => G_COL_NAME_TOKEN,
1530: p_token1_value => 'okl_trx_ar_invoices_b.org_id');
1531:
1532: RAISE G_EXCEPTION_HALT_VALIDATION;
1533: END IF;
1534:

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

1537: THEN
1538: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1539: p_msg_name => G_REQUIRED_VALUE,
1540: p_token1 => G_COL_NAME_TOKEN,
1541: p_token1_value => 'okl_trx_ar_invoices_b.legal_entity_id');
1542:
1543: RAISE G_EXCEPTION_HALT_VALIDATION;
1544: END IF;
1545:

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

1553: THEN
1554: OKL_API.set_message(p_app_name => 'OKL',
1555: p_msg_name => 'OKL_CONTRACTS_INVALID_VALUE',
1556: p_token1 => 'COL_NAME',
1557: p_token1_value => 'okl_trx_ar_invoices_b.trx_status_code');
1558: RAISE G_EXCEPTION_HALT_VALIDATION;
1559: END IF;
1560: --end: | 30-Mar-2007 cklee -- validate taiv_rec.trx_status_code and default to |
1561: --| 'SUBMITTED' |

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

1969:
1970: /*** Begin API body ****************************************************/
1971:
1972:
1973: -- 2. Create okl_trx_ar_invoices_b record: okl_tai_pvt.insert_row;
1974:
1975: -- start: cklee -- add additional columns 3/19/07
1976: validate_tai_values(
1977: p_taiv_rec => lp_taiv_rec,

Line 2328: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';

2324: l_tld_loop_cnt := lp_tldv_tbl.NEXT(l_tld_loop_cnt);
2325: end loop;
2326:
2327: ---- Added by Vpanwar --- Code for new accounting API uptake
2328: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';
2329: l_trx_header_id := lx_taiv_rec.id;
2330: --Call accounting with new signature
2331: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
2332: p_api_version => p_api_version,

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

2535: /*** Begin API body ****************************************************/
2536:
2537: --
2538:
2539: -- 2. Create okl_trx_ar_invoices_b record: okl_tai_pvt.insert_row;
2540:
2541: -- start: cklee -- add additional columns 3/19/07
2542:
2543: validate_tai_values(

Line 2864: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';

2860: l_tld_loop_cnt := lp_tldv_tbl.NEXT(l_tld_loop_cnt);
2861: end loop;
2862:
2863: ---- Added by Vpanwar --- Code for new accounting API uptake
2864: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';
2865: l_trx_header_id := lx_taiv_rec.id;
2866: --Call accounting with new signature
2867: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
2868: p_api_version => p_api_version,

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

3421: -- make a accounting call for all TLD records.
3422: -- Parameters :
3423: -- IN : p_api_version - Standard input parameter
3424: -- p_init_msg_list - Standard input parameter
3425: -- p_taiv_rec - Record type for OKL_TRX_AR_INVOICES_B.
3426: -- p_tilv_tbl -- Table type for OKL_TXL_AR_INV_LNS_B.
3427: -- Version : 1.0
3428: -- History : gkhuntet created.
3429: -- End of comments

Line 3834: -- p_taiv_id - ID of OKL_TRX_AR_INVOICES_B.

3830: -- And If p_tilv_id is passed then delete TIL and all TLD of TIL.
3831: -- Parameters :
3832: -- IN : p_api_version - Standard input parameter
3833: -- p_init_msg_list - Standard input parameter
3834: -- p_taiv_id - ID of OKL_TRX_AR_INVOICES_B.
3835: -- p_tilv_id -- ID of OKL_TXL_AR_INV_LNS_B.
3836: -- Version : 1.0
3837: -- History : gkhuntet created.
3838: -- End of comments

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

3851: l_api_name CONSTANT VARCHAR2(30) := 'update_manual_invoice';
3852: l_api_version CONSTANT NUMBER := 1.0;
3853: l_til_loop_cnt NUMBER;
3854: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3855: lp_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE :=p_taiv_id;
3856: lp_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE :=p_tilv_id;
3857: l_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE;
3858: l_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE ;
3859: l_til_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE ;

Line 3857: l_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE;

3853: l_til_loop_cnt NUMBER;
3854: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3855: lp_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE :=p_taiv_id;
3856: lp_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE :=p_tilv_id;
3857: l_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE;
3858: l_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE ;
3859: l_til_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE ;
3860: l_taiv_rec okl_tai_pvt.taiv_rec_type;
3861: l_tilv_rec okl_til_pvt.tilv_rec_type;