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_AUTH_UTIL_PVT dependencies on OKC_K_LINES_B

Line 4572: FROM okc_k_lines_b

4568: p_amount IN NUMBER,
4569: x_status OUT NOCOPY VARCHAR2) IS
4570: CURSOR subline_count IS
4571: SELECT COUNT( * )
4572: FROM okc_k_lines_b
4573: WHERE cle_id = p_cle_id
4574: AND lse_id IN (7, 8, 9, 10, 11, 35, 18, 25);
4575:
4576: CURSOR subline_cur IS

Line 4578: FROM okc_k_lines_b

4574: AND lse_id IN (7, 8, 9, 10, 11, 35, 18, 25);
4575:
4576: CURSOR subline_cur IS
4577: SELECT id, price_negotiated
4578: FROM okc_k_lines_b
4579: WHERE cle_id = p_cle_id
4580: AND lse_id IN (7, 8, 9, 10, 11, 35, 18, 25);
4581:
4582: l_total_amt NUMBER := 0;

Line 4629: FROM okc_k_lines_b

4625: l_inv_rule_id NUMBER;
4626:
4627: CURSOR inv_rule_cur(p_id IN NUMBER) IS
4628: SELECT inv_rule_id
4629: FROM okc_k_lines_b
4630: WHERE id = p_id;
4631:
4632: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
4633: l_bill_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;

Line 4751: FROM okc_k_lines_b

4747: FUNCTION GetCoverage(p_cle_id IN NUMBER) RETURN NUMBER
4748: IS
4749: CURSOR l_cov_csr IS
4750: SELECT id
4751: FROM okc_k_lines_b
4752: WHERE cle_id = p_cle_id
4753: AND lse_id IN(2, 20);
4754: l_cov_id NUMBER := NULL;
4755: BEGIN

Line 4912: FROM okc_k_lines_b cle, oks_k_lines_b sle

4908: --LLC
4909:
4910: CURSOR get_topline_tax_amt_csr (p_cle_id IN NUMBER) IS
4911: SELECT nvl(SUM(nvl(tax_amount, 0)), 0)
4912: FROM okc_k_lines_b cle, oks_k_lines_b sle
4913: WHERE cle.cle_id = p_cle_id
4914: AND cle.lse_id IN (7, 8, 9, 10, 11, 18, 25, 35)
4915: AND cle.id = sle.cle_id
4916: AND cle.dnz_chr_id = sle.dnz_chr_id

Line 4921: FROM okc_k_lines_b cle, oks_k_lines_b sle

4917: AND cle.date_cancelled IS NULL;
4918:
4919: CURSOR get_hdr_tax_amt_csr (p_chr_id IN NUMBER) IS
4920: SELECT nvl(SUM(nvl(tax_amount, 0)), 0)
4921: FROM okc_k_lines_b cle, oks_k_lines_b sle
4922: WHERE cle.dnz_chr_id = p_chr_id
4923: AND cle.lse_id IN (1, 12, 14, 19, 46)
4924: AND cle.cle_id IS NULL
4925: AND cle.id = sle.cle_id

Line 5038: FROM okc_k_lines_b cle,

5034: , cle.price_negotiated amt
5035: , cle.dnz_chr_id chr_id
5036: , kln.id kln_id
5037: , kln.object_version_number
5038: FROM okc_k_lines_b cle,
5039: oks_k_lines_b kln
5040: WHERE cle.cle_id = p_cle_id
5041: AND kln.cle_id = cle.id
5042: AND lse_id NOT IN (2, 15, 20, 46);

Line 5179: FROM okc_k_lines_b

5175: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
5176:
5177: CURSOR total_amount(p_chr_id IN NUMBER) IS
5178: SELECT nvl(SUM(price_negotiated), 0) SUM
5179: FROM okc_k_lines_b
5180: WHERE dnz_chr_id = p_chr_id
5181: AND lse_id IN (7, 8, 9, 10, 11, 35, 13, 18, 25)
5182: AND date_cancelled IS NULL; --ignore cancelled sublines
5183:

