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

916: ORDER BY lvl.date_start;
917:
918: Cursor l_csr_get_enddate IS
919: SELECT date_terminated,end_date ,start_date
920: FROM okc_k_lines_b
921: WHERE id = p_id;
922:
923: /**********
924: These two selects were included to ensure that

Line 945: l_terminated_date OKC_K_LINES_B.DATE_TERMINATED%TYPE;

941: level_element_rec L_CSR_LEVEL_ELEMENTS%ROWTYPE;
942: i NUMBER := 1;
943: l_advance_period VARCHAR2(3);
944: l_tuom_quantity NUMBER;
945: l_terminated_date OKC_K_LINES_B.DATE_TERMINATED%TYPE;
946: l_end_date OKC_K_LINES_B.END_DATE%TYPE;
947: l_start_date OKC_K_LINES_B.START_DATE%TYPE;
948: l_bill_to_date DATE;
949:

Line 946: l_end_date OKC_K_LINES_B.END_DATE%TYPE;

942: i NUMBER := 1;
943: l_advance_period VARCHAR2(3);
944: l_tuom_quantity NUMBER;
945: l_terminated_date OKC_K_LINES_B.DATE_TERMINATED%TYPE;
946: l_end_date OKC_K_LINES_B.END_DATE%TYPE;
947: l_start_date OKC_K_LINES_B.START_DATE%TYPE;
948: l_bill_to_date DATE;
949:
950: BEGIN

Line 947: l_start_date OKC_K_LINES_B.START_DATE%TYPE;

943: l_advance_period VARCHAR2(3);
944: l_tuom_quantity NUMBER;
945: l_terminated_date OKC_K_LINES_B.DATE_TERMINATED%TYPE;
946: l_end_date OKC_K_LINES_B.END_DATE%TYPE;
947: l_start_date OKC_K_LINES_B.START_DATE%TYPE;
948: l_bill_to_date DATE;
949:
950: BEGIN
951:

Line 1099: SELECT id from okc_k_lines_b

1095: p_flag IN NUMBER,
1096: x_return_status OUT NOCOPY VARCHAR2
1097: )IS
1098: CURSOR coverage (p_line_id IN NUMBER) is
1099: SELECT id from okc_k_lines_b
1100: WHERE cle_id = p_line_id
1101: AND lse_id in (7,8,9,10,11,35,18,13,25);
1102:
1103: l_msg_count NUMBER;

Line 1190: From Okc_k_lines_b

1186: to the above cursor ***/
1187:
1188: Cursor l_get_cp_csr(p_cle_id Number) IS
1189: Select id
1190: From Okc_k_lines_b
1191: Where cle_id = p_cle_id
1192: and lse_id in (35,7,8,9,10,11,13,18,25);
1193:
1194:

Line 1303: FROM okc_k_lines_b

1299: --deltes lvl elements for line and sub line.
1300:
1301: Cursor l_subLine_Csr(l_line_id number) Is
1302: SELECT id , TRUNC(date_terminated) cp_term_dt
1303: FROM okc_k_lines_b
1304: WHERE cle_id = l_line_id
1305: AND lse_id in (35,7,8,9,10,11,13,18,25);
1306:
1307: l_subline_rec l_subline_csr%ROWTYPE;

Line 1609: from okc_k_lines_b

1605: p_amount IN NUMBER,
1606: x_status OUT NOCOPY VARCHAR2) IS
1607: cursor subline_count is
1608: select count(*)
1609: from okc_k_lines_b
1610: where cle_id = p_cle_id
1611: and lse_id in (7,8,9,10,11,35, 18,25);
1612:
1613: cursor subline_cur is

Line 1615: from okc_k_lines_b

1611: and lse_id in (7,8,9,10,11,35, 18,25);
1612:
1613: cursor subline_cur is
1614: select id, price_negotiated
1615: from okc_k_lines_b
1616: where cle_id = p_cle_id
1617: and lse_id in (7,8,9,10,11,35, 18,25);
1618:
1619: l_total_amt NUMBER := 0;

Line 1665: from okc_k_lines_b

1661: x_status OUT NOCOPY VARCHAR2) IS
1662:
1663: cursor l_line_csr is
1664: select id, dnz_chr_id, inv_rule_id
1665: from okc_k_lines_b
1666: where id = p_cle_id;
1667:
1668: cursor l_sll_csr IS
1669: SELECT *

