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 683: CURSOR zx_lines_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER, cp_application_id IN NUMBER,

679: FROM okc_k_headers_b
680: WHERE id = p_contract_id;
681:
682: --sechawla 13-may-2008 6619311 : added this cursor
683: CURSOR zx_lines_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER, cp_application_id IN NUMBER,
684: cp_event_class_code IN VARCHAR2,cp_entity_code IN VARCHAR2 , cp_trx_level_type IN VARCHAR2) IS
685: SELECT tax_line_id, tax_amt
686: FROM zx_lines
687: WHERE trx_id = cp_trx_id

Line 686: FROM zx_lines

682: --sechawla 13-may-2008 6619311 : added this cursor
683: CURSOR zx_lines_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER, cp_application_id IN NUMBER,
684: cp_event_class_code IN VARCHAR2,cp_entity_code IN VARCHAR2 , cp_trx_level_type IN VARCHAR2) IS
685: SELECT tax_line_id, tax_amt
686: FROM zx_lines
687: WHERE trx_id = cp_trx_id
688: AND trx_line_id = cp_trx_line_id
689: AND application_id = cp_application_id
690: AND event_class_code = cp_event_class_code

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

871: --All invoice lines go under a single invoice header.
872: --Each invoice line corresponds to the tax line that needs to be billed
873:
874: --Loop through tax lines for each taxable line
875: FOR zx_lines_rec IN zx_lines_csr(l_allbilledtaxablelines_rec.trx_id,
876: l_allbilledtaxablelines_rec.trx_line_id,
877: l_allbilledtaxablelines_rec.application_id,
878: l_allbilledtaxablelines_rec.event_class_code,
879: l_allbilledtaxablelines_rec.entity_code ,

Line 887: 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

883: LOOP
884: -- Populate Billing Line Tbl
885: l_txl_ar_inv_lns_tbl(i).id := okc_p_util.raw_to_number(sys_guid());
886: l_txl_ar_inv_lns_tbl(i).kle_id := l_allbilledtaxablelines_rec.kle_id;
887: 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
888:
889: --sechawla 13-may-2008 6619311 : calculate total tax to store on the header
890: l_total_tax_amt := l_total_tax_amt + zx_lines_rec.tax_amt;
891:

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

886: l_txl_ar_inv_lns_tbl(i).kle_id := l_allbilledtaxablelines_rec.kle_id;
887: 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
888:
889: --sechawla 13-may-2008 6619311 : calculate total tax to store on the header
890: l_total_tax_amt := l_total_tax_amt + zx_lines_rec.tax_amt;
891:
892: l_txl_ar_inv_lns_tbl(i).tai_id := xp_taiv_rec.id;
893: l_txl_ar_inv_lns_tbl(i).sty_id := l_sty_id;
894: l_txl_ar_inv_lns_tbl(i).inv_receiv_line_code := l_line_code;

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

941: l_txl_ar_inv_lns_tbl(i).qte_line_id := NULL;
942: l_txl_ar_inv_lns_tbl(i).upgrade_from_two_level_yn := NULL;
943:
944: --sechawla 13-may-2008 6619311 : store the corresponding tax line reference on each invoice line
945: l_txl_ar_inv_lns_tbl(i).tax_line_id := zx_lines_rec.tax_line_id;
946:
947: --populate line detail table
948: l_txd_ar_inv_ln_dtls_tbl(i).id := okc_p_util.raw_to_number(sys_guid());
949: l_txd_ar_inv_ln_dtls_tbl(i).object_version_number := 1;

Line 957: 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;

953: l_txd_ar_inv_ln_dtls_tbl(i).last_update_date := SYSDATE;
954: l_txd_ar_inv_ln_dtls_tbl(i).til_id_details := l_txl_ar_inv_lns_tbl(i).id;
955: l_txd_ar_inv_ln_dtls_tbl(i).sty_id := l_sty_id;
956: --added additional attribute tld rec
957: 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;
958: l_txd_ar_inv_ln_dtls_tbl(i).inventory_org_id := l_inv_org_id;
959:
960: --28-May-2008 sechawla 6619311 : populate khr_id and kle_id
961: l_txd_ar_inv_ln_dtls_tbl(i).khr_id := p_khr_id;

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

1017: p_trx_id)
1018: LOOP
1019: --sechawla 13-may-2008 6619311 : added this cursor for loop
1020: -- Loop through the tax lines
1021: FOR zx_lines_rec IN zx_lines_csr(l_billedtaxablelines_rec.trx_id,
1022: l_billedtaxablelines_rec.trx_line_id,
1023: l_billedtaxablelines_rec.application_id,
1024: l_billedtaxablelines_rec.event_class_code,
1025: l_billedtaxablelines_rec.entity_code ,

Line 1034: 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

1030:
1031: -- Populate Billing Line Tbl
1032: l_txl_ar_inv_lns_tbl(i).id := okc_p_util.raw_to_number(sys_guid());
1033: l_txl_ar_inv_lns_tbl(i).kle_id := l_billedtaxablelines_rec.kle_id;
1034: 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
1035:
1036: --sechawla 13-may-2008 6619311 : calculate total tax to store on the header
1037: l_total_tax_amt := l_total_tax_amt + zx_lines_rec.tax_amt;
1038:

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

1033: l_txl_ar_inv_lns_tbl(i).kle_id := l_billedtaxablelines_rec.kle_id;
1034: 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
1035:
1036: --sechawla 13-may-2008 6619311 : calculate total tax to store on the header
1037: l_total_tax_amt := l_total_tax_amt + zx_lines_rec.tax_amt;
1038:
1039: l_txl_ar_inv_lns_tbl(i).tai_id := xp_taiv_rec.id;
1040: l_txl_ar_inv_lns_tbl(i).sty_id := l_sty_id;
1041: l_txl_ar_inv_lns_tbl(i).inv_receiv_line_code := l_line_code;

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

1087: l_txl_ar_inv_lns_tbl(i).bank_acct_id := NULL;
1088: l_txl_ar_inv_lns_tbl(i).qte_line_id := NULL;
1089: l_txl_ar_inv_lns_tbl(i).upgrade_from_two_level_yn := NULL;
1090:
1091: l_txl_ar_inv_lns_tbl(i).tax_line_id := zx_lines_rec.tax_line_id;--sechawla 13-may-2008 6619311 :Added
1092:
1093: --populate line detail table
1094: l_txd_ar_inv_ln_dtls_tbl(i).id := okc_p_util.raw_to_number(sys_guid());
1095: l_txd_ar_inv_ln_dtls_tbl(i).object_version_number := 1;

Line 1103: 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;

1099: l_txd_ar_inv_ln_dtls_tbl(i).last_update_date := SYSDATE;
1100: l_txd_ar_inv_ln_dtls_tbl(i).til_id_details := l_txl_ar_inv_lns_tbl(i).id;
1101: l_txd_ar_inv_ln_dtls_tbl(i).sty_id := l_sty_id;
1102: --added additional attribute tld rec
1103: 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;
1104: l_txd_ar_inv_ln_dtls_tbl(i).inventory_org_id := l_inv_org_id;
1105:
1106: --28-May-2008 sechawla 6619311 : populate khr_id and kle_id
1107: l_txd_ar_inv_ln_dtls_tbl(i).khr_id := p_khr_id;

Line 1423: IF zx_lines_csr%ISOPEN THEN

1419: EXCEPTION
1420: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1421:
1422: --sechawla 13-may-2008 6619311
1423: IF zx_lines_csr%ISOPEN THEN
1424: CLOSE zx_lines_csr;
1425: END IF;
1426:
1427: IF inv_org_id_csr%ISOPEN THEN

Line 1424: CLOSE zx_lines_csr;

1420: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1421:
1422: --sechawla 13-may-2008 6619311
1423: IF zx_lines_csr%ISOPEN THEN
1424: CLOSE zx_lines_csr;
1425: END IF;
1426:
1427: IF inv_org_id_csr%ISOPEN THEN
1428: CLOSE inv_org_id_csr;

Line 1471: IF zx_lines_csr%ISOPEN THEN

1467:
1468: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1469:
1470: --sechawla 13-may-2008 6619311
1471: IF zx_lines_csr%ISOPEN THEN
1472: CLOSE zx_lines_csr;
1473: END IF;
1474:
1475: IF inv_org_id_csr%ISOPEN THEN

Line 1472: CLOSE zx_lines_csr;

1468: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1469:
1470: --sechawla 13-may-2008 6619311
1471: IF zx_lines_csr%ISOPEN THEN
1472: CLOSE zx_lines_csr;
1473: END IF;
1474:
1475: IF inv_org_id_csr%ISOPEN THEN
1476: CLOSE inv_org_id_csr;

Line 1518: IF zx_lines_csr%ISOPEN THEN

1514: p_api_type => g_api_type);
1515:
1516: WHEN OTHERS THEN
1517: --sechawla 13-may-2008 6619311
1518: IF zx_lines_csr%ISOPEN THEN
1519: CLOSE zx_lines_csr;
1520: END IF;
1521:
1522: IF inv_org_id_csr%ISOPEN THEN

Line 1519: CLOSE zx_lines_csr;

1515:
1516: WHEN OTHERS THEN
1517: --sechawla 13-may-2008 6619311
1518: IF zx_lines_csr%ISOPEN THEN
1519: CLOSE zx_lines_csr;
1520: END IF;
1521:
1522: IF inv_org_id_csr%ISOPEN THEN
1523: CLOSE inv_org_id_csr;