Line 5218: FROM okc_k_lines_b

5214: IS
5215:
5216: CURSOR header_cur IS
5217: SELECT dnz_chr_id, start_date, end_date, object_version_number, lse_id
5218: FROM okc_k_lines_b
5219: WHERE id = p_source_rec.cle_id;
5220:
5221: CURSOR get_contract_modifier_cur (p_chr_id NUMBER)
5222: IS

Line 5301: FROM okc_k_lines_b

5297: --TAX
5298:
5299: CURSOR get_price_negotiated_amt_csr (p_cle_id IN NUMBER) IS
5300: SELECT nvl(SUM(price_negotiated), 0) amt
5301: FROM okc_k_lines_b
5302: WHERE cle_id = p_cle_id
5303: AND date_cancelled IS NULL; ---Added condition to exclude cancelled sublines
5304:
5305: get_price_negotiated_amt_rec get_price_negotiated_amt_csr%ROWTYPE;

Line 5309: FROM okc_k_lines_b

5305: get_price_negotiated_amt_rec get_price_negotiated_amt_csr%ROWTYPE;
5306:
5307: CURSOR sum_price_negotiated_lines_csr (p_chr_id NUMBER) IS
5308: SELECT nvl(SUM(price_negotiated), 0) amt
5309: FROM okc_k_lines_b
5310: WHERE dnz_chr_id = p_chr_id
5311: AND cle_id IS NULL
5312: AND date_cancelled IS NULL; ---Added condition to exclude cancelled lines
5313:

Line 5332: FROM okc_k_lines_b

5328: --LLC CANCELLED_AMOUNT
5329:
5330: CURSOR sum_cancelled_amt_lines_csr (p_chr_id NUMBER) IS
5331: SELECT SUM(nvl(cancelled_amount, 0))
5332: FROM okc_k_lines_b
5333: WHERE dnz_chr_id = p_chr_id
5334: AND cle_id IS NULL;
5335:
5336:

Line 5339: FROM okc_k_lines_b

5335:
5336:
5337: CURSOR get_topline_cancelled_amt (p_cle_id IN NUMBER) IS
5338: SELECT nvl(SUM(nvl(price_negotiated, 0)), 0) --BUG FIX 4758886 --Forced to return this query 0 value
5339: FROM okc_k_lines_b
5340: WHERE cle_id = p_cle_id
5341: AND date_cancelled IS NOT NULL; --Condition to consider only the cancelled sublines
5342:
5343: ---Added for bug 9481526 skuchima

Line 5359: FROM okc_k_lines_b WHERE id=p_cle_id;

5355:
5356: --fetch the line dates
5357: CURSOR fetch_line_date(p_cle_id IN number) is
5358: SELECT start_date,end_date
5359: FROM okc_k_lines_b WHERE id=p_cle_id;
5360:
5361: --end for bug 9481526 skuchima
5362:
5363:

Line 5417: FROM OKC_K_LINES_B

5413: --Fix for bug#2221910 start. Get Max Of Top Lines.
5414:
5415: SELECT nvl(MAX(to_number(line_number)), 0)
5416: INTO l_top_line_number
5417: FROM OKC_K_LINES_B
5418: WHERE dnz_chr_id = g_chr_id
5419: AND cle_id IS NULL;
5420: --Fix for bug#2221910 end.
5421:

Line 5496: UPDATE okc_k_lines_b SET line_number = l_top_line_number

5492:
5493: --Fix for bug#2221910 start. Update Top Line Sequence number.
5494:
5495: l_top_line_number := l_top_line_number + 1;
5496: UPDATE okc_k_lines_b SET line_number = l_top_line_number
5497: WHERE id = l_target_tbl(idx).cle_id;
5498: --Fix for bug#2221910 end.
5499:
5500: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 5792: UPDATE okc_k_lines_b

