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

Line 247: SELECT id from okc_k_lines_b

243:
244: FUNCTION chk_coverage_Exists(p_cle_id IN NUMBER) return BOOLEAN IS
245:
246: CURSOR l_coverage_csr(p_cle_id NUMBER) IS
247: SELECT id from okc_k_lines_b
248: WHERE cle_id = p_cle_id
249: and lse_id in (2,20);
250:
251: CURSOR check_oks_csr(p_line_id number) is

Line 640: FROM okc_k_lines_b

636: WHERE cle_id = p_cle_id;
637:
638: CURSOR get_lines_details_csr (p_cle_id NUMBER) IS
639: SELECT date_terminated, price_list_id
640: FROM okc_k_lines_b
641: WHERE id = p_cle_id;
642: -- Added for price lock
643: cursor get_contract_number(l_chr_id number) is
644: select contract_number

Line 886: From OKC_K_LINES_B

882: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
883:
884:
885: Cursor l_line_csr Is Select Sum(Nvl(PRICE_NEGOTIATED,0))
886: From OKC_K_LINES_B
887: Where dnz_chr_id = p_chr_id And
888: lse_id in (7,8,9,10,11,35,25);
889:
890: l_hdr_amount Number;

Line 1459: FROM okc_k_lines_b

1455:
1456: Cursor get_subscr_toplines(p_new_chr_id IN NUMBER,
1457: p_cle_id IN NUMBER) IS
1458: SELECT id, NVL(orig_system_id1, cle_id_renewed) old_line_id
1459: FROM okc_k_lines_b
1460: WHERE dnz_chr_id = p_new_chr_id and lse_id = 46
1461: AND id=p_cle_id;
1462:
1463: Cursor get_subscr_toplines_C(p_new_chr_id IN NUMBER

Line 1466: FROM okc_k_lines_b

1462:
1463: Cursor get_subscr_toplines_C(p_new_chr_id IN NUMBER
1464: ) IS
1465: SELECT id, NVL(orig_system_id1, cle_id_renewed) old_line_id
1466: FROM okc_k_lines_b
1467: WHERE dnz_chr_id = p_new_chr_id and lse_id = 46;
1468:
1469:
1470:

Line 1493: FROM okc_k_lines_b a, okc_k_items b

1489:
1490: -- Gets the new covered lines that are covering the old item instance.
1491: Cursor get_new_cps(oldItemInst number) IS
1492: SELECT b.id
1493: FROM okc_k_lines_b a, okc_k_items b
1494: WHERE b.cle_id = a.id and a.lse_id = 9 and b.object1_id1 = oldItemInst
1495: AND a.dnz_chr_id = p_new_chr_id;
1496:
1497: Begin

Line 1650: FROM okc_k_lines_b okc,

1646: IS
1647: Cursor get_billing_info is
1648: SELECT okc.inv_rule_id,
1649: oks.billing_schedule_type
1650: FROM okc_k_lines_b okc,
1651: oks_k_lines_b oks
1652: WHERE okc.id=p_cle_id
1653: AND okc.id=oks.cle_id;
1654:

Line 1686: FROM okc_k_lines_b line, oks_k_lines_b dtl

1682: CURSOR get_orig_line_amount(l_orig_line_id number) is
1683: SELECT TRUNC(date_terminated) line_term_dt,
1684: (nvl(line.price_negotiated,0) +nvl(dtl.ubt_amount,0) +
1685: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
1686: FROM okc_k_lines_b line, oks_k_lines_b dtl
1687: WHERE line.id = dtl.cle_id AND line.Id = l_orig_line_id;
1688:
1689: l_orig_line_rec get_orig_line_amount%ROWTYPE;
1690:

Line 1693: from okc_k_lines_b

1689: l_orig_line_rec get_orig_line_amount%ROWTYPE;
1690:
1691: CURSOR get_price(l_new_line_id number) is
1692: select price_negotiated
1693: from okc_k_lines_b
1694: where id = l_new_line_id;
1695:
1696: l_new_price number;
1697:

Line 1753: FROM okc_k_lines_b

1749: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1750:
1751: CURSOR old_cle_csr(p_cle_id NUMBER) IS
1752: SELECT orig_system_id1
1753: FROM okc_k_lines_b
1754: WHERE id=p_cle_id;
1755:
1756: CURSOR was_line_terminated(p_old_cle_id number) is
1757: select date_terminated

Line 1758: from okc_k_lines_b

1754: WHERE id=p_cle_id;
1755:
1756: CURSOR was_line_terminated(p_old_cle_id number) is
1757: select date_terminated
1758: from okc_k_lines_b
1759: where id = p_old_cle_id ;
1760:
1761: CURSOR strlvl_csr (p_cle_id NUMBER) IS
1762: SELECT ID

Line 1956: FROM okc_k_lines_b lines

1952: CURSOR sub_line_grp_csr (p_chr_id NUMBER,p_cle_id NUMBER) IS
1953: SELECT
1954: lines.id,
1955: lines.start_date,lines.dnz_chr_id,lines.orig_system_id1
1956: FROM okc_k_lines_b lines
1957: WHERE lines.dnz_chr_id = p_chr_id
1958: AND lines.cle_id = p_cle_id
1959: AND lines.lse_id in (7,8,9,10,11,13,18,25,35);
1960:

Line 1963: FROM okc_k_lines_b

1959: AND lines.lse_id in (7,8,9,10,11,13,18,25,35);
1960:
1961: CURSOR get_adv_arr_csr (p_cle_id NUMBER) IS
1962: SELECT inv_rule_id,cle_id
1963: FROM okc_k_lines_b
1964: WHERE id=p_cle_id;
1965:
1966: CURSOR Subline_Billsch_type(p_cle_id NUMBER) IS
1967: SELECT Billing_schedule_type

Line 2062: UPDATE okc_k_lines_b set

2058: END LOOP; --FOR sub_line_grp_rec IN sub_line_grp_csr (p_chr_id,p_cle_id)
2059:
2060:
2061: IF p_upd_line_flag IS NULL and p_chr_id is not null THEN
2062: UPDATE okc_k_lines_b set
2063: price_negotiated = (SELECT sum(price_negotiated) FROM okc_k_lines_b
2064: WHERE dnz_chr_id = p_chr_id AND chr_id is null
2065: AND cle_id = p_cle_id)
2066: WHERE lse_id in (1, 19, 12) -- added 12 in the IN clause for bug # 3534513

Line 2063: price_negotiated = (SELECT sum(price_negotiated) FROM okc_k_lines_b

2059:
2060:
2061: IF p_upd_line_flag IS NULL and p_chr_id is not null THEN
2062: UPDATE okc_k_lines_b set
2063: price_negotiated = (SELECT sum(price_negotiated) FROM okc_k_lines_b
2064: WHERE dnz_chr_id = p_chr_id AND chr_id is null
2065: AND cle_id = p_cle_id)
2066: WHERE lse_id in (1, 19, 12) -- added 12 in the IN clause for bug # 3534513
2067: AND chr_id = p_chr_id and id = p_cle_id;

Line 2323: FROM OKC_K_LINES_B

2319: where chr_id=p_chr_id;
2320:
2321: CURSOR get_toplines(p_chr_id number) IS
2322: SELECT id,object_version_number
2323: FROM OKC_K_LINES_B
2324: WHERE chr_id = p_chr_id
2325: AND lse_id IN (1,12,19,46);
2326:
2327: CURSOR get_okstoplines(p_cle_id NUMBER) IS

Line 2554: SELECT ID FROM OKC_K_LINES_B

2550: l_old_chr_id number;
2551:
2552:
2553: CURSOR csr_top_lines(p_chr_id number) IS
2554: SELECT ID FROM OKC_K_LINES_B
2555: WHERE CHR_ID = P_CHR_ID AND LSE_ID IN (1,12,19,46);
2556:
2557: CURSOR hdr_top_line_grp_csr (p_chr_id NUMBER) IS
2558: SELECT

Line 2564: FROM okc_k_lines_b lines

2560: lines.start_date,
2561: lines.orig_system_id1,
2562: lines.dnz_chr_id,
2563: lines.lse_id
2564: FROM okc_k_lines_b lines
2565: WHERE lines.dnz_chr_id = p_chr_id
2566: AND lines.cle_id IS NULL
2567: AND lines.lse_id IN (1,12,19, 46)
2568: ORDER BY lines.id;

Line 2578: FROM okc_k_lines_b lines

2574: lines.orig_system_id1,
2575: lines.dnz_chr_id,
2576: lines.lse_id,
2577: price_list_id
2578: FROM okc_k_lines_b lines
2579: WHERE lines.dnz_chr_id = p_chr_id
2580: AND lines.cle_id IS NULL
2581: AND lines.lse_id IN (1,12,19, 46)
2582: ORDER BY lines.id;

Line 2591: FROM okc_k_lines_b lines

2587: lines.start_date,
2588: lines.orig_system_id1,
2589: lines.dnz_chr_id,
2590: lines.lse_id
2591: FROM okc_k_lines_b lines
2592: WHERE lines.dnz_chr_id = p_chr_id
2593: AND lines.id = p_cle_id
2594: AND lines.lse_id IN (1,12,19, 46,7,8,9,10,11,35,13,18,25)
2595: ORDER BY lines.id;

Line 2612: from okc_k_lines_b

2608: LOCKED_PRICE_LIST_LINE_ID is not null);
2609:
2610: cursor get_price_list(l_cle_id number) is
2611: select PRICE_LIST_ID
2612: from okc_k_lines_b
2613: where id = l_cle_id;
2614:
2615: CURSOR get_all_lines_csr (p_chr_id NUMBER) IS
2616: SELECT

Line 2623: FROM okc_k_lines_b lines

2619: lines.orig_system_id1,
2620: lines.dnz_chr_id,
2621: lines.lse_id,
2622: lines.price_list_id
2623: FROM okc_k_lines_b lines
2624: WHERE lines.dnz_chr_id = p_chr_id
2625: AND lines.lse_id IN (12,13);
2626:
2627: cursor get_contract_number(l_chr_id number) is

Line 2663: FROM okc_k_lines_b

2659: -- Get all top lines
2660: /*
2661: CURSOR get_top_lines(P_CHR_ID IN NUMBER) IS
2662: SELECT id
2663: FROM okc_k_lines_b
2664: WHERE chr_id = p_chr_id
2665: AND cle_id is null;
2666: */
2667:

Line 2677: from okc_k_lines_b

2673: WHERE subject_chr_id =l_new_chr_id and object_chr_id is not null;
2674:
2675: Cursor is_terminated(l_old_chr_id number) IS
2676: select line_number
2677: from okc_k_lines_b
2678: where dnz_chr_id = l_old_chr_id
2679: and date_terminated is not null;
2680:
2681: cursor cur_pradj (p_chr_id NUMBEr) is

Line 2688: select id from okc_k_lines_b

2684: where chr_id =p_chr_id
2685: and cle_id is not null;
2686:
2687: cursor is_line_copy(l_new_chr_id number, l_old_chr_id number) is
2688: select id from okc_k_lines_b
2689: where dnz_chr_id = l_new_chr_id and
2690: orig_system_id1 not in (select id from okc_k_lines_b where dnz_chr_id = l_old_chr_id);
2691:
2692: l_oldchr_id NUMBER;

Line 2690: orig_system_id1 not in (select id from okc_k_lines_b where dnz_chr_id = l_old_chr_id);

2686:
2687: cursor is_line_copy(l_new_chr_id number, l_old_chr_id number) is
2688: select id from okc_k_lines_b
2689: where dnz_chr_id = l_new_chr_id and
2690: orig_system_id1 not in (select id from okc_k_lines_b where dnz_chr_id = l_old_chr_id);
2691:
2692: l_oldchr_id NUMBER;
2693: l_duration_match VARCHAR2(1) := 'F';
2694: l_billing_schedule_type VARCHAR2(30);

Line 3043: UPDATE okc_k_lines_b set

3039: IF l_topline_count>0 Then
3040:
3041: FOR top_lines_rec IN csr_top_lines(p_chr_id)
3042: LOOP
3043: UPDATE okc_k_lines_b set
3044: price_negotiated = (SELECT sum(price_negotiated) FROM okc_k_lines_b
3045: WHERE dnz_chr_id = p_chr_id AND chr_id is null
3046: AND cle_id = top_lines_rec.id)
3047: WHERE lse_id in (1, 19, 12) -- added lse id 12 for bug # 3534513

Line 3044: price_negotiated = (SELECT sum(price_negotiated) FROM okc_k_lines_b

3040:
3041: FOR top_lines_rec IN csr_top_lines(p_chr_id)
3042: LOOP
3043: UPDATE okc_k_lines_b set
3044: price_negotiated = (SELECT sum(price_negotiated) FROM okc_k_lines_b
3045: WHERE dnz_chr_id = p_chr_id AND chr_id is null
3046: AND cle_id = top_lines_rec.id)
3047: WHERE lse_id in (1, 19, 12) -- added lse id 12 for bug # 3534513
3048: AND chr_id = p_chr_id AND id = top_lines_rec.id;

Line 3434: (select sum(price_negotiated) from okc_k_lines_b

3430:
3431: -- Get the sum of all the top lines.
3432: update okc_k_headers_b set
3433: estimated_amount =
3434: (select sum(price_negotiated) from okc_k_lines_b
3435: where dnz_chr_id = p_chr_id and cle_id is null)
3436: where id = p_chr_id;
3437: End If;
3438:

Line 3578: FROM OKC_K_LINES_B

3574: -- will select all covered levels for given cle_id
3575:
3576: CURSOR l_csr_okc_k_lines IS
3577: SELECT id
3578: FROM OKC_K_LINES_B
3579: where dnz_chr_id = p_chr_id
3580: and cle_id = p_cle_id
3581: and lse_id IN (7,8,9,10,11,35,13,18,25);
3582:

Line 3600: UPDATE okc_k_lines_b

3596: FETCH l_csr_okc_k_lines INTO l_subline_id;
3597: IF l_csr_okc_k_lines%FOUND THEN
3598:
3599: l_line_seq_no := l_line_seq_no + 1;
3600: UPDATE okc_k_lines_b
3601: SET line_number = l_line_seq_no
3602: WHERE id = l_subline_id;
3603:
3604: ELSE

Line 3639: FROM OKC_K_LINES_B

3635: AND id =p_chr_id;
3636:
3637: Cursor l_csr_top_line(p_chr_id NUMBER) IS
3638: SELECT id
3639: FROM OKC_K_LINES_B
3640: Where dnz_chr_id = p_chr_id
3641: and lse_id IN (1,12,14,19, 46)
3642: order by line_number;
3643:

Line 3647: FROM OKC_K_LINES_B

3643:
3644:
3645: CURSOR l_csr_okc_k_lines(p_top_line_id NUMBER) IS
3646: SELECT id
3647: FROM OKC_K_LINES_B
3648: where cle_id = p_top_line_id
3649: and lse_id IN (7,8,9,10,11,35,13,18,25);
3650:
3651:

Line 3688: UPDATE OKC_K_LINES_B

3684: ELSE
3685: l_topline_seq := l_topline_seq + 1;
3686:
3687: If p_update_top_line Then
3688: UPDATE OKC_K_LINES_B
3689: SET line_number = l_topline_seq
3690: WHERE id = l_topline_id;
3691: End If;
3692:

Line 3701: UPDATE okc_k_lines_b

3697: FETCH l_csr_okc_k_lines INTO l_subline_id;
3698: IF l_csr_okc_k_lines%FOUND THEN
3699:
3700: l_line_seq_no := l_line_seq_no + 1;
3701: UPDATE okc_k_lines_b
3702: SET line_number = l_line_seq_no
3703: WHERE id = l_subline_id;
3704:
3705:

Line 4149: select id from okc_k_lines_b where cle_id = l_cle_id;

4145: l_counter number := 1;
4146: l_temp_counter number := 1;
4147:
4148: cursor get_child(l_cle_id number) is
4149: select id from okc_k_lines_b where cle_id = l_cle_id;
4150:
4151: Type t_number_tbl is table of number Index by BINARY_INTEGER;
4152:
4153:

Line 4236: SELECT ID FROM OKC_K_Lines_b

4232: x_msg_data OUT NOCOPY VARCHAR2) IS
4233:
4234: -- Get all lines
4235: CURSOR Cur_Line (P_Chr_Id IN NUMBER) IS
4236: SELECT ID FROM OKC_K_Lines_b
4237: WHERE chr_ID=p_chr_Id;
4238:
4239: CURSOR Cur_gov (P_chr_Id IN NUMBER) IS
4240: SELECT ID FROM OKC_GOVERNANCES

Line 4249: from okc_k_lines_b a

4245: select id from oks_k_headers_b where chr_id = p_chr_id;
4246:
4247: cursor topline_csr(p_chr_id number) is
4248: select a.id, a.lse_id
4249: from okc_k_lines_b a
4250: where a.dnz_chr_id = p_chr_id and a.cle_id IS NULL;
4251:
4252:
4253: l_khrv_rec oks_contract_hdr_pub.khrv_rec_type;

Line 4504: from okc_k_lines_b

4500: l_msg_data VARCHAR2(2000):=null;
4501:
4502: cursor get_line_type(l_line_id number) is
4503: select lse_id, cle_id
4504: from okc_k_lines_b
4505: where id = l_line_id;
4506:
4507:
4508: l_klnv_rec oks_contract_line_pub.klnv_rec_type;

Line 4680: okc_k_lines_b d

4676: SELECT subject_cle_id
4677: FROM okc_operation_lines a,
4678: okc_operation_instances b,
4679: okc_class_operations c,
4680: okc_k_lines_b d
4681: where a.object_cle_id = d.id and
4682: d.cle_id = p_cle_id and -- should be a top line id
4683: a.object_chr_id = p_chr_id and
4684: c.id=b.cop_id and

Line 4786: p_line_id : id of the top line/subline from OKC_K_LINES_B table

4782: OKS_SETUP_UTIL_PUB.Delete_Contract_Line and adds stuff that authoring does and some other
4783: stuff that nobody seems to be doing
4784:
4785: Parameters
4786: p_line_id : id of the top line/subline from OKC_K_LINES_B table
4787: */
4788:
4789: PROCEDURE DELETE_TOP_SUB_LINE
4790: (

Line 4810: FROM okc_k_lines_b a

4806: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4807:
4808: CURSOR c_chk_transfer(cp_line_id IN NUMBER) IS
4809: SELECT id
4810: FROM okc_k_lines_b a
4811: WHERE (a.id = cp_line_id OR a.cle_id = cp_line_id)
4812: AND lse_id IN (1,12,14,19,46, 7,8,9,10,11,35, 13, 18, 25)
4813: AND nvl(term_cancel_source, 'X') IN ('IBTRANSFER', 'IBTERMINATE', 'IBRETURN');
4814:

Line 4818: FROM okc_k_lines_b a, oks_k_lines_b b

4814:
4815: CURSOR c_get_line_type(cp_line_id IN NUMBER) IS
4816: SELECT a.lse_id, a.cle_id, a.cust_acct_id, a.bill_to_site_use_id,
4817: b.locked_price_list_line_id, b.trxn_extension_id
4818: FROM okc_k_lines_b a, oks_k_lines_b b
4819: WHERE a.id = cp_line_id
4820: AND b.cle_id = a.id;
4821:
4822: CURSOR c_usage_sub_lines(cp_line_id IN NUMBER) IS

Line 4824: FROM okc_k_lines_b a, oks_k_lines_b b

4820: AND b.cle_id = a.id;
4821:
4822: CURSOR c_usage_sub_lines(cp_line_id IN NUMBER) IS
4823: SELECT b.locked_price_list_line_id
4824: FROM okc_k_lines_b a, oks_k_lines_b b
4825: WHERE a.cle_id = cp_line_id
4826: AND b.cle_id = a.id;
4827:
4828: CURSOR c_get_child_lines(cp_line_id IN NUMBER) IS

Line 4830: FROM okc_k_lines_b

4826: AND b.cle_id = a.id;
4827:
4828: CURSOR c_get_child_lines(cp_line_id IN NUMBER) IS
4829: SELECT id
4830: FROM okc_k_lines_b
4831: CONNECT BY PRIOR id = cle_id
4832: START WITH id = cp_line_id;
4833:
4834: CURSOR c_party_from_billto(cp_bill_to_site_use_id IN NUMBER) IS

Line 5438: -- Manager processing for OKC_K_LINES_B table

5434: P_Num_Workers in number)
5435: IS
5436: BEGIN
5437: --
5438: -- Manager processing for OKC_K_LINES_B table
5439: --
5440: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5441: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5442: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

Line 5444: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');

5440: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5441: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5442: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5443:
5444: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');
5445:
5446: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5447: X_retcode,
5448: 'OKS',

Line 5465: -- Manager processing for OKC_K_LINES_BH table

5461: P_Num_Workers in number)
5462: IS
5463: BEGIN
5464: --
5465: -- Manager processing for OKC_K_LINES_BH table
5466: --
5467: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5468: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5469: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

Line 5471: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');

5467: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5468: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5469: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5470:
5471: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5472:
5473: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5474: X_retcode,
5475: 'OKS',

Line 5516: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');

5512: then
5513: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5514: end if;
5515:
5516: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');
5517: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5518: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5519:
5520: --

Line 5559: okc_k_lines_b cle

5555: / (cle.end_date - cle.start_date + 1)
5556: ELSE cle.annualized_factor
5557: end new_annualized_factor
5558: from okc_k_headers_all_b hdr,
5559: okc_k_lines_b cle
5560: where hdr.rowid between l_start_rowid and l_end_rowid
5561: and hdr.id = cle.dnz_chr_id
5562: and hdr.scs_code in ('SERVICE', 'WARRANTY', 'SUBSCRIPTION'))
5563: set payment_instruction_type = hdr_payment_instruction_type,

Line 5576: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_B table completed successfully');

5572: l_any_rows_to_process,
5573: P_batch_size,
5574: FALSE);
5575: end loop;
5576: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_B table completed successfully');
5577: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
5578: X_errbuf := ' ';
5579: EXCEPTION
5580: WHEN OTHERS THEN

Line 5620: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');

5616: then
5617: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5618: end if;
5619:
5620: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');
5621: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5622: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5623:
5624: --

Line 5662: okc_k_lines_bh cle

5658: / (cle.end_date - cle.start_date + 1)
5659: ELSE cle.annualized_factor
5660: end new_annualized_factor
5661: from okc_k_headers_all_bh hdr,
5662: okc_k_lines_bh cle
5663: where hdr.rowid between l_start_rowid and l_end_rowid
5664: and hdr.id = cle.dnz_chr_id
5665: and hdr.major_version = cle.major_version
5666: and hdr.scs_code in ('SERVICE', 'WARRANTY', 'SUBSCRIPTION'))

Line 5680: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_BH table completed successfully');

5676: l_any_rows_to_process,
5677: P_batch_size,
5678: FALSE);
5679: end loop;
5680: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_BH table completed successfully');
5681: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
5682: X_errbuf := ' ';
5683: EXCEPTION
5684: WHEN OTHERS THEN