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 612: -- respective new rows in the OKS_K_LINES_B table.This proc

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

Line 1659: oks_k_lines_b oks

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

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

1798: ,cc_expiry_date
1799: ,cc_bank_acct_id
1800: ,cc_auth_code
1801: ,object_version_number
1802: FROM oks_k_lines_b
1803: WHERE cle_id=p_cle_id;
1804:
1805: l_old_cle_id number;
1806: l_date_terminated date;

Line 1977: FROM oks_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
1977: FROM oks_k_lines_b
1978: WHERE cle_id =p_cle_id;
1979:
1980: l_subline_billsch_type Varchar2(30);
1981: l_price_negotiated NUMBER;

Line 2172: SELECT count(*) from oks_k_lines_b

2168:
2169: FUNCTION chk_topline_Exists(p_cle_id IN NUMBER) return number IS
2170:
2171: CURSOR l_topline_csr(p_cle_id NUMBER) IS
2172: SELECT count(*) from oks_k_lines_b
2173: WHERE cle_id = p_cle_id;
2174:
2175: l_topline_count NUMBER;
2176:

Line 2338: FROM OKS_k_LINES_B

2334: AND lse_id IN (1,12,19,46);
2335:
2336: CURSOR get_okstoplines(p_cle_id NUMBER) IS
2337: SELECT id,object_version_number
2338: FROM OKS_k_LINES_B
2339: WHERE cle_id = p_cle_id;
2340:
2341: CURSOR get_cpl(p_chr_id number) IS
2342: SELECT id

Line 2614: FROM oks_k_lines_b

2610: */
2611: -- Added for price lock project.
2612: CURSOR get_lines_attr_csr (p_cle_id NUMBER) IS
2613: SELECT *
2614: FROM oks_k_lines_b
2615: WHERE cle_id = p_cle_id
2616: and (LOCKED_PRICE_LIST_ID is not null or
2617: LOCKED_PRICE_LIST_LINE_ID is not null);
2618:

Line 2645: FROM oks_k_lines_b

2641: -- End added for price lock project
2642:
2643: CURSOR line_Billsch_type(p_cle_id NUMBER) IS
2644: SELECT Billing_schedule_type
2645: FROM oks_k_lines_b
2646: WHERE cle_id =p_cle_id;
2647:
2648:
2649: CURSOR get_item_csr (p_cle_id NUMBER) IS

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

3514: END IF;
3515: */
3516: select id
3517: into l_oks_line_id
3518: from oks_k_lines_b where cle_id = get_lines_rec.id;
3519:
3520: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3521: p_perf_msg =>'After cursor call');
3522: Update oks_k_lines_b set

Line 3522: Update oks_k_lines_b set

3518: from oks_k_lines_b where cle_id = get_lines_rec.id;
3519:
3520: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3521: p_perf_msg =>'After cursor call');
3522: Update oks_k_lines_b set
3523: LOCKED_PRICE_LIST_ID = l_locked_price_list_id,
3524: LOCKED_PRICE_LIST_LINE_ID = l_locked_price_list_line_id,
3525: break_uom = get_oks_line_attr.break_uom
3526: where id = l_oks_line_id;

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

4133:
4134: -------------------------------------------------------------------------------
4135: -- Procedure: Delete_OKS_Line
4136: -- Purpose: This procedure takes the okc line id and deletes all
4137: -- lines related to this line in oks_k_lines_b.
4138: --
4139: -- In Parameters: p_cle_id contract line id
4140: -- Out Parameters: x_return_status standard return status
4141: -----------------------------------------------------------------------------

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

4164: l_temp_tbl t_number_tbl;
4165: l_first_index BINARY_INTEGER;
4166:
4167: cursor get_oks_line(l_cle_id number) is
4168: select id from oks_k_lines_b where cle_id = l_cle_id;
4169:
4170: Begin
4171: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4172:

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

5236:
5237: --delete all OKS_K_LINES_TL records
5238: FORALL i IN l_id_tbl.first..l_id_tbl.last
5239: DELETE FROM oks_k_lines_tl WHERE id IN
5240: (SELECT id FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i));
5241:
5242: --delete all OKS_K_LINES_B records
5243: FORALL i IN l_id_tbl.first..l_id_tbl.last
5244: DELETE FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i);

Line 5242: --delete all OKS_K_LINES_B records

5238: FORALL i IN l_id_tbl.first..l_id_tbl.last
5239: DELETE FROM oks_k_lines_tl WHERE id IN
5240: (SELECT id FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i));
5241:
5242: --delete all OKS_K_LINES_B records
5243: FORALL i IN l_id_tbl.first..l_id_tbl.last
5244: DELETE FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i);
5245:
5246: --delete all OKS_K_SALES_CREDITS records

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

5240: (SELECT id FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i));
5241:
5242: --delete all OKS_K_LINES_B records
5243: FORALL i IN l_id_tbl.first..l_id_tbl.last
5244: DELETE FROM oks_k_lines_b WHERE cle_id = l_id_tbl(i);
5245:
5246: --delete all OKS_K_SALES_CREDITS records
5247: FORALL i IN l_id_tbl.first..l_id_tbl.last
5248: DELETE FROM oks_k_sales_credits WHERE cle_id = l_id_tbl(i);