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_BILL_UPFRONT_TAX_PVT dependencies on ZX_LINES

Line 674: CURSOR zx_lines_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER, cp_application_id IN NUMBER,

670: FROM okc_k_headers_b
671: WHERE id = p_contract_id;
672:
673: --sechawla 13-may-2008 6619311 : added this cursor
674: CURSOR zx_lines_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER, cp_application_id IN NUMBER,
675: cp_event_class_code IN VARCHAR2,cp_entity_code IN VARCHAR2 , cp_trx_level_type IN VARCHAR2) IS
676: SELECT tax_line_id, tax_amt
677: FROM zx_lines
678: WHERE trx_id = cp_trx_id

Line 677: FROM zx_lines

673: --sechawla 13-may-2008 6619311 : added this cursor
674: CURSOR zx_lines_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER, cp_application_id IN NUMBER,
675: cp_event_class_code IN VARCHAR2,cp_entity_code IN VARCHAR2 , cp_trx_level_type IN VARCHAR2) IS
676: SELECT tax_line_id, tax_amt
677: FROM zx_lines
678: WHERE trx_id = cp_trx_id
679: AND trx_line_id = cp_trx_line_id
680: AND application_id = cp_application_id
681: AND event_class_code = cp_event_class_code

Line 843: FOR zx_lines_rec IN zx_lines_csr(l_allbilledtaxablelines_rec.trx_id,

839: --All invoice lines go under a single invoice header.
840: --Each invoice line corresponds to the tax line that needs to be billed
841:
842: --Loop through tax lines for each taxable line
843: FOR zx_lines_rec IN zx_lines_csr(l_allbilledtaxablelines_rec.trx_id,
844: l_allbilledtaxablelines_rec.trx_line_id,
845: l_allbilledtaxablelines_rec.application_id,
846: l_allbilledtaxablelines_rec.event_class_code,
847: l_allbilledtaxablelines_rec.entity_code ,

Line 855: l_txl_ar_inv_lns_tbl(i).amount := zx_lines_rec.tax_amt; --sechawla 13-may-2008 6619311 : changed to store tax amount instead of 0

851: LOOP
852: -- Populate Billing Line Tbl
853: l_txl_ar_inv_lns_tbl(i).id := okc_p_util.raw_to_number(sys_guid());
854: l_txl_ar_inv_lns_tbl(i).kle_id := l_allbilledtaxablelines_rec.kle_id;
855: l_txl_ar_inv_lns_tbl(i).amount := zx_lines_rec.tax_amt; --sechawla 13-may-2008 6619311 : changed to store tax amount instead of 0
856:
857: --sechawla 13-may-2008 6619311 : calculate total tax to store on the header
858: l_total_tax_amt := l_total_tax_amt + zx_lines_rec.tax_amt;
859:

Line 858: l_total_tax_amt := l_total_tax_amt + zx_lines_rec.tax_amt;

854: l_txl_ar_inv_lns_tbl(i).kle_id := l_allbilledtaxablelines_rec.kle_id;
855: l_txl_ar_inv_lns_tbl(i).amount := zx_lines_rec.tax_amt; --sechawla 13-may-2008 6619311 : changed to store tax amount instead of 0
856:
857: --sechawla 13-may-2008 6619311 : calculate total tax to store on the header
858: l_total_tax_amt := l_total_tax_amt + zx_lines_rec.tax_amt;
859:
860: l_txl_ar_inv_lns_tbl(i).tai_id := xp_taiv_rec.id;
861: l_txl_ar_inv_lns_tbl(i).sty_id := l_sty_id;
862: l_txl_ar_inv_lns_tbl(i).inv_receiv_line_code := l_line_code;

Line 913: l_txl_ar_inv_lns_tbl(i).tax_line_id := zx_lines_rec.tax_line_id;

909: l_txl_ar_inv_lns_tbl(i).qte_line_id := NULL;
910: l_txl_ar_inv_lns_tbl(i).upgrade_from_two_level_yn := NULL;
911:
912: --sechawla 13-may-2008 6619311 : store the corresponding tax line reference on each invoice line
913: l_txl_ar_inv_lns_tbl(i).tax_line_id := zx_lines_rec.tax_line_id;
914:
915: --populate line detail table
916: l_txd_ar_inv_ln_dtls_tbl(i).id := okc_p_util.raw_to_number(sys_guid());
917: l_txd_ar_inv_ln_dtls_tbl(i).object_version_number := 1;

Line 925: l_txd_ar_inv_ln_dtls_tbl(i).amount := zx_lines_rec.tax_amt; --sechawla 13-may-2008 6619311 : changed to store tax amount instead of 0;

921: l_txd_ar_inv_ln_dtls_tbl(i).last_update_date := SYSDATE;
922: l_txd_ar_inv_ln_dtls_tbl(i).til_id_details := l_txl_ar_inv_lns_tbl(i).id;
923: l_txd_ar_inv_ln_dtls_tbl(i).sty_id := l_sty_id;
924: --added additional attribute tld rec
925: l_txd_ar_inv_ln_dtls_tbl(i).amount := zx_lines_rec.tax_amt; --sechawla 13-may-2008 6619311 : changed to store tax amount instead of 0;
926: l_txd_ar_inv_ln_dtls_tbl(i).inventory_org_id := l_inv_org_id;
927:
928: --28-May-2008 sechawla 6619311 : populate khr_id and kle_id
929: l_txd_ar_inv_ln_dtls_tbl(i).khr_id := p_khr_id;

Line 965: FOR zx_lines_rec IN zx_lines_csr(l_billedtaxablelines_rec.trx_id,

961: p_trx_id)
962: LOOP
963: --sechawla 13-may-2008 6619311 : added this cursor for loop
964: -- Loop through the tax lines
965: FOR zx_lines_rec IN zx_lines_csr(l_billedtaxablelines_rec.trx_id,
966: l_billedtaxablelines_rec.trx_line_id,
967: l_billedtaxablelines_rec.application_id,
968: l_billedtaxablelines_rec.event_class_code,
969: l_billedtaxablelines_rec.entity_code ,

Line 978: l_txl_ar_inv_lns_tbl(i).amount := zx_lines_rec.tax_amt;--sechawla 13-may-2008 6619311 : changed to store tax amount instead of 0

974:
975: -- Populate Billing Line Tbl
976: l_txl_ar_inv_lns_tbl(i).id := okc_p_util.raw_to_number(sys_guid());
977: l_txl_ar_inv_lns_tbl(i).kle_id := l_billedtaxablelines_rec.kle_id;
978: l_txl_ar_inv_lns_tbl(i).amount := zx_lines_rec.tax_amt;--sechawla 13-may-2008 6619311 : changed to store tax amount instead of 0
979:
980: --sechawla 13-may-2008 6619311 : calculate total tax to store on the header
981: l_total_tax_amt := l_total_tax_amt + zx_lines_rec.tax_amt;
982:

Line 981: l_total_tax_amt := l_total_tax_amt + zx_lines_rec.tax_amt;

977: l_txl_ar_inv_lns_tbl(i).kle_id := l_billedtaxablelines_rec.kle_id;
978: l_txl_ar_inv_lns_tbl(i).amount := zx_lines_rec.tax_amt;--sechawla 13-may-2008 6619311 : changed to store tax amount instead of 0
979:
980: --sechawla 13-may-2008 6619311 : calculate total tax to store on the header
981: l_total_tax_amt := l_total_tax_amt + zx_lines_rec.tax_amt;
982:
983: l_txl_ar_inv_lns_tbl(i).tai_id := xp_taiv_rec.id;
984: l_txl_ar_inv_lns_tbl(i).sty_id := l_sty_id;
985: l_txl_ar_inv_lns_tbl(i).inv_receiv_line_code := l_line_code;

Line 1035: l_txl_ar_inv_lns_tbl(i).tax_line_id := zx_lines_rec.tax_line_id;--sechawla 13-may-2008 6619311 :Added

1031: l_txl_ar_inv_lns_tbl(i).bank_acct_id := NULL;
1032: l_txl_ar_inv_lns_tbl(i).qte_line_id := NULL;
1033: l_txl_ar_inv_lns_tbl(i).upgrade_from_two_level_yn := NULL;
1034:
1035: l_txl_ar_inv_lns_tbl(i).tax_line_id := zx_lines_rec.tax_line_id;--sechawla 13-may-2008 6619311 :Added
1036:
1037: --populate line detail table
1038: l_txd_ar_inv_ln_dtls_tbl(i).id := okc_p_util.raw_to_number(sys_guid());
1039: l_txd_ar_inv_ln_dtls_tbl(i).object_version_number := 1;

Line 1047: l_txd_ar_inv_ln_dtls_tbl(i).amount := zx_lines_rec.tax_amt; --sechawla 13-may-2008 6619311 : changed to store tax amount instead of 0;

1043: l_txd_ar_inv_ln_dtls_tbl(i).last_update_date := SYSDATE;
1044: l_txd_ar_inv_ln_dtls_tbl(i).til_id_details := l_txl_ar_inv_lns_tbl(i).id;
1045: l_txd_ar_inv_ln_dtls_tbl(i).sty_id := l_sty_id;
1046: --added additional attribute tld rec
1047: l_txd_ar_inv_ln_dtls_tbl(i).amount := zx_lines_rec.tax_amt; --sechawla 13-may-2008 6619311 : changed to store tax amount instead of 0;
1048: l_txd_ar_inv_ln_dtls_tbl(i).inventory_org_id := l_inv_org_id;
1049:
1050: --28-May-2008 sechawla 6619311 : populate khr_id and kle_id
1051: l_txd_ar_inv_ln_dtls_tbl(i).khr_id := p_khr_id;

Line 1231: IF zx_lines_csr%ISOPEN THEN

1227: EXCEPTION
1228: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1229:
1230: --sechawla 13-may-2008 6619311
1231: IF zx_lines_csr%ISOPEN THEN
1232: CLOSE zx_lines_csr;
1233: END IF;
1234:
1235: IF inv_org_id_csr%ISOPEN THEN

Line 1232: CLOSE zx_lines_csr;

1228: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1229:
1230: --sechawla 13-may-2008 6619311
1231: IF zx_lines_csr%ISOPEN THEN
1232: CLOSE zx_lines_csr;
1233: END IF;
1234:
1235: IF inv_org_id_csr%ISOPEN THEN
1236: CLOSE inv_org_id_csr;

Line 1279: IF zx_lines_csr%ISOPEN THEN

1275:
1276: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1277:
1278: --sechawla 13-may-2008 6619311
1279: IF zx_lines_csr%ISOPEN THEN
1280: CLOSE zx_lines_csr;
1281: END IF;
1282:
1283: IF inv_org_id_csr%ISOPEN THEN

Line 1280: CLOSE zx_lines_csr;

1276: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1277:
1278: --sechawla 13-may-2008 6619311
1279: IF zx_lines_csr%ISOPEN THEN
1280: CLOSE zx_lines_csr;
1281: END IF;
1282:
1283: IF inv_org_id_csr%ISOPEN THEN
1284: CLOSE inv_org_id_csr;

Line 1326: IF zx_lines_csr%ISOPEN THEN

1322: p_api_type => g_api_type);
1323:
1324: WHEN OTHERS THEN
1325: --sechawla 13-may-2008 6619311
1326: IF zx_lines_csr%ISOPEN THEN
1327: CLOSE zx_lines_csr;
1328: END IF;
1329:
1330: IF inv_org_id_csr%ISOPEN THEN

Line 1327: CLOSE zx_lines_csr;

1323:
1324: WHEN OTHERS THEN
1325: --sechawla 13-may-2008 6619311
1326: IF zx_lines_csr%ISOPEN THEN
1327: CLOSE zx_lines_csr;
1328: END IF;
1329:
1330: IF inv_org_id_csr%ISOPEN THEN
1331: CLOSE inv_org_id_csr;