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

Line 28: FROM okc_k_lines_b kl, okc_k_items ki, okc_statuses_b ks

24:
25: CURSOR l_service_csr
26: IS
27: SELECT /*+ leading (kl) use_nl (kl ki) */ kl.ID cle_id
28: FROM okc_k_lines_b kl, okc_k_items ki, okc_statuses_b ks
29: WHERE kl.dnz_chr_id = p_chrid
30: AND kl.lse_id IN (1, 14, 19)
31: AND kl.ID = ki.cle_id
32: AND ki.object1_id1 = TO_CHAR (p_invserviceid)

Line 97: FROM okc_k_lines_b kl, oks_k_lines_b sl

93: l_shiporg_id NUMBER
94: )
95: IS
96: SELECT 'x'
97: FROM okc_k_lines_b kl, oks_k_lines_b sl
98: WHERE kl.ID = p_k_line_id
99: AND kl.ID = sl.cle_id
100: AND NVL (sl.acct_rule_id, -99) = NVL (l_acct_id, -99)
101: AND NVL (kl.inv_rule_id, -99) = NVL (l_inv_id, -99)

Line 1319: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c

1315: a.bill_to_site_use_id, a.line_renewal_type_code,
1316: b.tax_code --Fix for bug 4121175
1317: ,
1318: b.price_uom
1319: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c
1320: WHERE a.ID = l_line_id AND a.ID = b.cle_id AND a.sts_code = c.code;
1321:
1322: CURSOR service_item (l_line_id NUMBER)
1323: IS

Line 1349: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c

1345: l_price_uom VARCHAR2
1346: )
1347: IS
1348: SELECT a.ID
1349: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c
1350: WHERE a.ID = l_line_id
1351: AND a.ID = b.cle_id
1352: AND a.sts_code = c.code
1353: AND c.ste_code IN ('ACTIVE', 'ENTERED', 'SIGNED')

Line 1604: FROM okc_k_lines_b

1600: IS
1601: CURSOR l_line_csr
1602: IS
1603: SELECT start_date, end_date
1604: FROM okc_k_lines_b
1605: WHERE ID = p_cle_id;
1606:
1607: l_line_csr_rec l_line_csr%ROWTYPE;
1608: BEGIN

Line 1657: FROM okc_k_lines_b

1653: IS
1654: CURSOR l_rulegroup_csr
1655: IS
1656: SELECT inv_rule_id
1657: FROM okc_k_lines_b
1658: WHERE cle_id = p_cle_id AND dnz_chr_id = p_chr_id;
1659:
1660: --General
1661: l_api_version CONSTANT NUMBER := 1.0;

Line 2089: FROM okc_k_lines_b

2085: IS
2086: CURSOR l_parent_line_csr
2087: IS
2088: SELECT cle_id
2089: FROM okc_k_lines_b
2090: WHERE ID = p_covered_line_id;
2091:
2092: l_api_version CONSTANT NUMBER := 1.0;
2093: l_init_msg_list CONSTANT VARCHAR2 (1) := okc_api.g_false;

Line 3803: FROM okc_k_lines_b

3799:
3800: CURSOR get_line_number
3801: IS
3802: SELECT NVL (MAX (TO_NUMBER (line_number)), 0) + 1
3803: FROM okc_k_lines_b
3804: WHERE dnz_chr_id = p_chr_id AND lse_id IN (1, 12, 14, 19, 46);
3805: BEGIN
3806: OPEN get_line_number;
3807:

Line 3824: FROM okc_k_lines_b

3820:
3821: CURSOR get_line_number
3822: IS
3823: SELECT NVL (MAX (TO_NUMBER (line_number)), 0) + 1
3824: FROM okc_k_lines_b
3825: WHERE dnz_chr_id = p_chr_id
3826: AND cle_id = p_cle_id
3827: AND lse_id IN (35, 7, 8, 9, 10, 11, 13, 18, 25);
3828: BEGIN