5788: l_curr_code
5789: );
5790: --Updating topline with the price_negotiated and cancelled_amount
5791:
5792: UPDATE okc_k_lines_b
5793: SET price_negotiated = l_curr_price_negotiated_amt,
5794: cancelled_amount = l_curr_cancelled_amt
5795: WHERE id = l_target_tbl(idx).cle_id;
5796:

Line 6233: FROM okc_k_lines_b

6229: -- Get customer account id
6230: CURSOR l_csr_get_cust_acct_id(p_cle_id IN NUMBER)
6231: IS
6232: SELECT cust_acct_id
6233: FROM okc_k_lines_b
6234: WHERE id = p_cle_id;
6235:
6236:
6237: CURSOR l_Get_party_id(p_cust_acct_id IN NUMBER)

Line 6287: FROM okc_k_lines_b

6283: IS
6284: CURSOR l_csr_get_shipto_billto(p_cle_id IN NUMBER)
6285: IS
6286: SELECT ship_to_site_use_id, bill_to_site_use_id
6287: FROM okc_k_lines_b
6288: WHERE id = p_cle_id;
6289:
6290:
6291: CURSOR l_csr_partysite_from_custsite(p_shipto_or_billto IN NUMBER)

Line 6791: UPDATE okc_k_lines_b

6787: UPDATE okc_k_headers_b
6788: SET date_renewed = TRUNC(p_operation_lines_tbl(i).creation_date)
6789: WHERE id = p_operation_lines_tbl(i).object_chr_id;
6790: ELSE
6791: UPDATE okc_k_lines_b
6792: SET date_renewed = TRUNC(p_operation_lines_tbl(i).creation_date)
6793: WHERE id = p_operation_lines_tbl(i).object_cle_id;
6794: END IF;
6795: END LOOP;

Line 6821: FROM okc_k_lines_b

6817: IS
6818:
6819: CURSOR line_cur(c_cle_id NUMBER) IS
6820: SELECT cle_id, line_number
6821: FROM okc_k_lines_b
6822: WHERE id = c_cle_id;
6823:
6824: CURSOR price_adj_cur(c_list_line_id NUMBER, c_cle_id NUMBER) IS
6825: SELECT 'x'

Line 6838: FROM okc_k_lines_b

6834: AND chr_id = c_chr_id;
6835:
6836: CURSOR sub_line_cur(c_cle_id NUMBER) IS
6837: SELECT id, line_number
6838: FROM okc_k_lines_b
6839: WHERE cle_id = c_cle_id
6840: AND lse_id IN(9, 25);
6841:
6842: l_line_number VARCHAR2(301) := NULL;

Line 6936: FROM okc_k_lines_b

6932:
6933: CURSOR l_csr_total_line_amount(p_line_id IN NUMBER)
6934: IS
6935: SELECT nvl(SUM(nvl(price_negotiated, 0)), 0)
6936: FROM okc_k_lines_b
6937: WHERE cle_id = p_line_id
6938: AND date_cancelled IS NULL; -- line Level Cancellation
6939:
6940: CURSOR toplinetax_cur(p_cle_id IN NUMBER) IS

Line 6942: FROM okc_k_lines_b cle, oks_k_lines_b kln

6938: AND date_cancelled IS NULL; -- line Level Cancellation
6939:
6940: CURSOR toplinetax_cur(p_cle_id IN NUMBER) IS
6941: SELECT SUM(nvl(tax_amount, 0)) amount
6942: FROM okc_k_lines_b cle, oks_k_lines_b kln
6943: WHERE cle.cle_id = p_cle_id
6944: AND cle.id = kln.cle_id
6945: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
6946: AND cle.date_cancelled IS NULL;

Line 7082: FROM okc_k_lines_b

