APPS.OKL_UBB_INTEGRATION_PVT dependencies on MTL_SYSTEM_ITEMS

Line 541: p_item_id IN mtl_system_items.inventory_item_id%TYPE,

537: PROCEDURE get_item_uom_code(
538: x_return_status OUT NOCOPY VARCHAR2,
539: x_msg_count OUT NOCOPY NUMBER,
540: x_msg_data OUT NOCOPY VARCHAR2,
541: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
542: p_org_id IN mtl_system_items.organization_id%TYPE,
543: x_uom_code OUT NOCOPY mtl_system_items.primary_uom_code%TYPE
544: ) IS
545:

Line 542: p_org_id IN mtl_system_items.organization_id%TYPE,

538: x_return_status OUT NOCOPY VARCHAR2,
539: x_msg_count OUT NOCOPY NUMBER,
540: x_msg_data OUT NOCOPY VARCHAR2,
541: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
542: p_org_id IN mtl_system_items.organization_id%TYPE,
543: x_uom_code OUT NOCOPY mtl_system_items.primary_uom_code%TYPE
544: ) IS
545:
546: l_proc_name VARCHAR2(35) := 'GET_ITEM_UOM_CODE';

Line 543: x_uom_code OUT NOCOPY mtl_system_items.primary_uom_code%TYPE

539: x_msg_count OUT NOCOPY NUMBER,
540: x_msg_data OUT NOCOPY VARCHAR2,
541: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
542: p_org_id IN mtl_system_items.organization_id%TYPE,
543: x_uom_code OUT NOCOPY mtl_system_items.primary_uom_code%TYPE
544: ) IS
545:
546: l_proc_name VARCHAR2(35) := 'GET_ITEM_UOM_CODE';
547:

Line 548: CURSOR uom_csr (p_item_id mtl_system_items.inventory_item_id%TYPE,

544: ) IS
545:
546: l_proc_name VARCHAR2(35) := 'GET_ITEM_UOM_CODE';
547:
548: CURSOR uom_csr (p_item_id mtl_system_items.inventory_item_id%TYPE,
549: p_inv_org_id mtl_system_items.organization_id%TYPE) IS
550: SELECT primary_uom_code
551: FROM mtl_system_items
552: WHERE inventory_item_id = p_item_id

Line 549: p_inv_org_id mtl_system_items.organization_id%TYPE) IS

545:
546: l_proc_name VARCHAR2(35) := 'GET_ITEM_UOM_CODE';
547:
548: CURSOR uom_csr (p_item_id mtl_system_items.inventory_item_id%TYPE,
549: p_inv_org_id mtl_system_items.organization_id%TYPE) IS
550: SELECT primary_uom_code
551: FROM mtl_system_items
552: WHERE inventory_item_id = p_item_id
553: AND organization_id = p_inv_org_id;

Line 551: FROM mtl_system_items

547:
548: CURSOR uom_csr (p_item_id mtl_system_items.inventory_item_id%TYPE,
549: p_inv_org_id mtl_system_items.organization_id%TYPE) IS
550: SELECT primary_uom_code
551: FROM mtl_system_items
552: WHERE inventory_item_id = p_item_id
553: AND organization_id = p_inv_org_id;
554:
555: l_uom_code mtl_system_items.primary_uom_code%TYPE;

Line 555: l_uom_code mtl_system_items.primary_uom_code%TYPE;

551: FROM mtl_system_items
552: WHERE inventory_item_id = p_item_id
553: AND organization_id = p_inv_org_id;
554:
555: l_uom_code mtl_system_items.primary_uom_code%TYPE;
556:
557: BEGIN
558: IF (G_DEBUG_ENABLED = 'Y') THEN
559: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

Line 999: l_uom_code mtl_system_items.primary_uom_code%TYPE;

995: l_oks_start_date DATE;
996: l_oks_end_date DATE;
997: l_authoring_org_id NUMBER;
998:
999: l_uom_code mtl_system_items.primary_uom_code%TYPE;
1000:
1001: CURSOR oks_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1002: SELECT start_date,
1003: end_date,

Line 1270: l_uom_code mtl_system_items.primary_uom_code%TYPE;

1266: l_proc_name VARCHAR2(35) := 'POPULATE_COVERED_REC';
1267: x_rulv_rec rulv_rec_type;
1268: covered_failed EXCEPTION;
1269:
1270: l_uom_code mtl_system_items.primary_uom_code%TYPE;
1271:
1272: BEGIN
1273: IF (G_DEBUG_ENABLED = 'Y') THEN
1274: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);