Line 1839: from okc_k_lines_b

1835: l_chrv_tbl_out okc_contract_pub.chrv_tbl_type;
1836:
1837: cursor total_amount(p_chr_id IN NUMBER) IS
1838: select sum(price_negotiated) sum
1839: from okc_k_lines_b
1840: where dnz_chr_id = p_chr_id
1841: and lse_id in (7,8,9,10,11,35,13,18,25);
1842: Begin
1843: x_status := OKC_API.G_RET_STS_SUCCESS;

Line 1873: from okc_k_lines_b

1869: ) IS
1870:
1871: cursor header_cur IS
1872: select dnz_chr_id
1873: from okc_k_lines_b
1874: where id = p_source_rec.cle_id;
1875:
1876: idx NUMBER;
1877: l_rgp_id NUMBER;

Line 1925: FROM OKC_K_LINES_B

1921: --Fix for bug#2221910 start. Get Max Of Top Lines.
1922:
1923: Select nvl(max(to_number(line_number)),0)
1924: INTO l_top_line_number
1925: FROM OKC_K_LINES_B
1926: WHERE dnz_chr_id = g_chr_id
1927: and cle_id is null;
1928: --Fix for bug#2221910 end.
1929:

Line 1948: Update okc_k_lines_b Set line_number = l_top_line_number

1944: End If;
1945:
1946: --Fix for bug#2221910 start. Update Top Line Sequence number.
1947: l_top_line_number := l_top_line_number + 1;
1948: Update okc_k_lines_b Set line_number = l_top_line_number
1949: Where id = p_target_tbl(idx).cle_id;
1950: --Fix for bug#2221910 end.
1951:
1952: OKS_SETUP_UTIL_PUB.update_line_numbers(p_chr_id => g_chr_id,

Line 2090: From Okc_K_items Itm, okc_k_lines_b line

2086: WHERE ccr.counter_id = p_counter_id;
2087:
2088: Cursor l_usage_line_csr(p_counter_id Varchar2) Is
2089: Select itm.uom_code, line.cle_id usage_id
2090: From Okc_K_items Itm, okc_k_lines_b line
2091: Where itm.cle_id = line.id
2092: And itm.object1_id1 = p_counter_id
2093: And itm.jtot_object1_code = 'OKX_COUNTER';
2094:

Line 3178: ,OKC_K_LINES_B line

3174: ,okp.object1_id2
3175: ,line.line_number
3176: FROM
3177: OKC_K_PARTY_ROLES_B okp
3178: ,OKC_K_LINES_B line
3179: ,OKC_K_HEADERS_B Hdr
3180: WHERE Hdr.id = line.dnz_chr_id
3181: AND line.id = p_line_id
3182: AND okp.dnz_chr_id = hdr.id

Line 3434: select line_number into l_line_num from okc_k_lines_b

3430: Close l_service_account_csr;
3431:
3432: l_bil_amt := Null ;
3433:
3434: select line_number into l_line_num from okc_k_lines_b
3435: where id=p_billrep_error_tbl(l_sub_line_idx).Top_Line_id;
3436:
3437: FND_FILE.PUT_LINE( FND_FILE.OUTPUT,l_string||'Service Line: '||l_line_num||' '||l_line_name||' Service Account: '||l_service_account ) ;
3438:

Line 3781: FROM OKC_K_LINES_B LINE

3777: SELECT TRUNC(LINE.START_DATE) LINE_START_DATE
3778: ,TRUNC(LINE.END_DATE) LINE_END_DATE
3779: ,LINE.ID
3780: ,LINE.DNZ_CHR_ID
3781: FROM OKC_K_LINES_B LINE
3782: WHERE LINE.ID = P_LINE_ID ;
3783:
3784: CURSOR L_GET_BCL_LINES_CSR ( P_LINE_ID NUMBER ) IS
3785: SELECT BCL.ID ,

Line 3966: FROM OKC_K_LINES_B LINES

3962: SELECT LINES.ID ,
3963: LINES.START_DATE COVERED_LEVEL_START_DATE,
3964: LINES.END_DATE COVERED_LEVEL_END_DATE,
3965: LINES.PRICE_NEGOTIATED
3966: FROM OKC_K_LINES_B LINES
3967: WHERE LINES.CLE_ID = P_LINE_ID
3968: AND LINES.LSE_ID in (9, 25) ;
3969:
3970: CURSOR l_get_itm_uom_csr(p_cp_id NUMBER) IS

Line 4104: FROM okc_k_lines_b

4100:
4101:
4102: CURSOR l_line_amt_csr IS
4103: SELECT nvl(price_negotiated,0) amt
4104: FROM okc_k_lines_b
4105: WHERE id = p_line_id ;
4106:
4107: CURSOR l_billed_amt_csr IS
4108: SELECT nvl(SUM(AMOUNT),0) tot_amt

Line 4218: From okc_k_lines_b

4214: Select Trunc(Max(date_billed_to))
4215: From oks_bill_cont_lines
4216: Where cle_id In
4217: ( Select id
4218: From okc_k_lines_b
4219: Where dnz_chr_id = p_id
4220: And lse_id In(1,12,14,19,46)
4221: );
4222:

Line 4718: FROM okc_k_lines_b

4714:
4715: CURSOR l_subline_csr IS
4716: SELECT id , TRUNC(end_date) end_dt,
4717: price_negotiated cp_amt
4718: FROM okc_k_lines_b
4719: WHERE cle_id = p_top_line_id
4720: AND lse_id in (35,7,8,9,10,11,13,18,25)
4721: AND date_terminated IS NULL;
4722:

Line 4734: FROM okc_k_lines_b

4730: AND bcl.bill_action = 'RI';
4731:
4732: CURSOR l_top_line_Amt_csr IS
4733: SELECT nvl(SUM(price_negotiated),0) tot_amt
4734: FROM okc_k_lines_b
4735: where cle_id = p_top_line_id
4736: and lse_id in (35,7,8,9,10,11,13,18,25);
4737:
4738: CURSOR l_hdr_Amt_csr IS

Line 4740: FROM okc_k_lines_b

4736: and lse_id in (35,7,8,9,10,11,13,18,25);
4737:
4738: CURSOR l_hdr_Amt_csr IS
4739: SELECT nvl(SUM(price_negotiated),0) tot_amount
4740: FROM okc_k_lines_b
4741: where dnz_chr_id = p_dnz_chr_id
4742: and lse_id in (35,7,8,9,10,11,13,18,25,46);
4743:
4744: l_bsl_rec l_bsl_csr%ROWTYPE;

Line 4774: UPDATE okc_k_lines_b SET price_negotiated = l_bsl_rec.bill_amt

4770: CLOSE l_bsl_csr;
4771: IF l_bsl_rec.max_billed_to IS NOT NULL AND TRUNC(l_bsl_rec.max_billed_to) = l_SubLine_rec.end_dt
4772: AND nvl(l_SubLine_rec.cp_amt,0) <> l_bsl_rec.bill_amt THEN
4773:
4774: UPDATE okc_k_lines_b SET price_negotiated = l_bsl_rec.bill_amt
4775: WHERE id = l_SubLine_rec.id;
4776:
4777: l_subline_update := l_subline_update + 1;
4778: END IF; ---update decision chk

Line 4793: UPDATE okc_k_lines_b SET price_negotiated = l_bsl_rec.bill_amt

4789: CLOSE l_bsl_csr;
4790: IF l_bsl_rec.max_billed_to IS NOT NULL AND TRUNC(l_bsl_rec.max_billed_to) = TRUNC(p_end_date)
4791: AND nvl(p_amount,0) <> l_bsl_rec.bill_amt THEN
4792:
4793: UPDATE okc_k_lines_b SET price_negotiated = l_bsl_rec.bill_amt
4794: WHERE id = p_sub_line_id;
4795:
4796: x_amount := l_bsl_rec.bill_amt;
4797:

Line 4812: UPDATE okc_k_lines_b SET price_negotiated = l_top_line_amt

4808: OPEN l_top_line_Amt_csr;
4809: FETCH l_top_line_Amt_csr INTO l_top_line_amt ;
4810: CLOSE l_top_line_Amt_csr ;
4811:
4812: UPDATE okc_k_lines_b SET price_negotiated = l_top_line_amt
4813: WHERE id = p_top_line_id;
4814:
4815: OPEN l_hdr_Amt_csr;
4816: FETCH l_hdr_Amt_csr INTO l_hdr_amt ;