APPS.OKL_UBB_INTEGRATION_PVT dependencies on CS_COUNTERS

Line 103: cs_counters cc,

99: p_ib_line_id OKC_K_LINES_V.ID%TYPE) IS
100: SELECT cc.counter_id,
101: cc.uom_code
102: FROM cs_counter_groups csg,
103: cs_counters cc,
104: okc_k_items cim,
105: okc_k_lines_b cle,
106: okc_line_styles_b lse
107: WHERE TO_CHAR(csg.source_object_id) = cim.object1_id1

Line 1443: from --CS_COUNTERS ct,

1439: --cursor to get any counter instances created as part of activation for this line
1440: Cursor ctr_cur (p_oks_top_line_id IN NUMBER) IS
1441: select ct.*
1442: --Bug# 6374869
1443: from --CS_COUNTERS ct,
1444: CSI_COUNTERS_B ct,
1445: OKC_K_ITEMS ct_item,
1446: OKC_K_LINES_B ct_line
1447: where ct.counter_id = to_number(ct_item.object1_id1)

Line 1482: --l_csi_ctr_rec CS_COUNTERS_PUB.ctr_rec_type;

1478: l_lausbb_rec lausbb_cur%ROWTYPE;
1479: l_okl_top_line_id NUMBER;
1480:
1481: --Bug# 6374869
1482: --l_csi_ctr_rec CS_COUNTERS_PUB.ctr_rec_type;
1483: l_counter_instance_rec CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec;
1484: l_ctr_properties_tbl CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl;
1485: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
1486: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;

Line 1529: --Bug# 6374869: R12 IB uptake replacing the call from CS_COUNTERS_PUB

1525: l_counter_instance_rec.usage_item_id := l_lausbb_rec.usage_item_id;
1526: End If;
1527:
1528: ---------------------------------------------------------------------
1529: --Bug# 6374869: R12 IB uptake replacing the call from CS_COUNTERS_PUB
1530: -- to CSI_COUNTER_PUB
1531: ---------------------------------------------------------------------
1532: --call the csi api to update counter
1533: /*--CS_COUNTERS_PUB.UPDATE_COUNTER

Line 1533: /*--CS_COUNTERS_PUB.UPDATE_COUNTER

1529: --Bug# 6374869: R12 IB uptake replacing the call from CS_COUNTERS_PUB
1530: -- to CSI_COUNTER_PUB
1531: ---------------------------------------------------------------------
1532: --call the csi api to update counter
1533: /*--CS_COUNTERS_PUB.UPDATE_COUNTER
1534: --(p_api_version => 1.0,
1535: --p_init_msg_list => OKL_API.G_FALSE,
1536: --p_commit => OKL_API.G_FALSE,
1537: --x_return_status => x_return_status,

Line 1614: x_usage_item_id CS_COUNTERS.USAGE_ITEM_ID%TYPE;

1610: l_api_version CONSTANT NUMBER := 1;
1611: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1612:
1613: x_top_line_id OKC_K_LINES_V.ID%TYPE;
1614: x_usage_item_id CS_COUNTERS.USAGE_ITEM_ID%TYPE;
1615:
1616: l_usage_count NUMBER := 0;
1617: l_link_asset_count NUMBER := 0;
1618: l_ib_count NUMBER := 0;

Line 1624: l_counter_id CS_COUNTERS.COUNTER_ID%TYPE;

1620: l_customer_product_id NUMBER;
1621: l_usage_id_prev NUMBER := G_INIT_NUMBER;
1622: l_usage_item_id NUMBER;
1623:
1624: l_counter_id CS_COUNTERS.COUNTER_ID%TYPE;
1625: l_counter_uom_code CS_COUNTERS.UOM_CODE%TYPE;
1626: x_header_rec header_rec_type;
1627:
1628: --OKS record definition

Line 1625: l_counter_uom_code CS_COUNTERS.UOM_CODE%TYPE;

1621: l_usage_id_prev NUMBER := G_INIT_NUMBER;
1622: l_usage_item_id NUMBER;
1623:
1624: l_counter_id CS_COUNTERS.COUNTER_ID%TYPE;
1625: l_counter_uom_code CS_COUNTERS.UOM_CODE%TYPE;
1626: x_header_rec header_rec_type;
1627:
1628: --OKS record definition
1629: l_oks_header_rec oks_Header_rec_type;