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 2005: from okc_k_lines_b cle, oks_k_lines_b sle

2001: --Cursor to fetch tax_amount for a particular subline
2002:
2003: Cursor get_subline_tax_amt_csr (p_cle_id NUMBER) IS
2004: Select sle.tax_amount
2005: from okc_k_lines_b cle, oks_k_lines_b sle
2006: where cle.id = p_cle_id
2007: and cle.dnz_chr_id = p_id
2008: and cle.id = sle.cle_id
2009: and cle.dnz_chr_id = sle.dnz_chr_id;

Line 2015: from okc_k_lines_b cle, oks_k_lines_b sle

2011: --Cursor to add tax_amount of all the toplines
2012:
2013: Cursor get_hdr_tax_amt_csr IS
2014: select nvl(sum(nvl(tax_amount,0)),0)
2015: from okc_k_lines_b cle, oks_k_lines_b sle
2016: where cle.dnz_chr_id = p_id
2017: and cle.lse_id in (1, 12, 14, 19, 46)
2018: and cle.cle_id is null
2019: and cle.id = sle.cle_id

Line 2034: from okc_k_lines_b cle, oks_k_lines_b sle

2030:
2031: --/*Added for bug:8775250*/
2032: Cursor get_sub_tax_amt_csr (p_cle_id NUMBER) IS
2033: Select cle.id,sle.tax_amount
2034: from okc_k_lines_b cle, oks_k_lines_b sle
2035: where cle.cle_id = p_cle_id
2036: and cle.dnz_chr_id = p_id
2037: and cle.lse_id in (7, 8, 9, 10, 11, 13, 18, 25, 35)
2038: and cle.term_cancel_source IN ('MANUAL','CUSTOMER') ---modified condition for bug 12956286

Line 2111: Update oks_k_lines_b

2107: END IF;
2108:
2109: -- updating tax_amount for the topline (l_cle_id) of this subline (p_cle_id)
2110:
2111: Update oks_k_lines_b
2112: set tax_amount= nvl(tax_amount, 0) - l_sub_line_tax_amt
2113: where dnz_chr_id = p_id
2114: and cle_id = l_cle_id;
2115:

Line 2117: Update oks_k_lines_b

2113: where dnz_chr_id = p_id
2114: and cle_id = l_cle_id;
2115:
2116: --Bug:6765336 Updating the subline when it is cancelled
2117: Update oks_k_lines_b
2118: set tax_amount= Nvl(tax_amount, 0) - l_sub_line_tax_amt
2119: Where cle_id = p_cle_id
2120: and dnz_chr_id = p_id;
2121: --Bug:6765336

Line 2144: Update oks_k_lines_b

2140: x_msg_data => x_msg_data,
2141: x_return_status => x_return_status
2142: );
2143:
2144: Update oks_k_lines_b
2145: set tax_amount= nvl(g_rail_rec.TAX_VALUE,0)
2146: where dnz_chr_id = p_id
2147: and cle_id = g_cle_id;
2148:

Line 2151: Update oks_k_lines_b

2147: and cle_id = g_cle_id;
2148:
2149: -- updating tax_amount for the topline (l_cle_id) of this subline (p_cle_id)
2150:
2151: Update oks_k_lines_b
2152: set tax_amount= nvl(tax_amount, 0) + nvl(g_rail_rec.TAX_VALUE,0)
2153: where dnz_chr_id = p_id
2154: and cle_id = l_cle_id;
2155:

Line 2175: Update oks_k_lines_b

2171: END IF;
2172:
2173: -- updating tax_amount for the topline (p_cle_id)
2174:
2175: Update oks_k_lines_b
2176: set tax_amount= 0
2177: where dnz_chr_id = p_id
2178: and cle_id = p_cle_id;
2179:

Line 2182: Update oks_k_lines_b

2178: and cle_id = p_cle_id;
2179:
2180: FOR get_sub_tax_amt_csr_rec IN get_sub_tax_amt_csr(p_cle_id)
2181: LOOP
2182: Update oks_k_lines_b
2183: set tax_amount= Nvl(tax_amount, 0) - get_sub_tax_amt_csr_rec.tax_amount
2184: Where cle_id = get_sub_tax_amt_csr_rec.id
2185: and dnz_chr_id = p_id;
2186: END LOOP;

Line 2221: Update oks_k_lines_b