Line 3894: FROM okc_statuses_b os, okc_k_lines_b ol

3890: --enhancement to be commented
3891: CURSOR l_ste_csr (l_line_id NUMBER)
3892: IS
3893: SELECT os.ste_code
3894: FROM okc_statuses_b os, okc_k_lines_b ol
3895: WHERE ol.ID = l_line_id AND ol.sts_code = os.code;
3896:
3897: CURSOR l_salesgrp_csr (p_id NUMBER, p_start_date DATE, p_end_date DATE)
3898: IS

Line 4042: UPDATE okc_k_lines_b

4038: IF l_ste_code = 'EXPIRED'
4039: THEN
4040: get_sts_code ('ACTIVE', NULL, l_ste_code, l_sts_code);
4041:
4042: UPDATE okc_k_lines_b
4043: SET sts_code = l_sts_code
4044: WHERE ID = l_line_id;
4045: END IF;
4046: ELSE

Line 5012: FROM okc_k_lines_b kl

5008:
5009: CURSOR l_line_csr (p_line_id NUMBER)
5010: IS
5011: SELECT kl.start_date, kl.end_date, kl.inv_rule_id
5012: FROM okc_k_lines_b kl
5013: WHERE kl.ID = p_line_id;
5014:
5015: l_duration NUMBER;
5016: l_timeunits VARCHAR2 (25);

Line 5864: FROM okc_k_lines_b

5860:
5861: CURSOR l_lndates_csr (p_id NUMBER)
5862: IS
5863: SELECT start_date, end_date
5864: FROM okc_k_lines_b
5865: WHERE ID = p_id;
5866:
5867: CURSOR l_hdrdates_csr (p_id NUMBER)
5868: IS

Line 6415: UPDATE okc_k_lines_b

6411: END IF;
6412: END IF; -- strmlvl end
6413: END IF; -- warranty flag end
6414:
6415: UPDATE okc_k_lines_b
6416: SET price_negotiated =
6417: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
6418: FROM okc_k_lines_b
6419: WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)

Line 6418: FROM okc_k_lines_b

6414:
6415: UPDATE okc_k_lines_b
6416: SET price_negotiated =
6417: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
6418: FROM okc_k_lines_b
6419: WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)
6420: WHERE ID = l_lineid;
6421:
6422: UPDATE okc_k_headers_b

Line 6425: FROM okc_k_lines_b