7078:
7079: -- Header Level Tax Amount --
7080: CURSOR total_amount IS
7081: SELECT nvl(SUM(price_negotiated), 0) SUM
7082: FROM okc_k_lines_b
7083: WHERE dnz_chr_id = p_header_id
7084: AND cle_id IS NULL
7085: AND date_cancelled IS NULL; -- line Level Cancellation
7086: --Commented URP

Line 7092: FROM okc_k_lines_b cle, oks_k_lines_b kln

7088:
7089: -- Header Tax Total
7090: CURSOR hdrtax_cur IS
7091: SELECT SUM(kln.tax_amount) amount
7092: FROM okc_k_lines_b cle, oks_k_lines_b kln
7093: WHERE cle.dnz_chr_id = p_header_id
7094: AND cle.id = kln.cle_id
7095: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
7096: AND cle.date_cancelled IS NULL;

Line 7181: FROM okc_k_lines_b lines

7177: lines.date_terminated,
7178: lines.price_unit,
7179: lines.price_unit_percent,
7180: lines.id
7181: FROM okc_k_lines_b lines
7182: WHERE lines.cle_id = p_contract_line_id
7183: AND lines.lse_id IN(7, 8, 9, 10, 11, 18, 25, 35);
7184: l_subline_rec l_subline_csr%ROWTYPE;
7185: l_prorated_amount NUMBER := 0;

Line 7229: FROM okc_k_lines_b lines

7225:
7226: CURSOR l_svc_csr IS
7227: SELECT nvl(SUM(NVL(price_negotiated, 0)), 0) service_amount
7228: , COUNT(price_negotiated)
7229: FROM okc_k_lines_b lines
7230: WHERE lines.cle_id = p_contract_line_id
7231: AND lines.lse_id IN(7, 8, 9, 10, 11, 18, 25, 35)
7232: AND lines.date_cancelled IS NULL; -- line Level Cancellation
7233:

Line 7251: FROM okc_k_lines_b okc, oks_k_lines_b oks

7247: okc.dnz_chr_id,
7248: currency_code,
7249: oks.id oks_id,
7250: oks.object_version_number
7251: FROM okc_k_lines_b okc, oks_k_lines_b oks
7252: WHERE okc.Cle_id = p_contract_line_id
7253: AND OKS.cle_id = okc.id
7254: AND (okc.date_terminated IS NULL OR okc.date_terminated > TRUNC(SYSDATE))
7255: AND lse_id NOT IN(2, 15, 20)

Line 7269: FROM okc_k_lines_b okc, oks_k_lines_b oks

7265: okc.dnz_chr_id,
7266: currency_code,
7267: oks.id oks_id,
7268: oks.object_version_number
7269: FROM okc_k_lines_b okc, oks_k_lines_b oks
7270: WHERE okc.Cle_id = p_contract_line_id
7271: AND OKS.cle_id = okc.id
7272: AND (okc.date_terminated IS NULL OR okc.date_terminated > TRUNC(SYSDATE))
7273: AND lse_id NOT IN(2, 15, 20)

Line 7364: FROM okc_k_lines_b

7360:
7361: FUNCTION Get_Header_Id RETURN NUMBER IS
7362: CURSOR l_hdr_csr IS
7363: SELECT dnz_chr_id
7364: FROM okc_k_lines_b
7365: WHERE id = p_contract_line_id;
7366: l_header_id OKC_K_HEADERS_B.ID%TYPE;
7367: BEGIN
7368: OPEN l_hdr_csr;

Line 7466: from okc_k_lines_b

7462:
7463: ----------errorout_ad(' after updating coverag level ' ||clvl_rec.lse_id||' '||clvl_rec.id);
7464:
7465: /* select price_negotiated into cp_price
7466: from okc_k_lines_b
7467: where id = clvl_rec.id; */
7468:
7469: ----------errorout_ad(' price nego after update '||cp_price);
7470:

Line 7848: FROM okc_k_lines_b

7844: )
7845: IS
7846: CURSOR get_all_instances_csr IS
7847: SELECT id
7848: FROM okc_k_lines_b
7849: WHERE cle_id = p_cle_id
7850: AND lse_id IN (9, 25);
7851:
7852: CURSOR get_okc_item_qty_csr (p_item_cle_id NUMBER) IS

Line 8421: SELECT 'Y' FROM OKC_K_LINES_B

8417: x_msg_data OUT NOCOPY VARCHAR2
8418: ) RETURN BOOLEAN IS
8419:
8420: CURSOR check_eligiblity_line IS
8421: SELECT 'Y' FROM OKC_K_LINES_B
8422: WHERE dnz_chr_id = p_contract_hdr_id
8423: AND id = p_contract_line_id
8424: AND(date_terminated IS NULL OR date_terminated > TRUNC(SYSDATE))
8425: AND date_cancelled IS NULL

Line 8430: SELECT ID, LSE_ID FROM OKC_K_LINES_B

8426: AND end_date > NVL(oks_bill_util_pub.get_billed_upto(id, p_intent), end_date - 1);
8427:
8428:
8429: CURSOR get_lines_id IS
8430: SELECT ID, LSE_ID FROM OKC_K_LINES_B
8431: WHERE dnz_chr_id = p_contract_hdr_id
8432: AND cle_id IS NULL
8433: AND(date_terminated IS NULL OR date_terminated > TRUNC(SYSDATE))
8434: AND date_cancelled IS NULL

Line 8464: UPDATE okc_k_lines_b

8460: IF P_intent = 'H'
8461: THEN
8462: FOR cur_rec IN get_lines_id
8463: LOOP
8464: UPDATE okc_k_lines_b
8465: SET price_list_id = p_price_list_id
8466: WHERE dnz_chr_id = p_contract_hdr_id
8467: AND cle_id IS NULL
8468: AND ID = CUR_REC.id;

Line 8613: FROM okc_k_lines_b a, okc_k_lines_b b,

8609: SELECT a.id, nvl(a.price_negotiated, 0) topline_amt,
8610: SUM(nvl(b.price_negotiated,0)) sum_subline_amt,
8611: nvl(c.tax_amount,0) topline_tax_amt,
8612: SUM(nvl(d.tax_amount,0)) sum_subline_tax_amt
8613: FROM okc_k_lines_b a, okc_k_lines_b b,
8614: oks_k_lines_b c, oks_k_lines_b d
8615: WHERE a.dnz_chr_id = cp_chr_id AND a.lse_id IN (1,12,14,19)
8616: AND b.dnz_chr_id = a.dnz_chr_id AND b.cle_id = a.id
8617: AND a.id=c.cle_id AND b.id=d.cle_id

Line 8631: FROM okc_k_lines_b a,

8627: SELECT a.id, nvl(a.price_negotiated, 0) topline_amt,
8628: 0 sum_subline_amt,
8629: nvl(c.tax_amount,0) topline_tax_amt,
8630: 0 sum_subline_tax_amt
8631: FROM okc_k_lines_b a,
8632: oks_k_lines_b c
8633: WHERE a.dnz_chr_id = cp_chr_id
8634: AND a.lse_id IN (1,12,14,19)
8635: AND a.id=c.cle_id

Line 8637: and not exists( select 1 from okc_k_lines_b b

8633: WHERE a.dnz_chr_id = cp_chr_id
8634: AND a.lse_id IN (1,12,14,19)
8635: AND a.id=c.cle_id
8636: AND a.date_cancelled is null
8637: and not exists( select 1 from okc_k_lines_b b
8638: WHERE b.lse_id IN (7,8,9,10,11,35,13,18,25)
8639: AND b.date_cancelled is null
8640: AND b.dnz_chr_id=a.dnz_chr_id
8641: AND b.cle_id=a.id);

Line 8645: FROM okc_k_lines_b WHERE id = cp_id

8641: AND b.cle_id=a.id);
8642:
8643: CURSOR c_lock_tl(cp_id IN NUMBER) IS
8644: SELECT price_negotiated
8645: FROM okc_k_lines_b WHERE id = cp_id
8646: FOR UPDATE OF price_negotiated NOWAIT;
8647:
8648: CURSOR c_line_name(cp_id IN NUMBER) IS
8649: SELECT substr(RTRIM(RTRIM(line_number) || ', ' || RTRIM(lsev.name) || ' ' || RTRIM(clev.name)), 1, 2000) line_name

