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.OKS_CHANGE_STATUS_PVT dependencies on OKS_K_LINES_B

Line 1949: from okc_k_lines_b cle, oks_k_lines_b sle

1945: --Cursor to fetch tax_amount for a particular subline
1946:
1947: Cursor get_subline_tax_amt_csr (p_cle_id NUMBER) IS
1948: Select sle.tax_amount
1949: from okc_k_lines_b cle, oks_k_lines_b sle
1950: where cle.id = p_cle_id
1951: and cle.dnz_chr_id = p_id
1952: and cle.id = sle.cle_id
1953: and cle.dnz_chr_id = sle.dnz_chr_id;

Line 1959: from okc_k_lines_b cle, oks_k_lines_b sle

1955: --Cursor to add tax_amount of all the toplines
1956:
1957: Cursor get_hdr_tax_amt_csr IS
1958: select nvl(sum(nvl(tax_amount,0)),0)
1959: from okc_k_lines_b cle, oks_k_lines_b sle
1960: where cle.dnz_chr_id = p_id
1961: and cle.lse_id in (1, 12, 14, 19, 46)
1962: and cle.cle_id is null
1963: and cle.id = sle.cle_id

Line 2028: Update oks_k_lines_b

2024: END IF;
2025:
2026: -- updating tax_amount for the topline (l_cle_id) of this subline (p_cle_id)
2027:
2028: Update oks_k_lines_b
2029: set tax_amount= nvl(tax_amount, 0) - l_sub_line_tax_amt
2030: where dnz_chr_id = p_id
2031: and cle_id = l_cle_id;
2032:

Line 2034: Update oks_k_lines_b

2030: where dnz_chr_id = p_id
2031: and cle_id = l_cle_id;
2032:
2033: --Bug:6765336 Updating the subline when it is cancelled
2034: Update oks_k_lines_b
2035: set tax_amount= Nvl(tax_amount, 0) - l_sub_line_tax_amt
2036: Where cle_id = p_cle_id
2037: and dnz_chr_id = p_id;
2038: --Bug:6765336

Line 2050: Update oks_k_lines_b

2046:
2047:
2048: -- updating tax_amount for the topline (l_cle_id) of this subline (p_cle_id)
2049:
2050: Update oks_k_lines_b
2051: set tax_amount= nvl(tax_amount, 0) + l_sub_line_tax_amt
2052: where dnz_chr_id = p_id
2053: and cle_id = l_cle_id;
2054:

Line 2074: Update oks_k_lines_b

2070: END IF;
2071:
2072: -- updating tax_amount for the topline (p_cle_id)
2073:
2074: Update oks_k_lines_b
2075: set tax_amount= 0
2076: where dnz_chr_id = p_id
2077: and cle_id = p_cle_id;
2078:

Line 2112: Update oks_k_lines_b

2108: END IF;
2109:
2110: -- updating tax_amount for top line for SUBSCRIPTION line type due to change in the status of top line
2111:
2112: Update oks_k_lines_b
2113: set tax_amount= l_Tax_Value
2114: where dnz_chr_id = p_id
2115: and cle_id = p_cle_id;
2116:

Line 2127: Update oks_k_lines_b

2123: END IF;
2124:
2125: -- updating tax_amount for top line which is not of SUBSCRIPTION type
2126:
2127: Update oks_k_lines_b
2128: set tax_amount=
2129: (Select nvl(sum(nvl(tax_amount,0)),0)
2130: from okc_k_lines_b cle, oks_k_lines_b sle
2131: where cle.cle_id = p_cle_id

Line 2130: from okc_k_lines_b cle, oks_k_lines_b sle

2126:
2127: Update oks_k_lines_b
2128: set tax_amount=
2129: (Select nvl(sum(nvl(tax_amount,0)),0)
2130: from okc_k_lines_b cle, oks_k_lines_b sle
2131: where cle.cle_id = p_cle_id
2132: and cle.lse_id in (7,8,9,10,11,18,25,35)
2133: and cle.dnz_chr_id = p_id
2134: and cle.id = sle.cle_id

Line 2164: update oks_k_lines_b

2160: END IF;
2161:
2162: -- updating tax_amount for all the top lines of the contract
2163:
2164: update oks_k_lines_b
2165: set tax_amount = 0
2166: where dnz_chr_id = p_id
2167: and cle_id IN
2168: (select id

Line 2184: update oks_k_lines_b oks1

2180: END IF;
2181:
2182: -- updating tax_amount for all the top lines of the contract which are not of SUBSCRIPTION type
2183:
2184: update oks_k_lines_b oks1
2185: set oks1.tax_amount =
2186: (
2187: select nvl(sum(nvl(tax_amount,0)),0)
2188: from oks_k_lines_b oks2, okc_k_lines_b okc2

Line 2188: from oks_k_lines_b oks2, okc_k_lines_b okc2

2184: update oks_k_lines_b oks1
2185: set oks1.tax_amount =
2186: (
2187: select nvl(sum(nvl(tax_amount,0)),0)
2188: from oks_k_lines_b oks2, okc_k_lines_b okc2
2189: where oks2.cle_id = okc2.id
2190: and oks2.dnz_chr_id = okc2.dnz_chr_id
2191: and okc2.dnz_chr_id = p_id
2192: and okc2.cle_id = oks1.cle_id

Line 2364: Update oks_k_lines_b

2360: END IF;
2361:
2362: FORALL I IN l_id_Tbl.FIRST .. l_id_Tbl.LAST
2363:
2364: Update oks_k_lines_b
2365: set tax_amount= l_subs_tax_Tbl(I)
2366: where dnz_chr_id = p_id
2367: and cle_id = l_id_Tbl(I);
2368: