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

Line 954: FROM okc_k_lines_b

950: ORDER BY lvl.date_start;
951:
952: Cursor l_csr_get_enddate IS
953: SELECT date_terminated,end_date ,start_date
954: FROM okc_k_lines_b
955: WHERE id = p_id;
956:
957: /**********
958: These two selects were included to ensure that

Line 979: l_terminated_date OKC_K_LINES_B.DATE_TERMINATED%TYPE;

975: level_element_rec L_CSR_LEVEL_ELEMENTS%ROWTYPE;
976: i NUMBER := 1;
977: l_advance_period VARCHAR2(3);
978: l_tuom_quantity NUMBER;
979: l_terminated_date OKC_K_LINES_B.DATE_TERMINATED%TYPE;
980: l_end_date OKC_K_LINES_B.END_DATE%TYPE;
981: l_start_date OKC_K_LINES_B.START_DATE%TYPE;
982: l_bill_to_date DATE;
983:

Line 980: l_end_date OKC_K_LINES_B.END_DATE%TYPE;

976: i NUMBER := 1;
977: l_advance_period VARCHAR2(3);
978: l_tuom_quantity NUMBER;
979: l_terminated_date OKC_K_LINES_B.DATE_TERMINATED%TYPE;
980: l_end_date OKC_K_LINES_B.END_DATE%TYPE;
981: l_start_date OKC_K_LINES_B.START_DATE%TYPE;
982: l_bill_to_date DATE;
983:
984: BEGIN

Line 981: l_start_date OKC_K_LINES_B.START_DATE%TYPE;

977: l_advance_period VARCHAR2(3);
978: l_tuom_quantity NUMBER;
979: l_terminated_date OKC_K_LINES_B.DATE_TERMINATED%TYPE;
980: l_end_date OKC_K_LINES_B.END_DATE%TYPE;
981: l_start_date OKC_K_LINES_B.START_DATE%TYPE;
982: l_bill_to_date DATE;
983:
984: BEGIN
985:

Line 1133: SELECT id from okc_k_lines_b

1129: p_flag IN NUMBER,
1130: x_return_status OUT NOCOPY VARCHAR2
1131: )IS
1132: CURSOR coverage (p_line_id IN NUMBER) is
1133: SELECT id from okc_k_lines_b
1134: WHERE cle_id = p_line_id
1135: AND lse_id in (7,8,9,10,11,35,18,13,25);
1136:
1137: l_msg_count NUMBER;

Line 1224: From Okc_k_lines_b

1220: to the above cursor ***/
1221:
1222: Cursor l_get_cp_csr(p_cle_id Number) IS
1223: Select id
1224: From Okc_k_lines_b
1225: Where cle_id = p_cle_id
1226: and lse_id in (35,7,8,9,10,11,13,18,25);
1227:
1228:

Line 1337: FROM okc_k_lines_b

1333: --deltes lvl elements for line and sub line.
1334:
1335: Cursor l_subLine_Csr(l_line_id number) Is
1336: SELECT id , TRUNC(date_terminated) cp_term_dt
1337: FROM okc_k_lines_b
1338: WHERE cle_id = l_line_id
1339: AND lse_id in (35,7,8,9,10,11,13,18,25);
1340:
1341: l_subline_rec l_subline_csr%ROWTYPE;

Line 1643: from okc_k_lines_b

1639: p_amount IN NUMBER,
1640: x_status OUT NOCOPY VARCHAR2) IS
1641: cursor subline_count is
1642: select count(*)
1643: from okc_k_lines_b
1644: where cle_id = p_cle_id
1645: and lse_id in (7,8,9,10,11,35, 18,25);
1646:
1647: cursor subline_cur is

Line 1649: from okc_k_lines_b

1645: and lse_id in (7,8,9,10,11,35, 18,25);
1646:
1647: cursor subline_cur is
1648: select id, price_negotiated
1649: from okc_k_lines_b
1650: where cle_id = p_cle_id
1651: and lse_id in (7,8,9,10,11,35, 18,25);
1652:
1653: l_total_amt NUMBER := 0;

Line 1699: from okc_k_lines_b

1695: x_status OUT NOCOPY VARCHAR2) IS
1696:
1697: cursor l_line_csr is
1698: select id, dnz_chr_id, inv_rule_id
1699: from okc_k_lines_b
1700: where id = p_cle_id;
1701:
1702: cursor l_sll_csr IS
1703: SELECT *

Line 1873: from okc_k_lines_b

1869: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
1870:
1871: cursor total_amount(p_chr_id IN NUMBER) IS
1872: select sum(price_negotiated) sum
1873: from okc_k_lines_b
1874: where dnz_chr_id = p_chr_id
1875: and lse_id in (7,8,9,10,11,35,13,18,25);
1876: Begin
1877: x_status := OKC_API.G_RET_STS_SUCCESS;

Line 1907: from okc_k_lines_b

1903: ) IS
1904:
1905: cursor header_cur IS
1906: select dnz_chr_id
1907: from okc_k_lines_b
1908: where id = p_source_rec.cle_id;
1909:
1910: idx NUMBER;
1911: l_rgp_id NUMBER;

Line 1959: FROM OKC_K_LINES_B

1955: --Fix for bug#2221910 start. Get Max Of Top Lines.
1956:
1957: Select nvl(max(to_number(line_number)),0)
1958: INTO l_top_line_number
1959: FROM OKC_K_LINES_B
1960: WHERE dnz_chr_id = g_chr_id
1961: and cle_id is null;
1962: --Fix for bug#2221910 end.
1963:

Line 1982: Update okc_k_lines_b Set line_number = l_top_line_number

1978: End If;
1979:
1980: --Fix for bug#2221910 start. Update Top Line Sequence number.
1981: l_top_line_number := l_top_line_number + 1;
1982: Update okc_k_lines_b Set line_number = l_top_line_number
1983: Where id = p_target_tbl(idx).cle_id;
1984: --Fix for bug#2221910 end.
1985:
1986: OKS_SETUP_UTIL_PUB.update_line_numbers(p_chr_id => g_chr_id,

Line 2124: From Okc_K_items Itm, okc_k_lines_b line

2120: WHERE ccr.counter_id = p_counter_id;
2121:
2122: Cursor l_usage_line_csr(p_counter_id Varchar2) Is
2123: Select itm.uom_code, line.cle_id usage_id
2124: From Okc_K_items Itm, okc_k_lines_b line
2125: Where itm.cle_id = line.id
2126: And itm.object1_id1 = p_counter_id
2127: And itm.jtot_object1_code = 'OKX_COUNTER';
2128:

Line 3212: ,OKC_K_LINES_B line

3208: ,okp.object1_id2
3209: ,line.line_number
3210: FROM
3211: OKC_K_PARTY_ROLES_B okp
3212: ,OKC_K_LINES_B line
3213: ,OKC_K_HEADERS_B Hdr
3214: WHERE Hdr.id = line.dnz_chr_id
3215: AND line.id = p_line_id
3216: AND okp.dnz_chr_id = hdr.id

Line 3469: select line_number into l_line_num from okc_k_lines_b

3465: Close l_service_account_csr;
3466:
3467: l_bil_amt := Null ;
3468:
3469: select line_number into l_line_num from okc_k_lines_b
3470: where id=p_billrep_error_tbl(l_sub_line_idx).Top_Line_id;
3471:
3472: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||'Service Line: '||l_line_num||' '||l_line_name||' Service Account: '||l_service_account ) ;
3473:

Line 3816: FROM OKC_K_LINES_B LINE

3812: SELECT TRUNC(LINE.START_DATE) LINE_START_DATE
3813: ,TRUNC(LINE.END_DATE) LINE_END_DATE
3814: ,LINE.ID
3815: ,LINE.DNZ_CHR_ID
3816: FROM OKC_K_LINES_B LINE
3817: WHERE LINE.ID = P_LINE_ID ;
3818:
3819: CURSOR L_GET_BCL_LINES_CSR ( P_LINE_ID NUMBER ) IS
3820: SELECT BCL.ID ,

Line 4001: FROM OKC_K_LINES_B LINES

3997: SELECT LINES.ID ,
3998: LINES.START_DATE COVERED_LEVEL_START_DATE,
3999: LINES.END_DATE COVERED_LEVEL_END_DATE,
4000: LINES.PRICE_NEGOTIATED
4001: FROM OKC_K_LINES_B LINES
4002: WHERE LINES.CLE_ID = P_LINE_ID
4003: AND LINES.LSE_ID in (9, 25) ;
4004:
4005: CURSOR l_get_itm_uom_csr(p_cp_id NUMBER) IS

Line 4019: FROM okc_k_lines_b

4015: /*Added for ER 16039380*/
4016:
4017: CURSOR get_line_dtls(k_line_id NUMBER) IS
4018: SELECT lse_id,start_date,end_date
4019: FROM okc_k_lines_b
4020: WHERE id=k_line_id;
4021: CURSOR L_LEVEL_ELEMENTS (L_LINE_ID NUMBER) IS
4022: SELECT LINES.AMOUNT
4023: FROM OKS_LEVEL_ELEMENTS LINES

Line 4228: FROM OKC_K_LINES_B LINE

4224: ,TRUNC(LINE.END_DATE) LINE_END_DATE
4225: ,LINE.ID
4226: ,LINE.DNZ_CHR_ID
4227: ,LINE.LSE_ID
4228: FROM OKC_K_LINES_B LINE
4229: WHERE LINE.ID = P_LINE_ID ;
4230: CURSOR L_GET_BCL_LINES_CSR ( P_LINE_ID NUMBER ) IS
4231: SELECT BCL.ID ,
4232: TRUNC(BCL.DATE_BILLED_FROM) DATE_BILLED_FROM ,

Line 4381: FROM OKC_K_LINES_B LINES

