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 OKS_K_LINES_B

Line 182: from oks_k_lines_b

178: ,cc_expiry_date
179: ,cc_bank_acct_id
180: ,cc_auth_code
181: ,object_version_number
182: from oks_k_lines_b
183: where dnz_chr_id=p_chr_id
184: and cle_id =p_cle_id;
185:
186: get_ccr_rec get_ccr%rowtype;

Line 252: select count(*) from oks_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
252: select count(*) from oks_k_lines_b
253: where cle_id=p_line_id;
254:
255: l_coverage_count NUMBER;
256: l_line_id NUMBER;

Line 607: -- respective new rows in the OKS_K_LINES_B table.This proc

603:
604: -------------------------------------------------------------------------------
605: -- Procedure: copy_lines_attr
606: -- Purpose: This procedure copies old line attributes and creates
607: -- respective new rows in the OKS_K_LINES_B table.This proc
608: -- also checks for the date_terminated. If this is not null
609: -- then termination related fields are not copied.
610: -- In Parameters: p_new_chr_id the contract id
611: -- p_new_cle_id new line id passed

Line 1651: oks_k_lines_b oks

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:
1655: l_tbl_ctr NUMBER;

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 1793: FROM oks_k_lines_b

1789: ,cc_expiry_date
1790: ,cc_bank_acct_id
1791: ,cc_auth_code
1792: ,object_version_number
1793: FROM oks_k_lines_b
1794: WHERE cle_id=p_cle_id;
1795:
1796: l_old_cle_id number;
1797: l_date_terminated date;

Line 1968: FROM oks_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
1968: FROM oks_k_lines_b
1969: WHERE cle_id =p_cle_id;
1970:
1971: l_subline_billsch_type Varchar2(30);
1972: l_price_negotiated NUMBER;

Line 2163: SELECT count(*) from oks_k_lines_b

2159:
2160: FUNCTION chk_topline_Exists(p_cle_id IN NUMBER) return number IS
2161:
2162: CURSOR l_topline_csr(p_cle_id NUMBER) IS
2163: SELECT count(*) from oks_k_lines_b
2164: WHERE cle_id = p_cle_id;
2165:
2166: l_topline_count NUMBER;
2167:

Line 2329: FROM OKS_k_LINES_B

2325: AND lse_id IN (1,12,19,46);
2326:
2327: CURSOR get_okstoplines(p_cle_id NUMBER) IS
2328: SELECT id,object_version_number
2329: FROM OKS_k_LINES_B
2330: WHERE cle_id = p_cle_id;
2331:
2332: CURSOR get_cpl(p_chr_id number) IS
2333: SELECT id

Line 2605: FROM oks_k_lines_b

2601: */
2602: -- Added for price lock project.
2603: CURSOR get_lines_attr_csr (p_cle_id NUMBER) IS
2604: SELECT *
2605: FROM oks_k_lines_b
2606: WHERE cle_id = p_cle_id
2607: and (LOCKED_PRICE_LIST_ID is not null or
2608: LOCKED_PRICE_LIST_LINE_ID is not null);
2609:

Line 2636: FROM oks_k_lines_b

2632: -- End added for price lock project
2633:
2634: CURSOR line_Billsch_type(p_cle_id NUMBER) IS
2635: SELECT Billing_schedule_type
2636: FROM oks_k_lines_b
2637: WHERE cle_id =p_cle_id;
2638:
2639:
2640: CURSOR get_item_csr (p_cle_id NUMBER) IS

Line 3509: from oks_k_lines_b where cle_id = get_lines_rec.id;

3505: END IF;
3506: */
3507: select id
3508: into l_oks_line_id
3509: from oks_k_lines_b where cle_id = get_lines_rec.id;
3510:
3511: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3512: p_perf_msg =>'After cursor call');
3513: Update oks_k_lines_b set

Line 3513: Update oks_k_lines_b set

3509: from oks_k_lines_b where cle_id = get_lines_rec.id;
3510:
3511: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3512: p_perf_msg =>'After cursor call');
3513: Update oks_k_lines_b set
3514: LOCKED_PRICE_LIST_ID = l_locked_price_list_id,
3515: LOCKED_PRICE_LIST_LINE_ID = l_locked_price_list_line_id,
3516: break_uom = get_oks_line_attr.break_uom
3517: where id = l_oks_line_id;

Line 4128: -- lines related to this line in oks_k_lines_b.

4124:
4125: -------------------------------------------------------------------------------
4126: -- Procedure: Delete_OKS_Line
4127: -- Purpose: This procedure takes the okc line id and deletes all
4128: -- lines related to this line in oks_k_lines_b.
4129: --
4130: -- In Parameters: p_cle_id contract line id
4131: -- Out Parameters: x_return_status standard return status
4132: -----------------------------------------------------------------------------

Line 4159: select id from oks_k_lines_b where cle_id = l_cle_id;

4155: l_temp_tbl t_number_tbl;
4156: l_first_index BINARY_INTEGER;
4157:
4158: cursor get_oks_line(l_cle_id number) is
4159: select id from oks_k_lines_b where cle_id = l_cle_id;
4160:
4161: Begin
4162: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4163:

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 5231: (SELECT id FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i));

5227:
5228: --delete all OKS_K_LINES_TL records
5229: FORALL i IN l_id_tbl.first..l_id_tbl.last
5230: DELETE FROM oks_k_lines_tl WHERE id IN
5231: (SELECT id FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i));
5232:
5233: --delete all OKS_K_LINES_B records
5234: FORALL i IN l_id_tbl.first..l_id_tbl.last
5235: DELETE FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i);

Line 5233: --delete all OKS_K_LINES_B records

5229: FORALL i IN l_id_tbl.first..l_id_tbl.last
5230: DELETE FROM oks_k_lines_tl WHERE id IN
5231: (SELECT id FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i));
5232:
5233: --delete all OKS_K_LINES_B records
5234: FORALL i IN l_id_tbl.first..l_id_tbl.last
5235: DELETE FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i);
5236:
5237: --delete all OKS_K_SALES_CREDITS records

Line 5235: DELETE FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i);

5231: (SELECT id FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i));
5232:
5233: --delete all OKS_K_LINES_B records
5234: FORALL i IN l_id_tbl.first..l_id_tbl.last
5235: DELETE FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i);
5236:
5237: --delete all OKS_K_SALES_CREDITS records
5238: FORALL i IN l_id_tbl.first..l_id_tbl.last
5239: DELETE FROM oks_k_sales_credits WHERE cle_id = l_id_tbl(i);