6421:
6422: UPDATE okc_k_headers_b
6423: SET estimated_amount =
6424: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
6425: FROM okc_k_lines_b
6426: WHERE dnz_chr_id = l_chrid AND lse_id IN (1, 19))
6427: WHERE ID = l_chrid;
6428:
6429: launch_workflow ( 'INSTALL BASE ACTIVITY : NEW '

Line 6760: UPDATE okc_k_lines_b

6756: END IF;
6757:
6758: IF x_return_status = 'S'
6759: THEN
6760: UPDATE okc_k_lines_b
6761: SET date_renewed = p_txn_date
6762: WHERE ID = l_source_line_id;
6763:
6764: l_line_date_renewed :=

Line 6767: UPDATE okc_k_lines_b

6763:
6764: l_line_date_renewed :=
6765: oks_ib_util_pvt.check_renewed_sublines (l_source_line_id);
6766:
6767: UPDATE okc_k_lines_b
6768: SET date_renewed = l_line_date_renewed
6769: WHERE ID = (SELECT cle_id
6770: FROM okc_k_lines_b
6771: WHERE ID = l_source_line_id)

Line 6770: FROM okc_k_lines_b

6766:
6767: UPDATE okc_k_lines_b
6768: SET date_renewed = l_line_date_renewed
6769: WHERE ID = (SELECT cle_id
6770: FROM okc_k_lines_b
6771: WHERE ID = l_source_line_id)
6772: AND date_renewed IS NULL;
6773:
6774: l_hdr_date_renewed :=

Line 6780: FROM okc_k_lines_b

6776:
6777: UPDATE okc_k_headers_all_b
6778: SET date_renewed = l_hdr_date_renewed
6779: WHERE ID = (SELECT dnz_chr_id
6780: FROM okc_k_lines_b
6781: WHERE ID = l_source_line_id)
6782: AND date_renewed IS NULL;
6783: ELSE
6784: RAISE g_exception_halt_validation;

Line 7154: UPDATE okc_k_lines_b

7150: UPDATE okc_k_items
7151: SET number_of_items = l_old_qty
7152: WHERE cle_id = p_kdtl_tbl (l_ctr).object_line_id;
7153:
7154: UPDATE okc_k_lines_b
7155: SET price_negotiated = NVL (l_oldamt, 0),
7156: price_unit = NVL (p_kdtl_tbl (l_ctr).service_unit_price, 0)
7157: WHERE ID = p_kdtl_tbl (l_ctr).object_line_id;
7158:

Line 7473: UPDATE okc_k_lines_b

7469: END IF;
7470:
7471: -- Fixed Bug 5039806
7472: /*
7473: UPDATE okc_k_lines_b
7474: SET price_negotiated =
7475: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
7476: FROM okc_k_lines_b
7477: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id

Line 7476: FROM okc_k_lines_b

7472: /*
7473: UPDATE okc_k_lines_b
7474: SET price_negotiated =
7475: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
7476: FROM okc_k_lines_b
7477: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
7478: AND dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id)
7479: WHERE ID = p_kdtl_tbl (l_ctr).service_line_id;
7480:

Line 7484: FROM okc_k_lines_b

7480:
7481: UPDATE okc_k_headers_b
7482: SET estimated_amount =
7483: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
7484: FROM okc_k_lines_b
7485: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
7486: AND lse_id IN (1, 19))
7487: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
7488: */

Line 8064: FROM okc_k_lines_b okcl, oks_k_lines_b oksl

8060: /* Code added for Bug#14829043 */
8061: BEGIN
8062: SELECT okcl.price_unit,oksl.price_uom
8063: INTO l_covd_rec.list_price, l_covd_rec.price_uom
8064: FROM okc_k_lines_b okcl, oks_k_lines_b oksl
8065: WHERE okcl.id = p_kdtl_tbl (l_ctr).object_line_id
8066: AND okcl.id = oksl.cle_id;
8067: EXCEPTION WHEN OTHERS THEN
8068: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 8406: UPDATE okc_k_lines_b

8402:
8403: IF l_ste_code = 'ENTERED'
8404: THEN
8405: -- UPdate topline price negotiated.
8406: UPDATE okc_k_lines_b
8407: SET price_negotiated = price_negotiated + l_newamt
8408: WHERE ID = l_lineid;
8409:
8410: -- Update header estimated amount

Line 9451: FROM oks_k_lines_b LN, okc_k_lines_b kl, oks_k_lines_b ks

9447: IS
9448: CURSOR l_cov_csr (p_cle_id NUMBER)
9449: IS
9450: SELECT LN.transfer_option
9451: FROM oks_k_lines_b LN, okc_k_lines_b kl, oks_k_lines_b ks
9452: WHERE kl.ID = p_cle_id
9453: AND ks.cle_id = kl.ID
9454: AND LN.cle_id = ks.coverage_id;
9455:

Line 9485: FROM okc_k_lines_b

9481:
9482: CURSOR l_srvdt_csr (p_line_id NUMBER)
9483: IS
9484: SELECT start_date, end_date
9485: FROM okc_k_lines_b
9486: WHERE ID = p_line_id;
9487:
9488: CURSOR l_cust_rel_csr (
9489: p_old_customer VARCHAR2,

Line 9531: FROM okc_k_lines_b

9527:
9528: CURSOR l_subline_csr (p_id NUMBER)
9529: IS
9530: SELECT date_terminated, price_negotiated
9531: FROM okc_k_lines_b
9532: WHERE ID = p_id;
9533:
9534: l_date_terminated DATE;
9535: l_subline_price NUMBER;

Line 9541: FROM okc_k_lines_b kl, okc_k_items ki, okc_statuses_b st

9537:
9538: CURSOR l_toplines_csr (p_chr_id NUMBER, p_service_item_id NUMBER)
9539: IS
9540: SELECT kl.ID cle_id
9541: FROM okc_k_lines_b kl, okc_k_items ki, okc_statuses_b st
9542: WHERE kl.dnz_chr_id = p_chr_id
9543: AND kl.lse_id IN (1, 14, 19)
9544: AND kl.ID = ki.cle_id
9545: AND ki.object1_id1 = TO_CHAR (p_service_item_id)

Line 10276: FROM okc_k_lines_b okc, oks_k_lines_b oks

10272: IS
10273: CURSOR l_line_rule_csr (p_line_id NUMBER)
10274: IS
10275: SELECT oks.acct_rule_id, okc.inv_rule_id, okc.price_list_id
10276: FROM okc_k_lines_b okc, oks_k_lines_b oks
10277: WHERE okc.ID = p_line_id AND oks.cle_id = okc.ID;
10278:
10279: CURSOR l_party_csr (p_id NUMBER)
10280: IS

Line 10555: FROM okc_k_lines_b kl, okc_statuses_b st

10551: */
10552: CURSOR l_line_sts_csr (p_line_id NUMBER)
10553: IS
10554: SELECT st.ste_code, kl.sts_code
10555: FROM okc_k_lines_b kl, okc_statuses_b st
10556: WHERE kl.ID = p_line_id AND st.code = kl.sts_code;
10557:
10558: CURSOR l_getprice_csr (p_line_id NUMBER)
10559: IS

Line 10561: FROM okc_k_lines_b

10557:
10558: CURSOR l_getprice_csr (p_line_id NUMBER)
10559: IS
10560: SELECT price_negotiated
10561: FROM okc_k_lines_b
10562: WHERE ID = p_line_id;
10563:
10564:
10565: CURSOR l_serv_csr (p_serv_id NUMBER)

Line 12638: UPDATE okc_k_lines_b

12634: THEN
12635: RAISE g_exception_halt_validation;
12636: END IF;
12637:
12638: UPDATE okc_k_lines_b
12639: SET price_negotiated =
12640: (SELECT NVL
12641: (SUM
12642: (NVL

Line 12649: FROM okc_k_lines_b

12645: )
12646: ),
12647: 0
12648: )
12649: FROM okc_k_lines_b
12650: WHERE cle_id =
12651: l_merge_line_id
12652: AND dnz_chr_id =
12653: l_merge_chr_id)

Line 12678: FROM okc_k_lines_b

12674: )
12675: ),
12676: 0
12677: )
12678: FROM okc_k_lines_b
12679: WHERE dnz_chr_id =
12680: l_merge_chr_id
12681: AND lse_id IN (1, 19))
12682: WHERE ID = l_merge_chr_id;