4377: SELECT LINES.ID ,
4378: LINES.START_DATE COVERED_LEVEL_START_DATE,
4379: LINES.END_DATE COVERED_LEVEL_END_DATE,
4380: LINES.PRICE_NEGOTIATED
4381: FROM OKC_K_LINES_B LINES
4382: WHERE LINES.CLE_ID = P_LINE_ID
4383: AND LINES.LSE_ID in (9, 25) ;
4384: CURSOR L_LEVEL_ELEMENTS (L_LINE_ID NUMBER,L_DATE_FROM DATE ) IS
4385: SELECT LINES.AMOUNT

Line 4400: FROM OKC_K_LINES_B

4396: FROM OKS_BILL_SUB_LINES
4397: WHERE CLE_ID = P_ID ;
4398: CURSOR L_Line_Type is
4399: SELECT lse_id
4400: FROM OKC_K_LINES_B
4401: WHERE id=P_LINE_ID;
4402: l_get_itm_uom_rec l_get_itm_uom_csr%ROWTYPE;
4403: L_GET_COVERED_LEVELS_REC L_GET_COVERED_LEVELS_CSR%ROWTYPE ;
4404: L_GET_BSL_REC L_GET_BSL_CSR%ROWTYPE ;

Line 4598: FROM okc_k_lines_b

4594:
4595:
4596: CURSOR l_line_amt_csr IS
4597: SELECT nvl(price_negotiated,0) amt
4598: FROM okc_k_lines_b
4599: WHERE id = p_line_id ;
4600:
4601: CURSOR l_billed_amt_csr IS
4602: SELECT nvl(SUM(AMOUNT),0) tot_amt

Line 4712: From okc_k_lines_b

4708: Select Trunc(Max(date_billed_to))
4709: From oks_bill_cont_lines
4710: Where cle_id In
4711: ( Select id
4712: From okc_k_lines_b
4713: Where dnz_chr_id = p_id
4714: And lse_id In(1,12,14,19,46)
4715: );
4716:

Line 5212: FROM okc_k_lines_b

5208:
5209: CURSOR l_subline_csr IS
5210: SELECT id , TRUNC(end_date) end_dt,
5211: price_negotiated cp_amt
5212: FROM okc_k_lines_b
5213: WHERE cle_id = p_top_line_id
5214: AND lse_id in (35,7,8,9,10,11,13,18,25)
5215: AND date_terminated IS NULL;
5216:

Line 5228: FROM okc_k_lines_b

5224: AND bcl.bill_action = 'RI';
5225:
5226: CURSOR l_top_line_Amt_csr IS
5227: SELECT nvl(SUM(price_negotiated),0) tot_amt
5228: FROM okc_k_lines_b
5229: where cle_id = p_top_line_id
5230: and lse_id in (35,7,8,9,10,11,13,18,25);
5231:
5232: CURSOR l_hdr_Amt_csr IS

Line 5234: FROM okc_k_lines_b

5230: and lse_id in (35,7,8,9,10,11,13,18,25);
5231:
5232: CURSOR l_hdr_Amt_csr IS
5233: SELECT nvl(SUM(price_negotiated),0) tot_amount
5234: FROM okc_k_lines_b
5235: where dnz_chr_id = p_dnz_chr_id
5236: and lse_id in (35,7,8,9,10,11,13,18,25,46);
5237:
5238: l_bsl_rec l_bsl_csr%ROWTYPE;

Line 5268: UPDATE okc_k_lines_b SET price_negotiated = l_bsl_rec.bill_amt

5264: CLOSE l_bsl_csr;
5265: IF l_bsl_rec.max_billed_to IS NOT NULL AND TRUNC(l_bsl_rec.max_billed_to) = l_SubLine_rec.end_dt
5266: AND nvl(l_SubLine_rec.cp_amt,0) <> l_bsl_rec.bill_amt THEN
5267:
5268: UPDATE okc_k_lines_b SET price_negotiated = l_bsl_rec.bill_amt
5269: WHERE id = l_SubLine_rec.id;
5270:
5271: l_subline_update := l_subline_update + 1;
5272: END IF; ---update decision chk

Line 5287: UPDATE okc_k_lines_b SET price_negotiated = l_bsl_rec.bill_amt

5283: CLOSE l_bsl_csr;
5284: IF l_bsl_rec.max_billed_to IS NOT NULL AND TRUNC(l_bsl_rec.max_billed_to) = TRUNC(p_end_date)
5285: AND nvl(p_amount,0) <> l_bsl_rec.bill_amt THEN
5286:
5287: UPDATE okc_k_lines_b SET price_negotiated = l_bsl_rec.bill_amt
5288: WHERE id = p_sub_line_id;
5289:
5290: x_amount := l_bsl_rec.bill_amt;
5291:

Line 5306: UPDATE okc_k_lines_b SET price_negotiated = l_top_line_amt

5302: OPEN l_top_line_Amt_csr;
5303: FETCH l_top_line_Amt_csr INTO l_top_line_amt ;
5304: CLOSE l_top_line_Amt_csr ;
5305:
5306: UPDATE okc_k_lines_b SET price_negotiated = l_top_line_amt
5307: WHERE id = p_top_line_id;
5308:
5309: OPEN l_hdr_Amt_csr;
5310: FETCH l_hdr_Amt_csr INTO l_hdr_amt ;