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 645: FROM okc_k_lines_b

641: WHERE cle_id = p_cle_id;
642:
643: CURSOR get_lines_details_csr (p_cle_id NUMBER) IS
644: SELECT date_terminated, price_list_id
645: FROM okc_k_lines_b
646: WHERE id = p_cle_id;
647: -- Added for price lock
648: cursor get_contract_number(l_chr_id number) is
649: select contract_number

Line 892: From OKC_K_LINES_B

888: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
889:
890:
891: Cursor l_line_csr Is Select Sum(Nvl(PRICE_NEGOTIATED,0))
892: From OKC_K_LINES_B
893: Where dnz_chr_id = p_chr_id And
894: lse_id in (7,8,9,10,11,35,25);
895:
896: l_hdr_amount Number;

Line 1467: FROM okc_k_lines_b

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

Line 1474: FROM okc_k_lines_b

1470:
1471: Cursor get_subscr_toplines_C(p_new_chr_id IN NUMBER
1472: ) IS
1473: SELECT id, NVL(orig_system_id1, cle_id_renewed) old_line_id
1474: FROM okc_k_lines_b
1475: WHERE dnz_chr_id = p_new_chr_id and lse_id = 46;
1476:
1477:
1478:

Line 1501: FROM okc_k_lines_b a, okc_k_items b

1497:
1498: -- Gets the new covered lines that are covering the old item instance.
1499: Cursor get_new_cps(oldItemInst number) IS
1500: SELECT b.id
1501: FROM okc_k_lines_b a, okc_k_items b
1502: WHERE b.cle_id = a.id and a.lse_id = 9 and b.object1_id1 = oldItemInst
1503: AND a.dnz_chr_id = p_new_chr_id;
1504:
1505: Begin

Line 1658: FROM okc_k_lines_b okc,

1654: IS
1655: Cursor get_billing_info is
1656: SELECT okc.inv_rule_id,
1657: oks.billing_schedule_type
1658: FROM okc_k_lines_b okc,
1659: oks_k_lines_b oks
1660: WHERE okc.id=p_cle_id
1661: AND okc.id=oks.cle_id;
1662:

Line 1694: FROM okc_k_lines_b line, oks_k_lines_b dtl

1690: CURSOR get_orig_line_amount(l_orig_line_id number) is
1691: SELECT TRUNC(date_terminated) line_term_dt,
1692: (nvl(line.price_negotiated,0) +nvl(dtl.ubt_amount,0) +
1693: nvl(dtl.credit_amount,0) + nvl(dtl.suppressed_credit,0) ) line_amt
1694: FROM okc_k_lines_b line, oks_k_lines_b dtl
1695: WHERE line.id = dtl.cle_id AND line.Id = l_orig_line_id;
1696:
1697: l_orig_line_rec get_orig_line_amount%ROWTYPE;
1698:

Line 1701: from okc_k_lines_b

1697: l_orig_line_rec get_orig_line_amount%ROWTYPE;
1698:
1699: CURSOR get_price(l_new_line_id number) is
1700: select price_negotiated
1701: from okc_k_lines_b
1702: where id = l_new_line_id;
1703:
1704: l_new_price number;
1705:

Line 1761: FROM okc_k_lines_b

1757: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1758:
1759: CURSOR old_cle_csr(p_cle_id NUMBER) IS
1760: SELECT orig_system_id1
1761: FROM okc_k_lines_b
1762: WHERE id=p_cle_id;
1763:
1764: CURSOR was_line_terminated(p_old_cle_id number) is
1765: select date_terminated

Line 1766: from okc_k_lines_b

1762: WHERE id=p_cle_id;
1763:
1764: CURSOR was_line_terminated(p_old_cle_id number) is
1765: select date_terminated
1766: from okc_k_lines_b
1767: where id = p_old_cle_id ;
1768:
1769: CURSOR strlvl_csr (p_cle_id NUMBER) IS
1770: SELECT ID

Line 1965: FROM okc_k_lines_b lines

1961: CURSOR sub_line_grp_csr (p_chr_id NUMBER,p_cle_id NUMBER) IS
1962: SELECT
1963: lines.id,
1964: lines.start_date,lines.dnz_chr_id,lines.orig_system_id1
1965: FROM okc_k_lines_b lines
1966: WHERE lines.dnz_chr_id = p_chr_id
1967: AND lines.cle_id = p_cle_id
1968: AND lines.lse_id in (7,8,9,10,11,13,18,25,35);
1969:

Line 1972: FROM okc_k_lines_b

1968: AND lines.lse_id in (7,8,9,10,11,13,18,25,35);
1969:
1970: CURSOR get_adv_arr_csr (p_cle_id NUMBER) IS
1971: SELECT inv_rule_id,cle_id
1972: FROM okc_k_lines_b
1973: WHERE id=p_cle_id;
1974:
1975: CURSOR Subline_Billsch_type(p_cle_id NUMBER) IS
1976: SELECT Billing_schedule_type

Line 2071: UPDATE okc_k_lines_b set

2067: END LOOP; --FOR sub_line_grp_rec IN sub_line_grp_csr (p_chr_id,p_cle_id)
2068:
2069:
2070: IF p_upd_line_flag IS NULL and p_chr_id is not null THEN
2071: UPDATE okc_k_lines_b set
2072: price_negotiated = (SELECT sum(price_negotiated) FROM okc_k_lines_b
2073: WHERE dnz_chr_id = p_chr_id AND chr_id is null
2074: AND cle_id = p_cle_id)
2075: WHERE lse_id in (1, 19, 12) -- added 12 in the IN clause for bug # 3534513

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

2068:
2069:
2070: IF p_upd_line_flag IS NULL and p_chr_id is not null THEN
2071: UPDATE okc_k_lines_b set
2072: price_negotiated = (SELECT sum(price_negotiated) FROM okc_k_lines_b
2073: WHERE dnz_chr_id = p_chr_id AND chr_id is null
2074: AND cle_id = p_cle_id)
2075: WHERE lse_id in (1, 19, 12) -- added 12 in the IN clause for bug # 3534513
2076: AND chr_id = p_chr_id and id = p_cle_id;

Line 2332: FROM OKC_K_LINES_B

2328: where chr_id=p_chr_id;
2329:
2330: CURSOR get_toplines(p_chr_id number) IS
2331: SELECT id,object_version_number
2332: FROM OKC_K_LINES_B
2333: WHERE chr_id = p_chr_id
2334: AND lse_id IN (1,12,19,46);
2335:
2336: CURSOR get_okstoplines(p_cle_id NUMBER) IS

Line 2563: SELECT ID FROM OKC_K_LINES_B

2559: l_old_chr_id number;
2560:
2561:
2562: CURSOR csr_top_lines(p_chr_id number) IS
2563: SELECT ID FROM OKC_K_LINES_B
2564: WHERE CHR_ID = P_CHR_ID AND LSE_ID IN (1,12,19,46);
2565:
2566: CURSOR hdr_top_line_grp_csr (p_chr_id NUMBER) IS
2567: SELECT

Line 2573: FROM okc_k_lines_b lines

2569: lines.start_date,
2570: lines.orig_system_id1,
2571: lines.dnz_chr_id,
2572: lines.lse_id
2573: FROM okc_k_lines_b lines
2574: WHERE lines.dnz_chr_id = p_chr_id
2575: AND lines.cle_id IS NULL
2576: AND lines.lse_id IN (1,12,19, 46)
2577: ORDER BY lines.id;

Line 2587: FROM okc_k_lines_b lines

2583: lines.orig_system_id1,
2584: lines.dnz_chr_id,
2585: lines.lse_id,
2586: price_list_id
2587: FROM okc_k_lines_b lines
2588: WHERE lines.dnz_chr_id = p_chr_id
2589: AND lines.cle_id IS NULL
2590: AND lines.lse_id IN (1,12,19, 46)
2591: ORDER BY lines.id;

Line 2600: FROM okc_k_lines_b lines

2596: lines.start_date,
2597: lines.orig_system_id1,
2598: lines.dnz_chr_id,
2599: lines.lse_id
2600: FROM okc_k_lines_b lines
2601: WHERE lines.dnz_chr_id = p_chr_id
2602: AND lines.id = p_cle_id
2603: AND lines.lse_id IN (1,12,19, 46,7,8,9,10,11,35,13,18,25)
2604: ORDER BY lines.id;

Line 2621: from okc_k_lines_b

2617: LOCKED_PRICE_LIST_LINE_ID is not null);
2618:
2619: cursor get_price_list(l_cle_id number) is
2620: select PRICE_LIST_ID
2621: from okc_k_lines_b
2622: where id = l_cle_id;
2623:
2624: CURSOR get_all_lines_csr (p_chr_id NUMBER) IS
2625: SELECT

Line 2632: FROM okc_k_lines_b lines