Line 12808: UPDATE okc_k_lines_b

12804: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
12805: RAISE g_exception_halt_validation;
12806: END IF;
12807: /*bugfix for 6882512*/
12808: UPDATE okc_k_lines_b
12809: SET sts_code = l_sts_code
12810: WHERE dnz_chr_id =
12811: l_merge_chr_id;
12812:

Line 13186: UPDATE okc_k_lines_b

13182: THEN
13183: RAISE g_exception_halt_validation;
13184: END IF;
13185:
13186: UPDATE okc_k_lines_b
13187: SET price_negotiated =
13188: (SELECT NVL
13189: (SUM
13190: (NVL

Line 13197: FROM okc_k_lines_b

13193: )
13194: ),
13195: 0
13196: )
13197: FROM okc_k_lines_b
13198: WHERE cle_id = l_line_id
13199: AND dnz_chr_id =
13200: l_merge_chr_id)
13201: WHERE ID = l_line_id;

Line 13225: FROM okc_k_lines_b

13221: )
13222: ),
13223: 0
13224: )
13225: FROM okc_k_lines_b
13226: WHERE dnz_chr_id =
13227: l_merge_chr_id
13228: AND lse_id IN (1, 19))
13229: WHERE ID = l_merge_chr_id;

Line 13351: UPDATE okc_k_lines_b

