APPS.OKL_LLA_UTIL_PVT dependencies on OKL_K_LINES

Line 1612: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE

1608: x_return_status OUT NOCOPY VARCHAR2) IS
1609:
1610: cursor get_line_details_csr(p_chr_id in number) IS
1611: SELECT KLE.ID ID
1612: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE
1613: WHERE CLE.DNZ_CHR_ID = p_chr_id
1614: AND CLE.ID = KLE.ID
1615: AND CLE.LSE_ID in (33, 52, 53, 70) -- 48
1616: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED','ABANDONED', 'TERMINATED')

Line 1624: okl_k_lines kle

1620: SELECT vDtls.ID
1621: FROM okl_party_payment_hdr vHdr,
1622: okl_party_payment_dtls vDtls,
1623: okc_k_lines_b cle,
1624: okl_k_lines kle
1625: WHERE vDtls.payment_hdr_id = vHdr.id
1626: AND vHdr.CLE_ID = cle.id
1627: AND vHdr.DNZ_CHR_ID = p_chr_id
1628: AND vHdr.PASSTHRU_TERM = 'BASE'

Line 1665: update okl_k_lines

1661: CLOSE get_line_details_csr;
1662:
1663: if t_extr_id_tbl.count > 0 then
1664: forall i in t_extr_id_tbl.first..t_extr_id_tbl.last
1665: update okl_k_lines
1666: set orig_contract_line_id = t_extr_id_tbl(i)
1667: where id = t_extr_id_tbl(i)
1668: and orig_contract_line_id is null;
1669: end if;

Line 1728: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE

1724: x_return_status OUT NOCOPY VARCHAR2) IS
1725:
1726: cursor get_line_details_csr(p_chr_id in number) IS
1727: SELECT KLE.ID ID
1728: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE
1729: WHERE CLE.DNZ_CHR_ID = p_chr_id
1730: AND CLE.ID = KLE.ID
1731: AND CLE.LSE_ID in (33, 52, 53, 70) -- 48
1732: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED','ABANDONED', 'TERMINATED')

Line 1737: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE

1733: AND kle.orig_contract_line_id is null;
1734:
1735: cursor get_upg_line_details_csr(p_orig_chr_id in number) IS
1736: SELECT kle.id, kle.orig_contract_line_id
1737: FROM OKL_K_LINES KLE, OKC_K_LINES_B CLE
1738: WHERE CLE.DNZ_CHR_ID = p_orig_chr_id
1739: AND CLE.ID = KLE.ID
1740: AND CLE.LSE_ID in (33, 52, 53, 70) -- 48
1741: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED','ABANDONED', 'TERMINATED');

Line 1749: okl_k_lines kle,

1745: SELECT vDtls.ID
1746: FROM okl_party_payment_hdr vHdr,
1747: okl_party_payment_dtls vDtls,
1748: okc_k_lines_b cle,
1749: okl_k_lines kle,
1750: okc_k_headers_all_b chr
1751: WHERE vDtls.payment_hdr_id = vHdr.id
1752: AND vHdr.CLE_ID = cle.id
1753: AND vHdr.DNZ_CHR_ID = p_chr_id

Line 1775: okl_k_lines kle

1771: SELECT vDtls.orig_contract_line_id, vDtls.vendor_id, cle.id
1772: FROM okl_party_payment_hdr vHdr,
1773: okl_party_payment_dtls vDtls,
1774: okc_k_lines_b cle,
1775: okl_k_lines kle
1776: WHERE vDtls.payment_hdr_id = vHdr.id
1777: AND vHdr.CLE_ID = cle.id
1778: AND vHdr.PASSTHRU_TERM = 'BASE'
1779: AND vHdr.DNZ_CHR_ID = cle.dnz_chr_id

Line 1854: update okl_k_lines

1850: CLOSE get_line_details_csr;
1851:
1852: if t_extr_id_tbl.count > 0 then
1853: forall i in t_extr_id_tbl.first..t_extr_id_tbl.last
1854: update okl_k_lines
1855: set orig_contract_line_id = t_extr_id_tbl(i)
1856: where id = t_extr_id_tbl(i)
1857: and orig_contract_line_id is null;
1858: end if;

Line 1869: update okl_k_lines a

1865: close get_upg_line_details_csr;
1866:
1867: if t_extr_id_tbl.count > 0 then
1868: forall i in t_extr_id_tbl.first..t_extr_id_tbl.last
1869: update okl_k_lines a
1870: set orig_contract_line_id = t_extr_id_tbl(i)
1871: where id in (select id FROM okc_k_lines_b b
1872: where orig_system_id1 = t_orig_cle_id_tbl(i)
1873: and dnz_chr_id = p_chr_id)

Line 1887: update okl_k_lines

1883: CLOSE get_line_details_csr;
1884:
1885: if t_extr_id_tbl.count > 0 then
1886: forall i in t_extr_id_tbl.first..t_extr_id_tbl.last
1887: update okl_k_lines
1888: set orig_contract_line_id = t_extr_id_tbl(i)
1889: where id = t_extr_id_tbl(i)
1890: and orig_contract_line_id is null;
1891: end if;