Line 8660: FROM okc_k_headers_all_b a, okc_k_lines_b b,

8656: nvl(a.estimated_amount, 0) hdr_amt,
8657: SUM(nvl(b.price_negotiated,0)) sum_tl_line_amt,
8658: nvl(c.tax_amount,0) hdr_tax_amt,
8659: SUM(nvl(d.tax_amount,0)) sum_tl_line_amt_tax
8660: FROM okc_k_headers_all_b a, okc_k_lines_b b,
8661: oks_k_headers_b c, oks_k_lines_b d
8662: WHERE a.id = cp_chr_id
8663: AND b.dnz_chr_id = a.id AND b.cle_id IS NULL
8664: AND d.dnz_chr_id = c.chr_id AND d.cle_id=b.id

Line 8680: AND NOT EXISTS (SELECT 1 from okc_k_lines_b b

8676: FROM okc_k_headers_all_b a,
8677: oks_k_headers_b c
8678: WHERE a.id = cp_chr_id
8679: AND c.chr_id = a.id
8680: AND NOT EXISTS (SELECT 1 from okc_k_lines_b b
8681: WHERE b.dnz_chr_id = a.id
8682: AND b.cle_id IS NULL
8683: AND b.date_cancelled is null
8684: AND b.lse_id IN (1,12,14,19,46));

Line 8695: FROM okc_k_lines_b a, okc_k_lines_b b

8691: -- select all the toplines which has cancelled amount not equal to those of sublines
8692: CURSOR c_k_toplines_cancelled (cp_chr_id IN NUMBER) IS
8693: SELECT a.id, nvl(a.cancelled_amount, 0) topline_canceled_amt, /*modified for bug:6765336*/
8694: SUM(nvl(b.cancelled_amount,0)) sum_subline_cancelled_amt
8695: FROM okc_k_lines_b a, okc_k_lines_b b
8696: WHERE a.dnz_chr_id = cp_chr_id AND a.lse_id IN (1,12,14,19)
8697: AND b.dnz_chr_id = a.dnz_chr_id AND b.cle_id = a.id
8698: AND a.date_cancelled is null
8699: AND b.date_cancelled is not null

Line 8708: FROM okc_k_headers_all_b a, okc_k_lines_b b

8704: CURSOR c_k_hdr_cancelled(cp_chr_id IN NUMBER) IS
8705: SELECT
8706: nvl(a.cancelled_amount, 0) hdr_cancelled_amt,
8707: SUM(nvl(b.cancelled_amount,0)) sum_tl_line_cancelled_amt
8708: FROM okc_k_headers_all_b a, okc_k_lines_b b
8709: WHERE a.id = cp_chr_id
8710: AND b.dnz_chr_id = a.id AND b.cle_id IS NULL
8711: AND b.lse_id IN (1,12,14,19,46)
8712: GROUP BY a.cancelled_amount;

Line 8793: UPDATE okc_k_lines_b

8789: END IF;
8790:
8791: --if we come till here, we where able to obtain locks on all the toplines fectched previously
8792: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last
8793: UPDATE okc_k_lines_b
8794: SET price_negotiated = l_sl_amt_tbl(j)
8795: WHERE id = l_tl_id_tbl(j);
8796:
8797: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last

Line 8875: UPDATE okc_k_lines_b

8871: END IF;
8872:
8873: --if we come till here, we where able to obtain locks on all the toplines fectched previously
8874: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last
8875: UPDATE okc_k_lines_b
8876: SET price_negotiated = l_sl_amt_tbl(j)
8877: WHERE id = l_tl_id_tbl(j);
8878:
8879: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last

Line 9070: update okc_k_lines_b

9066: END IF;
9067:
9068: --if we come till here, we where able to obtain locks on all the toplines fectched previously
9069: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last
9070: update okc_k_lines_b
9071: set cancelled_amount =l_sl_amt_tbl(j)
9072: where id=l_tl_id_tbl(j);
9073:
9074: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 9412: FROM okc_k_lines_b

9408: x_return_status OUT NOCOPY VARCHAR2) IS
9409:
9410: CURSOR l_topline_csr(p_chr_id NUMBER) IS
9411: SELECT ID, start_date, end_date, lse_id
9412: FROM okc_k_lines_b
9413: WHERE chr_id = p_chr_id
9414: AND lse_id IN (1, 14, 19, 46)
9415: AND date_cancelled IS NULL
9416: AND date_terminated IS NULL