2217: END IF;
2218:
2219: -- updating tax_amount for top line for SUBSCRIPTION line type due to change in the status of top line
2220:
2221: Update oks_k_lines_b
2222: set tax_amount= l_Tax_Value
2223: where dnz_chr_id = p_id
2224: and cle_id = p_cle_id;
2225:

Line 2251: Update oks_k_lines_b

2247: x_msg_data => x_msg_data,
2248: x_return_status => x_return_status
2249: );
2250:
2251: Update oks_k_lines_b
2252: set tax_amount= Nvl(tax_amount, 0)+nvl(g_rail_rec.TAX_VALUE,0)
2253: Where cle_id = get_subline_csr_rec.id
2254: and dnz_chr_id = p_id;
2255: END LOOP;

Line 2258: Update oks_k_lines_b

2254: and dnz_chr_id = p_id;
2255: END LOOP;
2256: -- updating tax_amount for top line which is not of SUBSCRIPTION type
2257:
2258: Update oks_k_lines_b
2259: set tax_amount=
2260: (Select nvl(sum(nvl(tax_amount,0)),0)
2261: from okc_k_lines_b cle, oks_k_lines_b sle
2262: where cle.cle_id = p_cle_id

Line 2261: from okc_k_lines_b cle, oks_k_lines_b sle

2257:
2258: Update oks_k_lines_b
2259: set tax_amount=
2260: (Select nvl(sum(nvl(tax_amount,0)),0)
2261: from okc_k_lines_b cle, oks_k_lines_b sle
2262: where cle.cle_id = p_cle_id
2263: and cle.lse_id in (7,8,9,10,11,18,25,35)
2264: and cle.dnz_chr_id = p_id
2265: and cle.id = sle.cle_id

Line 2297: Update oks_k_lines_b

2293: FOR get_lines_id_rec IN get_lines_id(p_id)
2294: LOOP
2295: FOR get_sub_tax_amt_csr_rec IN get_sub_tax_amt_csr(get_lines_id_rec.ID)
2296: LOOP
2297: Update oks_k_lines_b
2298: set tax_amount= 0
2299: Where cle_id = get_sub_tax_amt_csr_rec.id
2300: and dnz_chr_id = p_id;
2301: END LOOP;

Line 2305: update oks_k_lines_b

2301: END LOOP;
2302: END LOOP;
2303: -- updating tax_amount for all the top lines of the contract
2304:
2305: update oks_k_lines_b
2306: set tax_amount = 0
2307: where dnz_chr_id = p_id
2308: and cle_id IN
2309: (select id

Line 2341: Update oks_k_lines_b

2337: x_msg_count => x_msg_count,
2338: x_msg_data => x_msg_data,
2339: x_return_status => x_return_status
2340: );
2341: Update oks_k_lines_b
2342: set tax_amount= Nvl(tax_amount, 0)+nvl(g_rail_rec.TAX_VALUE,0)
2343: Where cle_id = get_subline_csr_rec.id
2344: and dnz_chr_id = p_id;
2345:

Line 2350: update oks_k_lines_b oks1

2346: END LOOP;
2347: END LOOP;
2348: -- updating tax_amount for all the top lines of the contract which are not of SUBSCRIPTION type
2349:
2350: update oks_k_lines_b oks1
2351: set oks1.tax_amount =
2352: (
2353: select nvl(sum(nvl(tax_amount,0)),0)
2354: from oks_k_lines_b oks2, okc_k_lines_b okc2

Line 2354: from oks_k_lines_b oks2, okc_k_lines_b okc2

2350: update oks_k_lines_b oks1
2351: set oks1.tax_amount =
2352: (
2353: select nvl(sum(nvl(tax_amount,0)),0)
2354: from oks_k_lines_b oks2, okc_k_lines_b okc2
2355: where oks2.cle_id = okc2.id
2356: and oks2.dnz_chr_id = okc2.dnz_chr_id
2357: and okc2.dnz_chr_id = p_id
2358: and okc2.cle_id = oks1.cle_id

Line 2530: Update oks_k_lines_b

2526: END IF;
2527:
2528: FORALL I IN l_id_Tbl.FIRST .. l_id_Tbl.LAST
2529:
2530: Update oks_k_lines_b
2531: set tax_amount= l_subs_tax_Tbl(I)
2532: where dnz_chr_id = p_id
2533: and cle_id = l_id_Tbl(I);
2534: