DBA Data[Home] [Help]

APPS.WMS_CATCH_WEIGHT_PVT dependencies on INV_CACHE

Line 1109: IF inv_cache.set_item_rec(p_organization_id,p_inventory_item_id) THEN

1105: , l_txn_date
1106: , 0
1107: );
1108:
1109: IF inv_cache.set_item_rec(p_organization_id,p_inventory_item_id) THEN
1110: l_loc_ctrl_code := inv_cache.item_rec.location_control_code;
1111: l_rev_ctrl_code := inv_cache.item_rec.revision_qty_control_code;
1112: l_lot_ctrl_code := inv_cache.item_rec.lot_control_code;
1113: l_srl_ctrl_code := inv_cache.item_rec.serial_number_control_code;

Line 1110: l_loc_ctrl_code := inv_cache.item_rec.location_control_code;

1106: , 0
1107: );
1108:
1109: IF inv_cache.set_item_rec(p_organization_id,p_inventory_item_id) THEN
1110: l_loc_ctrl_code := inv_cache.item_rec.location_control_code;
1111: l_rev_ctrl_code := inv_cache.item_rec.revision_qty_control_code;
1112: l_lot_ctrl_code := inv_cache.item_rec.lot_control_code;
1113: l_srl_ctrl_code := inv_cache.item_rec.serial_number_control_code;
1114: END IF;

Line 1111: l_rev_ctrl_code := inv_cache.item_rec.revision_qty_control_code;

1107: );
1108:
1109: IF inv_cache.set_item_rec(p_organization_id,p_inventory_item_id) THEN
1110: l_loc_ctrl_code := inv_cache.item_rec.location_control_code;
1111: l_rev_ctrl_code := inv_cache.item_rec.revision_qty_control_code;
1112: l_lot_ctrl_code := inv_cache.item_rec.lot_control_code;
1113: l_srl_ctrl_code := inv_cache.item_rec.serial_number_control_code;
1114: END IF;
1115:

Line 1112: l_lot_ctrl_code := inv_cache.item_rec.lot_control_code;

1108:
1109: IF inv_cache.set_item_rec(p_organization_id,p_inventory_item_id) THEN
1110: l_loc_ctrl_code := inv_cache.item_rec.location_control_code;
1111: l_rev_ctrl_code := inv_cache.item_rec.revision_qty_control_code;
1112: l_lot_ctrl_code := inv_cache.item_rec.lot_control_code;
1113: l_srl_ctrl_code := inv_cache.item_rec.serial_number_control_code;
1114: END IF;
1115:
1116: IF (l_debug = 1) THEN

Line 1113: l_srl_ctrl_code := inv_cache.item_rec.serial_number_control_code;

1109: IF inv_cache.set_item_rec(p_organization_id,p_inventory_item_id) THEN
1110: l_loc_ctrl_code := inv_cache.item_rec.location_control_code;
1111: l_rev_ctrl_code := inv_cache.item_rec.revision_qty_control_code;
1112: l_lot_ctrl_code := inv_cache.item_rec.lot_control_code;
1113: l_srl_ctrl_code := inv_cache.item_rec.serial_number_control_code;
1114: END IF;
1115:
1116: IF (l_debug = 1) THEN
1117: print_debug(' l_txn_temp_id: ' || l_txn_temp_id ||

Line 1688: IF inv_cache.set_org_rec(p_organization_id) THEN

1684: ELSE
1685: l_lot_ctrl := FALSE;
1686: END IF;
1687:
1688: IF inv_cache.set_org_rec(p_organization_id) THEN
1689: IF inv_cache.org_rec.default_status_id IS NOT NULL THEN
1690: l_onh_status := TRUE;
1691: END IF;
1692: END IF;

Line 1689: IF inv_cache.org_rec.default_status_id IS NOT NULL THEN

1685: l_lot_ctrl := FALSE;
1686: END IF;
1687:
1688: IF inv_cache.set_org_rec(p_organization_id) THEN
1689: IF inv_cache.org_rec.default_status_id IS NOT NULL THEN
1690: l_onh_status := TRUE;
1691: END IF;
1692: END IF;
1693:

Line 1702: IF inv_cache.set_item_rec(p_organization_id,p_inventory_item_id) THEN

1698: print_debug('Onhand status not enabled.', 4);
1699: END IF;
1700: END IF;
1701:
1702: IF inv_cache.set_item_rec(p_organization_id,p_inventory_item_id) THEN
1703: l_pr_uom_code := inv_cache.item_rec.primary_uom_code;
1704:
1705: l_lot_control_code := inv_cache.item_rec.lot_control_code;
1706: IF l_lot_control_code <> 1 THEN

Line 1703: l_pr_uom_code := inv_cache.item_rec.primary_uom_code;

1699: END IF;
1700: END IF;
1701:
1702: IF inv_cache.set_item_rec(p_organization_id,p_inventory_item_id) THEN
1703: l_pr_uom_code := inv_cache.item_rec.primary_uom_code;
1704:
1705: l_lot_control_code := inv_cache.item_rec.lot_control_code;
1706: IF l_lot_control_code <> 1 THEN
1707: l_lot_divisible_flag := inv_cache.item_rec.lot_divisible_flag;

Line 1705: l_lot_control_code := inv_cache.item_rec.lot_control_code;

1701:
1702: IF inv_cache.set_item_rec(p_organization_id,p_inventory_item_id) THEN
1703: l_pr_uom_code := inv_cache.item_rec.primary_uom_code;
1704:
1705: l_lot_control_code := inv_cache.item_rec.lot_control_code;
1706: IF l_lot_control_code <> 1 THEN
1707: l_lot_divisible_flag := inv_cache.item_rec.lot_divisible_flag;
1708: END IF;
1709:

Line 1707: l_lot_divisible_flag := inv_cache.item_rec.lot_divisible_flag;

1703: l_pr_uom_code := inv_cache.item_rec.primary_uom_code;
1704:
1705: l_lot_control_code := inv_cache.item_rec.lot_control_code;
1706: IF l_lot_control_code <> 1 THEN
1707: l_lot_divisible_flag := inv_cache.item_rec.lot_divisible_flag;
1708: END IF;
1709:
1710: IF l_pr_uom_code = p_uom_code THEN
1711: l_primary_qty := ROUND(p_quantity,5);