APPS.OKS_BILL_UTIL_PUB dependencies on OKC_K_ITEMS

Line 1621: from okc_k_items_v

1617: l_cimv_rec_in OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
1618: l_cimv_rec_out OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
1619: cursor item_cur is
1620: select id
1621: from okc_k_items_v
1622: where cle_id = p_cle_id;
1623: begin
1624: open item_cur;
1625: fetch item_cur into l_cimv_rec_in.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 3250: ,OKC_K_ITEMS itm

3246:
3247: Cursor l_line_name_csr (p_line_id Number,p_organization_id Number) IS
3248: Select sys.NAME LineName
3249: From OKX_SYSTEM_ITEMS_V sys
3250: ,OKC_K_ITEMS itm
3251: Where itm.CLE_ID = p_line_id
3252: and sys.ID1 = itm.OBJECT1_ID1
3253: and sys.ID2 = itm.OBJECT1_ID2;
3254:

Line 3268: From OKC_K_ITEMS itm

3264: itm.JTOT_OBJECT1_CODE) CoveredLine
3265: ,itm.JTOT_OBJECT1_CODE
3266: ,itm.object1_id1
3267: ,itm.object1_id2
3268: From OKC_K_ITEMS itm
3269: Where itm.CLE_ID = p_sub_line_id;
3270:
3271: l_line_idx Binary_Integer;
3272: l_sub_line_idx Binary_Integer;

Line 4007: FROM okc_k_items

4003: AND LINES.LSE_ID in (9, 25) ;
4004:
4005: CURSOR l_get_itm_uom_csr(p_cp_id NUMBER) IS
4006: SELECT uom_code
4007: FROM okc_k_items
4008: WHERE cle_id = p_cp_id;
4009:
4010: CURSOR L_GET_BSL_CSR ( P_ID NUMBER ) IS
4011: SELECT 1

Line 4100: ----Get the item uom from okc_k_items

4096: );
4097: IF NOT L_RETURN_STATUS = OKC_API.G_RET_STS_SUCCESS THEN
4098: RAISE G_EXCEPTION_HALT_VALIDATION;
4099: END IF;
4100: ----Get the item uom from okc_k_items
4101: OPEN L_GET_ITM_UOM_CSR( P_LINE_ID );
4102: FETCH L_GET_ITM_UOM_CSR INTO L_GET_ITM_UOM_rec ;
4103: IF L_GET_ITM_UOM_CSR%NOTFOUND THEN
4104: CLOSE L_GET_ITM_UOM_CSR;

Line 4167: ----Get the item uom from okc_k_items

4163:
4164: ---create rec in oks_subline_bill_dtl table.
4165:
4166:
4167: ----Get the item uom from okc_k_items
4168: OPEN L_GET_ITM_UOM_CSR( L_GET_COVERED_LEVELS_REC.ID );
4169: FETCH L_GET_ITM_UOM_CSR INTO L_GET_ITM_UOM_rec ;
4170: IF L_GET_ITM_UOM_CSR%NOTFOUND THEN
4171: CLOSE L_GET_ITM_UOM_CSR;

Line 4392: FROM okc_k_items

4388: AND LINES.DATE_START = L_DATE_FROM
4389: AND LINES.DATE_END =P_DATE_TO;
4390: CURSOR l_get_itm_uom_csr(p_cp_id NUMBER) IS
4391: SELECT uom_code
4392: FROM okc_k_items
4393: WHERE cle_id = p_cp_id;
4394: CURSOR L_GET_BSL_CSR ( P_ID NUMBER ) IS
4395: SELECT 1
4396: FROM OKS_BILL_SUB_LINES

Line 4451: ----Get the item uom from okc_k_items

4447: IF NOT L_RETURN_STATUS = OKC_API.G_RET_STS_SUCCESS THEN
4448: RAISE G_EXCEPTION_HALT_VALIDATION;
4449: END IF;
4450: ---create rec in oks_subline_bill_dtl table.
4451: ----Get the item uom from okc_k_items
4452: OPEN L_GET_ITM_UOM_CSR( P_LINE_ID );
4453: FETCH L_GET_ITM_UOM_CSR INTO L_GET_ITM_UOM_rec ;
4454: IF L_GET_ITM_UOM_CSR%NOTFOUND THEN
4455: CLOSE L_GET_ITM_UOM_CSR;

Line 4529: ----Get the item uom from okc_k_items

4525: L_SUB_LINES_INSERTED := L_SUB_LINES_INSERTED + 1 ;
4526: L_TOTAL_AMOUNT := L_TOTAL_AMOUNT + L_GET_COVERED_LEVELS_REC.PRICE_NEGOTIATED ;
4527: END IF;
4528: ---create rec in oks_subline_bill_dtl table.
4529: ----Get the item uom from okc_k_items
4530: OPEN L_GET_ITM_UOM_CSR( L_GET_COVERED_LEVELS_REC.ID );
4531: FETCH L_GET_ITM_UOM_CSR INTO L_GET_ITM_UOM_rec ;
4532: IF L_GET_ITM_UOM_CSR%NOTFOUND THEN
4533: CLOSE L_GET_ITM_UOM_CSR;