13347: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
13348: RAISE g_exception_halt_validation;
13349: END IF;
13350: /*bugfix for 6882512*/
13351: UPDATE okc_k_lines_b
13352: SET sts_code = l_sts_code
13353: WHERE dnz_chr_id = l_merge_chr_id;
13354:
13355: l_wf_attr_details.contract_id :=

Line 13693: UPDATE okc_k_lines_b

13689: l_inst_dtls_tbl (l_ptr).instance_amt_new :=
13690: l_subline_price;
13691:
13692: -- Fixed for bug 3751050
13693: UPDATE okc_k_lines_b
13694: SET price_negotiated =
13695: (SELECT NVL (SUM (NVL (price_negotiated,
13696: 0
13697: )

Line 13701: FROM okc_k_lines_b

13697: )
13698: ),
13699: 0
13700: )
13701: FROM okc_k_lines_b
13702: WHERE cle_id = l_line_id
13703: AND dnz_chr_id = l_chr_id)
13704: WHERE ID = l_line_id;
13705:

Line 13722: FROM okc_k_lines_b

13718: )
13719: ),
13720: 0
13721: )
13722: FROM okc_k_lines_b
13723: WHERE dnz_chr_id = l_chr_id
13724: AND lse_id IN (1, 19))
13725: WHERE ID = l_chr_id;
13726:

Line 13777: /*UPDATE okc_k_lines_b

13773: THEN
13774: RAISE g_exception_halt_validation;
13775: END IF;
13776:
13777: /*UPDATE okc_k_lines_b
13778: SET price_negotiated = ( SELECT NVL( SUM(NVL( price_negotiated, 0)),0 )
13779: FROM okc_k_lines_b
13780: WHERE cle_id = l_line_id
13781: AND dnz_chr_id = l_chr_id)

Line 13779: FROM okc_k_lines_b

13775: END IF;
13776:
13777: /*UPDATE okc_k_lines_b
13778: SET price_negotiated = ( SELECT NVL( SUM(NVL( price_negotiated, 0)),0 )
13779: FROM okc_k_lines_b
13780: WHERE cle_id = l_line_id
13781: AND dnz_chr_id = l_chr_id)
13782: WHERE id = l_line_id;
13783:

Line 13786: FROM okc_k_lines_b

13782: WHERE id = l_line_id;
13783:
13784: UPDATE okc_k_headers_b
13785: SET estimated_amount = ( SELECT NVL( SUM( NVL(price_negotiated,0) ), 0 )
13786: FROM okc_k_lines_b
13787: WHERE dnz_chr_id = l_chr_id
13788: AND lse_id in (1,19) )
13789: WHERE id = l_chr_id;*/
13790:

Line 13899: UPDATE okc_k_lines_b

13895: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
13896: RAISE g_exception_halt_validation;
13897: /*bugfix for 6882512*/ END IF;
13898:
13899: UPDATE okc_k_lines_b
13900: SET sts_code = l_sts_code
13901: WHERE dnz_chr_id = l_chr_id;
13902:
13903: l_wf_attr_details.contract_id := l_chr_id;

Line 14907: FROM okc_k_lines_b

14903: p_subline_id NUMBER
14904: )
14905: IS
14906: SELECT MIN (start_date) sdt, MAX (end_date) edt
14907: FROM okc_k_lines_b
14908: WHERE cle_id = p_topline_id
14909: AND dnz_chr_id = p_hdr_id
14910: AND lse_id = 18
14911: AND ID <> p_subline_id;

Line 14917: FROM okc_k_lines_b

14913: -- Cursor to get start and end date of top lines
14914: CURSOR l_topline_dates (p_hdr_id NUMBER, p_topline_id NUMBER)
14915: IS
14916: SELECT MIN (start_date) sdt, MAX (end_date) edt
14917: FROM okc_k_lines_b
14918: WHERE dnz_chr_id = p_hdr_id AND cle_id IS NULL
14919: AND ID <> p_topline_id;
14920:
14921: -- Cursor to get the header dates and status

Line 14925: FROM okc_k_lines_b

14921: -- Cursor to get the header dates and status
14922: CURSOR l_lndates_csr (p_id NUMBER)
14923: IS
14924: SELECT start_date, end_date
14925: FROM okc_k_lines_b
14926: WHERE ID = p_id;
14927:
14928: -- Cursor to get the line dates and status
14929: CURSOR l_hdrdates_csr (p_id NUMBER)

Line 15865: FROM okc_k_lines_b

15861:
15862: CURSOR l_amount_csr (p_cle_id NUMBER)
15863: IS
15864: SELECT price_negotiated
15865: FROM okc_k_lines_b
15866: WHERE ID = p_cle_id;
15867:
15868: l_cov_tbl oks_bill_rec_pub.covered_tbl;
15869: l_ptr NUMBER := 0;

Line 16118: UPDATE okc_k_lines_b

16114: INTO l_subline_amount;
16115:
16116: CLOSE l_amount_csr;
16117:
16118: UPDATE okc_k_lines_b
16119: SET price_negotiated =
16120: (SELECT NVL (SUM (NVL (price_negotiated, 0)),0)
16121: FROM okc_k_lines_b
16122: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id

Line 16121: FROM okc_k_lines_b

16117:
16118: UPDATE okc_k_lines_b
16119: SET price_negotiated =
16120: (SELECT NVL (SUM (NVL (price_negotiated, 0)),0)
16121: FROM okc_k_lines_b
16122: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
16123: AND dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16124: and date_cancelled is null)
16125: WHERE ID = p_kdtl_tbl (l_ctr).service_line_id;

Line 16132: FROM okc_k_lines_b

16128: SET tax_amount =
16129: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16130: FROM oks_k_lines_b
16131: WHERE cle_id IN ( SELECT id
16132: FROM okc_k_lines_b
16133: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
16134: AND lse_id IN (9,25)
16135: AND date_cancelled IS NULL ))
16136: WHERE cle_id =p_kdtl_tbl (l_ctr).service_line_id;

Line 16141: FROM okc_k_lines_b

16137:
16138: UPDATE okc_k_headers_b
16139: SET estimated_amount =
16140: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0 )
16141: FROM okc_k_lines_b
16142: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16143: AND lse_id IN (1, 19)
16144: AND date_cancelled IS NULL )
16145: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;

Line 16152: FROM okc_k_lineS_b

16148: UPDATE oks_k_headers_b
16149: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16150: FROM oks_k_lines_b
16151: WHERE cle_id IN (SELECT id
16152: FROM okc_k_lineS_b
16153: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16154: AND date_cancelled IS NULL
16155: AND lse_id IN (1,19)))
16156: WHERE chr_id = p_kdtl_tbl (l_ctr).hdr_id;

Line 16592: UPDATE okc_k_lines_b