Line 9421: FROM okc_k_lines_b

9417: ORDER BY line_number;
9418:
9419: CURSOR l_subline_csr(p_cle_id NUMBER) IS
9420: SELECT ID, start_date, end_date, lse_id ,price_negotiated
9421: FROM okc_k_lines_b
9422: WHERE cle_id = p_cle_id
9423: AND lse_id IN (7, 8, 9, 10, 11, 18, 25, 35)
9424: AND date_cancelled IS NULL
9425: AND date_terminated IS NULL

Line 9468: FROM okc_k_lines_b

9464: l_api_name CONSTANT VARCHAR2(30) := 'GET_AMOUNTS';
9465:
9466: CURSOR l_line_csr(p_line_id NUMBER) IS
9467: SELECT SUM(price_negotiated) amount
9468: FROM okc_k_lines_b
9469: WHERE cle_id = p_line_id
9470: AND chr_id IS NULL
9471: AND lse_id IN (7, 8, 9, 10, 11, 18, 25, 35)
9472: AND date_cancelled IS NULL;

Line 9476: FROM okc_k_lines_b

9472: AND date_cancelled IS NULL;
9473:
9474: CURSOR l_hdr_csr(p_chr_id NUMBER) IS
9475: SELECT SUM(price_negotiated) amount
9476: FROM okc_k_lines_b
9477: WHERE chr_id = p_chr_id
9478: AND cle_id IS NULL
9479: AND date_cancelled IS NULL;
9480:

Line 9524: SELECT ID, object_version_number FROM okc_k_lines_b WHERE ID = p_id;

9520: FROM okc_k_headers_all_b
9521: WHERE ID = p_id;
9522:
9523: CURSOR l_okc_cle_csr(p_id NUMBER) IS
9524: SELECT ID, object_version_number FROM okc_k_lines_b WHERE ID = p_id;
9525:
9526: CURSOR l_oks_chr_csr(p_id NUMBER) IS
9527: SELECT ID, object_version_number
9528: FROM oks_k_headers_b

Line 9632: UPDATE okc_k_lines_b okl

9628: LOOP
9629:
9630: IF l_topline_rec.lse_id = 46 THEN
9631:
9632: UPDATE okc_k_lines_b okl
9633: SET okl.price_negotiated = ((okl.price_negotiated *
9634: l_old_conversion_rate) /
9635: Nvl(p_new_conversion_rate, 1))
9636: WHERE okl.id = l_topline_rec.id;

Line 9704: UPDATE okc_k_lines_b okl

9700:
9701:
9702: ELSE --if lse_id in 7,9,25
9703:
9704: UPDATE okc_k_lines_b okl
9705: SET okl.price_negotiated = ((okl.price_negotiated *
9706: l_old_conversion_rate) /
9707: Nvl(p_new_conversion_rate, 1))
9708: WHERE okl.id = l_subline_rec.id;