2628: lines.orig_system_id1,
2629: lines.dnz_chr_id,
2630: lines.lse_id,
2631: lines.price_list_id
2632: FROM okc_k_lines_b lines
2633: WHERE lines.dnz_chr_id = p_chr_id
2634: AND lines.lse_id IN (12,13);
2635:
2636: cursor get_contract_number(l_chr_id number) is

Line 2672: FROM okc_k_lines_b

2668: -- Get all top lines
2669: /*
2670: CURSOR get_top_lines(P_CHR_ID IN NUMBER) IS
2671: SELECT id
2672: FROM okc_k_lines_b
2673: WHERE chr_id = p_chr_id
2674: AND cle_id is null;
2675: */
2676:

Line 2686: from okc_k_lines_b

2682: WHERE subject_chr_id =l_new_chr_id and object_chr_id is not null;
2683:
2684: Cursor is_terminated(l_old_chr_id number) IS
2685: select line_number
2686: from okc_k_lines_b
2687: where dnz_chr_id = l_old_chr_id
2688: and date_terminated is not null;
2689:
2690: cursor cur_pradj (p_chr_id NUMBEr) is

Line 2697: select id from okc_k_lines_b

2693: where chr_id =p_chr_id
2694: and cle_id is not null;
2695:
2696: cursor is_line_copy(l_new_chr_id number, l_old_chr_id number) is
2697: select id from okc_k_lines_b
2698: where dnz_chr_id = l_new_chr_id and
2699: orig_system_id1 not in (select id from okc_k_lines_b where dnz_chr_id = l_old_chr_id);
2700:
2701: l_oldchr_id NUMBER;

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

2695:
2696: cursor is_line_copy(l_new_chr_id number, l_old_chr_id number) is
2697: select id from okc_k_lines_b
2698: where dnz_chr_id = l_new_chr_id and
2699: orig_system_id1 not in (select id from okc_k_lines_b where dnz_chr_id = l_old_chr_id);
2700:
2701: l_oldchr_id NUMBER;
2702: l_duration_match VARCHAR2(1) := 'F';
2703: l_billing_schedule_type VARCHAR2(30);

Line 3052: UPDATE okc_k_lines_b set

3048: IF l_topline_count>0 Then
3049:
3050: FOR top_lines_rec IN csr_top_lines(p_chr_id)
3051: LOOP
3052: UPDATE okc_k_lines_b set
3053: price_negotiated = (SELECT sum(price_negotiated) FROM okc_k_lines_b
3054: WHERE dnz_chr_id = p_chr_id AND chr_id is null
3055: AND cle_id = top_lines_rec.id)
3056: WHERE lse_id in (1, 19, 12) -- added lse id 12 for bug # 3534513

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

3049:
3050: FOR top_lines_rec IN csr_top_lines(p_chr_id)
3051: LOOP
3052: UPDATE okc_k_lines_b set
3053: price_negotiated = (SELECT sum(price_negotiated) FROM okc_k_lines_b
3054: WHERE dnz_chr_id = p_chr_id AND chr_id is null
3055: AND cle_id = top_lines_rec.id)
3056: WHERE lse_id in (1, 19, 12) -- added lse id 12 for bug # 3534513
3057: AND chr_id = p_chr_id AND id = top_lines_rec.id;

Line 3443: (select sum(price_negotiated) from okc_k_lines_b

3439:
3440: -- Get the sum of all the top lines.
3441: update okc_k_headers_b set
3442: estimated_amount =
3443: (select sum(price_negotiated) from okc_k_lines_b
3444: where dnz_chr_id = p_chr_id and cle_id is null)
3445: where id = p_chr_id;
3446: End If;
3447:

Line 3587: FROM OKC_K_LINES_B

3583: -- will select all covered levels for given cle_id
3584:
3585: CURSOR l_csr_okc_k_lines IS
3586: SELECT id
3587: FROM OKC_K_LINES_B
3588: where dnz_chr_id = p_chr_id
3589: and cle_id = p_cle_id
3590: and lse_id IN (7,8,9,10,11,35,13,18,25);
3591:

Line 3609: UPDATE okc_k_lines_b

3605: FETCH l_csr_okc_k_lines INTO l_subline_id;
3606: IF l_csr_okc_k_lines%FOUND THEN
3607:
3608: l_line_seq_no := l_line_seq_no + 1;
3609: UPDATE okc_k_lines_b
3610: SET line_number = l_line_seq_no
3611: WHERE id = l_subline_id;
3612:
3613: ELSE

Line 3648: FROM OKC_K_LINES_B

3644: AND id =p_chr_id;
3645:
3646: Cursor l_csr_top_line(p_chr_id NUMBER) IS
3647: SELECT id
3648: FROM OKC_K_LINES_B
3649: Where dnz_chr_id = p_chr_id
3650: and lse_id IN (1,12,14,19, 46)
3651: order by line_number;
3652:

Line 3656: FROM OKC_K_LINES_B

3652:
3653:
3654: CURSOR l_csr_okc_k_lines(p_top_line_id NUMBER) IS
3655: SELECT id
3656: FROM OKC_K_LINES_B
3657: where cle_id = p_top_line_id
3658: and lse_id IN (7,8,9,10,11,35,13,18,25);
3659:
3660:

Line 3697: UPDATE OKC_K_LINES_B

3693: ELSE
3694: l_topline_seq := l_topline_seq + 1;
3695:
3696: If p_update_top_line Then
3697: UPDATE OKC_K_LINES_B
3698: SET line_number = l_topline_seq
3699: WHERE id = l_topline_id;
3700: End If;
3701:

Line 3710: UPDATE okc_k_lines_b

3706: FETCH l_csr_okc_k_lines INTO l_subline_id;
3707: IF l_csr_okc_k_lines%FOUND THEN
3708:
3709: l_line_seq_no := l_line_seq_no + 1;
3710: UPDATE okc_k_lines_b
3711: SET line_number = l_line_seq_no
3712: WHERE id = l_subline_id;
3713:
3714:

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

4154: l_counter number := 1;
4155: l_temp_counter number := 1;
4156:
4157: cursor get_child(l_cle_id number) is
4158: select id from okc_k_lines_b where cle_id = l_cle_id;
4159:
4160: Type t_number_tbl is table of number Index by BINARY_INTEGER;
4161:
4162:

Line 4245: SELECT ID FROM OKC_K_Lines_b

4241: x_msg_data OUT NOCOPY VARCHAR2) IS
4242:
4243: -- Get all lines
4244: CURSOR Cur_Line (P_Chr_Id IN NUMBER) IS
4245: SELECT ID FROM OKC_K_Lines_b
4246: WHERE chr_ID=p_chr_Id;
4247:
4248: CURSOR Cur_gov (P_chr_Id IN NUMBER) IS
4249: SELECT ID FROM OKC_GOVERNANCES

Line 4258: from okc_k_lines_b a

4254: select id from oks_k_headers_b where chr_id = p_chr_id;
4255:
4256: cursor topline_csr(p_chr_id number) is
4257: select a.id, a.lse_id
4258: from okc_k_lines_b a
4259: where a.dnz_chr_id = p_chr_id and a.cle_id IS NULL;
4260:
4261:
4262: l_khrv_rec oks_contract_hdr_pub.khrv_rec_type;

Line 4513: from okc_k_lines_b

4509: l_msg_data VARCHAR2(2000):=null;
4510:
4511: cursor get_line_type(l_line_id number) is
4512: select lse_id, cle_id
4513: from okc_k_lines_b
4514: where id = l_line_id;
4515:
4516:
4517: l_klnv_rec oks_contract_line_pub.klnv_rec_type;

Line 4689: okc_k_lines_b d

4685: SELECT subject_cle_id
4686: FROM okc_operation_lines a,
4687: okc_operation_instances b,
4688: okc_class_operations c,
4689: okc_k_lines_b d
4690: where a.object_cle_id = d.id and
4691: d.cle_id = p_cle_id and -- should be a top line id
4692: a.object_chr_id = p_chr_id and
4693: c.id=b.cop_id and

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

4791: OKS_SETUP_UTIL_PUB.Delete_Contract_Line and adds stuff that authoring does and some other
4792: stuff that nobody seems to be doing
4793:
4794: Parameters
4795: p_line_id : id of the top line/subline from OKC_K_LINES_B table
4796: */
4797:
4798: PROCEDURE DELETE_TOP_SUB_LINE
4799: (

Line 4819: FROM okc_k_lines_b a

4815: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4816:
4817: CURSOR c_chk_transfer(cp_line_id IN NUMBER) IS
4818: SELECT id
4819: FROM okc_k_lines_b a
4820: WHERE (a.id = cp_line_id OR a.cle_id = cp_line_id)
4821: AND lse_id IN (1,12,14,19,46, 7,8,9,10,11,35, 13, 18, 25)
4822: AND nvl(term_cancel_source, 'X') IN ('IBTRANSFER', 'IBTERMINATE', 'IBRETURN');
4823:

Line 4827: FROM okc_k_lines_b a, oks_k_lines_b b

4823:
4824: CURSOR c_get_line_type(cp_line_id IN NUMBER) IS
4825: SELECT a.lse_id, a.cle_id, a.cust_acct_id, a.bill_to_site_use_id,
4826: b.locked_price_list_line_id, b.trxn_extension_id
4827: FROM okc_k_lines_b a, oks_k_lines_b b
4828: WHERE a.id = cp_line_id
4829: AND b.cle_id = a.id;
4830:
4831: CURSOR c_usage_sub_lines(cp_line_id IN NUMBER) IS

Line 4833: FROM okc_k_lines_b a, oks_k_lines_b b

4829: AND b.cle_id = a.id;
4830:
4831: CURSOR c_usage_sub_lines(cp_line_id IN NUMBER) IS
4832: SELECT b.locked_price_list_line_id
4833: FROM okc_k_lines_b a, oks_k_lines_b b
4834: WHERE a.cle_id = cp_line_id
4835: AND b.cle_id = a.id;
4836:
4837: CURSOR c_get_child_lines(cp_line_id IN NUMBER) IS

Line 4839: FROM okc_k_lines_b

4835: AND b.cle_id = a.id;
4836:
4837: CURSOR c_get_child_lines(cp_line_id IN NUMBER) IS
4838: SELECT id
4839: FROM okc_k_lines_b
4840: CONNECT BY PRIOR id = cle_id
4841: START WITH id = cp_line_id;
4842:
4843: CURSOR c_party_from_billto(cp_bill_to_site_use_id IN NUMBER) IS

Line 5447: -- Manager processing for OKC_K_LINES_B table

5443: P_Num_Workers in number)
5444: IS
5445: BEGIN
5446: --
5447: -- Manager processing for OKC_K_LINES_B table
5448: --
5449: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5450: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5451: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

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

5449: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5450: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5451: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5452:
5453: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');
5454:
5455: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5456: X_retcode,
5457: 'OKS',

Line 5474: -- Manager processing for OKC_K_LINES_BH table

5470: P_Num_Workers in number)
5471: IS
5472: BEGIN
5473: --
5474: -- Manager processing for OKC_K_LINES_BH table
5475: --
5476: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5477: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5478: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

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

5476: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5477: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5478: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5479:
5480: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5481:
5482: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5483: X_retcode,
5484: 'OKS',

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

5521: then
5522: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5523: end if;
5524:
5525: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');
5526: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5527: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5528:
5529: --

Line 5568: okc_k_lines_b cle

5564: / (cle.end_date - cle.start_date + 1)
5565: ELSE cle.annualized_factor
5566: end new_annualized_factor
5567: from okc_k_headers_all_b hdr,
5568: okc_k_lines_b cle
5569: where hdr.rowid between l_start_rowid and l_end_rowid
5570: and hdr.id = cle.dnz_chr_id
5571: and hdr.scs_code in ('SERVICE', 'WARRANTY', 'SUBSCRIPTION'))
5572: set payment_instruction_type = hdr_payment_instruction_type,

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

5581: l_any_rows_to_process,
5582: P_batch_size,
5583: FALSE);
5584: end loop;
5585: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_B table completed successfully');
5586: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
5587: X_errbuf := ' ';
5588: EXCEPTION
5589: WHEN OTHERS THEN

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

5625: then
5626: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5627: end if;
5628:
5629: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');
5630: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5631: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5632:
5633: --

Line 5671: okc_k_lines_bh cle

5667: / (cle.end_date - cle.start_date + 1)
5668: ELSE cle.annualized_factor
5669: end new_annualized_factor
5670: from okc_k_headers_all_bh hdr,
5671: okc_k_lines_bh cle
5672: where hdr.rowid between l_start_rowid and l_end_rowid
5673: and hdr.id = cle.dnz_chr_id
5674: and hdr.major_version = cle.major_version
5675: and hdr.scs_code in ('SERVICE', 'WARRANTY', 'SUBSCRIPTION'))

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

5685: l_any_rows_to_process,
5686: P_batch_size,
5687: FALSE);
5688: end loop;
5689: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_BH table completed successfully');
5690: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
5691: X_errbuf := ' ';
5692: EXCEPTION
5693: WHEN OTHERS THEN