16588: || l_subline_amount
16589: );
16590: END IF;
16591:
16592: UPDATE okc_k_lines_b
16593: SET price_negotiated =
16594: (SELECT NVL (SUM (NVL (price_negotiated,0 ) ), 0 )
16595: FROM okc_k_lines_b
16596: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id

Line 16595: FROM okc_k_lines_b

16591:
16592: UPDATE okc_k_lines_b
16593: SET price_negotiated =
16594: (SELECT NVL (SUM (NVL (price_negotiated,0 ) ), 0 )
16595: FROM okc_k_lines_b
16596: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
16597: AND dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16598: AND date_cancelled is NULL)
16599: WHERE ID = p_kdtl_tbl (l_ctr).service_line_id;

Line 16606: FROM okc_k_lines_b

16602: SET tax_amount =
16603: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16604: FROM oks_k_lines_b
16605: WHERE cle_id IN ( SELECT id
16606: FROM okc_k_lines_b
16607: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
16608: AND lse_id IN (9,25)
16609: AND date_cancelled IS NULL ))
16610: WHERE cle_id =p_kdtl_tbl (l_ctr).service_line_id;

Line 16620: FROM okc_k_lines_b

16616: )
16617: ),
16618: 0
16619: )
16620: FROM okc_k_lines_b
16621: WHERE dnz_chr_id =
16622: p_kdtl_tbl (l_ctr).hdr_id
16623: AND lse_id IN (1, 19)
16624: AND date_cancelled IS NULL)

Line 16631: FROM okc_k_lineS_b

16627: UPDATE oks_k_headers_b
16628: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16629: FROM oks_k_lines_b
16630: WHERE cle_id IN (SELECT id
16631: FROM okc_k_lineS_b
16632: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16633: AND date_cancelled IS NULL
16634: AND lse_id IN (1,19)))
16635: WHERE chr_id = p_kdtl_tbl (l_ctr).hdr_id;

Line 16783: UPDATE okc_k_lines_b

16779: l_amount := l_output_details.serv_ext_amount;
16780:
16781: IF l_amount <= l_billed_amount
16782: THEN
16783: UPDATE okc_k_lines_b
16784: SET price_negotiated = l_billed_amount
16785: WHERE ID = p_kdtl_tbl (l_ctr).object_line_id;
16786: END IF;
16787:

Line 16798: UPDATE okc_k_lines_b

16794: INTO l_subline_amount;
16795:
16796: CLOSE l_amount_csr;
16797:
16798: UPDATE okc_k_lines_b
16799: SET price_negotiated =
16800: (SELECT NVL (SUM (NVL (price_negotiated,
16801: 0
16802: )

Line 16806: FROM okc_k_lines_b

16802: )
16803: ),
16804: 0
16805: )
16806: FROM okc_k_lines_b
16807: WHERE cle_id =
16808: p_kdtl_tbl (l_ctr).service_line_id
16809: AND dnz_chr_id =
16810: p_kdtl_tbl (l_ctr).hdr_id

Line 16819: FROM okc_k_lines_b

16815: SET tax_amount =
16816: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16817: FROM oks_k_lines_b
16818: WHERE cle_id IN ( SELECT id
16819: FROM okc_k_lines_b
16820: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
16821: AND lse_id IN (9,25)
16822: AND date_cancelled IS NULL ))
16823: WHERE cle_id =p_kdtl_tbl (l_ctr).service_line_id;

Line 16833: FROM okc_k_lines_b

16829: )
16830: ),
16831: 0
16832: )
16833: FROM okc_k_lines_b
16834: WHERE dnz_chr_id =
16835: p_kdtl_tbl (l_ctr).hdr_id
16836: AND lse_id IN (1, 19)
16837: AND date_cancelled IS NULL)

Line 16845: FROM okc_k_lineS_b

16841: UPDATE oks_k_headers_b
16842: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16843: FROM oks_k_lines_b
16844: WHERE cle_id IN (SELECT id
16845: FROM okc_k_lineS_b
16846: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16847: AND date_cancelled IS NULL
16848: AND lse_id IN (1,19)))
16849: WHERE chr_id = p_kdtl_tbl (l_ctr).hdr_id;